Ad Widget

Collapse

problem monitoring mysql

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • funkytwig
    Member
    • Jun 2016
    • 37
    #1

    problem monitoring mysql

    I am getting a lots of errors in the zabbix_server.log. Zabbix 3.0.3. I am using zabbix 3 and mysql 5.5.49-MariaDB-1ubuntu0.14.04.1 (well actually MariaDB, is this the problem?

    Ben


    4840:20160618:204936.713 item "localhost:mysql.ping" became not supported: Received value [^Gmysqladmin: connect to server at 'localhost' failederror: 'Access denied for user 'zabbix'@'localhost' (using password: NO)'0] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
    4840:20160618:204937.769 item "localhost:mysql.status[Bytes_received]" became not supported: Received value [ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: NO)] is not suitable for value type [Numeric (float)]
    4840:20160618:204938.822 item "localhost:mysql.status[Bytes_sent]" became not supported: Received value [ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: NO)] is not suitable for value type [Numeric (float)]
    4840:20160618:204939.838 item "localhost:mysql.status[Com_begin]" became not supported: Received value [ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: NO)] is not suitable for value type [Numeric (float)]
    4840:20160618:204940.868 item "localhost:mysql.status[Com_commit]" became not supported: Received value [ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: NO)] is not suitable for value type [Numeric (float)]
    4840:20160618:204941.913 item "localhost:mysql.status[Com_delete]" became not supported: Received value [ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: NO)] is not suitable for value type [Numeric (float)]
    4840:20160618:204942.943 item "localhost:mysql.status[Com_insert]" became not supported: Received value [ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: NO)] is not suitable for value type [Numeric (float)]
    4840:20160618:204944.055 item "localhost:mysql.status[Com_rollback]" became not supported: Received value [ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: NO)] is not suitable for value type [Numeric (float)]
    4840:20160618:204945.076 item "localhost:mysql.status[Com_select]" became not supported: Received value [ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: NO)] is not suitable for value type [Numeric (float)]
    4839:20160618:204946.096 item "localhost:mysql.status[Com_update]" became not supported: Received value [ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: NO)] is not suitable for value type [Numeric (float)]
    4837:20160618:204947.104 item "localhost:mysql.status[Questions]" became not supported: Received value [ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: NO)] is not suitable for value type [Numeric (float)]
    4838:20160618:204948.112 item "localhost:mysql.status[Slow_queries]" became not supported: Received value [ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: NO)] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
    4840:20160618:204949.127 item "localhost:mysql.status[Uptime]" became not supported: Received value [ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: NO)] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
    Tags: None
    • zabx_ks
      Member
      • May 2016
      • 48
      #2
      Hi funkytwig,

      Make sure that you have correctly configured your zabbix_server.conf

      Code:
      DBHost=
DBName=
DBUser=
DBPassword=
      zabx_ks
      Last edited by zabx_ks; 20-06-2016, 09:09.

        Comment

        • funkytwig
          Member
          • Jun 2016
          • 37
          #3
          Yes. The general monitoring is working (can see Graphs etc.). I would imagine if I had not correctly configured database a lot world not work.

            Comment

            • funkytwig
              Member
              • Jun 2016
              • 37
              #4
              Does the 'using password: NO' tell me anything, sounds wrong.

                Comment

                • kloczek
                  Senior Member
                  • Jun 2006
                  • 1771
                  #5
                  Originally posted by funkytwig
                  Does the 'using password: NO' tell me anything, sounds wrong.
                  It means that:
                  - DB settings in zabbix configuration have nothing to do with monitoring
                  - your monitoring UserParameter used in agent setup or othrt backed scrip used on collecting mysql monitoring data has a authentication issue.
                  http://uk.linkedin.com/pub/tomasz-k%...zko/6/940/430/
                  https://kloczek.wordpress.com/
                  zapish - Zabbix API SHell binding https://github.com/kloczek/zapish
                  My zabbix templates https://github.com/kloczek/zabbix-templates

                    Comment

                    • funkytwig
                      Member
                      • Jun 2016
                      • 37
                      #6
                      OK, so looking at userparameter_mysql.conf it has

                      # For all the following commands HOME should be set to the directory that has .my.cnf file with password information.

                      I have password in but do I need to set $HOME somewhere?

                        Comment

                        Previous template Next
                        Working...