Strange bacula ld-elf behaviour

[Clemens Renner]

Hi everyone,

I'm experiencing a strange behaviour of the bacula-server port. Bacula
all in all consists of three services, the file daemon (FD), the storage
daemon (SD) and the director (DIR). The FD is part of the bacula-client
port; SD and DIR are provided with the bacula-server port.

I'm using FreeBSD 6.1 (before that 6.0 and before that 5.4 with the same
issue) and MySQL 4.1 as the database backend.

Here's some info:

root at xerxes:~# pkg_info | grep bacula
bacula-client-1.38.9 The network backup solution (client)
bacula-server-1.38.9 The network backup solution (server)

root at xerxes:~# pkg_info | grep mysql
mysql-client-4.1.19 Multithreaded SQL database (client)
mysql-server-4.1.19 Multithreaded SQL database (server)


Now, the funny thing is that after a while, ldd gives strange results
for bacula-dir:

root at xerxes:/usr/local/sbin# ldd bacula-dir
bacula-dir:
        libmysqlclient_r.so.14 => not found (0x0)        <------ !!
        libz.so.3 => /lib/libz.so.3 (0x28101000)
        libpthread.so.2 => /usr/lib/libpthread.so.2 (0x28116000)
        libxpg4.so.3 => /usr/lib/libxpg4.so.3 (0x28140000)
        libintl.so.6 => /usr/local/lib/libintl.so.6 (0x28142000)
        libwrap.so.4 => /usr/lib/libwrap.so.4 (0x2814c000)
        libiconv.so.3 => /usr/local/lib/libiconv.so.3 (0x28153000)
        libstdc++.so.5 => /usr/lib/libstdc++.so.5 (0x28243000)
        libm.so.4 => /lib/libm.so.4 (0x28320000)
        libc.so.6 => /lib/libc.so.6 (0x2833a000)

Specifically, when starting the DIR via the start script (old or new,
doesn't matter), the following is said:
/libexec/ld-elf.so.1: Shared object "libmysqlclient_r.so.14" not found,
required by "bacula-dir"

Notice that the mysql client library appears to be unavailable although
it does exist in  /usr/local/lib/mysql and other binaries seem to find it:

# ldd /usr/local/bin/mysql
/usr/local/bin/mysql:
        libreadline.so.6 => /lib/libreadline.so.6 (0x2808c000)
        libncurses.so.6 => /lib/libncurses.so.6 (0x280c2000)
        libmysqlclient.so.14 =>
/usr/local/lib/mysql/libmysqlclient.so.14 (0x2810d000)    <------ !!
        libcrypt.so.3 => /lib/libcrypt.so.3 (0x28177000)
        libz.so.3 => /lib/libz.so.3 (0x28191000)
        libstdc++.so.5 => /usr/lib/libstdc++.so.5 (0x281a6000)
        libm.so.4 => /lib/libm.so.4 (0x28283000)
        libc.so.6 => /lib/libc.so.6 (0x2829d000)

If I make deinstall install the mysql41-client port, the problem goes
away -- but only for a while! And after some time, usually a few days,
the same issue recurs.

This is really strange behaviour and I've tried about everything I could
think of. Suggestions?

Clemens