Ad Widget

Collapse

'zabbix_get -k mysql.*' and 'zabbix_agentd -t mysql.*' get different results

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MajorTom
    Junior Member
    • Sep 2019
    • 2

    #1

    'zabbix_get -k mysql.*' and 'zabbix_agentd -t mysql.*' get different results

    'zabbix_get -s 127.0.0.1 -k mysql.ping' get 'mysqladmin: [Warning] Using a password on the command line interface can be insecure.'.
    'zabbix_agentd -t mysql.ping' get 'mysql.ping [t|mysqladmin: [Warning] Using a password on the command line interface can be insecure.
    mysqld is alive]'
    You see the first one missing 'mysqld is alive'.
    I've changed my 'mysql.ping' command to using password on the command line and dropped the 'grep -c alive' part . If I don't change that , all I got is '0' with 'zabbix_get -s 127.0.0.1 -k mysql.ping' , and the result using 'zabbix_agentd -t mysql.ping' is '1' .
    I think zabbix_get can't get response from mysql . Now the mysql server is always down and can't get any number specific data in zabbix web.
  • MajorTom
    Junior Member
    • Sep 2019
    • 2

    #2
    I end up starting zabbix_agent with zabbix_agentd instead of systemctl.

    Comment

    • dimir
      Zabbix developer
      • Apr 2011
      • 1080

      #3
      Could you show your UserParameter mysql.ping?

      Comment

      Working...