Ad Widget

Collapse

Problem to supervise a MySQL base on windows

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Jguigot
    Junior Member
    • Mar 2008
    • 14

    #1

    Problem to supervise a MySQL base on windows

    Hello,

    zabbix server is install in Linux with database MySQL.

    I would like supervise another database which are in windows server. I supervise a MySQL which are install on Linux but in windows, the command on zabbix_agentd.conf is false.

    zabbix_agentd.conf:

    ####### USER-DEFINED MONITORED PARAMETERS #######
    # Format: UserParameter=<key>,<shell command>
    # Note that shell command must not return empty string or EOL only
    UserParameter=system.test,who|wc -l
    ### Set of parameter for monitoring MySQL server (v3.23.42 and later)
    ### Change -u<username> and add -p<password> if required
    UserParameter=mysql.ping,mysql -uroot -proot ping|grep alive|wc -l
    UserParameter=mysql.uptime,mysql -uroot -proot zabbix|cut -f2 -d":"|cut -f1 -d"T"
    UserParameter=mysql.threads,mysql -uroot -proot zabbix|cut -f3 -d":"|cut -f1 -d"Q"
    UserParameter=mysql.questions,mysql -uroot -proot zabbix|cut -f4 -d":"|cut -f1 -d"S"
    UserParameter=mysql.slowqueries,mysql -uroot -proot zabbix|cut -f5 -d":"|cut -f1 -d"O"
    UserParameter=mysql.qps,mysql -uroot -proot zabbix|cut -f9 -d":"
    UserParameter=mysql.version,mysql -V


    but in iwndows, cut and grep as not reconize. Please help
  • Jguigot
    Junior Member
    • Mar 2008
    • 14

    #2
    Nobody have an idea for command "cut" to windows?

    Comment

    Working...