SOLVED Warning about Unresolved IP addresses

[Droidism20011]

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]

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]

Hi @cPanelMichael

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

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]

Hello,

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

Thanks!

 

[Droidism20011]

@cPanelMichael

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

W.