1.6.3 Agentd: mysql.version [m|ZBX_NOTSUPPORTED]

[InventOR]

compile zabbbix from latest sources
./configure --with-ucd-snmp --enable-server --enable-agent --enable-proxy --with-mysql --with-libcurl

system.uname [t|FreeBSD lime4.host.xx 7.0-RELEASE-p5 FreeBSD 7.0-RELEASE-p5 #1: Fri Nov 14 11:24:17 MSK 2008 [email protected]:/usr/obj/usr/src/sys/LIME4 amd64]
agent.version [s|1.6.3]
system.run[echo test] [m|ZBX_NOTSUPPORTED]

./zabbix_agentd -t mysql.version
mysql.version [m|ZBX_NOTSUPPORTED]

in zabbix_agentd.conf have:
UserParameter=mysql.version,mysql -V

any ideas?

[InventOR]

[root@webdev /home/user/zabbix-1.6.3]# ./configure --with-ucd-snmp --enable-server --enable-agent --enable-proxy --with-mysql --with-libcurl
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe mkdir -p... ./install-sh -c -d
checking for gawk... no
checking for mawk... no
checking for nawk... nawk
checking whether make sets $(MAKE)... yes
configure: Configuring
checking whether make sets $(MAKE)... (cached) yes
checking build system type... x86_64-unknown-freebsd7.0
checking host system type... x86_64-unknown-freebsd7.0
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking how to run the C preprocessor... gcc -E
checking for grep that handles long lines and -e... /usr/bin/grep
checking for egrep... /usr/bin/grep -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking stdio.h usability... yes
checking stdio.h presence... yes
checking for stdio.h... yes
checking for stdlib.h... (cached) yes
checking for string.h... (cached) yes
checking for unistd.h... (cached) yes
checking netdb.h usability... yes
checking netdb.h presence... yes
checking for netdb.h... yes
checking signal.h usability... yes
checking signal.h presence... yes
checking for signal.h... yes
checking syslog.h usability... yes
checking syslog.h presence... yes
checking for syslog.h... yes
checking time.h usability... yes
checking time.h presence... yes
checking for time.h... yes
checking errno.h usability... yes
checking errno.h presence... yes
checking for errno.h... yes
checking for sys/types.h... (cached) yes
checking for sys/stat.h... (cached) yes
checking netinet/in.h usability... yes
checking netinet/in.h presence... yes
checking for netinet/in.h... yes
checking math.h usability... yes
checking math.h presence... yes
checking for math.h... yes
checking sys/socket.h usability... yes
checking sys/socket.h presence... yes
checking for sys/socket.h... yes
checking dirent.h usability... yes
checking dirent.h presence... yes
checking for dirent.h... yes
checking ctype.h usability... yes
checking ctype.h presence... yes
checking for ctype.h... yes
checking mtent.h usability... no
checking mtent.h presence... no
checking for mtent.h... no
checking fcntl.h usability... yes
checking fcntl.h presence... yes
checking for fcntl.h... yes
checking sys/param.h usability... yes
checking sys/param.h presence... yes
checking for sys/param.h... yes
checking sys/mount.h usability... yes
checking sys/mount.h presence... yes
checking for sys/mount.h... yes
checking arpa/inet.h usability... yes

[InventOR]

checking arpa/inet.h presence... yes
checking for arpa/inet.h... yes
checking sys/vfs.h usability... no
checking sys/vfs.h presence... no
checking for sys/vfs.h... no
checking sys/pstat.h usability... no
checking sys/pstat.h presence... no
checking for sys/pstat.h... no
checking sys/sysinfo.h usability... no
checking sys/sysinfo.h presence... no
checking for sys/sysinfo.h... no
checking sys/statvfs.h usability... yes
checking sys/statvfs.h presence... yes
checking for sys/statvfs.h... yes
checking for sys/socket.h... (cached) yes
checking sys/loadavg.h usability... no
checking sys/loadavg.h presence... no
checking for sys/loadavg.h... no
checking for arpa/inet.h... (cached) yes
checking sys/swap.h usability... no
checking sys/swap.h presence... no
checking for sys/swap.h... no
checking sys/vmmeter.h usability... yes
checking sys/vmmeter.h presence... yes
checking for sys/vmmeter.h... yes
checking for strings.h... (cached) yes
checking sys/sysctl.h usability... yes
checking sys/sysctl.h presence... yes
checking for sys/sysctl.h... yes
checking vm/vm_param.h usability... yes
checking vm/vm_param.h presence... yes
checking for vm/vm_param.h... yes
checking sys/time.h usability... yes
checking sys/time.h presence... yes
checking for sys/time.h... yes
checking kstat.h usability... no
checking kstat.h presence... no
checking for kstat.h... no
checking sys/syscall.h usability... yes
checking sys/syscall.h presence... yes
checking for sys/syscall.h... yes
checking sys/sysmacros.h usability... no
checking sys/sysmacros.h presence... no
checking for sys/sysmacros.h... no
checking sys/procfs.h usability... yes
checking sys/procfs.h presence... yes
checking for sys/procfs.h... yes
checking for stdint.h... (cached) yes
checking mach/host_info.h usability... no
checking mach/host_info.h presence... no
checking for mach/host_info.h... no
checking mach/mach_host.h usability... no
checking mach/mach_host.h presence... no
checking for mach/mach_host.h... no
checking knlist.h usability... no
checking knlist.h presence... no
checking for knlist.h... no
checking pwd.h usability... yes
checking pwd.h presence... yes
checking for pwd.h... yes
checking sys/proc.h usability... yes
checking sys/proc.h presence... yes
checking for sys/proc.h... yes
checking sys/var.h usability... no
checking sys/var.h presence... no
checking for sys/var.h... no
checking resolv.h usability... no
checking resolv.h presence... yes
configure: WARNING: resolv.h: present but cannot be compiled
configure: WARNING: resolv.h: check for missing prerequisite headers?
configure: WARNING: resolv.h: see the Autoconf documentation
configure: WARNING: resolv.h: section "Present But Cannot Be Compiled"
configure: WARNING: resolv.h: proceeding with the preprocessor's result
configure: WARNING: resolv.h: in the future, the compiler will take precedence
checking for resolv.h... yes
checking arpa/nameser.h usability... yes
checking arpa/nameser.h presence... yes
checking for arpa/nameser.h... yes
checking assert.h usability... yes
checking assert.h presence... yes
checking for assert.h... yes
checking sys/dkstat.h usability... yes
checking sys/dkstat.h presence... yes
checking for sys/dkstat.h... yes
checking sys/disk.h usability... yes
checking sys/disk.h presence... yes
checking for sys/disk.h... yes
checking nlist.h usability... yes
checking nlist.h presence... yes
checking for nlist.h... yes
checking net/if.h usability... no
checking net/if.h presence... yes
configure: WARNING: net/if.h: present but cannot be compiled
configure: WARNING: net/if.h: check for missing prerequisite headers?
configure: WARNING: net/if.h: see the Autoconf documentation
configure: WARNING: net/if.h: section "Present But Cannot Be Compiled"
configure: WARNING: net/if.h: proceeding with the preprocessor's result
configure: WARNING: net/if.h: in the future, the compiler will take precedence
checking for net/if.h... yes
checking kvm.h usability... yes
checking kvm.h presence... yes
checking for kvm.h... yes
checking linux/kernel.h usability... no
checking linux/kernel.h presence... no
checking for linux/kernel.h... no
checking getopt.h usability... yes
checking getopt.h presence... yes
checking for getopt.h... yes
checking procinfo.h usability... no
checking procinfo.h presence... no
checking for procinfo.h... no
checking sys/dk.h usability... no
checking sys/dk.h presence... no
checking for sys/dk.h... no
checking sys/resource.h usability... yes
checking sys/resource.h presence... yes
checking for sys/resource.h... yes
checking pthread.h usability... yes
checking pthread.h presence... yes
checking for pthread.h... yes
checking windows.h usability... no
checking windows.h presence... no
checking for windows.h... no
checking process.h usability... no
checking process.h presence... no
checking for process.h... no
checking conio.h usability... no
checking conio.h presence... no
checking for conio.h... no
checking sys/wait.h usability... yes
checking sys/wait.h presence... yes
checking for sys/wait.h... yes
checking regex.h usability... yes
checking regex.h presence... yes
checking for regex.h... yes
checking stdarg.h usability... yes
checking stdarg.h presence... yes
checking for stdarg.h... yes
checking winsock2.h usability... no
checking winsock2.h presence... no
checking for winsock2.h... no
checking pdh.h usability... no
checking pdh.h presence... no
checking for pdh.h... no
checking psapi.h usability... no
checking psapi.h presence... no
checking for psapi.h... no
checking sys/sem.h usability... yes
checking sys/sem.h presence... yes
checking for sys/sem.h... yes
checking sys/ipc.h usability... yes
checking sys/ipc.h presence... yes
checking for sys/ipc.h... yes
checking sys/shm.h usability... yes
checking sys/shm.h presence... yes
checking for sys/shm.h... yes
checking Winldap.h usability... no
checking Winldap.h presence... no
checking for Winldap.h... no
checking sys/timeb.h usability... yes
checking sys/timeb.h presence... yes
checking for sys/timeb.h... yes
checking Winber.h usability... no
checking Winber.h presence... no
checking for Winber.h... no
checking lber.h usability... no
checking lber.h presence... no
checking for lber.h... no
checking ws2tcpip.h usability... no
checking ws2tcpip.h presence... no
checking for ws2tcpip.h... no
checking for inttypes.h... (cached) yes
checking sys/file.h usability... yes
checking sys/file.h presence... yes
checking for sys/file.h... yes
checking grp.h usability... yes
checking grp.h presence... yes
checking for grp.h... yes
checking net/if_mib.h usability... no
checking net/if_mib.h presence... yes
configure: WARNING: net/if_mib.h: present but cannot be compiled
configure: WARNING: net/if_mib.h: check for missing prerequisite headers?
configure: WARNING: net/if_mib.h: see the Autoconf documentation
configure: WARNING: net/if_mib.h: section "Present But Cannot Be Compiled"
configure: WARNING: net/if_mib.h: proceeding with the preprocessor's result
configure: WARNING: net/if_mib.h: in the future, the compiler will take precedence
checking for net/if_mib.h... yes
checking sys/user.h usability... yes
checking sys/user.h presence... yes
checking for sys/user.h... yes
checking libperfstat.h usability... no
checking libperfstat.h presence... no
checking for libperfstat.h... no
checking devstat.h usability... no
checking devstat.h presence... yes
configure: WARNING: devstat.h: present but cannot be compiled
configure: WARNING: devstat.h: check for missing prerequisite headers?
configure: WARNING: devstat.h: see the Autoconf documentation
configure: WARNING: devstat.h: section "Present But Cannot Be Compiled"
configure: WARNING: devstat.h: proceeding with the preprocessor's result
configure: WARNING: devstat.h: in the future, the compiler will take precedence
checking for devstat.h... yes
checking for an ANSI C-conforming const... yes
checking for pid_t... yes
checking for library containing socket... none required
checking for library containing kstat_open... no
checking for library containing gethostbyname... none required
checking for library containing __res_query... none required
checking for library containing res_query... none required
checking for library containing perfstat_memory_total... no
checking for library containing devstat_getdevs... -ldevstat
checking for library containing getdevs... no
checking for main in -lm... yes
checking for main in -lkvm... yes
checking for function res_query... yes
checking for union semun... yes
checking for long long format... yes
checking for socklen_t... yes
checking for /proc filesystem... yes
checking for file /proc/stat... no
checking for file /proc/cpuinfo... no
checking for file /proc/1/status... no
checking for file /proc/0/psinfo... no
checking for file /proc/loadavg... no
checking for file /proc/net/dev... no
checking for mem_unit in struct sysinfo... no
checking for freeswap in struct sysinfo... no
checking for function setpriority() in sys/resource.h... yes
checking for function sysconf() in unistd.h... no
checking for macro __va_copy() in stdarg.h... yes
checking for vmtotal in struct sys/vmmeter.h... yes
checking for uvmexp_sysctl in struct uvm/uvm_extern.h... no
checking for uvmexp in struct uvm/uvm_extern.h... no
checking for struct swaptable in sys/swap.h... no
checking for totalswap in struct sysinfo... no

[InventOR]

checking for function sysctl (KERN_BOOTTIME)... yes
checking for function sysctl (HW_NCPU)... yes
checking for function sysctlbyname()... yes
checking for function sysctl (KERN_MAXFILES)... yes
checking for function sysctl (KERN_MAXPROC)... yes
checking for function sysctl (KERN_CPTIME,KERN_CPTIME2)... no
checking for function initgroups()... yes
checking for function seteuid()... yes
checking for function setproctitle()... yes
checking for totalram in struct sysinfo... no
checking for __VA_ARGS__... yes
checking for sharedram in struct sysinfo... no
checking for bufferram in struct sysinfo... no
checking for freeram in struct sysinfo... no
checking for uptime in struct sysinfo... no
checking for procs in struct sysinfo... no
checking return type of signal handlers... void
checking for getloadavg... yes
checking for socket... yes
checking for strtod... yes
checking for snprintf... yes
checking for vasprintf... yes
checking for asprintf... yes
checking for vsnprintf... yes
checking for hstrerror... yes
checking for atoll... yes
checking for getopt_long... yes
checking for mysql_config... /usr/local/bin/mysql_config
checking for main in -lmysqlclient ... yes
checking for ZABBIX server database selection... ok
checking for pkg-config... /usr/local/bin/pkg-config
checking pkg-config is at least version 0.9.0... yes
checking for gawk... (cached) nawk
checking for curl-config... /usr/local/bin/curl-config
checking for the version of libcurl... 7.19.2
checking for libcurl >= version 7.13.1... yes
checking for main in -lcurl... yes
checking whether libcurl is usable... yes
checking for curl_free... yes
checking for UCD-SNMP support... yes
checking for main in -lcrypto... yes
checking for localname in struct snmp_session... no
checking for architecture... ok (freebsd7.0)
configure: creating ./config.status
config.status: creating Makefile
config.status: creating create/Makefile
config.status: creating misc/Makefile
config.status: creating src/Makefile
config.status: creating src/libs/Makefile
config.status: creating src/libs/zbxlog/Makefile
config.status: creating src/libs/zbxcrypto/Makefile
config.status: creating src/libs/zbxconf/Makefile
config.status: creating src/libs/zbxdbcache/Makefile
config.status: creating src/libs/zbxdbhigh/Makefile
config.status: creating src/libs/zbxemail/Makefile
config.status: creating src/libs/zbxsysinfo/Makefile
config.status: creating src/libs/zbxsms/Makefile
config.status: creating src/libs/zbxjabber/Makefile
config.status: creating src/libs/zbxcommon/Makefile
config.status: creating src/libs/zbxsysinfo/common/Makefile
config.status: creating src/libs/zbxsysinfo/simple/Makefile
config.status: creating src/libs/zbxsysinfo/linux/Makefile
config.status: creating src/libs/zbxsysinfo/aix/Makefile
config.status: creating src/libs/zbxsysinfo/freebsd/Makefile
config.status: creating src/libs/zbxsysinfo/hpux/Makefile
config.status: creating src/libs/zbxsysinfo/openbsd/Makefile
config.status: creating src/libs/zbxsysinfo/osx/Makefile
config.status: creating src/libs/zbxsysinfo/solaris/Makefile
config.status: creating src/libs/zbxsysinfo/osf/Makefile
config.status: creating src/libs/zbxsysinfo/netbsd/Makefile
config.status: creating src/libs/zbxsysinfo/unknown/Makefile
config.status: creating src/libs/zbxnix/Makefile
config.status: creating src/libs/zbxplugin/Makefile
config.status: creating src/libs/zbxsys/Makefile
config.status: creating src/libs/zbxcomms/Makefile
config.status: creating src/libs/zbxdb/Makefile
config.status: creating src/libs/zbxjson/Makefile
config.status: creating src/libs/zbxserver/Makefile
config.status: creating src/libs/zbxicmpping/Makefile
config.status: creating src/zabbix_agent/Makefile
config.status: creating src/zabbix_get/Makefile
config.status: creating src/zabbix_sender/Makefile
config.status: creating src/zabbix_server/Makefile
config.status: creating src/zabbix_server/alerter/Makefile
config.status: creating src/zabbix_server/dbsyncer/Makefile
config.status: creating src/zabbix_server/discoverer/Makefile
config.status: creating src/zabbix_server/housekeeper/Makefile
config.status: creating src/zabbix_server/httppoller/Makefile
config.status: creating src/zabbix_server/nodewatcher/Makefile
config.status: creating src/zabbix_server/pinger/Makefile
config.status: creating src/zabbix_server/poller/Makefile
config.status: creating src/zabbix_server/timer/Makefile
config.status: creating src/zabbix_server/trapper/Makefile
config.status: creating src/zabbix_server/utils/Makefile
config.status: creating src/zabbix_server/watchdog/Makefile
config.status: creating src/zabbix_server/escalator/Makefile
config.status: creating src/zabbix_proxy/Makefile
config.status: creating src/zabbix_proxy/heart/Makefile
config.status: creating src/zabbix_proxy/housekeeper/Makefile
config.status: creating src/zabbix_proxy/proxyconfig/Makefile
config.status: creating src/zabbix_proxy/datasender/Makefile
config.status: creating upgrades/Makefile
config.status: creating include/config.h
config.status: include/config.h is unchanged
config.status: executing depfiles commands


Configuration:

Detected OS: freebsd7.0
Install path: /usr/local
Compilation arch: freebsd

Compiler: gcc
Compiler flags: -g -O2 -I/usr/local/include/mysql -fno-strict-aliasing -pipe -I/usr/local/include

Enable server: yes
With database: MySQL
WEB Monitoring via: cURL
Native Jabber: no
SNMP: ucd-snmp
IPMI: no
Linker flags: -L/usr/local/lib/mysql -L/usr/local/lib -lcurl -L/usr/local/lib -L/usr/local/lib -lssh2 -lssl -lcrypto -lldap -lz -L/usr/local/lib -lsnmp -lcrypto
Libraries: -lkvm -lm -ldevstat -lmysqlclient -lcurl

Enable proxy: yes
With database: MySQL
WEB Monitoring via: cURL
SNMP: ucd-snmp
IPMI: no
Linker flags: -L/usr/local/lib/mysql -L/usr/local/lib -lcurl -L/usr/local/lib -L/usr/local/lib -lssh2 -lssl -lcrypto -lldap -lz -L/usr/local/lib -lsnmp -lcrypto
Libraries: -lkvm -lm -ldevstat -lmysqlclient -lcurl

Enable agent: yes
Linker flags:
Libraries: -lkvm -lm -ldevstat

LDAP support: no
IPv6 support: no

************************************************** *********
* Now run 'make install' *
* *
* Thank you for using ZABBIX! *
* <http://www.zabbix.com> *
************************************************** *********

[InventOR]

saw the post the new version 1.6.4 - compiled with the same parameters of the source code - the result is the same.
mysql support commands is missing

[richlv]

there was no need to post whole configure output.
as for the problem, first, make sure zabbix user can execute the userparameter command.

second, -t flag unfortunately is broken for userparameters - it was fixed once, then the fix was silently reverted.
see http://www.zabbix.com/forum/showthread.php?t=11560 for more details

try telnetting to agent port and entering key

[jroberson]

you might also try:

zabbix_get -s localhost -k mysql.version

[t2y]

Hi jroberson,

you might also try:

zabbix_get -s localhost -k mysql.version

I run as follows commands. Is this mean a function of getting mysql version hasn't been implemented in zabbix-agent still?

# cat /etc/redhat-release
CentOS release 5.3 (Final)
# rpm -q zabbix-agent
zabbix-agent-1.6.4-1
# zabbix_agentd -t mysql.version
mysql.version                                 [m|ZBX_NOTSUPPORTED]
# zabbix_get -s localhost -k mysql.version
ZBX_NOTSUPPORTED

[zordio]

I believe it just runs some local commands to get mysql info. Do you have mysql.version uncommented in zabbix_agentd.conf?

[t2y]

Hi zordio,

Do you have mysql.version uncommented in zabbix_agentd.conf?

Thank you for advice. It's pithy advice. I could get mysql version.

# vi /etc/zabbix/zabbix_agentd.conf
# grep "mysql.version" /etc/zabbix/zabbix_agentd.conf
UserParameter=mysql.version,mysql -V
# service zabbix-agent restart
Shutting down zabbix agent:          [  OK  ]
Starting zabbix agent:                    [  OK  ]
# zabbix_get -s localhost -k mysql.version
mysql  Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i686) using readline 5.0
# zabbix_agentd -t mysql.version
mysql.version                                 [m|ZBX_NOTSUPPORTED]

