Uploaded image for project: 'Help-Desk'
  1. Help-Desk
  2. HELP-9506

[fiware-stackoverflow] Access to sql Fiware

    Details

      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)

      { 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.

        Activity

        fla Fernando Lopez made changes -
        Fix Version/s 2021 [ 12600 ]
        aarranz Álvaro Arranz made changes -
        Resolution Done [ 10000 ]
        Status Answered [ 10104 ] Closed [ 6 ]
        backlogmanager Backlog Manager made changes -
        Component/s FIWARE-TECH-HELP [ 10278 ]
        Component/s FIWARE-LAB-HELP [ 10279 ]
        fla Fernando Lopez made changes -
        HD-Enabler Wirecloud [ 10857 ]
        HD-Chapter Apps [ 10836 ]
        fla Fernando Lopez made changes -
        Status In Progress [ 3 ] Answered [ 10104 ]
        fla Fernando Lopez made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        fla Fernando Lopez made changes -
        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&lt;br&gt;';
                    }
                    //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&lt;br&gt;';
                    }
                    //devolvemos el objeto de conexión para usarlo en las consultas
                    return $conexion;
            }


        Greetings and thank you.
        fla Fernando Lopez made changes -
        Assignee Álvaro Arranz [ aarranz ]
        backlogmanager Backlog Manager made changes -
        Field Original Value New Value
        Component/s FIWARE-TECH-HELP [ 10278 ]
        backlogmanager Backlog Manager created issue -

          People

          • Assignee:
            aarranz Álvaro Arranz
            Reporter:
            backlogmanager Backlog Manager
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: