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.

SOLVED Warning about Unresolved IP addresses

Discussion in 'Database Discussions' started by Droidism20011, Aug 1, 2017.

  1. Droidism20011

    Droidism20011 Member

    Joined:
    Jul 20, 2017
    Messages:
    23
    Likes Received:
    9
    Trophy Points:
    3
    Location:
    Amsterdam
    cPanel Access Level:
    Root Administrator
    Hi,

    After running mySQLTuner and looking at the output I see that MySQLTuner suggests to have a look at Control warning line(s) in the /var/lib/mysql/xxxxxxxxxxx.err file

    After opening this file a noticed two entries amongst many others:

    170729 11:31:27 [Warning] IP address '58.xxx.xxx.xx' could not be resolved: Name or service not known

    170729 12:01:03 [Warning] IP address '222.xxx.xxx.xxx' could not be resolved: Name or service not known

    Both IP address originate from China.

    And now for the mind boggling question: Is this harmless?

    1: Yes, nothing to worry about, totally normal.

    2: No, but just simply add them to WHMCS as your first two customers and try to send them a bill for the use of your VPS.

    3: No, not really... It's a better idea to hire somebody with way more knowledge then you as a server admin. It's clear you should not admin any VPS or Server.

    4: (feel free to add your own answer to my question)

    Thanks in advance for any help, answers and suggestions.

    W.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,167
    Likes Received:
    1,295
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Those warning messages indicate that MySQL failed to resolve those IP address to a host name. It's likely those IP addresses do not have RDNS configured. It's generally a good idea to use a firewall management utility such as CSF to block non-local connection attempts to port 3306 to prevent those connection attempts from occurring. You'd then simply whitelist any IP addresses that need to connect to MySQL from a remote server for a valid purpose.

    Thank you.
     
  3. Droidism20011

    Droidism20011 Member

    Joined:
    Jul 20, 2017
    Messages:
    23
    Likes Received:
    9
    Trophy Points:
    3
    Location:
    Amsterdam
    cPanel Access Level:
    Root Administrator
    Hi @cPanelMichael

    A.t.m. ConfigServer is installed and the firewall check indicates green for the section:

    Code:
    Incoming MySQL port check
    The TCP incoming MySQL port (3306) is open. This can pose both a security and server abuse threat since not only can hackers attempt to break into MySQL, any user can host their SQL database on your server and access it from another host and so (ab)use your server resources
    So this should be fine I believe.

    At this moment in time it is still a lot of n00bing around with WHM/cPanel, CL and all the other software and there is nothing important on this installation. Only a WP install to test and tweak against and the opportunity to get my feet wet administrating a VPS.

    When the time is there, there are enough funds AND I feel confident enough about my skills and understanding of WHM/cPanel, I will get the CS cPanel server service in combination with cxs and take it from there.

    Again, thanks for your help and explanation.

    W.
     
    cPanelMichael likes this.
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,167
    Likes Received:
    1,295
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Feel free to reach out to us again should you have any additional questions.

    Thanks!
     
    Droidism20011 likes this.
  5. Droidism20011

    Droidism20011 Member

    Joined:
    Jul 20, 2017
    Messages:
    23
    Likes Received:
    9
    Trophy Points:
    3
    Location:
    Amsterdam
    cPanel Access Level:
    Root Administrator
    @cPanelMichael

    Will do! Thanks again for your time and effort and have a great day!

    W.
     
    cPanelMichael likes this.
Loading...

Share This Page