Remote Access Host won't work with DYNDNS host

[bluesteam]

Hello,

So I have my own DYNDNS host. For practicality purposes lets say it is:

myhost.dyndns.org

So I added this host to the allow Access Hosts list for the database in question.



For completion sake, I also added this to the csf.dyndns file through the CSF config section.



However, whenever I connect using MySQL workbench, the connection fails and says that I cannot connect using my own reverseDNS internet host.

Of course if I add my actual IP address in, it works fine but this defeats the purpose of DYNDNS.

I found this article online and they say to use the --skip-name-resolve option during the startup of mysqld but the user stated that it did not work.

This is the error I am getting when trying to connect remotely:



Can someone please assist me in bypassing the MySQL reverse DNS so that our DynDNS will work as expected?

 

[Ohm J]

try this

Enable remote access to MySQL database server

I'm unable to locate the /etc/my.cnf file where I need to edit to include port and bind-address. Is there any other method to enable remote access to MySQL database server? Any help/ guidance is much appreciated. Thanks in advance.

forum.directadmin.com

Allow Access Host, It just allow like [email protected] in database
but you need to enable bind to public ip


so first checking with telnet from diferrent location/Server
telnet 1.2.3.4 3306


========================And about DYNDNS on csf firewall
You need enable in config option "DYNDNS"
just set to like 300 ( updates every 5Minute )

 

[bluesteam]

try this

Enable remote access to MySQL database server

I'm unable to locate the /etc/my.cnf file where I need to edit to include port and bind-address. Is there any other method to enable remote access to MySQL database server? Any help/ guidance is much appreciated. Thanks in advance.

forum.directadmin.com

Allow Access Host, It just allow like [email protected] in database
but you need to enable bind to public ip


so first checking with telnet from diferrent location/Server
telnet 1.2.3.4 3306


========================And about DYNDNS on csf firewall
You need enable in config option "DYNDNS"
just set to like 300 ( updates every 5Minute )

Thanks but this is to enable remote access.

Remote Access is working perfectly fine without the need to follow any of those instructions.

The problem is when connecting to the remote database using a DYNDNS host. This is the problem as MySQL always checks your reverse DNS. This guy had the same problem:

MySQL Workbench sends computer name with login not IP

I am attempting to connect MySQLWorkbench to a remote MySQL Server. The server has granted access to user@IPAddress However, when I try to connect MySQLWorkbench, it sends user@computername

serverfault.com

 

[Richard G]

Remote Access is working perfectly fine without the need to follow any of those instructions.

So in that case I presume you have port 3306 opened or nothing will work remotely.

The guy you're pointing to did not have the same issue. He wanted ip use instead of what you want, which is name resolution. So he wanted the opposite as you want.

It looks like it, but it's different. I found one which is better for your needs, but no solution either.

MySQL :: Re: Using NOIP provided hostname in MySQL user

forums.mysql.com

 

[bluesteam]

Port 3306 is not explicitly opened in CSF but I am able to remotely access the database just fine when adding my direct IP address to the allowed list of Access Hosts. So for some reason it doesn't look like I need to explicitly specify 3306.

Whenever my ISP changes my IP, my online reverse dns host becomes the-ip.the-isp.com.

So this is what MySQL sees when I try connecting and it ignores my IP entirely.

How do I disable the reverse DNS lookup when starting MySQL on directadmin?

 

[Richard G]

How do I disable the reverse DNS lookup when starting MySQL on directadmin?

Try adding this to your /etc/my.cnf file under [myslqd]:
skip-name-resolve
and restart mysql.

If that doesn't work, we'll have to wait until somebody else answers.

 

[bluesteam]

Try adding this to your /etc/my.cnf file under [myslqd]:
skip-name-resolve
and restart mysql.

If that doesn't work, we'll have to wait until somebody else answers.

But if I do disable reverse DNS lookup, will adding a DYNDNS host still work??

I know I will only really know once I test it but I'm not near a pc now.

 

[bluesteam]

So adding this to the /etc/my.cnf definitely disabled the reverse dns lookup but completely removes the ability to add DYNDNS hosts to the Access Hosts list.



When running a connection test now, it is only seeing my IP but the problem is that when trying to add a DYNDNS host now it complains about the above. Therefore it simply won't work.

Sooo...

Looks like DirectAdmin is unable to allow DYNDNS hosts as an allowed host in the Access Host list...

What a shame!

 

[Richard G]

Looks like DirectAdmin is unable to allow DYNDNS hosts as an allowed host in the Access Host list...

I think you're mistaken. What I read from the other thread, also the thread I pointed to, it's a Mysql issue, not a Directadmin issue.

So it's not a DA shame.

 

[bluesteam]

Hmmmm you are right but what surprises me is that this has not been solved across the entire world...

Am I truly the only one who needs to connect to MySQL using a dynamic IP that changes from the to time??

 

[Richard G]

You're certainly not the only one but I gues one of the few.
Loads of people have a dynamic ip which is rather static (seldom changes) and/or don't use external mysql connection.
Most hosting company's don't even allow it.

 

[bluesteam]

While that may be true, the way it is now, not person in the world can use DYNDNS with MySQL because it simply won't work at all if your ISP allocates a hostname along with your IP.

 

[Richard G]

That is correct. But mysql is never ment for use with use with dynamic ip's. I understand your issue, but if you want things fixed, the only solution is to talk about it at mysql forums or put in a suggestion/request there if possible.

Another option is to use your dynamic ip and maybe a cron which checks and changes the ip in mysql when changed in dyndns.

 

[bluesteam]

Thanks