MySQL monitor failing

[sprsad18]

Hi All,

I have configured MySQL & also setup Zabbix to monitor the MySQL process.
But I'm not able to successfully achieve MySQL monitoring.

Can someone please help.

Sorry this is my 1st week with Zabbix, & not much aware of lot of things here.
Do let me know if you need any info to debug & solve this issue.

Error shown in Zabbix:
================
Received value [sh: mysqladmin: command not found0] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]

From Linux shell:
============
[root@neuro01 apache-tomcat-7.0.62]# which mysql
/usr/local/sbin/mysql
[root@neuro01 apache-tomcat-7.0.62]# which mysqladmin
/usr/local/sbin/mysqladmin
[root@neuro01 apache-tomcat-7.0.62]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 50047
Server version: 5.5.46-log MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>


Thanks,
Prasad

[Colttt]

hello and welcome to zabbix!

HOW would you like to monitor you mysql-database? can you please post you item config or a screenshot?

[sprsad18]

>HOW would you like to monitor you mysql-database?

Want to see if MySQL process is up & running.

If possible, if MySQL is not dishonouring the user queries, or not going unresponsive.

Usage stats of MySQL, the cpu, memory etc.

>can you please post you item config or a screenshot?
PFA

[shinguz]

FromDual Performance Monitor for MySQL (fpmmm)

You can try our MySQL Performance Monitor which reports to Zabbix:

http://fromdual.com/mpm-installation-guide

[Steveo]

Did you configure the the Agent UserParameter section correctly? I have no issue monitoring our mySQL.

[sprsad18]

I have no issues monitoring the other OS parameters like CPU,Memory etc

[Steveo]

The mySQL UserParameter section is not configured by default in the zabbix_server.conf, you need to make sure it is enabled and configure it to match your installation.

[sprsad18]

Thanks for the useful info.
I'm trying to add the mysql userparameters
But it fails with below error message


[root@neuro01 ~]# /etc/init.d/zabbix-agent restart
Shutting down Zabbix agent: [FAILED]
Starting Zabbix agent: zabbix_agentd [34997]: ERROR: cannot add user parameter "mysql.ping,/usr/local/mysql/bin/mysqladmin -uroot -proot ping|grep alive|wc -l": key "mysql.ping" already exists
[FAILED]

[root@neuro01 ~]# grep "mysql.ping" /etc/zabbix/zabbix_agentd.conf
UserParameter=mysql.ping,/usr/local/mysql/bin/mysqladmin -uroot -proot ping|grep alive|wc -l
[root@neuro01 ~]#

[sprsad18]

BTW, I got the steps to configure mysql, from below link

https://www.zabbix.com/documentation/2.0/manual/appendix/recipes

[Colttt]

please try

 grep -R "mysql.ping" /etc/zabbix/*

on the screenshot i see "mysql command not found" did you install the mysql-client on the machine?

[sprsad18]

Thanks a lot. My query is solved.
Zabbix server is able to monitor MySQL smoothly.

Wish you Merry Christmas & a very Happy New Year (in advance)