Mantis - mysql5client
Viewing Issue Advanced Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
4839 regular use block always 2011-09-29 22:24 2011-10-01 14:05
Reporter: gadavis Platform:  
Assigned To: maciej OS:  
Priority: normal OS Version:  
Status: closed Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version:  
Summary: 0004839: Package is missing 64-bit libmysqlclient.so.15, mysql command doesn't work
Description: [davis@anfweb-dev:~]$ pkginfo -l CSWmysql5client | grep VERSION
   VERSION: 5.0.87,REV=2011.03.07


[davis@anfweb-dev:~]$ ldd /opt/csw/mysql5/bin/sparcv9/mysql
        libncursesw.so.5 => /opt/csw/lib/sparcv9/libncursesw.so.5
        libmysqlclient.so.15 => /opt/csw/lib/sparcv8/libmysqlclient.so.15 - wrong ELF class: ELFCLASS32
        librt.so.1 => /lib/64/librt.so.1
        libresolv.so.2 => /lib/64/libresolv.so.2
        libc.so.1 => /lib/64/libc.so.1
        libgen.so.1 => /lib/64/libgen.so.1
        libsocket.so.1 => /lib/64/libsocket.so.1
        libnsl.so.1 => /lib/64/libnsl.so.1
        libm.so.1 => /lib/64/libm.so.1
        libz.so.1 => /opt/csw/lib/sparcv9/libz.so.1
        libCstd.so.1 => /usr/lib/64/libCstd.so.1
        libCrun.so.1 => /usr/lib/64/libCrun.so.1
        libthread.so.1 => /lib/64/libthread.so.1
        libaio.so.1 => /lib/64/libaio.so.1
        libmd.so.1 => /lib/64/libmd.so.1
        libmp.so.2 => /lib/64/libmp.so.2
        libscf.so.1 => /lib/64/libscf.so.1
        libdoor.so.1 => /lib/64/libdoor.so.1
        libuutil.so.1 => /lib/64/libuutil.so.1
        libm.so.2 => /lib/64/libm.so.2
        /platform/SUNW,SPARC-Enterprise-T5220/lib/sparcv9/libc_psr.so.1
        /platform/SUNW,SPARC-Enterprise-T5220/lib/sparcv9/libmd_psr.so.1


[davis@anfweb-dev:~]$ ls -l /opt/csw/lib/sparcv9/libmysqlclient*
gls: cannot access /opt/csw/lib/sparcv9/libmysqlclient*: No such file or directory
Steps To Reproduce:
Additional Information:
Relationships
Attached Files:
Issue History
Date Modified Username Field Change
2011-09-29 22:24 gadavis New Issue
2011-09-30 00:27 maciej Note Added: 0009312
2011-09-30 01:46 gadavis Note Added: 0009313
2011-09-30 01:47 gadavis Note Added: 0009314
2011-09-30 11:32 maciej Note Added: 0009315
2011-09-30 23:06 gadavis Note Added: 0009316
2011-10-01 14:04 maciej Status new => assigned
2011-10-01 14:04 maciej Assigned To => maciej
2011-10-01 14:05 maciej Note Added: 0009317
2011-10-01 14:05 maciej Status assigned => closed
2011-10-01 14:05 maciej Resolution open => fixed

Notes
(0009312)
maciej   
2011-09-30 00:27   
I can't reproduce it on the buildfarm:

maciej@unstable9s :~/src/opencsw/pkg/mysql5/branches/mysql-5.0.x > pkgparam CSWmysql5client VERSION
5.0.87,REV=2011.03.07
maciej@unstable9s :~/src/opencsw/pkg/mysql5/branches/mysql-5.0.x > ldd /opt/csw/mysql5/bin/sparcv9/mysql
        /usr/lib/secure/64/s9_preload.so.1
        libncursesw.so.5 => /opt/csw/lib/sparcv9/libncursesw.so.5
        libmysqlclient.so.15 => /opt/csw/mysql5/lib/sparcv9/libmysqlclient.so.15
        librt.so.1 => /usr/lib/64/librt.so.1
        libresolv.so.2 => /usr/lib/64/libresolv.so.2
        libc.so.1 => /usr/lib/64/libc.so.1
        libgen.so.1 => /usr/lib/64/libgen.so.1
        libsocket.so.1 => /usr/lib/64/libsocket.so.1
        libnsl.so.1 => /usr/lib/64/libnsl.so.1
        libm.so.1 => /usr/lib/64/libm.so.1
        libz.so.1 => /opt/csw/lib/sparcv9/libz.so.1
        libCstd.so.1 => /usr/lib/64/libCstd.so.1
        libCrun.so.1 => /usr/lib/64/libCrun.so.1
        libthread.so.1 => /usr/lib/64/libthread.so.1
        libaio.so.1 => /usr/lib/64/libaio.so.1
        libmd5.so.1 => /usr/lib/64/libmd5.so.1
        libdl.so.1 => /usr/lib/64/libdl.so.1
        libmp.so.2 => /usr/lib/64/libmp.so.2
        /usr/platform/SUNW,SPARC-Enterprise-T5220/lib/sparcv9/libc_psr.so.1

Something is wrong in the way the mysql binary is looking for the shared libraries. Could you truss it and list all the consecutive paths it tries to open?

Can you also check for the CSWlibmysqlclient15 package, is it installed in your system?
(0009313)
gadavis   
2011-09-30 01:46   
The problem is that the file is in CSWmysql5, not in CSWlibmysqlclient15

here it is on a working system:

[davis@anfweb:/etc/opt/csw/php5]$ pkgchk -l -p /opt/csw/mysql5/lib/sparcv9/libmysqlclient.so.15
NOTE: Couldn't lock the package database.
Pathname: /opt/csw/mysql5/lib/sparcv9/libmysqlclient.so.15
Type: symbolic link
Source of link: libmysqlclient.so.15.0.0
Referenced by the following packages:
        CSWmysql5
Current status: installed
(0009314)
gadavis   
2011-09-30 01:47   
Indeed, once I installed CSWmysql5 (which is not listed as a dependency for CSWmysql5client), the mysql command runs correctly.
(0009315)
maciej   
2011-09-30 11:31   
Something is wrong. CSWmysql5client depends on CSWlibmysqlclient15, which provides the binary. Is your CSWmysql5 installed package old?

In the meantime, I've fixed a compilation issue with MySQL 5.0.92 and will soon put it into experimental for testing.

Maciej
(0009316)
gadavis   
2011-09-30 23:06   
Per your email about the unstable catalog being goofed up a bit, I just tested the new version you tossed into unstable. Looks like it works, both client and server.
(0009317)
maciej   
2011-10-01 14:05   
The dublin catalog was in a bad state, where libmysqlclient and the main mysql packages were not in sync. This is fixed now, new mysql-5.0.92 packages have been pushed to dublin.