FC3 X86_64 and latest beta compile problem

[grabber]

I am having maor hairloss due to this.

can anyone please help.

gcc -g -O2 -o zabbix_server -L/usr/lib/mysql -lmysqlclient -lm -lz -L/usr/lib -lnetsnmp -lcrypto evalfunc.o expression.o actions.o zlog.o functions.o server.o ../libs/zbxsysinfo/libzbxsysinfo.a ../libs/zbxlog/libzbxlog.a ../libs/zbxpid/libzbxpid.a ../libs/zbxconf/libzbxconf.a ../libs/zbxdbhigh/libzbxdbhigh.a ../libs/zbxcrypto/libzbxcrypto.a ../libs/zbxnet/libzbxnet.a pinger/libzbxpinger.a poller/libzbxpoller.a escalator/libzbxescalator.a housekeeper/libzbxhousekeeper.a alerter/libzbxalerter.a timer/libzbxtimer.a trapper/libzbxtrapper.a ../libs/zbxemail/libzbxemail.a ../libs/zbxcommon/libzbxcommon.a -lresolv -lnsl
/usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
make[3]: *** [zabbix_server] Error 1
make[3]: Leaving directory `/root/zabbix-1.1beta1/src/zabbix_server'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/root/zabbix-1.1beta1/src/zabbix_server'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/root/zabbix-1.1beta1/src'
make: *** [all-recursive] Error 1

Is the end of the "make"

my compile line is

./configure --with-mysql --with-net-snmp --enable-server --enable-agent

I have tried both

ln -s /usr/lib64/libmysqlclient.so.14.0.0 /usr/lib/mysql/libmysqlclient.so

and

ln -s /usr/lib/libmysqlclient.so.14.0.0 /usr/lib/mysql/libmysqlclient.so

I have installed mysql, net-snmp and the devel packages from rpm and also tried from source with the latest versions.

still no joy.

[James Wells]

Greetings,

Right off the bat, I suspect that you don't have the mysql-client and mysql-devel packages installed.

[grabber]

[root@peng12-int ~]# rpm -qa |grep mysql
mysql-3.23.58-16.FC3.1
mysql-server-3.23.58-16.FC3.1
mysql-devel-3.23.58-16.FC3.1
php-mysql-4.3.11-2.7
mysql-3.23.58-16.FC3.1

That looks like it is installed

[James Wells]

Hmmm, okay, check out;
/usr/lib/libmysqlclient.so.*

Make sure it is;
/usr/lib/libmysqlclient.so.14.0.0

If not, recreate your symbolic link with the correct libmysqlclient version.

[grabber]

Hmmm, okay, check out;
/usr/lib/libmysqlclient.so.*

Make sure it is;
/usr/lib/libmysqlclient.so.14.0.0

If not, recreate your symbolic link with the correct libmysqlclient version.

you were right...I was being a lile lazy it was so.10 not 14

I changed it to .10 bt it still did not work.....

so I now have

[root@peng12-int zabbix-1.1beta1]# ls -l /usr/lib/mysql/
total 464
lrwxrwxrwx 1 root root 26 Oct 10 17:20 libmysqlclient_r.so.10 -> libmysqlclient_r.so.10.0.0
-rwxr-xr-x 1 root root 211036 Apr 2 2005 libmysqlclient_r.so.10.0.0
lrwxrwxrwx 1 root root 33 Oct 11 11:45 libmysqlclient.so -> /usr/lib/libmysqlclient.so.10.0.0
lrwxrwxrwx 1 root root 24 Oct 10 17:20 libmysqlclient.so.10 -> libmysqlclient.so.10.0.0
-rwxr-xr-x 1 root root 207520 Apr 2 2005 libmysqlclient.so.10.0.0
-rwxr-xr-x 1 root root 10732 Apr 2 2005 mysqlbug
-rwxr-xr-x 1 root root 3059 Apr 2 2005 mysql_config

AHA!!!!

I now get a different error

more undefined references to `mysql_free_result' follow

changed it to: (because it is running on Opteron)

ln -s /usr/lib64/mysql/libmysqlclient.so.10.0.0 /usr/lib/mysql/libmysqlclient.so

and get:

/usr/bin/ld: skipping incompatible /usr/lib/libm.so when searching for -lm
/usr/bin/ld: skipping incompatible /usr/lib/libm.a when searching for -lm
/usr/bin/ld: skipping incompatible /usr/lib/libz.so when searching for -lz
/usr/bin/ld: skipping incompatible /usr/lib/libz.a when searching for -lz
/usr/bin/ld: skipping incompatible /usr/lib/libnetsnmp.a when searching for -lnetsnmp
/usr/bin/ld: skipping incompatible /usr/lib/libresolv.so when searching for -lresolv
/usr/bin/ld: skipping incompatible /usr/lib/libresolv.a when searching for -lresolv
/usr/bin/ld: skipping incompatible /usr/lib/libnsl.so when searching for -lnsl
/usr/bin/ld: skipping incompatible /usr/lib/libnsl.a when searching for -lnsl
/usr/bin/ld: skipping incompatible /usr/lib/libc.so when searching for -lc
/usr/bin/ld: skipping incompatible /usr/lib/libc.a when searching for -lc
make[3]: Leaving directory `/root/zabbix-1.1beta1/src/zabbix_server'
make[2]: Leaving directory `/root/zabbix-1.1beta1/src/zabbix_server'
make[2]: Entering directory `/root/zabbix-1.1beta1/src'
make[2]: Nothing to be done for `all-am'.
make[2]: Leaving directory `/root/zabbix-1.1beta1/src'
make[1]: Leaving directory `/root/zabbix-1.1beta1/src'
make[1]: Entering directory `/root/zabbix-1.1beta1'
make[1]: Nothing to be done for `all-am'.
make[1]: Leaving directory `/root/zabbix-1.1beta1'

[James Wells]

Okay, now that is starting to make sense.

You have what appears to be two problems;
1. Your version of MySQL is too old, MySQL3 vs MySQL4. IIRC, Zabbix 1.1 requires MySQL 4.
2. The version of MySQL client you have is incompatible with your base OS. My first guess is that your base OS is built for i386/i686, while the version of MySQL you have is build for AMD64. At present this will not work as the two are compiled with completely different versions of the base libs.

[grabber]

Okay, now that is starting to make sense.

You have what appears to be two problems;
1. Your version of MySQL is too old, MySQL3 vs MySQL4. IIRC, Zabbix 1.1 requires MySQL 4.
2. The version of MySQL client you have is incompatible with your base OS. My first guess is that your base OS is built for i386/i686, while the version of MySQL you have is build for AMD64. At present this will not work as the two are compiled with completely different versions of the base libs.

I understand what you are saying and it all makes sense. This is a default install of FC3 with updates. I tried 1.0 but it failed to even run "make".

having a further look it seems that FC3 installed both i386 versions as well as x86_64, a real mess

I'm going to try mandriva and see how that goes.

Thanks for your help....so far

[grabber]

So I installed Mandriva 2005 and with the minimum of fuss have it all up and running.

Thanks James for all your help.

[James Wells]

So I installed Mandriva 2005 and with the minimum of fuss have it all up and running.

AWESOME. Gald it worked out for you.

[bing]

known bug

Im quoting someone else here....

This is a known bug in these packages, which will be resolved with the next version. You should be able to use the 5.0.15 shared library package instead. The client libs don't change that often, so using a previous version should not harm. In fact, you might not even need the shared libs at all - the MySQL-server and MySQL-client RPMs don't depend on it.