Ad Widget

Collapse

strange problem with "Unsupported item key."

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ttudor
    Junior Member
    • Jul 2020
    • 5

    #1

    strange problem with "Unsupported item key."

    Code:
    27746:20200706:170432.559 active check "mysql.ping" is not supported: Unsupported item key.
    27746:20200706:170432.559 active check "mysql.qps" is not supported: Unsupported item key.
    27746:20200706:170432.559 active check "mysql.sbm" is not supported: Unsupported item key.
    27746:20200706:170432.559 active check "mysql.sir" is not supported: Unsupported item key.
    27746:20200706:170432.559 active check "mysql.slowqueries" is not supported: Unsupported item key.
    27746:20200706:170432.559 active check "mysql.sott" is not supported: Unsupported item key.
    27746:20200706:170432.559 active check "mysql.sr" is not supported: Unsupported item key.
    27746:20200706:170432.559 active check "mysql.srt" is not supported: Unsupported item key.
    27746:20200706:170432.559 active check "mysql.threads" is not supported: Unsupported item key.
    27746:20200706:170432.559 active check "mysql.uptime" is not supported: Unsupported item key.
    Code:
    cat /etc/zabbix/zabbix_agentd.conf
    LogFile=/var/log/zabbix/zabbix_agentd.log
    LogFileSize=10
    Server=zabbix-server
    StartAgents=0
    ServerActive=zabbix-server
    Hostname=mysql-slave
    BufferSend=10
    BufferSize=400
    TLSConnect=psk
    TLSAccept=psk
    TLSPSKIdentity=identity
    TLSPSKFile=/etc/zabbix/zabbix_agent.psk
    BufferSend=10
    BufferSize=400
    PidFile=/var/run/zabbix/zabbix_agentd.pid
    #DebugLevel=4
    Code:
    cat /etc/zabbix/zabbix_agentd.d/zabbix_agentd.mysql.conf
    UserParameter=mysql.ping,mysqladmin --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock ping|grep alive|wc -l
    UserParameter=mysql.uptime,mysqladmin --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock status|cut -f2 -d":"|cut -f1 -d"T"
    UserParameter=mysql.threads,mysqladmin --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock status|cut -f3 -d":"|cut -f1 -d"Q"
    UserParameter=mysql.slowqueries,mysqladmin --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock status|cut -f5 -d":"|cut -f1 -d"O"
    UserParameter=mysql.qps,mysqladmin --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock status|cut -f9 -d":"
    
    UserParameter=mysql.srt,mysqladmin --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock extended-status|/bin/grep -i 'Slave_retried_transactions' | cut -f3 -d'|'
    UserParameter=mysql.sott,mysqladmin --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock extended-status|/bin/grep -i 'Slave_open_temp_tables' | cut -f3 -d'|'
    UserParameter=mysql.sr,mysql --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock -e "Show slave status\G"|/bin/grep -w 'Slave_SQL_Running' | cut -f2 -d':' | sed "s/No/0/; s/Yes/1/"
    UserParameter=mysql.sir,mysql --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock -e "Show slave status\G"|/bin/grep -w 'Slave_IO_Running' | cut -f2 -d':' | sed "s/No/0/; s/Yes/1/"
    UserParameter=mysql.sbm,mysql --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock -e "Show slave status\G"|/bin/grep -i 'Seconds_Behind_Master' | cut -f2 -d':'
    the mysql commands are working fine:
    Code:
    mysqladmin --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock ping
    mysqld is alive
    mysql --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock -e "Show slave status\G"|/bin/grep -w 'Slave_IO_Running'
    Slave_IO_Running: Yes
    now, everything is working on that server, except this mysql part, also this configuration is working very well on other servers, with the same zabbix server and same version of zabbix agentd

    any ideea what can be the problem, and how to solve it ?
  • tim.mooney
    Senior Member
    • Dec 2012
    • 1427

    #2
    You don't say what version of the zabbix-agent is in use on the client. If I remember correctly, the default path to the Include directory changed at some point.

    You're not specifying "Include=" in the zabbix_agentd.conf on the client that is failing. Are you specifying it on the clients that are working? Are those clients using the same directory?

    Comment

    • ttudor
      Junior Member
      • Jul 2020
      • 5

      #3
      Originally posted by tim.mooney
      You don't say what version of the zabbix-agent is in use on the client. If I remember correctly, the default path to the Include directory changed at some point.

      You're not specifying "Include=" in the zabbix_agentd.conf on the client that is failing. Are you specifying it on the clients that are working? Are those clients using the same directory?
      wow, thank you, that was it, now I'm sorry that I didn't think about that myself

      really THANK YOU

      Comment

      Working...