[Serusers] Problem with mysql.so on new server -- SOLVED

sip sip at infinideas.com
Fri Feb 2 17:15:56 CET 2007


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
> 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
> > 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
> > > Hi Sip,
> > > 
> > > * sip <sip at infinideas.com> [070201 14:33]:
> > > > 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.
> > > 
> > > 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
> > > > 
> > > > 
> > > > N.
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > > On Thu, 1 Feb 2007 12:15:49 +0100, Atle Samuelsen 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 at OgoBoo sip_router]# killall ser
> > > > > [root at OgoBoo sip_router]# grep "mysql" /usr/local/etc/ser/ser.cfg
> > > > > loadmodule "/usr/local/lib/ser/modules/mysql.so"
> > > > > [root at OgoBoo sip_router]# cat /etc/redhat-release
> > > > > Red Hat Enterprise Linux ES release 4 (Nahant Update 2)
> > > > > [root at OgoBoo sip_router]# ser
> > > > > Listening on
> > > > >              udp: 192.168.0.1 [192.168.0.1]:5080
> > > > > Aliases:
> > > > > 
> > > > > [root at 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 at OgoBoo sip_router]#
> > > > > 
> > > > > [root at 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 at infinideas.com> [070201 11:56]:
> > > > > > [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
> > > > > > > RHEL4 should be fine. ldd mysql.so should reveal if you are missing 
> > > > > > > any libraries. g-)
> > > > > > > 
> > > > > > > sip wrote:
> > > > > > > > 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.
> > > > > > > > _______________________________________________
> > > > > > > > Serusers mailing list
> > > > > > > > Serusers at lists.iptel.org
> > > > > > > > http://lists.iptel.org/mailman/listinfo/serusers
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > 
> > > > > > _______________________________________________
> > > > > > Serusers mailing list
> > > > > > Serusers at lists.iptel.org
> > > > > > http://lists.iptel.org/mailman/listinfo/serusers
> > > >
> > 
> > _______________________________________________
> > Serusers mailing list
> > Serusers at lists.iptel.org
> > http://lists.iptel.org/mailman/listinfo/serusers




More information about the sr-users mailing list