zabbix 1.7 rev. 7202 compile problem

[mvrk]

Hi, i've downloaded today rev 7202 of zabbix 1.7 and i get an error compiling on CentOS 5.3 (x86):

make[3]: Entering directory `/usr/src/redhat/BUILD/zabbix-1.7/src/zabbix_server/poller'
gcc -DHAVE_CONFIG_H -I. -I../../../include -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables -I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing -fwrapv -I/usr/include -I/usr/include/rpm -I/usr/local/include -I/usr/include/gdbm -I/usr/lib/perl5/5.8.8/i386-linux-thread-multi/CORE -I. -I/usr/include/net-snmp -I/usr/include -MT checks_agent.o -MD -MP -MF .deps/checks_agent.Tpo -c -o checks_agent.o checks_agent.c
mv -f .deps/checks_agent.Tpo .deps/checks_agent.Po
gcc -DHAVE_CONFIG_H -I. -I../../../include -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables -I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing -fwrapv -I/usr/include -I/usr/include/rpm -I/usr/local/include -I/usr/include/gdbm -I/usr/lib/perl5/5.8.8/i386-linux-thread-multi/CORE -I. -I/usr/include/net-snmp -I/usr/include -MT checks_internal.o -MD -MP -MF .deps/checks_internal.Tpo -c -o checks_internal.o checks_internal.c
mv -f .deps/checks_internal.Tpo .deps/checks_internal.Po
gcc -DHAVE_CONFIG_H -I. -I../../../include -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables -I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing -fwrapv -I/usr/include -I/usr/include/rpm -I/usr/local/include -I/usr/include/gdbm -I/usr/lib/perl5/5.8.8/i386-linux-thread-multi/CORE -I. -I/usr/include/net-snmp -I/usr/include -MT checks_simple.o -MD -MP -MF .deps/checks_simple.Tpo -c -o checks_simple.o checks_simple.c
mv -f .deps/checks_simple.Tpo .deps/checks_simple.Po
gcc -DHAVE_CONFIG_H -I. -I../../../include -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables -I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing -fwrapv -I/usr/include -I/usr/include/rpm -I/usr/local/include -I/usr/include/gdbm -I/usr/lib/perl5/5.8.8/i386-linux-thread-multi/CORE -I. -I/usr/include/net-snmp -I/usr/include -MT checks_snmp.o -MD -MP -MF .deps/checks_snmp.Tpo -c -o checks_snmp.o checks_snmp.c
mv -f .deps/checks_snmp.Tpo .deps/checks_snmp.Po
gcc -DHAVE_CONFIG_H -I. -I../../../include -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables -I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing -fwrapv -I/usr/include -I/usr/include/rpm -I/usr/local/include -I/usr/include/gdbm -I/usr/lib/perl5/5.8.8/i386-linux-thread-multi/CORE -I. -I/usr/include/net-snmp -I/usr/include -MT checks_db.o -MD -MP -MF .deps/checks_db.Tpo -c -o checks_db.o checks_db.c
checks_db.c: In function 'get_value_db':
checks_db.c:162: warning: passing argument 3 of 'set_result_type' makes integer from pointer without a cast
checks_db.c:162: error: too few arguments to function 'set_result_type'
make[3]: *** [checks_db.o] Error 1
make[3]: Leaving directory `/usr/src/redhat/BUILD/zabbix-1.7/src/zabbix_server/poller'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/usr/src/redhat/BUILD/zabbix-1.7/src/zabbix_proxy'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/src/redhat/BUILD/zabbix-1.7/src'
make: *** [all-recursive] Error 1

[toomasp]

same in pre-zabbix-1.7-7620.tar.g

gcc -DHAVE_CONFIG_H -I. -I../../../include -g -O2 -I/usr/include/mysql -DBIG_JOINS=1 -fPIC -I/usr/include -I/usr/local/include -I/usr/lib/perl/5.10/CORE -I. -I/usr/include -I/usr/include -MT checks_db.o -MD -MP -MF .deps/checks_db.Tpo -c -o checks_db.o checks_db.c
checks_db.c: In function āget_value_dbā:
checks_db.c:162: warning: passing argument 3 of āset_result_typeā makes integer from pointer without a cast
checks_db.c:162: error: too few arguments to function āset_result_typeā
make[3]: *** [checks_db.o] Error 1
make[3]: Leaving directory `/tmp/zabbix-1.7/src/zabbix_server/poller'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/tmp/zabbix-1.7/src/zabbix_server'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/tmp/zabbix-1.7/src'
make: *** [all-recursive] Error 1

[rizwank]

Same problem - it's unix-odbc

Same problem with Alpha 1.7.1

gcc -DHAVE_CONFIG_H -I. -I../../../include -g -O2 -I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing -fwrapv -I/usr/include -I/usr/include/rpm -I/usr/local/include -I/usr/include/gdbm -I/usr/lib/perl5/5.8.8/i386-linux-thread-multi/CORE -I. -I/usr/include/net-snmp -I/usr/include -MT checks_db.o -MD -MP -MF .deps/checks_db.Tpo -c -o checks_db.o checks_db.c
checks_db.c: In function ‘get_value_db’:
checks_db.c:162: warning: passing argument 3 of ‘set_result_type’ makes integer from pointer without a cast
checks_db.c:162: error: too few arguments to function ‘set_result_type’


Thanks for
./configure --enable-server --with-mysql --with-net-snmp --enable-agent --with-jabber --with-openipmi --with-unixodbc --enable-agent

[rizwank@tardis zabbix-1.7.1]$ rpm -qa | grep tds
docbook-dtds-1.0-30.1
freetds-0.64-11.el5.centos
freetds-devel-0.64-11.el5.centos
[rizwank@tardis zabbix-1.7.1]$ rpm -qa | grep mysql
mysql-5.0.45-7.el5
mysql-connector-odbc-3.51.12-2.2
perl-DBD-mysql-4.008-1.el5.rf
mysql-server-5.0.45-7.el5
php-mysql-5.1.6-20.el5_2.1
libdbi-dbd-mysql-0.8.1a-1.2.2
mysql-devel-5.0.45-7.el5

switch out --unix-odbc and it works fine.

[primos]

Proposal

Looking at other usages, 4 params are needed for function set_result_type in checks_db.c

So corrected the file src/zabbix_server/poller/checks_db.c in line 162 :

if (SUCCEED == set_result_type(result, item->value_type, row[0]))
->
if (SUCCEED == set_result_type(result, item->value_type, item->data_type, row[0]))


... because I need the unixODBC, just hope it works.

lp, Primož

[richlv]

could you report this problem on the tracker ? thanks.

[primos]

Problem is that one child dies after couple minutes, could be related, or some misconfiguration of the unixODBC & Oracle.
... still working on it.

[rizwank]

The compile does work, however.