<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
As I wrote in a previous post (didn't see your update as it turned up
in a separate thread for some reason):<br>
ser will look for the header files only when compiling. It probably
found header files that worked. So, even though the so libraries are
not installed, the make will not give an error. As the loading of
mysql.so is at ser start-up, only then you will notice the missing
binary libraries. <br>
g-)<br>
<br>
sip wrote:
<blockquote cite="mid20070202160932.M42984@infinideas.com" type="cite">
<pre wrap="">So, I'm a little disappointed in the compiler/linker for not erroring out
during compile/link and just letting this go through, but here's the issue:
The new RHEL4 client libs (libmysqlclient.so.15, et al) from the mysql.org
RPMs don't install into /usr/lib/mysql. They install into /usr/lib. For some
reason, the SER code refuses to find them if they're not in /usr/lib/mysql or
/usr/local/lib/mysql or /usr/local/lib. I added the necessary links in the
makefile to no avail.
Symlinking the client libs into /usr/lib/mysql and recompiling the ser stuff
works as it should.
(ln -s /usr/lib/libmysqlclient* /usr/lib/mysql)
Thanks to everyone for being a sounding board. :)
N.
On Fri, 2 Feb 2007 08:24:59 -0500, sip wrote
</pre>
<blockquote type="cite">
<pre wrap="">Okay... an ldd -r of the mysql.so module shows this:
[bob]#ldd -r mysql.so
undefined symbol: log_facility (./mysql.so)
undefined symbol: mem_block (./mysql.so)
undefined symbol: debug (./mysql.so)
undefined symbol: log_stderr (./mysql.so)
undefined symbol: log (./mysql.so)
undefined symbol: fm_malloc (./mysql.so)
undefined symbol: dprint (./mysql.so)
undefined symbol: fm_free (./mysql.so)
undefined symbol: pow (./mysql.so)
libc.so.6 => /lib/tls/libc.so.6 (0x00111000)
/lib/ld-linux.so.2 (0x0099e000)
It's as though it's not including something rather critical, but
there's no error on link or compile. So odd.
N.
On Thu, 1 Feb 2007 09:15:08 -0500, sip wrote
</pre>
<blockquote type="cite">
<pre wrap="">I thought of that. It HAD an older version of the mysql client
libraries on there, but I removed those (and all other mysql-related
packages) before installing the new libraries and compiling ser.
Again, everything compiles and links correctly. It's just missing something
when it tries to load it. I'm wondering if perhaps SER doesn't work
with the mysql5 client/development libs -- if something is missing
from them that is expected.
I'm most confused.
N.
On Thu, 1 Feb 2007 14:42:53 +0100, Atle Samuelsen wrote
</pre>
<blockquote type="cite">
<pre wrap="">Hi Sip,
* sip <a class="moz-txt-link-rfc2396E" href="mailto:sip@infinideas.com"><sip@infinideas.com></a> [070201 14:33]:
</pre>
<blockquote type="cite">
<pre wrap="">It is indeed most irksome. This works like a charm on all my other
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap=""><!---->servers,
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">but not on this one, and I haven't done anything differently except
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap=""><!---->that my
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">mysqlclient RPM is the one from the mysql.org (mysql 5) site for RHEL4
(installing libmysqlclient.so.15 into /usr/lib instead of
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap=""><!---->/usr/lib/mysql).
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">But, of course, there are no errors on compile and no missing
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap=""><!---->libraries upon
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">link... so I'm confused.
</pre>
</blockquote>
<pre wrap="">Hmm.. did you only download mysqlclient? maybe you are mixing
libaries or something, like mysql-cient 4.1 and mysql client-5-devel
I would propose to do a rpm -qa |grep mysql|grep clint |xargs rpm
--force -e and then install mysql client and mysql devel once more
(ps, I have'nt tried the rpm -qa|grep... thingie..
- Atle
</pre>
<blockquote type="cite">
<pre wrap="">
N.
On Thu, 1 Feb 2007 12:15:49 +0100, Atle Samuelsen wrote
</pre>
<blockquote type="cite">
<pre wrap="">Hi guys,
It seems to work in my setup atleast :) I'v only got the defalt RHEL
4 + mysql-devel packages installed.
See under :
[root@OgoBoo sip_router]# killall ser
[root@OgoBoo sip_router]# grep "mysql" /usr/local/etc/ser/ser.cfg
loadmodule "/usr/local/lib/ser/modules/mysql.so"
[root@OgoBoo sip_router]# cat /etc/redhat-release
Red Hat Enterprise Linux ES release 4 (Nahant Update 2)
[root@OgoBoo sip_router]# ser
Listening on
udp: 192.168.0.1 [192.168.0.1]:5080
Aliases:
[root@OgoBoo sip_router]# ps -C ser
PID TTY TIME CMD
17853 ? 00:00:00 ser
17854 ? 00:00:00 ser
17855 ? 00:00:00 ser
17856 ? 00:00:00 ser
17857 ? 00:00:00 ser
17858 ? 00:00:00 ser
[root@OgoBoo sip_router]#
[root@OgoBoo sip_router]# ldd /usr/local/lib/ser/modules/mysql.so
libmysqlclient.so.14 => /usr/lib/mysql/libmysqlclient.so.14
(0x001df000)
libz.so.1 => /usr/lib/libz.so.1 (0x00111000)
libc.so.6 => /lib/tls/libc.so.6 (0x00692000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x00121000)
libnsl.so.1 => /lib/libnsl.so.1 (0x00989000)
libm.so.6 => /lib/tls/libm.so.6 (0x0014f000)
libssl.so.4 => /lib/libssl.so.4 (0x00adc000)
libcrypto.so.4 => /lib/libcrypto.so.4 (0x002f8000)
/lib/ld-linux.so.2 (0x001c8000)
libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2
(0x00877000) libkrb5.so.3 => /usr/lib/libkrb5.so.3
(0x003e1000) libcom_err.so.2 => /lib/libcom_err.so.2
(0x00e4a000) libk5crypto.so.3 => /usr/lib/libk5crypto.so.3
(0x00f6c000) libresolv.so.2 => /lib/libresolv.so.2
(0x007ee000) libdl.so.2 => /lib/libdl.so.2 (0x00ed2000)
- Atle
* sip <a class="moz-txt-link-rfc2396E" href="mailto:sip@infinideas.com"><sip@infinideas.com></a> [070201 11:56]:
</pre>
<blockquote type="cite">
<pre wrap="">[mysql]$ ldd mysql.so
libc.so.6 => /lib/tls/libc.so.6 (0x009bc000)
/lib/ld-linux.so.2 (0x0099e000)
Looks just fine. Linked to the appropriate libs.
I did a search on this error in the archives and it only comes up
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">with one
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">other message, also someone who was having problems in RHEL4. Are we
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">sure it
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">works in RHEL4?
N.
On Thu, 01 Feb 2007 09:41:32 +0100, Greger V. Teigre wrote
</pre>
<blockquote type="cite">
<pre wrap="">RHEL4 should be fine. ldd mysql.so should reveal if you are missing
any libraries. g-)
sip wrote:
</pre>
<blockquote type="cite">
<pre wrap="">So... I've had ser 0.9.6 running on RH EL3, and FC3 and 4. I'm
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">building out a
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">server on RH EL4 for SER, but I've run into a snag. I'm sure it's
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">something
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">simple, but it has me stumped at the moment.
I've recompiled mysql.so on the new server... compiles fine (as
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">do the
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">rest of
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">the modules). However, when I try to start up SER with mysql.so
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">loaded, it
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">gives me this:
ERROR: load_module: could not open module
</usr/local/lib/ser/modules/mysql.so>:
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">/usr/local/lib/ser/modules/mysql.so:
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">undefined symbol: log
Undefined symbol: log
Never seen this before. Anyone know what it means or, more
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">importantly, how to
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">fix it (and no... I'm not going to scrap it all and go with
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">Ottendorf
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">yet, so
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">that's not a solution ;) )?
N.
_______________________________________________
Serusers mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Serusers@lists.iptel.org">Serusers@lists.iptel.org</a>
<a class="moz-txt-link-freetext" href="http://lists.iptel.org/mailman/listinfo/serusers">http://lists.iptel.org/mailman/listinfo/serusers</a>
</pre>
</blockquote>
</blockquote>
<pre wrap="">_______________________________________________
Serusers mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Serusers@lists.iptel.org">Serusers@lists.iptel.org</a>
<a class="moz-txt-link-freetext" href="http://lists.iptel.org/mailman/listinfo/serusers">http://lists.iptel.org/mailman/listinfo/serusers</a>
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">_______________________________________________
Serusers mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Serusers@lists.iptel.org">Serusers@lists.iptel.org</a>
<a class="moz-txt-link-freetext" href="http://lists.iptel.org/mailman/listinfo/serusers">http://lists.iptel.org/mailman/listinfo/serusers</a>
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!---->
_______________________________________________
Serusers mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Serusers@lists.iptel.org">Serusers@lists.iptel.org</a>
<a class="moz-txt-link-freetext" href="http://lists.iptel.org/mailman/listinfo/serusers">http://lists.iptel.org/mailman/listinfo/serusers</a>
</pre>
</blockquote>
</body>
</html>