So... I've had ser 0.9.6 running on RH EL3, and FC3 and 4. I'm building out a server on RH EL4 for SER, but I've run into a snag. I'm sure it's something simple, but it has me stumped at the moment.
I've recompiled mysql.so on the new server... compiles fine (as do the rest of the modules). However, when I try to start up SER with mysql.so loaded, it gives me this:
ERROR: load_module: could not open module </usr/local/lib/ser/modules/mysql.so>: /usr/local/lib/ser/modules/mysql.so: undefined symbol: log
Undefined symbol: log
Never seen this before. Anyone know what it means or, more importantly, how to fix it (and no... I'm not going to scrap it all and go with Ottendorf yet, so that's not a solution ;) )?
N.
Is mysql.so in the /usr/local/lib/ser/modules/ directory? Plz, check.
I had this problem several times, when mysql.so went missing even i recompiled with include_modules="mysql .... etc" from source. So, what i did, after compilation and install, i went to the modules directory of compiled ser (path-to-ser-source/ser-0.9.6/modules/mysql/) and manually copied mysql.so into the /usr/local/lib/ser/modules/ directory, where it should be after installation. Worked well for me.
On 2/1/07, Greger V. Teigre greger@teigre.com wrote:
Yes. It's there in the directory. I copied it in there myself, since I wanted to recompile the module alone to make sure nothing went wrong in the initial compile.
N.
On Thu, 1 Feb 2007 17:22:23 +0700, Andrey Kuprianov wrote
out a
rest of
how to
fix it (and no... I'm not going to scrap it all and go with Ottendorf
yet, so
[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 with one other message, also someone who was having problems in RHEL4. Are we sure it works in RHEL4?
N.
On Thu, 01 Feb 2007 09:41:32 +0100, Greger V. Teigre wrote
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 sip@infinideas.com [070201 11:56]:
It is indeed most irksome. This works like a charm on all my other servers, but not on this one, and I haven't done anything differently except that my mysqlclient RPM is the one from the mysql.org (mysql 5) site for RHEL4 (installing libmysqlclient.so.15 into /usr/lib instead of /usr/lib/mysql).
But, of course, there are no errors on compile and no missing libraries upon link... so I'm confused.
N.
On Thu, 1 Feb 2007 12:15:49 +0100, Atle Samuelsen wrote
building out a
server on RH EL4 for SER, but I've run into a snag. I'm sure it's
something
simple, but it has me stumped at the moment.
I've recompiled mysql.so on the new server... compiles fine (as do the
rest of
/usr/local/lib/ser/modules/mysql.so:
importantly, how to
fix it (and no... I'm not going to scrap it all and go with Ottendorf
yet, so
Hi Sip,
* sip sip@infinideas.com [070201 14:33]:
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
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
sure it
loaded, it
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
with one
do the
Ottendorf
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
servers,
but not on this one, and I haven't done anything differently except
that my
mysqlclient RPM is the one from the mysql.org (mysql 5) site for RHEL4 (installing libmysqlclient.so.15 into /usr/lib instead of
/usr/lib/mysql).
But, of course, there are no errors on compile and no missing
libraries upon
As I wrote in a previous post (didn't see your update as it turned up in a separate thread for some reason): 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. g-)
sip wrote:
You may be right, I'm not sure if ser is tested with mysql 5?! Here is a grep on my rhel4 packages(all standard rhel4): libdbi-dbd-mysql-0.6.5-10.RHEL4.1.i386.rpm mysql-4.1.20-1.RHEL4.1.i386.rpm mysql-devel-4.1.20-1.RHEL4.1.i386.rpm mysql-server-4.1.20-1.RHEL4.1.i386.rpm mysqlclient10-3.23.58-4.RHEL4.1.i386.rpm php-mysql-4.3.9-3.22.i386.rpm
And your ldd of mysql.so does not look fine. I would say you have probably compiled against mysql4 header files (left overs?!), but does not have mysql4 client rpm installed. g-)
sip wrote:
-
Andrey Kuprianov -
Atle Samuelsen -
Greger V. Teigre -
sip