Ad Widget

Collapse

UserParameter for MySQL on windows

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rysar
    Junior Member
    • Apr 2005
    • 4

    #1

    UserParameter for MySQL on windows

    First of all, let me thank the developers for this excellent product. We're able to monitor server and processors more closely than ever before.

    My question pertains to UserParameters for MySql on Windows. I've uncommented the
    UserParameter=mysql[ping],mysqladmin -uroot ping|grep alive|wc -l
    UserParameter=mysql[uptime],mysqladmin -uroot status|cut -f2 -d":"|cut -f1 -d"T"
    UserParameter=mysql[threads],mysqladmin -uroot status|cut -f3 -d":"|cut -f1 -d"Q"
    UserParameter=mysql[questions],mysqladmin -uroot status|cut -f4 -d":"|cut -f1 -d"S"
    UserParameter=mysql[slowqueries],mysqladmin -uroot status|cut -f5 -d":"|cut -f1 -d"O"
    UserParameter=mysql[qps],mysqladmin -uroot status|cut -f9 -d":"
    UserParameter=version[mysql],mysql -V


    section in zabbix_agentd.conf (which sits at the root of C: with the agent executable), as well as installed Cygwin for Windows, and have verified the command can run from the command line and return correct results.

    The problem I have is that when I look at the Item Configuration, Status shows up as Non Supported, and the Error is Not Supported by Zabbix Agent.

    What am I doing wrong? I have done a ZabbixW32.exe check-config, which passes.

    Please point me in the right direction. Thanks in advance for your help.
  • rysar
    Junior Member
    • Apr 2005
    • 4

    #2
    Output from commands

    To make sure I wasnt totally losing it, I'm also posting the result of the custom commands (username and password ***'d out for security reasons... )

    C:\>mysqladmin -u*** -p*** ping|grep alive|wc -l
    1

    C:\>mysqladmin -u*** -p*** status|cut -f2 -d":"|cut -f1 -d"T"
    3529288

    C:\>mysqladmin -u*** -p*** status|cut -f3 -d":"|cut -f1 -d"Q"
    1

    C:\>mysqladmin -u*** -p*** status|cut -f4 -d":"|cut -f1 -d"S"
    15604066

    C:\>mysqladmin -u*** -p*** status|cut -f5 -d":"|cut -f1 -d"O"
    789

    C:\>mysqladmin -u*** -p*** status|cut -f9 -d":"
    4.421

    C:\>mysql -V
    mysql Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32)

    I also have in the path variable the directories for cygwin and mysql, which is why I can run the commands from the root of C, which is from where I'm guessing the commands are ran.

    (Operating System is Windows 2000 Server, fwiw)

    -----

    I also checked on another server, with Windows 2003 and MySQL 4.1, and have the same results.

    ------------------

    I also changed the command to run from the full path, and can get the resulting output from a version[mysql], but includes the d:\program files\mysql\bin output as well.
    Last edited by rysar; 12-04-2005, 19:06.

    Comment

    • rysar
      Junior Member
      • Apr 2005
      • 4

      #3
      Could a moderator move this to the Troubleshooting Forum if possible? After posting, I realize this isnt the forum for this thread...

      my apologies.

      Comment

      Working...