[Serusers] Can SER support MySQL 5.0.22

[roayu]

Hi,

I managed to create the mysql.so after re-intall the MySQL, especially the
mysql-dev package.

Thanks for your help!

Roa Yu

-----Original Message-----
From: SIP [mailto:sip at arcdiv.com] 
Sent: Monday, November 26, 2007 8:36 PM
To: roayu
Cc: serusers at lists.iptel.org
Subject: Re: [Serusers] Can SER support MySQL 5.0.22

First off, do you have the mysql-dev package installed?


As for whether or not it will run with mysql 5.0.22, it can, but it's 
tricky.  The makefile for the mysql module doesn't look everywhere for 
the libmysqlclient libs when it's compiling. It expects the libs to be 
in a particular place, and if they're not there, it ignores the libpath, 
compiles ANYway, and they just fails to work once you start up SER. It 
gives NO errors on compile, which makes it utterly difficult to track down.

The latest RPMs for RHEL/CentOS from the MySQL community site place the 
libmysqlclient.so.X libs into /usr/lib and NOT /usr/lib/mysql as SER 
expects.

SER will simply NOT find it in that location. What we've ended up having 
to do is symlinking the /usr/lib/libmysqlclient* into /usr/lib/mysql, 
recompile the mysql module, and install it in the correct place. Then, 
SER runs happily and readily without weird errors.

Also note that there is a patch that must be applied to use MySQL 5.0.X 
for SER 0.9.6

see 
http://www.iptel.org/faq/why_does_my_mysql_5_0_x_connection_time_out_when_us
ing_ser_0_9_x


N.

roayu wrote:
>
> Hi there!
>
>  
>
> Would like to ask, can SER 0.9.6 support MySQL 5.0.22 ? I got the 
> following errors when I tried start SER and to connect to MySQL:
>
>  
>
> [root at localhost ~]# /usr/local/sbin/ser
>
>  0(3291) ERROR: load_module: could not open module 
> </usr/local/lib/ser/modules/mysql.so>: libmysqlclient.so.14: cannot 
> open shared object file: No such file or directory
>
>  0(3291) parse error (31,13-14): failed to load module
>
> ERROR: bad config file (1 errors)
>
>  
>
>  
>
> Thanks.
>
>  
>
> Roa Yu
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Serusers mailing list
> Serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>