When trying to compile the "server" with mysql support on RHEL 4 Update 3 using:
./configure --enable-server --with-mysql --with-net-snmp
This machine was installed using an "everything" install to ensure that all libs needed would be installed. It is a Dell PowerEdge 2850 dual Xeon with 2GB of ram using hardware raid 1.
gcc -O2 -g -pipe -m64 -o zabbix_server -L/usr/lib/mysql -L/usr/lib evalfunc.o expression.o actions.o zlog.o functions.o server.o ../libs/zbxsysinfo/libzbxsysinfo.a ../libs/zbxsysinfo/linux/libzbxsysinfo2.a ../libs/zbxlog/libzbxlog.a ../libs/zbxpid/libzbxpid.a ../libs/zbxconf/libzbxconf.a ../libs/zbxcrypto/libzbxcrypto.a ../libs/zbxnet/libzbxnet.a pinger/libzbxpinger.a poller/libzbxpoller.a housekeeper/libzbxhousekeeper.a alerter/libzbxalerter.a timer/libzbxtimer.a trapper/libzbxtrapper.a ../libs/zbxemail/libzbxemail.a ../libs/zbxdbhigh/libzbxdbhigh.a ../libs/zbxcommon/libzbxcommon.a -lmysqlclient -lm -lz -lnetsnmp -lcrypto -lresolv -lnsl
/usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
make[3]: *** [zabbix_server] Error 1
make[3]: Leaving directory `/usr/src/redhat/BUILD/zabbix-1.1beta9/src/zabbix_server'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/usr/src/redhat/BUILD/zabbix-1.1beta9/src/zabbix_server'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/src/redhat/BUILD/zabbix-1.1beta9/src'
make: *** [all-recursive] Error 1
output from rpm -qa | grep mysql
mysqlclient10-3.23.58-4.RHEL4.1
mysql-4.1.12-3.RHEL4.1
mysql-4.1.12-3.RHEL4.1
php-mysql-4.3.9-3.9
mysqlclient10-devel-3.23.58-4.RHEL4.1
mysql-server-4.1.12-3.RHEL4.1
mysqlclient10-3.23.58-4.RHEL4.1
libdbi-dbd-mysql-0.6.5-10.RHEL4.1
mysql-devel-4.1.12-3.RHEL4.1
mysql-bench-4.1.12-3.RHEL4.1
freeradius-mysql-1.0.1-3.RHEL4.3
mod_auth_mysql-2.6.1-2.2
output of gcc --version
gcc (GCC) 3.4.5 20051201 (Red Hat 3.4.5-2)
output of ld --version
GNU ld version 2.15.92.0.2 20040927
This happens for both beta8 and beta9, I have not tried any other versions.
UPDATE:
I forgot to add the output of ls -l /usr/lib/mysql so here it is
lrwxrwxrwx 1 root root 26 Apr 5 07:27 libmysqlclient_r.so.10 -> libmysqlclient_r.so.10.0.0
-rwxr-xr-x 1 root root 211004 Nov 23 2004 libmysqlclient_r.so.10.0.0
lrwxrwxrwx 1 root root 26 Apr 6 09:53 libmysqlclient_r.so.14 -> libmysqlclient_r.so.14.0.0
-rwxr-xr-x 1 root root 1144248 Aug 23 2005 libmysqlclient_r.so.14.0.0
lrwxrwxrwx 1 root root 24 Apr 5 07:27 libmysqlclient.so.10 -> libmysqlclient.so.10.0.0
-rwxr-xr-x 1 root root 207520 Nov 23 2004 libmysqlclient.so.10.0.0
lrwxrwxrwx 1 root root 24 Apr 6 09:53 libmysqlclient.so.14 -> libmysqlclient.so.14.0.0
-rwxr-xr-x 1 root root 1137364 Aug 23 2005 libmysqlclient.so.14.0.0
-rwxr-xr-x 1 root root 11060 Aug 23 2005 mysqlbug
-rwxr-xr-x 1 root root 4452 Aug 23 2005 mysql_config
Added symlink and ran ldconfig
lrwxrwxrwx 1 root root 24 Apr 24 11:28 libmysqlclient.so -> libmysqlclient.so.14.0.0
Problem still persists
UPDATE 2::
The server builds fine on FC4, and the agent builds on RHEL4, RHEL3, FC4 FC3, and ubuntu (dapper flight5) just fine.
./configure --enable-server --with-mysql --with-net-snmp
This machine was installed using an "everything" install to ensure that all libs needed would be installed. It is a Dell PowerEdge 2850 dual Xeon with 2GB of ram using hardware raid 1.
gcc -O2 -g -pipe -m64 -o zabbix_server -L/usr/lib/mysql -L/usr/lib evalfunc.o expression.o actions.o zlog.o functions.o server.o ../libs/zbxsysinfo/libzbxsysinfo.a ../libs/zbxsysinfo/linux/libzbxsysinfo2.a ../libs/zbxlog/libzbxlog.a ../libs/zbxpid/libzbxpid.a ../libs/zbxconf/libzbxconf.a ../libs/zbxcrypto/libzbxcrypto.a ../libs/zbxnet/libzbxnet.a pinger/libzbxpinger.a poller/libzbxpoller.a housekeeper/libzbxhousekeeper.a alerter/libzbxalerter.a timer/libzbxtimer.a trapper/libzbxtrapper.a ../libs/zbxemail/libzbxemail.a ../libs/zbxdbhigh/libzbxdbhigh.a ../libs/zbxcommon/libzbxcommon.a -lmysqlclient -lm -lz -lnetsnmp -lcrypto -lresolv -lnsl
/usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
make[3]: *** [zabbix_server] Error 1
make[3]: Leaving directory `/usr/src/redhat/BUILD/zabbix-1.1beta9/src/zabbix_server'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/usr/src/redhat/BUILD/zabbix-1.1beta9/src/zabbix_server'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/src/redhat/BUILD/zabbix-1.1beta9/src'
make: *** [all-recursive] Error 1
output from rpm -qa | grep mysql
mysqlclient10-3.23.58-4.RHEL4.1
mysql-4.1.12-3.RHEL4.1
mysql-4.1.12-3.RHEL4.1
php-mysql-4.3.9-3.9
mysqlclient10-devel-3.23.58-4.RHEL4.1
mysql-server-4.1.12-3.RHEL4.1
mysqlclient10-3.23.58-4.RHEL4.1
libdbi-dbd-mysql-0.6.5-10.RHEL4.1
mysql-devel-4.1.12-3.RHEL4.1
mysql-bench-4.1.12-3.RHEL4.1
freeradius-mysql-1.0.1-3.RHEL4.3
mod_auth_mysql-2.6.1-2.2
output of gcc --version
gcc (GCC) 3.4.5 20051201 (Red Hat 3.4.5-2)
output of ld --version
GNU ld version 2.15.92.0.2 20040927
This happens for both beta8 and beta9, I have not tried any other versions.
UPDATE:
I forgot to add the output of ls -l /usr/lib/mysql so here it is
lrwxrwxrwx 1 root root 26 Apr 5 07:27 libmysqlclient_r.so.10 -> libmysqlclient_r.so.10.0.0
-rwxr-xr-x 1 root root 211004 Nov 23 2004 libmysqlclient_r.so.10.0.0
lrwxrwxrwx 1 root root 26 Apr 6 09:53 libmysqlclient_r.so.14 -> libmysqlclient_r.so.14.0.0
-rwxr-xr-x 1 root root 1144248 Aug 23 2005 libmysqlclient_r.so.14.0.0
lrwxrwxrwx 1 root root 24 Apr 5 07:27 libmysqlclient.so.10 -> libmysqlclient.so.10.0.0
-rwxr-xr-x 1 root root 207520 Nov 23 2004 libmysqlclient.so.10.0.0
lrwxrwxrwx 1 root root 24 Apr 6 09:53 libmysqlclient.so.14 -> libmysqlclient.so.14.0.0
-rwxr-xr-x 1 root root 1137364 Aug 23 2005 libmysqlclient.so.14.0.0
-rwxr-xr-x 1 root root 11060 Aug 23 2005 mysqlbug
-rwxr-xr-x 1 root root 4452 Aug 23 2005 mysql_config
Added symlink and ran ldconfig
lrwxrwxrwx 1 root root 24 Apr 24 11:28 libmysqlclient.so -> libmysqlclient.so.14.0.0
Problem still persists
UPDATE 2::
The server builds fine on FC4, and the agent builds on RHEL4, RHEL3, FC4 FC3, and ubuntu (dapper flight5) just fine.