[LON-CAPA-dev] Re: LON-CAPA-mysql

[Martin Siegert]

On Tue, Mar 12, 2002 at 06:36:31PM -0500, Scott Harrison wrote:
> 
> Short answer:
> * there are no plans to revisit LON-CAPA-mysql
> * and, I assume, since the compilation was standard,
>   mysql uses shared zlib library
> 
> Long answer:
> LON-CAPA-mysql is a standard compilation of mysql on a RedHat 6.2
> system.
> 
> Initially done from source:
> DBI-1.13.tar.gz  Msql-Mysql-modules-1.2209.tar.gz  mysql-3.22.32.tar.gz
> 
> To quote my writing in:
> CVS:doc/mysql_note.txt
> 
> BeginQuote
> There were problems with using the RedHat packages since the three
> different RedHat packages were somewhat noncompatible with each other
> in terms of expected file locations. (The Debian linux distribution,
> on the other hand, has a working set of these packages).
> EndQuote
> 
> We are now working on a more focused post-installation approach
> to LON-CAPA installation.
> 
> For RedHat 7.* systems, see the note I wrote
> "Regarding MySQL." in CVS:doc/how_to_install_on_RedHat7.2.tx
> 
> RedHat 7.* can/should use rpm packages for mysql, though LON-CAPA-mysql
> still works in this scenario.
> 
> Please let me know if you think we/all are still facing a glitch here.

Hmm. 

# cd /usr/local/mysql-3.23.33-pc-linux-gnu-i686/bin
# ldd mysqld
	not a dynamic executable
# ldd mysql
	not a dynamic executable

This looks like as if those binaries are compiled with static libraries.
... which is bad news.

Thus, what is the easiest way of fixing this on RH 6.2? Would rebuilding the 
src.rpm with a prefix /usr/local work? Or do you have a src.rpm for
LON-CAPA-mysql that I can modify to use shared libraries?

Under RH 7.2 using the mysql-server rpm I find:
# ldd /usr/libexec/mysqld
	libdl.so.2 => /lib/libdl.so.2 (0x40022000)
	libpthread.so.0 => /lib/i686/libpthread.so.0 (0x40026000)
	libz.so.1 => /usr/lib/libz.so.1 (0x4003b000)
	libcrypt.so.1 => /lib/libcrypt.so.1 (0x40049000)
	libnsl.so.1 => /lib/libnsl.so.1 (0x40076000)
	libstdc++-libc6.2-2.so.3 => /usr/lib/libstdc++-libc6.2-2.so.3 (0x4008c000)
	libm.so.6 => /lib/i686/libm.so.6 (0x400cf000)
	libc.so.6 => /lib/i686/libc.so.6 (0x400f2000)
	/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)

Thus this does used shared libraries. Would rebuilding the src.rpm of this
package for RH 6.2 work?

Cheers,
Martin