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@arcdiv.com] Sent: Monday, November 26, 2007 8:36 PM To: roayu Cc: serusers@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@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers