Details
-
Type: Monitor
-
Status: Closed
-
Priority: Major
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: 2021
-
Component/s: FIWARE-TECH-HELP
-
Labels:
-
HD-Chapter:Apps
-
HD-Enabler:Wirecloud
Description
Created question in FIWARE Q/A platform on 06-06-2017 at 13:06
Please, ANSWER this question AT https://stackoverflow.com/questions/44388213/access-to-sql-fiware
Question:
Access to sql Fiware
Description:
I have a problem with sql access from the fiwarelab machine.
I have duplicate the same as in fiwarelab in local, by code I have designed a graph to show the sql data.
As I said in local if I work correctly, but when I make the query to the machine of fiwarelab I can not show the graphs, nor the errors that I have programmed for a bad connection.
I'm somewhat lost with the fiwarelab theme
Do I have to open the ports or change some configuration of sql?
This is one of my codes:
function conectarBD(){
$server = "localhost";
$usuario = "root";
$pass = "";
$BD = "ual";
//variable que guarda la conexión de la base de datos
$conexion = mysqli_connect($server, $usuario, $pass, $BD);
//Comprobamos si la conexión ha tenido exito
if(!$conexion)
//devolvemos el objeto de conexión para usarlo en las consultas
return $conexion;
}
Greetings and thank you.
Activity
Field | Original Value | New Value |
---|---|---|
Component/s | FIWARE-TECH-HELP [ 10278 ] |
Assignee | Álvaro Arranz [ aarranz ] |
Component/s | FIWARE-LAB-HELP [ 10279 ] | |
Component/s | FIWARE-TECH-HELP [ 10278 ] | |
Description |
Created question in FIWARE Q/A platform on 06-06-2017 at 13:06 {color: red}Please, ANSWER this question AT{color} https://stackoverflow.com/questions/44388213/access-to-sql-fiware +Question:+ Access to sql Fiware +Description:+ I have a problem with sql access from the fiwarelab machine. I have duplicate the same as in fiwarelab in local, by code I have designed a graph to show the sql data. As I said in local if I work correctly, but when I make the query to the machine of fiwarelab I can not show the graphs, nor the errors that I have programmed for a bad connection. I'm somewhat lost with the fiwarelab theme Do I have to open the ports or change some configuration of sql? This is one of my codes: function conectarBD(){ $server = "localhost"; $usuario = "root"; $pass = ""; $BD = "ual"; //variable que guarda la conexión de la base de datos $conexion = mysqli_connect($server, $usuario, $pass, $BD); //Comprobamos si la conexión ha tenido exito if(!$conexion){ echo 'Ha sucedido un error inexperado en la conexion de la base de datos<br>'; } //devolvemos el objeto de conexión para usarlo en las consultas return $conexion; } Greetings and thank you. |
Created question in FIWARE Q/A platform on 06-06-2017 at 13:06
{color: red}Please, ANSWER this question AT{color} https://stackoverflow.com/questions/44388213/access-to-sql-fiware +Question:+ Access to sql Fiware +Description:+ I have a problem with sql access from the fiwarelab machine. I have duplicate the same as in fiwarelab in local, by code I have designed a graph to show the sql data. As I said in local if I work correctly, but when I make the query to the machine of fiwarelab I can not show the graphs, nor the errors that I have programmed for a bad connection. I'm somewhat lost with the fiwarelab theme Do I have to open the ports or change some configuration of sql? This is one of my codes: function conectarBD(){ $server = "localhost"; $usuario = "root"; $pass = ""; $BD = "ual"; //variable que guarda la conexión de la base de datos $conexion = mysqli_connect($server, $usuario, $pass, $BD); //Comprobamos si la conexión ha tenido exito if(!$conexion){ echo 'Ha sucedido un error inexperado en la conexion de la base de datos<br>'; } //devolvemos el objeto de conexión para usarlo en las consultas return $conexion; } Greetings and thank you. |
Status | Open [ 1 ] | In Progress [ 3 ] |
Status | In Progress [ 3 ] | Answered [ 10104 ] |
HD-Enabler | Wirecloud [ 10857 ] | |
HD-Chapter | Apps [ 10836 ] |
Component/s | FIWARE-TECH-HELP [ 10278 ] | |
Component/s | FIWARE-LAB-HELP [ 10279 ] |
Resolution | Done [ 10000 ] | |
Status | Answered [ 10104 ] | Closed [ 6 ] |
Fix Version/s | 2021 [ 12600 ] |
Transition | Time In Source Status | Execution Times | Last Executer | Last Execution Date | |||||
---|---|---|---|---|---|---|---|---|---|
|
1d 23h 52m | 1 | Fernando Lopez | 08/Jun/17 2:56 PM | |||||
|
2s | 1 | Fernando Lopez | 08/Jun/17 2:56 PM | |||||
|
14d 18h 15m | 1 | Álvaro Arranz | 23/Jun/17 9:11 AM |
2017-06-06 15:05|CREATED monitor | # answers= 0, accepted answer= False