[SR-Users] Failure to load module db_mysql.so due to undefined symbol: log

[Pratab Ali]

Hello

My version of libmysqlclient was installed from this file
MySQL-client-community-5.1.43-1.sles10.i586.rpm. So, that'd make it
version 5.1.43.1 I'd guess.

Unfortunately, it is the config file parser that is detecting the
unresolved symbol and so refusing to run kamailio at all.

Thanks
Pratab

-----Original Message-----
From: marius zbihlei [mailto:marius.zbihlei at 1and1.ro] 
Sent: 14 April 2010 14:07
To: Pratab Ali
Cc: sr-users at lists.sip-router.org
Subject: Re: [SR-Users] Failure to load module db_mysql.so due to
undefined symbol: log

Pratab Ali wrote:
> Hello,
>  
> I have installed from source version 3.0.1 of Kamailio on an OpenSuSE 
> 10 Linux system.
>  
> Currently I am attempting to enable persistence in my Kamailio with 
> the help of MySQL.
>  
> In the config file kamailio.cfg I have enabled MySQL as follows
>  
>             #!define WITH_MYSQL
>  
> In the config file db_mysql.so is the first module to be loaded by 
> calling loadmodule, but the module fails to load.
>
> By turning, Kamailio, debugging on I get the following explanation.
>  
>  0(9858) DEBUG: <core> [sr_module.c:382]: load_module: trying to load 
> </usr/local/lib/kamailio/modules/db_mysql.so>
>  0(9858) ERROR: <core> [sr_module.c:390]: ERROR: load_module: could 
> not open module </usr/local/lib/kamailio/modules/db_mysql.so>:
> /usr/local/lib/kamailio/modules/db_mysql.so: undefined symbol: log
>
> Using the unix/linux tool 'nm' I see the following.
>
> 	mindy:~/tmp # nm /usr/local/lib/kamailio/modules/db_mysql.so  |
grep 
> log
>       	   U getlogin@@GLIBC_2.0
> 	         U log
> 	001a6e40 R log_10
> 	001e5d00 D log_10_int
> 	         U log_level_info
> 	         U log_stderr
> 	         U syslog@@GLIBC_2.0
>   

> Hello

> What libmysqlclient are you using? I can't seem to find anywhere where
this log_10_int is declared . It seems to > be related to mysql server
(my_date.h)...

> Can you go to /usr/include/mysql a do a grep for this...

> There are ok to be Undefined variables in the module.so . They will be
resolved by the linker when dlopen is called.

> Marius