Library "ulogd_MYSQL.so" should be linked to "libmysqlclient.so"

[Anderson]

Binary package hint: ulogd-mysql

I know "ulogd" is a software from Universe, but... I need it. And I think this bug can be easily fixed by a package developer...

I just upgraded an server from Ubuntu Hardy to Ubuntu Intrepid and now, MySQL plugin in ULOG does not work because of an undefined symbol:

# invoke-rc.d ulogd start
Starting netfilter userspace log daemon: Fri Oct 31 00:32:09 2008 <3> ulogd.c:308 registering interpreter `raw'
Fri Oct 31 00:32:09 2008 <3> ulogd.c:308 registering interpreter `oob'
Fri Oct 31 00:32:09 2008 <3> ulogd.c:308 registering interpreter `ip'
Fri Oct 31 00:32:09 2008 <3> ulogd.c:308 registering interpreter `tcp'
Fri Oct 31 00:32:09 2008 <3> ulogd.c:308 registering interpreter `icmp'
Fri Oct 31 00:32:09 2008 <3> ulogd.c:308 registering interpreter `udp'
Fri Oct 31 00:32:09 2008 <3> ulogd.c:308 registering interpreter `ahesp'
Fri Oct 31 00:32:09 2008 <3> ulogd.c:308 registering interpreter `local'
Fri Oct 31 00:32:09 2008 <3> ulogd.c:363 registering output `syslogemu'
Fri Oct 31 00:32:09 2008 <7> ulogd.c:462 load_plugins: '/usr/lib/ulogd/ulogd_MYSQL.so': /usr/lib/ulogd/ulogd_MYSQL.so: undefined symbol: mysql_fetch_field
ulogd.

--------------

When preloading /usr/lib/libmysqlclient.so, the plugin works:

# env LD_PRELOAD=/usr/lib/libmysqlclient.so invoke-rc.d ulogd start
Starting netfilter userspace log daemon: Fri Oct 31 00:32:18 2008 <3> ulogd.c:308 registering interpreter `raw'
Fri Oct 31 00:32:18 2008 <3> ulogd.c:308 registering interpreter `oob'
Fri Oct 31 00:32:18 2008 <3> ulogd.c:308 registering interpreter `ip'
Fri Oct 31 00:32:18 2008 <3> ulogd.c:308 registering interpreter `tcp'
Fri Oct 31 00:32:18 2008 <3> ulogd.c:308 registering interpreter `icmp'
Fri Oct 31 00:32:18 2008 <3> ulogd.c:308 registering interpreter `udp'
Fri Oct 31 00:32:18 2008 <3> ulogd.c:308 registering interpreter `ahesp'
Fri Oct 31 00:32:18 2008 <3> ulogd.c:308 registering interpreter `local'
Fri Oct 31 00:32:18 2008 <3> ulogd.c:363 registering output `syslogemu'
Fri Oct 31 00:32:18 2008 <3> ulogd.c:363 registering output `mysql'
ulogd.

[Victor Stinner (vstinner)]

I have the same problem (ulogd.c... load_plugins... ulogd_MYSQL.so... undefined symbol: mysql_fetch_field).

Ubuntu source package contains a patch specific to Ubuntu about the MySQL module:
--------------------------- 8< ------------------------
--- ulogd-1.24/mysql/Makefile.in 2005-11-25 20:58:27.000000000 +0100
(...)
 SHARED_LIBS=ulogd_MYSQL.so

+# fix the LDFLAGS included in MYSQL_LDFLAGS
+MYSQL_LDFLAGS:=$(shell echo $(MYSQL_LDFLAGS) | sed s/-Wl,//;s/-rpath//)
+

(...)
--------------------------- 8< ------------------------

First remark: I don't understand how the sed can work because ";" is the separator for shell commands. It should be >sed 's/-Wl,//;s/-rpath//'<.

The command "mysql_config --libs" creates arguments for gcc, not for ld program:
--------------------------- 8< ------------------------
$ mysql_config --libs
-Wl,-Bsymbolic-functions -rdynamic -L/usr/lib/mysql -lmysqlclient
--------------------------- 8< ------------------------

It looks like -rdynamic causes a link problem (bad -rpath option).

I don't know ld/gcc/dlopen options very well, but I'm sure that ulogd_MYSQL.so have to linked to libmysqlclient.so.15. Example on Ubuntu Ibex :
$ ldd /usr/lib/ulogd/ulogd_MYSQL.so
 linux-gate.so.1 => (0xb7f48000)
 libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0xb7dd5000)
 /lib/ld-linux.so.2 (0xb7f49000)

Example on Debian Lenny:
$ ldd /usr/lib/ulogd/ulogd_MYSQL.so
 linux-gate.so.1 => (0xb7f98000)
 libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15 (0xb7db4000)

The bug is still open since 3 months, why? Do you need more informations? The package is compiled correctly on Debian.

[KBios (kbios)]

Confirmed on Ubuntu server amd64.
Thanks for the workaround, I didn't know what to do!

[LGB [Gábor Lénárt] (lgb)]

I can confirm this too, with Ubuntu 9.04 server on x86_64 arch. I also used the LD_PRELOAD trick to make it work, but I think this bug should be fixed, otherwise this package is totally unusable and broken.

Version of the package (ulogd-mysql): 1.24-2.1ubuntu2

Tue Jun 16 09:32:55 2009 <7> ulogd.c:462 load_plugins: '/usr/lib/ulogd/ulogd_MYSQL.so': /usr/lib/ulogd/ulogd_MYSQL.so: undefined symbol: mysql_fetch_field

[Simon Engelsman (simon-engelsman)]

Confirmed on Ubuntu 9.10

ulogd 1.24-2.1ubuntu2
ulogd-mysql 1.24-2.1ubuntu2

When starting ulogd with the MySQL plugin enabled:
...
ulogd.c:462 load_plugins: '/usr/lib/ulogd/ulogd_MYSQL.so': /usr/lib/ulogd/ulogd_MYSQL.so: undefined symbol: mysql_fetch_field
...

Worked around it by adding:

export LD_PRELOAD=/usr/lib/libmysqlclient.so.16

to the ulogd init script (/etc/init.d/ulogd)