MySQL Bugs: #17205: libmysqlclient.so missing in Solaris .pkg archive

Bug #17205	libmysqlclient.so missing in Solaris .pkg archive
Submitted:	7 Feb 2006 21:25	Modified:	3 Oct 2008 16:10
Reporter:	Per Hall	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Packaging	Severity:	S3 (Non-critical)
Version:	5.0.18	OS:	Solaris (Solaris 10)
Assigned to:		CPU Architecture:	Any

Description:
I installed a fresh mysql 5:

mysql-standard-5.0.18-solaris10-i386.pkg
mysql-standard-5.0.18-solaris10-sparc-64bit.pkg

The package installation gets fine (but lots of attribute verification failed errors that did not affect operation) and can be started manually for verification.

When using apache with mysql I need the libmysqlclient.so.NN file.
This is not included in the Solaris .pkg distribution at all.

The included docs/mysql.info file hints at Linux MySQL-shared-compat package or building from source to get the libmysqlclient.so archive. 

The forum says this file should be in the mysql-shared archives for linux etc, but there is no such distinction for the Solaris packages.

Building from source is a functional workaround, but leaves the solaris .pkg less usable - a pity as it's very handy and understands zones, a very nice feature.
(I solved my problem by copying it from an old MySQL 4.1 source installation.)

How to repeat:
pkgadd -d mysql-standard-5.0.18-solaris10-i386.pkg

find /opt/mysql | grep libmysqlclient.so

Suggested fix:
Include the shared parts, specifially the libmysqlclient.so needed for apache integration, in the Solaris .pkg package.  (Or worse, make a separate -shared pkg)

Thank you for a problem report. This is a known problem for Solaris and some other platfroms, that will be fixed some day. I can not give you any exact version or timeframe, though.

In the meantime, you have to build from sources to get that .so.x libraries.

Seriously, this is adsurd.  I know that this is free software and all, but if you are going to bother supplying a package for solaris, it should be usable in the context people tend to use things.  People write web applications using Apache.  People write scripts using Perl.  Withouth this shared library, you can't do that.  Its silly.

At the very least you all should create a downloadable version of the library and attach it to this message.

Seems to be the same story on Mac OS X - just grep'd the tar version packages and found only the static libraries for libmysqlclient.  Will see how the build-from-source goes... I trust that will resolve for me, but in the mean time, please add comments to the download page that the .so libraries are NOT included!  It would have saved me a couple of hours wondering what was wrong with my install, or in what strange location they might have been put.

Problem still persists in 5.0.21

problem still persists in 5.0.37

Seems to be fixed in version 5.0.45 downloaded as a .pkg for Solaris 9 from sunfreeware. It included libmysqlclient.so.15.0.0 which I then used by copying it on to my target server running mysql 5.0.22.

Needs to be re-verified.

The library is definitely in the .pkg in 5.0.67:

-bash-3.00$ strings mysql-5.0.67-solaris10-i386.pkg | grep libmysqlclient.so
1 f none mysql/lib/libmysqlclient.so 0755 root bin 3512516 62695 1217856989
1 f none mysql/lib/libmysqlclient.so.15 0755 root bin 3512516 62695 1217856989
1 f none mysql/lib/libmysqlclient.so.15.0.0 0755 root bin 3512516 62695 1217856989
1 f none mysql/lib/libmysqlclient.so 0755 root bin 3512516 62695 1217856989
1 f none mysql/lib/libmysqlclient.so.15 0755 root bin 3512516 62695 1217856989
1 f none mysql/lib/libmysqlclient.so.15.0.0 0755 root bin 3512516 62695 1217856989
...

So, this problem is already fixed, it seems.