Ignition mariaDB connection

Ignition
1

Hello every body!
I’ve Ignition 7.9.13 installed in a Linux server (IP: 10.0.1.66) which I can connect via VPN.

in the same server there’s a mariaDB server and a Database (db name: ‘V2949’). I tried to connect in 2 ways and none is working…

1- using “MySQL ConnectorJ” JDBC Driver

db%20mysql
db%20mysql1027×1032 47.1 KB

2- using a custom driver

db%20mariadb
db%20mariadb1031×878 32 KB

drivers list:

sql%20driver
sql%20driver1032×607 32 KB

mariadb driver:
mariadb%20driver
mariadb%20driver1011×1143 35.8 KB

db
db1009×611 19.2 KB

the errors are the same:

Cannot create PoolableConnectionFactory (Could not connect to address=(host=10.0.1.66)(port=3306)(type=master) : Access denied for user 'Ignition'@'10.0.1.66' (using password: YES) Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding')

I have tried using Database Workbench to connect to this server and everything is working fine.
workbench

can please somebody help me? :slight_smile:
thanks

2

That looks pretty clear. Are you using that same exact user in your workbench?

1 Like
3

yep, that’s why i’m so upset :confused:

mariadb%20connection%20workbench

4

Are you running workbench itself right on the gateway? If not, then your workbench user is not @‘10.0.1.66’, but the IP address of your workstation. You need to inspect the privilege tables in MariaDB to see what is being applied. MariaDB (and MySQL) treat different source IPs as different users, unless there’s a wildcard in the privilege tables.

1 Like