View Full Version : No support for Application.MySQL in 1.1beta6
Hi, i want to use the items from Application.MySQL. I have added the items to my zabbixserver host to get infromation about the mysql database. But even i changed the status to monitored and i refesh the page i got not supported. Have anyone an idea why?
For your infromation i uncomment the following lines in zabbix_agentd.conf
UserParameter=mysql.ping,mysqladmin -uroot -ppassword ping|grep alive|wc -l
UserParameter=mysql.uptime,mysqladmin -uroot -ppassword status|cut -f2 -d":"|cut -f1 -d"T"
UserParameter=mysql.threads,mysqladmin -uroot -ppassword status|cut -f3 -d":"|cut -f1 -d"Q"
UserParameter=mysql.questions,mysqladmin -uroot -ppassword status|cut -f4 -d":"|cut -f1 -d"S"
UserParameter=mysql.slowqueries,mysqladmin -uroot -ppassword status|cut -f5 -d":"|cut -f1 -d"O"
UserParameter=mysql.qps,mysqladmin -uroot -ppassword status|cut -f9 -d":"
UserParameter=mysql.version,mysql -V
Have you restarted ZABBIX agent?
Have you restarted ZABBIX agent?
Yes, do you mean zabbix_agent oder zabbix_agentd? I restarted zabbix_agentd.
Yes, I mean zabbix_agentd. Can you run these command in command line under user 'zabbix'?
i got this error
zabbix@suse:/var/lib/mysql> /etc/init.d/zabbix_agentd start
Starting zabbix_agentd startproc: cannot stat /proc/24995/exe: Permission denied
failed
zabbix@suse:/var/lib/mysql>
but if i look with ps -A the prozesstree, i see that zabbix_agentd is running.
24997 ? 00:00:00 zabbix_agentd
24998 ? 00:00:00 zabbix_agentd
24999 ? 00:00:00 zabbix_agentd
25000 ? 00:00:00 zabbix_agentd
25001 ? 00:00:00 zabbix_agentd
25002 ? 00:00:00 zabbix_agentd
:confused: :confused:
well, that's kind of odd.
can you stop it?
what user are you doing this as? zabbix should be started as root as it assumes the zabbix user after startup.
well, that's kind of odd.
can you stop it?
yes i can stop it but i can't start it.
what user are you doing this as? zabbix should be started as root as it assumes the zabbix user after startup.
i use user zabbix
start it as root (or use sudo to root) and see if you still have problems
yes i have the same problem :( :confused: :(
Hello,
I have the same problem with the use of mysql.qps as defined below in zabbix_agentd.conf (this is the default value supplied by the zabbix distribution):
UserParameter=mysql.qps,mysqladmin -uroot status|cut -f9 -d":"
In fact, the zabbix_agentd binary is working nice, but it seems to send this data as string and not as number:
% zabbix_agentd -p |grep "mysql.qps"
mysql.qps [s| 24.599]
And my ZABBIX server expects "numeric (float)" as data type ....
The same happens with mysql.threads, that make me think that the zabbix_agentd send every UserParameter returns as string datas .....
Does it means that the ZABBIX server does not handle well UserParameter "functions" or is it coming from zabbix_agentd ???
my 0.02 EUR
Regards,
Yopito
sorry,
I forgot to post the relevant error of zabbix_server in my previous post:
22911:20060217:085457 Type of received value [ 31.904] is not suitable for [mysql.qps@amnesix]
Perharps is it the space " " just before the value (31.904) that let think zabbix server that this is not a numeric (float) value ?
Perharps is it the space " " just before the value (31.904) that let think zabbix server that this is not a numeric (float) value ?
Hello
I solved this problem adding another cut at the end of the lines
Example
UserParameter=mysql.threads,mysqladmin -uroot status|cut -f3 -d":"|cut -f1 -d"Q"| cut -f2 -d" "
It worked for me on FC4 and Zabbix 1.1beta6
i will check it on monday. Thanks for your tip.
ryanboyce
22-04-2006, 03:13
Using v1.1beta8
The User Parameters for MySQL monitoring in a default install in zabbix_agentd.conf didn't work. To get them to work I had to change them to this:
UserParameter=mysql.ping ,/usr/local/mysql/bin/mysqladmin -uXXXX -pXXXX ping|grep alive|wc -l]
And then in the front end my key is:
mysql.ping
mysql.slowqueries
etc. etc.