REXYGEN Community Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Login

    Database connection with PHPMyAdmin

    Database (MySQL, MariaDB, PostgreSQL, MSSQL)
    2
    2
    304
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • I
      IstrateSorin01
      last edited by

      Hello, i ran into an issue when trying to connect to an external database.
      The database info:
      name: plc
      username: root1
      pass - i won't disclose it, but in config file is right
      table: sqltable
      I am using the rexygen example program, the "Reading data from a database" example.
      I also have an raspberry pie 3b+ that acts as the target device. I installed the odbc driver and everything needed on it.
      The driver configuration can be seen below.
      b295fda2-54a1-43ed-9e4b-2ea17d91775e-image.png

      The issue is that when i run the example, the data stored in the database does not get pulled.
      Here you can see the table with the values and the rexygen exec and task files
      ab76675b-0844-4486-8fc5-9c8c4d94923f-image.png
      76a211c5-5212-4c1b-ad98-b7718da9783e-image.png
      When i try to run the program, it connects to the raspberry, but then in the log it gives me the error "Dialog Failed", although everything in the config file is right. Does anybody have an idea of what i can do to solve this?

      cechuratC 1 Reply Last reply Reply Quote 1
      • cechuratC
        cechurat @IstrateSorin01
        last edited by

        @istratesorin01
        Hi Istrate,

        it seems that the issue is remote access to the Database which is forbidden by default. Have a look at this tutorial: https://webdock.io/en/docs/how-guides/database-guides/remote-access-your-mariadb-mysql-database-ubuntu-focal-mariadb-v106

        Kind regards,
        Tomas

        1 Reply Last reply Reply Quote 0
        • First post
          Last post

        This is a community forum for REXYGEN users and fans. Detailed information can be found at REXYGEN homepage.

        There is also an outdated REXYGEN community forum.

        Powered by NodeBB.