HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   Strange mysql logs (http://www.howtoforge.com/forums/showthread.php?t=59961)

lollollollol 15th December 2012 08:43

Strange mysql logs
 
Hello,
System: ISPConfig 3.0.4.6 on Debian 7 (OVH)

I noticed a strange output in the logs.

Exactly once in two, running the cron job "usr / local / ispconfig / server / server.sh" causes an error in the logs of mysql (5.5.24 + dfsg-4):

Multitail on syslog and mysql.log

Code:

Dec 15 08:26:01 mail /USR/SBIN/CRON[501]: (root) CMD (/usr/local/ispconfig/server/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log)
                4034 Connect  Access denied for user 'root'@'localhost' (using password: NO)
Dec 15 08:27:01 mail /USR/SBIN/CRON[597]: (root) CMD (/usr/local/ispconfig/server/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log)
Dec 15 08:28:01 mail /USR/SBIN/CRON[679]: (root) CMD (/usr/local/ispconfig/server/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log)
                4070 Connect  Access denied for user 'root'@'localhost' (using password: NO)
Dec 15 08:29:01 mail /USR/SBIN/CRON[755]: (root) CMD (/usr/local/ispconfig/server/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log)
Dec 15 08:30:01 mail /USR/SBIN/CRON[821]: (root) CMD (/usr/local/ispconfig/server/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log)
                4078 Connect  Access denied for user 'root'@'localhost' (using password: NO)
Dec 15 08:31:01 mail /USR/SBIN/CRON[1033]: (root) CMD (/usr/local/ispconfig/server/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log)
Dec 15 08:32:01 mail /USR/SBIN/CRON[1100]: (root) CMD (/usr/local/ispconfig/server/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log)
                4099 Connect  Access denied for user 'root'@'localhost' (using password: NO)
Dec 15 08:33:01 mail /USR/SBIN/CRON[1174]: (root) CMD (/usr/local/ispconfig/server/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log)
Dec 15 08:34:01 mail /USR/SBIN/CRON[1241]: (root) CMD (/usr/local/ispconfig/server/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log)
                4105 Connect  Access denied for user 'root'@'localhost' (using password: NO)
Dec 15 08:35:01 mail /USR/SBIN/CRON[1316]: (root) CMD (/usr/local/ispconfig/server/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log)
Dec 15 08:36:01 mail /USR/SBIN/CRON[1486]: (root) CMD (/usr/local/ispconfig/server/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log)
                4111 Connect  Access denied for user 'root'@'localhost' (using password: NO)
Dec 15 08:37:01 mail /USR/SBIN/CRON[1561]: (root) CMD (/usr/local/ispconfig/server/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log)
Dec 15 08:38:01 mail /USR/SBIN/CRON[1638]: (root) CMD (/usr/local/ispconfig/server/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log)
                4117 Connect  Access denied for user 'root'@'localhost' (using password: NO)

I guess that it is not a problem as the task executes half the time, but I do not understand what can cause this ...

Thank you in advance,
Laurent.

falko 16th December 2012 13:10

Is your system running out of memory?

Is it a physical server or a virtual machine?

lollollollol 18th December 2012 05:56

Hi falko,Thanks fot your interest.

Non, I don't think it's a memory problem:
Code:

root@mail:~# free
            total      used      free    shared    buffers    cached
Mem:      66084500    4684564  61399936          0    305304    3084316
-/+ buffers/cache:    1294944  64789556
Swap:      1046520          0    1046520

And yes it's a physical machine not a VM one.

I tried to have a look at all my logs, but I don't found anything...

lollollollol 18th December 2012 06:44

Solved...
 
I'm so stupid...:rolleyes:

I finally found the cause: webmin sysstats (the root password wasn't recorded in the mysql module).

Laurent.


All times are GMT +2. The time now is 02:30.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.