Ad Widget

Collapse

Access denied for zabbix@localhost every 10 minutes

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • lnicotra
    Junior Member
    • Jul 2017
    • 2
    #1

    Access denied for zabbix@localhost every 10 minutes

    I have been running zabbix for years... I just migrated mysqld/zabbix from a server that had been running for about a year to a more powerful server.

    Migration was done by rsyncing database directory after installing zabbix via rpms. I have checked that rpms are at same version on old and new system.

    I am getting this weird error on mysql logs, every 10 minutes at 4,14,24,34,44 and 54 minutes, every hour since the migration. I just cant seem to figure out what is causing it.

    Error is repeated 13 times every time. Something is trying to access the DB not using the password. Can't figure out what is trying to make the connection.

    Mysql log shows:
    2017-07-24T16:04:30.205463Z 7886 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:04:31.353012Z 7887 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:04:32.540038Z 7889 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:04:33.249760Z 7890 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:04:34.592328Z 7891 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:04:35.659698Z 7892 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:04:36.684219Z 7894 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:04:37.236983Z 7895 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:04:38.797307Z 7896 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:04:39.864971Z 7897 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:04:40.897909Z 7898 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:04:41.991311Z 7899 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:04:42.126551Z 7900 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:14:31.289744Z 7984 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:14:31.446872Z 7985 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:14:32.681309Z 7986 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:14:33.572645Z 7987 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:14:34.808383Z 7988 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:14:35.798923Z 7990 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:14:36.847157Z 7991 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:14:37.052000Z 7992 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:14:38.935049Z 7993 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:14:39.988672Z 7994 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:14:40.597264Z 7995 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:14:41.547227Z 7996 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
    2017-07-24T16:14:42.647852Z 7997 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)

    I set mysql to dump log and all I get is:
    2017-07-24T14:24:30.325211Z 5343 Connect zabbix@localhost on using Socket
    2017-07-24T14:24:30.325281Z 5343 Connect Access denied for user 'zabbix'@'localhost' (using password: NO)

    Nothing indicates what might be trying to make the connection.

    This was basically a cloned upgrade of a working system. Everything else seems to be working fine with both mysql and zabbix.

    Does anyone know what internal processes might run every 10 minutes? I have restarted mysql and zabbix multiple times and it always comes back to 10 minutes with it taking place on minutes ending in "4".

    Thanks!
    Tags: mysql recurring error
    • wick
      Member
      • May 2017
      • 57
      #2
      Hi lnicotra,

      your Sql server is start ? cause your log for mysql is at 14h24
      and your zabbix log is at 16h04 maybe mysql is down after the start ?

      Code:
      # service mysql status
      Have you create the zabbix@localhost on the new database same as that:

      Code:
      mysql> grant all privileges on zabbix.* to 'zabbix'@'localhost' identified by 'set-password-here';
mysql>flush privileges;
mysql> quit;
      sorry for my bad english

        Comment

        • lnicotra
          Junior Member
          • Jul 2017
          • 2
          #3
          This issue was resolved. It turn out the zabbix-agent was causing the problem. Errors stopped after turning it off. I copied the config files in /etc/zabbix/zabbix_agentd.d from the old system and after restarting the agent, there are no more errors in the mysql log...

          Case closed.

            Comment

            • forbiddenlake
              Junior Member
              • Sep 2015
              • 3
              #4
              I had this problem and the problem was indeed with the agent, specifically in file /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf
              where several HOME= snippets were NOT set to the location of a proper .my.cnf file
              # For all the following commands HOME should be set to the directory that has .my.cnf file with password information.

                Comment

                Previous template Next
                Working...