RE: [Serusers] HELP!! CFG ERROR - sr-users

15 Sep 2004

See my post...

Good luck
Gwen

---------------------------- Message original ----------------------------
Objet:        RE: [Serusers] could not open module mysql.so
De:           g.billoudet(a)arwen-tech.fr
Date:         Ven 10 septembre 2004 15:04
À:       g.billoudet(a)arwen-tech.fr
Copie à: "Zeus Ng" &lt;zeus.ng(a)isquare.com.au&gt;
              serusers(a)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(a)arwen-tech.fr [mailto:g.billoudet@arwen-tech.fr] Sent:
Friday, 10 September 2004 5:10 PM
...
 >> To: Zeus Ng
>> Cc: serusers(a)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(a)lists.iptel.org
>> [mailto:serusers-bounces@lists.iptel.org]
>> >> On Behalf Of g.billoudet(a)arwen-tech.fr
>> >> Sent: Friday, 10 September 2004 12:46 AM
>> >> To: g.billoudet(a)arwen-tech.fr
>> >> Cc: serusers(a)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(a)lists.iptel.org
 http://lists.iptel.org/mailman/listinfo/serusers