MySQL ODBC Connector - How to update libmysqlclient

Author

How to update libmysqlclient

thomas Armstrong

2005-09-28, 11:23 am

Hi.

Working on Linux Fedora Core 2.

I'm programming an application which requires version 14 of the MySQL Clien=
t
libraries. Now I've got version 10:
---------------
[root@pc]# mysql_config --libs
-L'/usr/lib/mysql' -lmysqlclient -lz -lcrypt -lnsl -lm

[root@pc]# locate mysqlclient
/usr/src/mysql-3.23.58/libmysql/.libs/libmysqlclient.so
/usr/src/mysql-3.23.58/libmysql/.libs/libmysqlclient.a
/usr/src/mysql-3.23.58/libmysql/.libs/libmysqlclient.so.10
/usr/src/mysql-3.23.58/libmysql/.libs/libmysqlclient.so.10.0.0
/usr/src/mysql-3.23.58/libmysql/.libs/libmysqlclient.lai
/usr/src/mysql-3.23.58/libmysql/.libs/libmysqlclient.la
/usr/src/mysql-3.23.58/libmysql/libmysqlclient.la
/usr/local/mysql/lib/mysql/libmysqlclient.la
/usr/local/mysql/lib/mysql/libmysqlclient.so.10.0.0
/usr/local/mysql/lib/mysql/libmysqlclient.so
/usr/local/mysql/lib/mysql/libmysqlclient.a
/usr/local/mysql/lib/mysql/libmysqlclient.so.10
-------------------

So, I downloaded 'MySQL-client-4.1.14-0.i386.rpm' and installed it:
[root@pc]# rpm -Uvh --force MySQL-client-4.1.14-0.i386.rpm

However, I don't find 'libmysqlclient.so.14'
-----------
[root@pc]# ll /usr/lib/mysql/
total 1816
-rw-r--r-- 1 root root 10784 Apr 3 06:16 libdbug.a
-rw-r--r-- 1 root root 33840 Apr 3 06:16 libheap.a
-rw-r--r-- 1 root root 14410 Apr 3 06:16 libmerge.a
-rw-r--r-- 1 root root 238224 Apr 3 06:16 libmyisam.a
-rw-r--r-- 1 root root 22056 Apr 3 06:16 libmyisammrg.a
-rw-r--r-- 1 root root 295278 Apr 3 06:16 libmysqlclient.a
-rw-r--r-- 1 root root 300568 Apr 3 06:16 libmysqlclient_r.a
lrwxrwxrwx 1 root root 26 Apr 27 13:33 libmysqlclient_r.so ->
libmysqlclient_r.so.10.0.0
lrwxrwxrwx 1 root root 26 Apr 27 13:33 libmysqlclient_r.so.10 ->
libmysqlclient_r.so.10.0.0
-rwxr-xr-x 1 root root 215352 Apr 3 06:16 libmysqlclient_r.so.10.0.0
lrwxrwxrwx 1 root root 24 Apr 27 13:33 libmysqlclient.so ->
libmysqlclient.so.10.0.0
lrwxrwxrwx 1 root root 24 Apr 27 13:33 libmysqlclient.so.10 ->
libmysqlclient.so.10.0.0
-rwxr-xr-x 1 root root 213356 Apr 3 06:16 libmysqlclient.so.10.0.0
-rw-r--r-- 1 root root 143510 Apr 3 06:16 libmystrings.a
-rw-r--r-- 1 root root 187886 Apr 3 06:16 libmysys.a
-rw-r--r-- 1 root root 104992 Apr 3 06:16 libnisam.a
-rwxr-xr-x 1 root root 10682 Apr 3 06:16 mysqlbug
-rwxr-xr-x 1 root root 3059 Apr 3 06:16 mysql_config

[root@pc /]# find . -name "*libmysqlclient.so.14*"
(empty)
[root@pc /]#

[root@pc]# /sbin/ldconfig -v | grep libmysqlclient
libmysqlclient.so.10 -> libmysqlclient.so.10.0.0
libmysqlclient_r.so.10 -> libmysqlclient_r.so.10.0.0
libmysqlclient.so.10 -> libmysqlclient.so.10.0.0
--------------------

Could anybody tell me please what I am doing wrong? When I find it,
must I perform a soft link to these libraries from '/usr/lib/mysql/'?.

Thank you very much.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Joerg Bruehe

2005-09-29, 7:24 am

Hi Thomas, all!

thomas Armstrong wrote:
> Hi.
>
> Working on Linux Fedora Core 2.
>
> I'm programming an application which requires version 14 of the MySQL Client
> libraries. Now I've got version 10:
> ---------------
> [[...]]
> /usr/src/mysql-3.23.58/libmysql/.libs/libmysqlclient.so.10
> /usr/src/mysql-3.23.58/libmysql/.libs/libmysqlclient.so.10.0.0
> [[...]]

Well, that was installed with MySQL 3.23.58 which is fairly old.
MySQL 4.1 comes with version 14 of that shared lib.

>
> So, I downloaded 'MySQL-client-4.1.14-0.i386.rpm' and installed it:
> [root@pc]# rpm -Uvh --force MySQL-client-4.1.14-0.i386.rpm
>
> However, I don't find 'libmysqlclient.so.14'
> [[...]]

Yes - because that "client RPM" package contains just the applications,
but no separate libraries:

....> rpm2cpio MySQL-client-4.1.14-0.i386.rpm | cpio -it
usr/bin/msql2mysql
usr/bin/mysql
usr/bin/mysql_find_rows
usr/bin/mysql_tableinfo
usr/bin/mysql_waitpid
usr/bin/mysqlaccess
usr/bin/mysqladmin
usr/bin/mysqlbinlog
usr/bin/mysqlcheck
usr/bin/mysqldump
usr/bin/mysqldumpslow
usr/bin/mysqlimport
usr/bin/mysqlshow
usr/share/man/man1/mysql.1.gz
usr/share/man/man1/mysqlaccess.1.gz
usr/share/man/man1/mysqladmin.1.gz
usr/share/man/man1/mysqldump.1.gz
usr/share/man/man1/mysqlshow.1.gz
24165 blocks

>
> Could anybody tell me please what I am doing wrong? When I find it,
> must I perform a soft link to these libraries from '/usr/lib/mysql/'?.

The "shared RPM" has them:
....> rpm2cpio MySQL-shared-4.1.14-0.i386.rpm | cpio -it | grep
libmysqlclient
4793 blocks
usr/lib/libmysqlclient.so
usr/lib/libmysqlclient.so.14
usr/lib/libmysqlclient.so.14.0.0
usr/lib/libmysqlclient_r.so
usr/lib/libmysqlclient_r.so.14
usr/lib/libmysqlclient_r.so.14.0.0

If you do not want to install it all, use "rpm2cpio" and then do a
selective extract.

HTH,
Jörg

--
Joerg Bruehe, Senior Production Engineer
MySQL AB, www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links