Finally figured this one out, I think. I was trying to compile aolserver4-nsmysql on debian, using the package source, but I kept hitting that error. then I found some bug about openSUSE related to this, and the workaround for x86 was to do this:
ln -s /lib/libgcc_s.so.1 /usr/lib/libgcc_s.so
DOH! Unfortunately, I'm back to square one. I'm now able to compile aolserver4-nsmysql, but I still get this error when trying to load the driver:
Warning: modload: could not load /usr/lib/aolserver4/bin/nsmysql.so: /usr/lib/aolserver4/lib/libnsmysql.so: undefined symbol: mysql_select_db
Maybe I'll stick with Postgres?
Dossy seems to be around still, so I've just sent an email:
Hi Dossy,
How are you? I'm trying to get your AOL Server mysql driver up and running but keep running into the same problem:
Warning: modload: could not load /usr/lib/aolserver4/bin/nsmysql.so: /usr/lib/aolserver4/lib/libnsmysql.so: undefined symbol: mysql_select_db
I've been on this for a few days, I'm using debian lenny, and have /usr/lib/aolserver4/lib in /etc/ld.so.conf.d/aolserver4.conf. I'm using the debian packages for aolserver4 and aolserver4-nsmysql, but since it didn't work like that, I've been trying to compile it myself.
First I ran into an issue where it couldn't find gcc_s, so I did this:
ln -s /usr/lib/libgcc_s.so /lib/libgcc_s.so
That helped the compile finish, but I still get the same error when starting AOL Server.
What do you think? Any ideas? Thanks!
Albert
More info:
ldd /usr/lib/aolserver4/bin/nsmysql.so linux-gate.so.1 => (0xffffe000) libnsmysql.so => /usr/lib/aolserver4/lib/libnsmysql.so (0xb7fc7000) libnsd.so => /usr/lib/aolserver4/lib/libnsd.so (0xb7f69000) libnsthread.so => /usr/lib/aolserver4/lib/libnsthread.so (0xb7f60000) libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb7f53000) libtcl8.4.so.0 => /usr/lib/libtcl8.4.so.0 (0xb7e9e000) libdl.so.2 => /lib/i686/cmov/libdl.so.2 (0xb7e9a000) libpthread.so.0 => /lib/i686/cmov/libpthread.so.0 (0xb7e82000) libm.so.6 => /lib/i686/cmov/libm.so.6 (0xb7e5d000) libc.so.6 => /lib/i686/cmov/libc.so.6 (0xb7d0e000) /lib/ld-linux.so.2 (0x80000000)
¥