Strange mysql logs

Discussion in 'Installation/Configuration' started by lollollollol, Dec 15, 2012.

  1. lollollollol

    lollollollol Member

    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.
     
  2. falko

    falko Super Moderator

    Is your system running out of memory?

    Is it a physical server or a virtual machine?
     
  3. lollollollol

    lollollollol Member

    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...
     
  4. lollollollol

    lollollollol Member

    Solved...

    I'm so stupid...:rolleyes:

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

    Laurent.
     

Share This Page