<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RE: [Serusers] could not open module mysql.so</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Gwen,</FONT>
</P>
<P><FONT SIZE=2>Where did you make the ln -s libmysqlclient.so.12 libmysqlclient.so.10?</FONT>
</P>
<P><FONT SIZE=2>I have the same problem - and have tried to link the old embedded reference but without success</FONT>
</P>
<P><FONT SIZE=2>Regards</FONT>
</P>
<P><FONT SIZE=2>Paul</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: g.billoudet@arwen-tech.fr [<A HREF="mailto:g.billoudet@arwen-tech.fr">mailto:g.billoudet@arwen-tech.fr</A>] </FONT>
<BR><FONT SIZE=2>Sent: 10 September 2004 14:05</FONT>
<BR><FONT SIZE=2>To: g.billoudet@arwen-tech.fr</FONT>
<BR><FONT SIZE=2>Cc: serusers@lists.iptel.org</FONT>
<BR><FONT SIZE=2>Subject: RE: [Serusers] could not open module mysql.so</FONT>
</P>
<P><FONT SIZE=2>I finally found the solution...</FONT>
</P>
<P><FONT SIZE=2>First, I don't know why but I had a strange link file</FONT>
<BR><FONT SIZE=2>(libmysqlclient.so.10) in my folder /usr/local/lib/ser/modules. I deleted</FONT>
<BR><FONT SIZE=2>it and then I got the following result of the command "ldd mysql.so" :</FONT>
<BR><FONT SIZE=2> linux-gate.so.1 => (0xffffe000)</FONT>
<BR><FONT SIZE=2> libmysqlclient.so.10 => /usr/lib/libmysqlclient.so.10 (0x40028000)</FONT>
<BR><FONT SIZE=2> libz.so.1 => /usr/lib/libz.so.1 (0x4005f000)</FONT>
<BR><FONT SIZE=2> libc.so.6 => /lib/tls/libc.so.6 (0x40070000)</FONT>
<BR><FONT SIZE=2> libcrypt.so.1 => /lib/libcrypt.so.1 (0x401b8000)</FONT>
<BR><FONT SIZE=2> libnsl.so.1 => /lib/libnsl.so.1 (0x401e5000)</FONT>
<BR><FONT SIZE=2> libm.so.6 => /lib/tls/libm.so.6 (0x401f8000)</FONT>
<BR><FONT SIZE=2> /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)</FONT>
</P>
<P><FONT SIZE=2>Now, I have the same result than Zeus but I didn't have any</FONT>
<BR><FONT SIZE=2>/usr/lib/libmysqlclient.so.10...</FONT>
</P>
<P><FONT SIZE=2>When I installed the libmysql12, I obtained new files in /usr/lib/</FONT>
<BR><FONT SIZE=2>(libmysqlclient.so.12 and some others). When SER try to load mysql.so, it</FONT>
<BR><FONT SIZE=2>looks for the library libmysqlclient.so.10 and obviously can't find it.</FONT>
<BR><FONT SIZE=2>So I made a link with the following command :</FONT>
<BR><FONT SIZE=2>ln -s libmysqlclient.so.12 libmysqlclient.so.10</FONT>
</P>
<P><FONT SIZE=2>And now, SER can load the mysql module !!</FONT>
</P>
<P><FONT SIZE=2>Thanks for your help Zeus !!</FONT>
<BR><FONT SIZE=2>Bye, Gwen</FONT>
</P>
<BR>
<P><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> Hi Zeus and other serusers,</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> The mysql.so file is the one I got with SER.(ser-0.8.12_linux_i386.tar.gz,</FONT>
<BR><FONT SIZE=2>> if I remember...).</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> Could you tell me what output you get with this command :</FONT>
<BR><FONT SIZE=2>> # ldconfig -v |grep mysql</FONT>
<BR><FONT SIZE=2>> ldconfig: Path `/usr/lib' given more than once</FONT>
<BR><FONT SIZE=2>> libmysqlclient_r.so.12 -> libmysqlclient_r.so.12.0.0</FONT>
<BR><FONT SIZE=2>> libmysqlclient.so.12 -> libmysqlclient.so.12.0.0</FONT>
<BR><FONT SIZE=2>> libmysqlclient.so.10 -> libmysqlclient.so.10</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> Thanks,</FONT>
<BR><FONT SIZE=2>> Gwen</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>> Gwen,</FONT>
<BR><FONT SIZE=2>>></FONT>
<BR><FONT SIZE=2>>> There is something wrong with your mysql.so file. Did you compile it</FONT>
<BR><FONT SIZE=2>>> yourself or download it somewhere? It doesn't look like mysql library is</FONT>
<BR><FONT SIZE=2>>> linked into it. My ldd output is like this:</FONT>
<BR><FONT SIZE=2>>></FONT>
<BR><FONT SIZE=2>>> sip:/usr/local/lib/ser/modules> ldd mysql.so</FONT>
<BR><FONT SIZE=2>>> libmysqlclient.so.10 => /usr/lib/libmysqlclient.so.10</FONT>
<BR><FONT SIZE=2>>> (0x00bbb000)</FONT>
<BR><FONT SIZE=2>>> libz.so.1 => /usr/lib/libz.so.1 (0x00abf000)</FONT>
<BR><FONT SIZE=2>>> libc.so.6 => /lib/tls/libc.so.6 (0x003f3000)</FONT>
<BR><FONT SIZE=2>>> libcrypt.so.1 => /lib/libcrypt.so.1 (0x0056a000)</FONT>
<BR><FONT SIZE=2>>> libnsl.so.1 => /lib/libnsl.so.1 (0x0029e000)</FONT>
<BR><FONT SIZE=2>>> libm.so.6 => /lib/tls/libm.so.6 (0x00111000)</FONT>
<BR><FONT SIZE=2>>> libnss_files.so.2 => /lib/libnss_files.so.2 (0x00a7d000)</FONT>
<BR><FONT SIZE=2>>> libnss_dns.so.2 => /lib/libnss_dns.so.2 (0x006dd000)</FONT>
<BR><FONT SIZE=2>>> libresolv.so.2 => /lib/libresolv.so.2 (0x00967000)</FONT>
<BR><FONT SIZE=2>>> /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x0036b000)</FONT>
<BR><FONT SIZE=2>>></FONT>
<BR><FONT SIZE=2>>> Note the first line states that mysql.so should dynamically load the</FONT>
<BR><FONT SIZE=2>>> mysql</FONT>
<BR><FONT SIZE=2>>> library from /usr/lib/libmysqlclient.so.10. It is absent from your</FONT>
<BR><FONT SIZE=2>>> output.</FONT>
<BR><FONT SIZE=2>>> Either recompile the module or download another copy from the FTP</FONT>
<BR><FONT SIZE=2>>> server.</FONT>
<BR><FONT SIZE=2>>></FONT>
<BR><FONT SIZE=2>>> Zeus</FONT>
<BR><FONT SIZE=2>>></FONT>
<BR><FONT SIZE=2>>>> -----Original Message-----</FONT>
<BR><FONT SIZE=2>>>> From: g.billoudet@arwen-tech.fr [<A HREF="mailto:g.billoudet@arwen-tech.fr">mailto:g.billoudet@arwen-tech.fr</A>]</FONT>
<BR><FONT SIZE=2>>>> Sent: Friday, 10 September 2004 5:10 PM</FONT>
<BR><FONT SIZE=2>>>> To: Zeus Ng</FONT>
<BR><FONT SIZE=2>>>> Cc: serusers@lists.iptel.org</FONT>
<BR><FONT SIZE=2>>>> Subject: RE: [Serusers] could not open module mysql.so</FONT>
<BR><FONT SIZE=2>>>></FONT>
<BR><FONT SIZE=2>>>></FONT>
<BR><FONT SIZE=2>>>> Thank you for your help Zeus,</FONT>
<BR><FONT SIZE=2>>>></FONT>
<BR><FONT SIZE=2>>>> Here are the output of the commands :</FONT>
<BR><FONT SIZE=2>>>></FONT>
<BR><FONT SIZE=2>>>> [root@linux gwen]# ldd /usr/local/lib/ser/modules/mysql.so</FONT>
<BR><FONT SIZE=2>>>> linux-gate.so.1 => (0xffffe000)</FONT>
<BR><FONT SIZE=2>>>> libz.so.1 => /usr/lib/libz.so.1 (0x40028000)</FONT>
<BR><FONT SIZE=2>>>> libc.so.6 => /lib/tls/libc.so.6 (0x40039000)</FONT>
<BR><FONT SIZE=2>>>> /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)</FONT>
<BR><FONT SIZE=2>>>></FONT>
<BR><FONT SIZE=2>>>> [root@linux gwen]# cat /etc/ld.conf</FONT>
<BR><FONT SIZE=2>>>> cat: /etc/ld.conf: No such file or directory</FONT>
<BR><FONT SIZE=2>>>></FONT>
<BR><FONT SIZE=2>>>> [root@linux gwen]# cat /etc/ld.so.conf</FONT>
<BR><FONT SIZE=2>>>> /usr/X11R6/lib</FONT>
<BR><FONT SIZE=2>>>> /usr/lib/qt3/lib</FONT>
<BR><FONT SIZE=2>>>> /usr/local/lib/ser/modules</FONT>
<BR><FONT SIZE=2>>>> /usr/lib</FONT>
<BR><FONT SIZE=2>>>></FONT>
<BR><FONT SIZE=2>>>> Gwen</FONT>
<BR><FONT SIZE=2>>>></FONT>
<BR><FONT SIZE=2>>>></FONT>
<BR><FONT SIZE=2>>>> > Gwen,</FONT>
<BR><FONT SIZE=2>>>> ></FONT>
<BR><FONT SIZE=2>>>> > It appears that your mysql.so is not link properly with the mysql</FONT>
<BR><FONT SIZE=2>>>> > library. Send the following output to the list. It may give us more</FONT>
<BR><FONT SIZE=2>>>> > insight on your problem.</FONT>
<BR><FONT SIZE=2>>>> ></FONT>
<BR><FONT SIZE=2>>>> > root# ldd /usr/local/lib/ser/modules/mysql.so</FONT>
<BR><FONT SIZE=2>>>> > root# cat /etc/ld.conf</FONT>
<BR><FONT SIZE=2>>>> ></FONT>
<BR><FONT SIZE=2>>>> ></FONT>
<BR><FONT SIZE=2>>>> > Zeus</FONT>
<BR><FONT SIZE=2>>>> ></FONT>
<BR><FONT SIZE=2>>>> >> -----Original Message-----</FONT>
<BR><FONT SIZE=2>>>> >> From: serusers-bounces@lists.iptel.org</FONT>
<BR><FONT SIZE=2>>>> [<A HREF="mailto:serusers-bounces@iptel.org">mailto:serusers-bounces@lists.iptel.org</A>]</FONT>
<BR><FONT SIZE=2>>>> >> On Behalf Of g.billoudet@arwen-tech.fr</FONT>
<BR><FONT SIZE=2>>>> >> Sent: Friday, 10 September 2004 12:46 AM</FONT>
<BR><FONT SIZE=2>>>> >> To: g.billoudet@arwen-tech.fr</FONT>
<BR><FONT SIZE=2>>>> >> Cc: serusers@lists.iptel.org</FONT>
<BR><FONT SIZE=2>>>> >> Subject: Re: [Serusers] could not open module mysql.so</FONT>
<BR><FONT SIZE=2>>>> >></FONT>
<BR><FONT SIZE=2>>>> >></FONT>
<BR><FONT SIZE=2>>>> >></FONT>
<BR><FONT SIZE=2>>>> >> Hi,</FONT>
<BR><FONT SIZE=2>>>> >></FONT>
<BR><FONT SIZE=2>>>> >> I checked my MySQL-client package. So I installed</FONT>
<BR><FONT SIZE=2>>>> >> MySQL-client-4.0.20-0.i386.rpm. I also had to install the package</FONT>
<BR><FONT SIZE=2>>>> >> libmysql12. But, I still have the same problem with the</FONT>
<BR><FONT SIZE=2>>>> load of mysql</FONT>
<BR><FONT SIZE=2>>>> >> module...</FONT>
<BR><FONT SIZE=2>>>> >></FONT>
<BR><FONT SIZE=2>>>> >> I the folder /usr/lib, new files appeared : libmysqlclient_r.so.12@</FONT>
<BR><FONT SIZE=2>>>> >> libmysqlclient_r.so.12.0.0*</FONT>
<BR><FONT SIZE=2>>>> >> libmysqlclient.so.10*</FONT>
<BR><FONT SIZE=2>>>> >> libmysqlclient.so.12@</FONT>
<BR><FONT SIZE=2>>>> >> libmysqlclient.so.12.0.0*</FONT>
<BR><FONT SIZE=2>>>> >></FONT>
<BR><FONT SIZE=2>>>> >> What 'libmysqlclient' files do you have in your folder</FONT>
<BR><FONT SIZE=2>>>> /usr/lib and</FONT>
<BR><FONT SIZE=2>>>> >> /usr/local/lib/ser/modules/ ??</FONT>
<BR><FONT SIZE=2>>>> >></FONT>
<BR><FONT SIZE=2>>>> >> When I use "/usr/local/sbin/ser -c", the message of the error is a</FONT>
<BR><FONT SIZE=2>>>> >> bit different :</FONT>
<BR><FONT SIZE=2>>>> >> 0(2570) loading module /usr/local/lib/ser/modules/mysql.so</FONT>
<BR><FONT SIZE=2>>>> >> 0(2570) ERROR: load_module: could not open module</FONT>
<BR><FONT SIZE=2>>>> >> </usr/local/lib/ser/modules/mysql.so>:</FONT>
<BR><FONT SIZE=2>>>> >> /usr/local/lib/ser/modules/mysql.so: undefined symbol:</FONT>
<BR><FONT SIZE=2>>>> >> mysql_field_count</FONT>
<BR><FONT SIZE=2>>>> >> 0(2570) parse error (14,13-49): failed to load module</FONT>
<BR><FONT SIZE=2>>>> >> # ...bla bla... don't mind</FONT>
<BR><FONT SIZE=2>>>> >> ERROR: bad config file (1 errors)</FONT>
<BR><FONT SIZE=2>>>> >></FONT>
<BR><FONT SIZE=2>>>> >></FONT>
<BR><FONT SIZE=2>>>> >> Thanks for help</FONT>
<BR><FONT SIZE=2>>>> >> Gwen</FONT>
<BR><FONT SIZE=2>>>> >></FONT>
<BR><FONT SIZE=2>>>> >></FONT>
<BR><FONT SIZE=2>>>> >></FONT>
<BR><FONT SIZE=2>>>> ></FONT>
<BR><FONT SIZE=2>>>> ></FONT>
<BR><FONT SIZE=2>>>></FONT>
<BR><FONT SIZE=2>>></FONT>
<BR><FONT SIZE=2>>></FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> _______________________________________________</FONT>
<BR><FONT SIZE=2>> Serusers mailing list</FONT>
<BR><FONT SIZE=2>> serusers@lists.iptel.org</FONT>
<BR><FONT SIZE=2>> <A HREF="http://lists.iptel.org/mailman/listinfo/serusers" TARGET="_blank">http://lists.iptel.org/mailman/listinfo/serusers</A></FONT>
<BR><FONT SIZE=2>></FONT>
</P>
<P><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>Serusers mailing list</FONT>
<BR><FONT SIZE=2>serusers@lists.iptel.org</FONT>
<BR><FONT SIZE=2><A HREF="http://lists.iptel.org/mailman/listinfo/serusers" TARGET="_blank">http://lists.iptel.org/mailman/listinfo/serusers</A></FONT>
</P>
<P><FONT SIZE=2>************************************************************************** </FONT>
<BR><B><FONT SIZE=2>Disclaimer </FONT></B>
<BR><B><FONT SIZE=2>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. </FONT></B></P>
<P><B><FONT SIZE=2>************************************************************************** </FONT></B>
</P>
</BODY>
</HTML>