See my post...
Good luck
Gwen
---------------------------- Message original ----------------------------
Objet: RE: [Serusers] could not open module mysql.so
De: g.billoudet@arwen-tech.fr
Date: Ven 10 septembre 2004 15:04
À: g.billoudet@arwen-tech.fr
Copie à: "Zeus Ng" zeus.ng@isquare.com.au
serusers@lists.iptel.org
--------------------------------------------------------------------------
I finally found the solution...
First, I don't know why but I had a strange link file
(libmysqlclient.so.10) in my folder /usr/local/lib/ser/modules. I deleted
it and then I got the following result of the command "ldd mysql.so" :
linux-gate.so.1 => (0xffffe000)
libmysqlclient.so.10 => /usr/lib/libmysqlclient.so.10 (0x40028000)
libz.so.1 => /usr/lib/libz.so.1 (0x4005f000)
libc.so.6 => /lib/tls/libc.so.6 (0x40070000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x401b8000)
libnsl.so.1 => /lib/libnsl.so.1 (0x401e5000)
libm.so.6 => /lib/tls/libm.so.6 (0x401f8000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)
Now, I have the same result than Zeus but I didn't have any
/usr/lib/libmysqlclient.so.10...
When I installed the libmysql12, I obtained new files in /usr/lib/
(libmysqlclient.so.12 and some others). When SER try to load mysql.so, it
looks for the library libmysqlclient.so.10 and obviously can't find it. So
I made a link with the following command :
ln -s libmysqlclient.so.12 libmysqlclient.so.10
And now, SER can load the mysql module !!
Thanks for your help Zeus !!
Bye, Gwen
Hi Zeus and other serusers,
The mysql.so file is the one I got with
SER.(ser-0.8.12_linux_i386.tar.gz, if I remember...).
Could you tell me what output you get with this command :
# ldconfig -v |grep mysql
ldconfig: Path `/usr/lib' given more than once
libmysqlclient_r.so.12 -> libmysqlclient_r.so.12.0.0
libmysqlclient.so.12 -> libmysqlclient.so.12.0.0
libmysqlclient.so.10 -> libmysqlclient.so.10
Thanks,
Gwen
Gwen,
There is something wrong with your mysql.so file. Did you compile it
yourself or download it somewhere? It doesn't look like mysql library
is linked into it. My ldd output is like this:
sip:/usr/local/lib/ser/modules> ldd mysql.so
libmysqlclient.so.10 => /usr/lib/libmysqlclient.so.10
(0x00bbb000)
libz.so.1 => /usr/lib/libz.so.1 (0x00abf000)
libc.so.6 => /lib/tls/libc.so.6 (0x003f3000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x0056a000)
libnsl.so.1 => /lib/libnsl.so.1 (0x0029e000)
libm.so.6 => /lib/tls/libm.so.6 (0x00111000)
libnss_files.so.2 => /lib/libnss_files.so.2 (0x00a7d000)
libnss_dns.so.2 => /lib/libnss_dns.so.2 (0x006dd000)
libresolv.so.2 => /lib/libresolv.so.2 (0x00967000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x0036b000)
Note the first line states that mysql.so should dynamically load the mysql
library from /usr/lib/libmysqlclient.so.10. It is absent from your output.
Either recompile the module or download another copy from the FTP server.
Zeus
-----Original Message-----
From: g.billoudet@arwen-tech.fr [mailto:g.billoudet@arwen-tech.fr]
Sent: Friday, 10 September 2004 5:10 PM
To: Zeus Ng
Cc: serusers@lists.iptel.org
Subject: RE: [Serusers] could not open module mysql.so
Thank you for your help Zeus,
Here are the output of the commands :
[root@linux gwen]# ldd /usr/local/lib/ser/modules/mysql.so
linux-gate.so.1 => (0xffffe000)
libz.so.1 => /usr/lib/libz.so.1 (0x40028000)
libc.so.6 => /lib/tls/libc.so.6 (0x40039000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)
[root@linux gwen]# cat /etc/ld.conf
cat: /etc/ld.conf: No such file or directory
[root@linux gwen]# cat /etc/ld.so.conf
/usr/X11R6/lib
/usr/lib/qt3/lib
/usr/local/lib/ser/modules
/usr/lib
Gwen
Gwen,
It appears that your mysql.so is not link properly with the mysql
library. Send the following output to the list. It may give us more
insight on your problem.
root# ldd /usr/local/lib/ser/modules/mysql.so
root# cat /etc/ld.conf
Zeus
-----Original Message-----
From: serusers-bounces@lists.iptel.org
[mailto:serusers-bounces@lists.iptel.org]
On Behalf Of g.billoudet@arwen-tech.fr
Sent: Friday, 10 September 2004 12:46 AM
To: g.billoudet@arwen-tech.fr
Cc: serusers@lists.iptel.org
Subject: Re: [Serusers] could not open module mysql.so
Hi,
I checked my MySQL-client package. So I installed
MySQL-client-4.0.20-0.i386.rpm. I also had to install the package
libmysql12. But, I still have the same problem with the
load of mysql
module...
I the folder /usr/lib, new files appeared : libmysqlclient_r.so.12@
libmysqlclient_r.so.12.0.0*
libmysqlclient.so.10*
libmysqlclient.so.12@
libmysqlclient.so.12.0.0*
What 'libmysqlclient' files do you have in your folder
/usr/lib and
/usr/local/lib/ser/modules/ ??
When I use "/usr/local/sbin/ser -c", the message of the error is a
bit different :
0(2570) loading module /usr/local/lib/ser/modules/mysql.so 0(2570)
ERROR: load_module: could not open module
</usr/local/lib/ser/modules/mysql.so>:
/usr/local/lib/ser/modules/mysql.so: undefined symbol:
mysql_field_count
0(2570) parse error (14,13-49): failed to load module
# ...bla bla... don't mind
ERROR: bad config file (1 errors)
Thanks for help
Gwen
Serusers mailing list
serusers@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers