Home / server / Questions / 359946
In Process
krisdigitx
Asked: 2012-02-15 04:13:47 +0800 CST

zabbix monitoring mysql database

  • 772

I have a server running multiple instances of mysql and also has the zabbix-agent running.

In zabbix_agentd.conf i have specified:

UserParameter=multi.mysql[*],mysqladmin --socket=$1  -uzabbixagent extended-status 2>/dev/null | awk '/ $3 /{print $$4}'

where $1 is the socket instance.

From the zabbix server i can run the test successfully.

zabbix_get -s ip_of_server  -k multi.mysql[/var/lib/mysql/mysql2.sock]

and it returns all the values

However the zabbix item/trigger does not generate the graphs, I have created a MACRO for $1 which is the socket location

{$MYSQL_SOCKET1} = '/var/lib/mysql/mysql2.sock'

and i use this key in items to poll the value

multi.mysql[{$MYSQL_SOCKET1},Bytes_sent]

LOGS:

this is what i get on the logs:

3360:20120214:144716.278 item [multi.mysql['/var/lib/mysql/mysql2.sock',Bytes_received]] error: Special characters '\'"`*?[]{}~$!&;()<>|#@' are not allowed in the parameters
  3360:20120214:144716.372 item [multi.mysql['/var/lib/mysql/mysql2.sock',Bytes_sent]] error: Special characters '\'"`*?[]{}~$!&;()<>|#@' are not allowed in the parameters

Any ideas where the problem could be?

FIXED

{$MYSQL_SOCKET1} = /var/lib/mysql/mysql2.sock

i removed the single quotes from the line and it worked...

linux zabbix

1 Answers

  1. FIXED

    {$MYSQL_SOCKET1} = /var/lib/mysql/mysql2.sock

    i removed the single quotes from the line and it worked...

    • 1