[IvanG]

I have a similar problem with zabbix_get and zabbix_agentd

In Windows servers, I have created somer UserParameters called bkverify<something>:

UserParameter=bkverifymdaen, C:\ZabbixAgent\bkverifymdaen.bat
UserParameter=bkverifymdaen-sdw, C:\ZabbixAgent\bkverifymdaen-sdw.bat
UserParameter=bkverifyamden, C:\ZabbixAgent\bkverifyamden.bat
UserParameter=bkverifyamden-sdw, C:\ZabbixAgent\bkverifyamden-sdw.bat

I can zabbix_get from the Zabbix server:

[root@srv8 zabbix_sender]# zabbix_get -s server-store -k bkverifymdaen
0

But when I try zabbix_agentd.exe -t and the key of my UserParameter it is unsupported:

[root@srv8 zabbix_sender]# zabbix_get -s server-store -k system.run["c:\ZabbixAgent\zabbix_agentd.exe -t bkverifyen"]
bkverifyen                                    [m|ZBX_NOTSUPPORTED]

If I execute zabbix_agentd.exe -p on the agent I don't get the UserParameter, but if I telnet the agent's port and execute my UserParameter I get the correct value.
The main problem is when I configure the item (it is on Active status) and trigger I don't receive any data from this item (I checked on the overview and changing the triggers data for the data visualization).
Does anyone help me at least giving me an approach? My agent version is
1.6.4

Manny thanks!
Ivan

[richlv]

zabbix_agentd -t does not work with user parameters. but that doesn't mean anything - parameter itself will work for zabbix_get, zabbix server and everything else.
just don-t use zabbix_agentd -t for user parameter testing.

[IvanG]

Thanks for the reply, but, in that case, why the data doesn't appear on the overview, if I can zabbix_get that value correctly? I have this configuration:

Item Sybase Daily Backup DB failed
Type Zabbix agent (active)
Key bkverifymdaen
Type of information Numeric (integer 64 bit)
Update interval 30 sec
Status Active

And the trigger

Sybase Daily DB Backup failed
Expression {server-bk-acoyte:bkverifyen. last( 0 ) }=0

This only has two possible values, 1 or 0, but in the dashboard I don't see any value.

Manny thanks!
Ivan

[richlv]

forget about the trigger for now. make sure your item receives data (see monitoring - latest data for that).
see server logfile for any errors, related to that host.