Here is a tester for you
I have a fresh ispconfig 3 install in a DMZ (ORANGE) with all ports required open and pointing directly to the ISPConfig server at my house.
I have written a program in visual basic to connect to a database on this server but i keep getting this error message when trying a connection using this program from a friends house.
"Cannot connect to database: Unable to connect to any of the specified MySQL hosts."
MySQL has been stopped and started
Port 3306 TCP is forwarded from my smoothwall box to the server in the DMZ
Remote Access is enabled for this database
My User name has been entered with the correct "client prefix" I.E "c1testuser"
Now, this is the stinger !
If i try to connect to this database from my "GREEN" subnet using this program at my house i get a connection using the servers 192.168.1.*** I.P Address.It seems any access to MySQL from the internet is resulting in no connection, and the error message above in blue! By the way he has also already installed on his pc the MySQL.DATA.DLL files for the connection.
I Also get the same error when replacing the 'local' IP address to my ISP static address from at my house. which is a pain if you program and use connection strings!!!!!!!
Any Ideas will be COOOL!