Database Communication

General Discussion
1

Im testing upgrading to the newsiest version of ignition and im running into a problem with trying to communicate to are MySQL servers that aren't on the host Computer. talking to ignition a bit and looking around it seems as though its a network error where they simply cant communicate. Ive checked to make sure the port im telling it to go through is open and im currently going through all of are firewalls to see what i might be missing but if anyone has any suggestions on what to check/ what might be blocking the Database connection to are MySQL server.

Error:
"java.sql.SQLException: Cannot create PoolableConnectionFactory (Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)"

2

What does a good old ping from the gateway to the MySQL server tell you?

3

I get a request timed out so im guessing it is a firewall that is blocking the communication. I have connected to this MySQL server before so i know it is open to be connected to. I did also try it from are live ignition server Computer and it also Timed out when trying to ping the server but it currently has active confections to the MySQL database.

4

What version of MySQL? It may be a JDBC driver issue.

EDIT: Sorry, just noticed the zero packets thing. That seems to be a pure network issue.

5

I found the problem to be with the fire wall that are hosting service has set up on are Remote computer so even though i had opened my port 3306 i was still being blocked by IONOS own personal firewalls.

1 Like