Strange but true!

(I am using mysql 5)

I had tried previously to link the two files in /usr/lib - but without any luck.

After using strace as directed the output showed no association between libmysqlclient.so.12 and libmysqlclent.so.10 in /usr/lib.

However - when I re-linked the two files in /usr/lib after running strace - everything 'magically' started working - and so ended 5 days of frustration!

Thanks for all your help

Best Regards

Paul

_____

From: Ezequiel Colombo [mailto:ecolombo@arcotel.net] Sent: 13 September 2004 18:26 To: Ezequiel Colombo; Paul Cowie; g.billoudet@arwen-tech.fr Cc: serusers@lists.iptel.org Subject: Re: [Serusers] could not open module mysql.so

If recompilation if done and dont work you can use strace to see where are SER searching libmysqlclient:

strace ser -D 2>execlog

grep "libmysqlclient" execlog

Probably SER try to open /lib/libmysqlclient.so.12 and your mysql installation put the library under /usr/lib/mysql

----- Original Message -----

From: Ezequiel mailto:ecolombo@arcotel.net Colombo

To: Paul mailto:Paul.Cowie@dataflex.com Cowie ; g.billoudet@arwen-tech.fr mailto:g.billoudet@arwen-tech.fr

Cc: serusers@lists.iptel.org mailto:serusers@lists.iptel.org

Sent: Monday, September 13, 2004 1:58 PM

Subject: Re: [Serusers] could not open module mysql.so

I think that this is due to mysql upgrade from 3.23 to 4.

Try recompiling the ser mysql module

----- Original Message -----

From: Paul mailto:Paul.Cowie@dataflex.com Cowie

To: g.billoudet@arwen-tech.fr mailto:g.billoudet@arwen-tech.fr

Cc: serusers@lists.iptel.org mailto:serusers@lists.iptel.org

Sent: Monday, September 13, 2004 1:25 PM

Subject: RE: [Serusers] could not open module mysql.so

Gwen,

Where did you make the ln -s libmysqlclient.so.12 libmysqlclient.so.10?

I have the same problem - and have tried to link the old embedded reference but without success

Regards

Paul

-----Original Message----- From: g.billoudet@arwen-tech.fr mailto:g.billoudet@arwen-tech.fr [mailto:g.billoudet@arwen-tech.fr mailto:g.billoudet@arwen-tech.fr ] Sent: 10 September 2004 14:05 To: g.billoudet@arwen-tech.fr mailto:g.billoudet@arwen-tech.fr Cc: serusers@lists.iptel.org mailto:serusers@lists.iptel.org Subject: RE: [Serusers] could not open module mysql.so

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

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@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

http://lists.iptel.org/mailman/listinfo/serusers

_______________________________________________ Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers http://lists.iptel.org/mailman/listinfo/serusers

************************************************************************** Disclaimer This email transmission is confidential and intended solely for the person or organisation to whom it is addressed. If you are not the intended recipient, you must not copy, distribute or disseminate the information, or take any action in reliance of it. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of any organisation or employer. If you have received this message in error, do not open any attachment but please notify the sender (above) and delete this message from your system. Please rely on your own virus check. Although all outbound mail is checked for viruses, no responsibility is taken by the sender for any damage rising out of any bug or virus infection.

**************************************************************************

_____

_______________________________________________ Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

_____

_______________________________________________ Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

************************************************************************** Disclaimer This email transmission is confidential and intended solely for the person or organisation to whom it is addressed. If you are not the intended recipient, you must not copy, distribute or disseminate the information, or take any action in reliance of it. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of any organisation or employer. If you have received this message in error, do not open any attachment but please notify the sender (above) and delete this message from your system. Please rely on your own virus check. Although all outbound mail is checked for viruses, no responsibility is taken by the sender for any damage rising out of any bug or virus infection. **************************************************************************