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

[Daniel-Constantin Mierla]

Hello,

should not be a problem to compile and run on opensuse. Can you pull 
latest git branch kamailio_3.0 and try again? Hints at:
http://www.kamailio.org/dokuwiki/doku.php/install:kamailio-3.0.x-from-git

There were some files missing the logging include, hope will solve it -- 
on debian it was not reported so far. Let me know if works now on opensuse.

Thanks,
Daniel


On 4/13/10 3:04 PM, 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
>
> And for sure the capital 'U' means undefined. I have also searched the
> source code that came with the kamailio package, for definitions of
> 'log'. And it also looks like I'll be in trouble later for
> log_level_info, log_level_stderr and syslog are undefined too. However,
> log_level_info I have just found in source files in the kamailio
> package. So, why isn't it linking in?
>
> Unfortunately, searching on the internet I have not yet come across a
> forum post that tackles the above issue. As, I suspect everyone else has
> got the build right.
>
> Have I built db_mysql.so incorrectly? Though I built it using the make
> files that came with the package.
>
> Is it a case of linking in the appropriate libraries to resolve these
> undefined symbols?
>
> Finally, I have a colleague who has used the same version of kamailio
> but installed on a Debian lenny distro. He has been successful in
> getting db_mysql loaded and persistence enabled. However, he has an
> older version of mysql (by only one minor-version number) though. Having
> looked that the changes' history for the two mysql versions, I see no
> obvious reasons that could be the cause of my failure.
>
> By comparing notes, he did nothing too different than I did. We both
> followed the instructions in the INSTALL and README files.
>
> There is no particular reason for me using OpenSuSE 10 other than it was
> already installed and the computer was not being used by anyone. I am
> considering installing Debian Lenny on my computer to match my
> colleague, would this be prudent or a waste of time? i.e I may face my
> same problem because I'm missing a stage?
>
> Regards and thank you, in advance, for any help given.
>
> Pratab
>
>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>    

-- 
Daniel-Constantin Mierla * http://www.asipto.com/ * 
http://twitter.com/miconda * 
http://www.linkedin.com/in/danielconstantinmierla