mysql support with 1.1alpha12

[jpawlowski]

Hi there!

mysql support seems to have changed in the current version: I cannot use my old style for the configuration parameter of "configure" which is:

--with-mysql=/usr/local/mysql/current

The path is a symlink to the current directory of mysql (/usr/local/mysql/4.1.11). After running the configure script the Makefile contains the correct path to the mysqlclient lib (/usr/local/mysql/current/lib/mysql) and in this path a symlink named libmysqlclient.so.14 (which goes to libmysqlclient.so.14.0.0) exists.
so everything should be fine but I get this startup failure:

/usr/local/zabbix/current/bin/zabbix_server: error while loading shared libraries: libmysqlclient.so.14: cannot open shared object file: No such file or directory

how can i solve this problem?

[primos]

I compiled --with-mysql without the path as before when I changed my DB to MYSQL 4.1.13 on my SLES 9 box, and no problems what so ever!!


Maybe if you try adding all the libs before ./configure and perhaps adding --enable-static

LDLIBS=-lenlibs LDFLAGS=-L/path/to/my/libs ./configure ... --enable-static


or editing /etc/ld.so.conf to include all the thing you need

# ldconfig ; to refresh

and try again!

My *.so needs for server

linux-gate.so.1 => (0xffffe000)
libmysqlclient.so.12 => /usr/lib/libmysqlclient.so.12 (0x40032000)
libm.so.6 => /lib/tls/libm.so.6 (0x40068000)
libz.so.1 => /lib/libz.so.1 (0x4008a000)
libsnmp.so.5 => /usr/lib/libsnmp.so.5 (0x4009b000)
libcrypto.so.0.9.7 => /usr/lib/libcrypto.so.0.9.7 (0x40124000)
libnetsnmp.so.5 => /usr/lib/libnetsnmp.so.5 (0x40214000)
libresolv.so.2 => /lib/libresolv.so.2 (0x4029e000)
libnsl.so.1 => /lib/libnsl.so.1 (0x402b0000)
libc.so.6 => /lib/tls/libc.so.6 (0x402c5000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x403da000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
libdl.so.2 => /lib/libdl.so.2 (0x4040b000)

[jpawlowski]

I compiled --with-mysql without the path as before when I changed my DB to MYSQL 4.1.13 on my SLES 9 box, and no problems what so ever!!I need the direct program path because I do not have my installation in the default directory (as I do not want to have all the files thrown out all over the directories and I can handle the versions in a very better way if I do not).

Maybe if you try adding all the libs before ./configurethose flag definitions are still correct in the Makefile.

and perhaps adding --enable-staticI do not want to have static binaries because it would make a lot of more work to update the system. by the way you even need the libraries once to compile a static version :-)

My *.so needs for servermy binary does in a similar way...

[primos]

I see you have given it some time.Sorry to waste your time reading my post, I've tried to help.

ps Maybe zabbix cannot follow link!

[jpawlowski]

I used the 1.1alpha10 before and that worked fine.
now i got it working with symlinking that .so-file directly to the directory /usr/lib (although I have an link from /usr/lib/mysql to /usr/local/mysql/current/lib/mysql ...)

strange behavior

[primos]

I guess you are missing in /etc/ld.so.conf your mysql libs path, correct it then ldconfig should make os aware of the change!

[jpawlowski]

no I don't want to edit this file all the time. that's why I give the correct path as a parameter to the configure script.

[grabber]

I am encoutering the same problem....any further suggestions?