Can't gain access to MySQL with dynamic IP outside of my LAN

[Volpaia]

Hi there,

Our small charity group have their MySQL database hosted on a Miniserver VM, donated by Memset, with cPanel &WHM and ConfigServer Firewall. I am trying to make it accessible to other members on their laptops which all have a dynamic IP. I can get it to work fine at my house connected through my wifi LAN but cannot access MySQL, in their own homes with a Delphi 6 app through MyODBC., outside of my LAN .

I have installed (Paid for)No-IP DCU’s on each machine with an appropriate FQDN, xxx.xxx.no-ip.info, which works OK and can see their IP shows up on their Laptops. I have made the following changes in cPanel/WHM: Added the No-IP FQDN to cPanel-Remote MySQL, WMP-Additional MySQL Access Host, CFS ifd Dynamic DNS and changed DYNDNS to 1.

Our local station down the road has public WiFi so I can nip down there to test my stuff outside my LAN but I keep getting a MySQL error saying this IP is not permitted to access the database but the interesting thing is that if I key in the IP from the DUC into cPanel-Remote MySQL I can get into the DB without any problems. That is without changing any of the settings in WHM. I have also tried it after disabling CSF but without any success.

The problem seems to be that cPanel isn’t resolving the FQDN to an IP or is not passing it to Remote MySQL.

I don’t believe it should be this difficult and am wondering if I have overlooked some step or if something is scrambled in cPanel.

I have had a great deal of help from the support team at Memset but they have run out of ideas. I have also contacted No-IP but with very limited success.
Any ideas?

 

[cPanelMichael]

Hello

Please ensure you see the following note in "WHM Home » SQL Services » Additional MySQL Access Hosts":

Important: Users must log into cPanel and use the Remote MySQL feature to set up access from these hosts. After you have done this, if you would like to configure access from all users' accounts, Click Here.

Also, make sure the host resolves to a valid IP address by using a command such as:

host abc.domain.com

Thank you.

 

[Volpaia]

Michael,

Thanks for that. I knew about clicking to configure all accounts and had done that. I didn't know about putting 'host' before the fqdn but I did that and tried it but sadly, it didn't fly. I thing there is something more fundamental at the root like a corrupt file or something but I know very little about cPanel so I am stymied.

To be a bit pedantic, I put my no-ip domain into WMP-Additional MySQL Access Host as host abc-cde.no-ip.info and did the same in csf Dynamic DNS.

In cPanel Remote MySQL it doesn't allow for a statement such as 'host xxx.xxx.co' so it is just the fqdn.

If you have any other thoughts I should be grateful.

Kind regards

 

[cPanelMichael]

I provided the following as a command that you would run via SSH:

host abc.domain.com

It was not intended to be used in a configuration file. It's a command that you can use to see if your server is resolving a domain name to an IP address.

Thank you.