Bug #56958 mysql 5.5.6-rc compiled on Centos5.5,But file "mysql" not work on Centos4.8
Submitted: 23 Sep 2010 2:41 Modified: 28 Oct 2010 11:56
Reporter: li mohao Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Compiling Severity:S3 (Non-critical)
Version:mysql 5.5.6 OS:Linux (Centos5.5 X64)
Assigned to: CPU Architecture:Any

[23 Sep 2010 2:41] li mohao
Description:
mysql 5.5.6 configline

CONFIGURE_LINE="./configure.am  '--prefix=/opt/mysql' '--enable-local-infile' '--enable-thread-safe-client' '--enable-assembler' '--with-client-ldflags=-static' '--with-mysqld-ldflags=-static' '--with-unix-socket-path=/opt/mysql/tmp/mysql.sock' '--with-plugins=partition,archive,blackhole,federated,ibmdb2i,innobase,perfschema,myisam,myisammrg' '--with-big-tables' '--without-debug' '--with-tcp-port=3306' '--with-readline' '--enable-profiling' '--enable-shared' '--enable-static' '--with-extra-charsets=complex' '--with-pic' '--with-fast-mutexes' '--with-zlib-dir=bundled' '--with-ssl' '--without-docs' '--without-man' 'CC=/opt/gcc/gcc-4.4.4/bin/gcc' 'CFLAGS=-O3 -pipe -fPIC -static-libgcc -m64 -fomit-frame-pointer -DDBUG_OFF' 'LIBS=-lrt' 'CXX=/opt/gcc/gcc-4.4.4/bin/gcc' 'CXXFLAGS=-O3 -pipe -fPIC -static-libgcc -m64 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -DDBUG_OFF'"

mysql 5.1.50 configline
CONFIGURE_LINE="./configure  '--prefix=/opt/mysql' '--enable-local-infile' '--enable-thread-safe-client' '--enable-assembler' '--with-client-ldflags=-static' '--with-mysqld-ldflags=-static' '--with-unix-socket-path=/opt/mysql/tmp/mysql.sock' '--with-plugins=partition,archive,blackhole,csv,federated,heap,ibmdb2i,innobase,myisam,myisammrg' '--with-big-tables' '--without-debug' '--with-tcp-port=3306' '--with-readline' '--enable-profiling' '--enable-shared' '--enable-static' '--with-extra-charsets=complex' '--with-pic' '--with-fast-mutexes' '--with-zlib-dir=bundled' '--with-ssl' '--without-docs' 'CC=/opt/gcc/gcc-4.4.4/bin/gcc -static-libgcc' 'CFLAGS=-O3 -pipe -fPIC  -fomit-frame-pointer ' 'LIBS=-lrt' 'CXX=/opt/gcc/gcc-4.4.4/bin/gcc -static-libgcc' 'CXXFLAGS=-O3 -pipe -fPIC  -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti '"

then ldd files

mysql 5.5.6

m/bin/mysql: /lib64/tls/libc.so.6: version `GLIBC_2.4' not found (required by m/bin/mysql)
        libpthread.so.0 => /lib64/tls/libpthread.so.0 (0x0000002a9566c000)
        libcrypt.so.1 => /lib64/libcrypt.so.1 (0x0000002a95781000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x0000002a958b9000)
        libm.so.6 => /lib64/tls/libm.so.6 (0x0000002a959d1000)
        librt.so.1 => /lib64/tls/librt.so.1 (0x0000002a95b57000)
        libc.so.6 => /lib64/tls/libc.so.6 (0x0000002a95c72000)
        /lib64/ld-linux-x86-64.so.2 (0x0000002a95556000)

mysql 5.1.50 ldd is right and can work
ldd mysql/bin/mysql
        linux-gate.so.1 =>  (0xffffe000)
        libncursesw.so.5 => /usr/lib/libncursesw.so.5 (0xf7f7c000)
        libpthread.so.0 => /lib/tls/libpthread.so.0 (0xf7f6a000)
        libcrypt.so.1 => /lib/libcrypt.so.1 (0xf7f39000)
        libnsl.so.1 => /lib/libnsl.so.1 (0xf7f22000)
        libm.so.6 => /lib/tls/libm.so.6 (0xf7eff000)
        librt.so.1 => /lib/tls/librt.so.1 (0xf7eeb000)
        libc.so.6 => /lib/tls/libc.so.6 (0xf7dba000)

BUT ldd mysqld and libmysqlclent is right.
Server can start normal and mysql gui tools can work right!

ldd m/libexec/mysqld
        libpthread.so.0 => /lib64/tls/libpthread.so.0 (0x0000002a9566c000)
        libdl.so.2 => /lib64/libdl.so.2 (0x0000002a95781000)
        libcrypt.so.1 => /lib64/libcrypt.so.1 (0x0000002a95885000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x0000002a959bc000)
        libm.so.6 => /lib64/tls/libm.so.6 (0x0000002a95ad4000)
        librt.so.1 => /lib64/tls/librt.so.1 (0x0000002a95c5b000)
        libc.so.6 => /lib64/tls/libc.so.6 (0x0000002a95d75000)
        /lib64/ld-linux-x86-64.so.2 (0x0000002a95556000)

 ldd m/lib/mysql/libmysqlclient_r.so 
        libpthread.so.0 => /lib64/tls/libpthread.so.0 (0x0000002a95afb000)
        libcrypt.so.1 => /lib64/libcrypt.so.1 (0x0000002a95c10000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x0000002a95d47000)
        libm.so.6 => /lib64/tls/libm.so.6 (0x0000002a95e60000)
        librt.so.1 => /lib64/tls/librt.so.1 (0x0000002a95fe6000)
        libc.so.6 => /lib64/tls/libc.so.6 (0x0000002a96100000)
        /lib64/ld-linux-x86-64.so.2 (0x000000552aaaa000)

Is a bug

How to repeat:
as desc
[25 Sep 2010 12:06] Sveta Smirnova
Thank you for the report.

Please describe what you mean mysql not working. Please paste error you get when call mysql.
[25 Sep 2010 13:10] li mohao
m/bin/mysql: /lib64/tls/libc.so.6: version `GLIBC_2.4' not found
[28 Sep 2010 11:56] Sveta Smirnova
Thank you for the feedback.

What will it output if you compile as recommended:

./BUILD/AUTORUN.sh
./configure [your options here]

?
[28 Oct 2010 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".