Ad Widget

Collapse

MySQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • utel
    Junior Member
    • Mar 2006
    • 3

    #1

    MySQL

    Hi, i'm having trouble setting up mysql monitoring,
    i have put this in my za...agentd.conf

    snip - snip
    UserParameter=mysql[ping],/usr/local/mysql/bin/mysqladmin -uroot ping|grep alive|wc -l
    UserParameter=mysql[uptime],/usr/local/mysql/bin/mysqladmin -uroot status|cut -f2 -d":"|cut -f1 -d"T"
    UserParameter=mysql[threads],/usr/local/mysql/bin/mysqladmin -uroot status|cut -f3 -d":"|cut -f1 -d"Q"
    UserParameter=mysql[questions],/usr/local/mysql/bin/mysqladmin -uroot status|cut -f4 -d":"|cut -f1 -d"S"
    UserParameter=mysql[slowqueries],/usr/local/mysql/bin/mysqladmin -uroot status|cut -f5 -d":"|cut -f1 -d"O"
    UserParameter=mysql[qps],/usr/local/mysql/bin/mysqladmin -uroot status|cut -f9 -d":"
    UserParameter=mysql[version],/usr/local/mysql/bin/mysql -V

    snip-snip

    made sure zabbix use can run them ...

    but the zabbix server reports "insuported" ver:1.1-7

    can anyone help ?
  • krusty
    Senior Member
    • Oct 2005
    • 222

    #2
    I'm running 1.1beta7 and 1.1beta6, and i have the same problems.

    I've checked that the zabbix user can run the commands.

    Any idea?

    Comment

    • cameronsto
      Senior Member
      • Oct 2005
      • 148

      #3
      I believe my post here will fix this for you.

      -cameron

      Comment

      Working...