Database connection with PHPMyAdmin
-
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.
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
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? -
@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