Problem with mysql under Mandrake 10.0

[1brej101]

Hi and sorry for my english,

My server is under Mandrake 10.0 with the RPM for mysql.
When I try to install Zabbix with the option --with-mysql, the program stop with the error " unable to find mysql.h"

What can I do ?

Thanks.

[LEM]

Seems it lack you some headers for MySQL. Does a pacakage named myslq*[dev,lib]* exist with MDK 10.0 ? If so, just install it.

[1brej101]

Mysql is installed and I use it every days.

[Alexei]

You must have MySQL development packages installed. The packages provide both include (*.h) and library files.

Have a look at ZABBIX Manual, it contains list of third-party software ZABBIX depends on.

[1brej101]

OK, I find and install it.
Compile is ok, but during 'make', I receive the following message '/usr/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0xbc): In function 'my_compress_alloc': undefined reference to 'compress', and the same with (.text+0x13a): In function 'my_uncompress'.

[Alexei]

Check this:

http://sourceforge.net/forum/message.php?msg_id=1612870

Please post your src/zabbix_sucker/Makefile.

[mtownsen]

Here is my build file that I just created under Mandrake 10.1:

----
# Build rules

INCLUDE = -I/usr/include/mysql -I/usr/include
LIBS = -lnsl -L/usr/lib/mysql -lmysqlclient -lm -lz -L/usr/lib -lnetsnmp

all:

gcc -o ../../bin/zabbix_suckerd -g -O2 -I../../include $(INCLUDE) zabbix_sucker.c ../../include/db.c ../../include/functions.c ../../include/expression.c ../../include/cfg.c ../../include/log.c ../../include/security.c ../../include/pid.c ../../include/snprintf.c ../zabbix_agent/sysinfo.c alerter.c pinger.c housekeeper.c -Wall $(LIBS)

clean:
rm -f *.o
rm -f ../../bin/zabbix_suckerd
----

This is the error I am getting:

----
In file included from ../../include/db.h:26,
from zabbix_sucker.c:59:
../../include/config.h:232:1: warning: "PACKAGE_TARNAME" redefined
In file included from zabbix_sucker.c:46:
/usr/include/net-snmp/net-snmp-config.h:880:1: warning: this is the location of the previous definition
In file included from ../../include/db.h:26,
from zabbix_sucker.c:59:
../../include/config.h:235:1: warning: "PACKAGE_VERSION" redefined
In file included from zabbix_sucker.c:46:
/usr/include/net-snmp/net-snmp-config.h:883:1: warning: this is the location of the previous definition
/usr/lib/libnetsnmp.so: undefined reference to `EVP_DigestInit'
/usr/lib/libnetsnmp.so: undefined reference to `EVP_DigestFinal'
/usr/lib/libnetsnmp.so: undefined reference to `EVP_DigestFinal_ex'
/usr/lib/libnetsnmp.so: undefined reference to `AES_set_encrypt_key'
/usr/lib/libnetsnmp.so: undefined reference to `EVP_md5'
/usr/lib/libnetsnmp.so: undefined reference to `HMAC'
/usr/lib/libnetsnmp.so: undefined reference to `EVP_MD_CTX_cleanup'
/usr/lib/libnetsnmp.so: undefined reference to `SSLeay'
/usr/lib/libnetsnmp.so: undefined reference to `EVP_sha1'
/usr/lib/libnetsnmp.so: undefined reference to `EVP_MD_CTX_init'
/usr/lib/libnetsnmp.so: undefined reference to `EVP_DigestUpdate'
/usr/lib/libnetsnmp.so: undefined reference to `RAND_bytes'
/usr/lib/libnetsnmp.so: undefined reference to `DES_cbc_encrypt'
/usr/lib/libnetsnmp.so: undefined reference to `DES_ncbc_encrypt'
/usr/lib/libnetsnmp.so: undefined reference to `DES_key_sched'
/usr/lib/libnetsnmp.so: undefined reference to `AES_cfb128_encrypt'
collect2: ld returned 1 exit status
make[1]: *** [all] Error 1
make[1]: Leaving directory `/home/mark/tmp/zabbix-1.0/src/zabbix_sucker'
make: *** [all] Error 1
----

Any help would be appreciated. I look forward to trying out this great looking tool!