MySQL Server not accepting connection over VPN unless Telnet first
We are using a OpenVPN as our VPN software to access mysql databases across the country with MySQL Server 5.1 running on the hosting servers.
I am using VB.NET with MySQL Connector 6.6.4 for software to run queries on the databases on the VPN, but for some reason on the one server on the VPN it doesn't want to open a connection with my .NET application unless i telnet the port first.
This is what i normally do:
telnet 10.?.?.? 3306
As soon as the connection opens i run my software. Sometimes it opens a connection and runs the queries, sometimes it doesn't.
Also sometimes i ping the server and everything is fine, but i can't open a telnet connection.
It is like the mysql server is sleeping sometimes and i need to wake it up before i try and open a connection.
Does anybody know what this can be and have a solution for this?