SOLVED Warning about Unresolved IP addresses

Droidism20011

Member
Jul 20, 2017
23
10
3
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
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.
 

Droidism20011

Member
Jul 20, 2017
23
10
3
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.
 
  • Like
Reactions: cPanelMichael

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
Hello,

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

Thanks!
 
  • Like
Reactions: Droidism20011