The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Database Discussions' started by Volpaia, Mar 7, 2014.

  1. Volpaia

    Volpaia Registered

    Joined:
    Mar 6, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

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

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

    Code:
    host abc.domain.com
    Thank you.
     
  3. Volpaia

    Volpaia Registered

    Joined:
    Mar 6, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page