MySQL Bugs: #13304: Failed dependencies: libmysqlclient.so.10()(64bit) is needed

Bug #13304	Failed dependencies: libmysqlclient.so.10()(64bit) is needed
Submitted:	18 Sep 2005 8:34	Modified:	1 Nov 2011 4:18
Reporter:	Paolo Santinelli	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Packaging	Severity:	S2 (Serious)
Version:		OS:	Linux (Linux Fedora 2 x86_64)
Assigned to:		CPU Architecture:	Any

Description:
I need to update Mysql on Fedora 2 AMD64. The actually running version is :

mysql  Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (x86_64).

When I try to install a newer version (server-4.1) I get some dependence errors:

[root@caronte mysql]# rpm -hUv --test MySQL-server-4.1.12-1.glibc23.x86_64.rpm 
warning: MySQL-server-4.1.12-1.glibc23.x86_64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
        libmysqlclient.so.10()(64bit) is needed by (installed) perl-DBD-MySQL-2.9003-4
        libmysqlclient.so.10()(64bit) is needed by (installed) mod_auth_mysql-20030510-4.1
        libmysqlclient.so.10()(64bit) is needed by (installed) php-mysql-4.3.10-2.4

How to repeat:
I think that I need some shared-compat rpm for AMD64 but I didn't find it.

Thanks 

Paolo Santinelli

Please, try to download and install newer version from http://dev.mysql.com/downloads/mysql/4.1.html. I'd recommend to use tar.gz distribution (http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-standard-4.1.14-unknown-linux-gnu-x86_6...), but there are RPM's also:

http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-server-4.1.14-0.glibc23.x86_64.rpm/from...

Inform about the results, please.

I made these actions:

I downloaded these rpm:

MySQL-server-4.1.14-0.glibc23.x86_64.rpm 
MySQL-shared-4.1.14-0.glibc23.x86_64.rpm
mysqlclient10-3.23.58-6.x86_64.rpm
 
(http://fedora.inode.at/development/x86_64/Fedora/RPMS/mysqlclient10-devel-3.23.58-6.x86_64...)

I removed these old packages:

 rpm -e mysql-server
 rpm -e --nodeps mysql
  
and then I installed the downloaded packages.

  rpm -hiv MySQL-server-4.1.14-0.glibc23.x86_64.rpm 
  rpm -hiv MySQL-shared-4.1.14-0.glibc23.x86_64.rpm 
  rpm -hiv mysqlclient10-3.23.58-6.x86_64.rpm 

and restarted mysql.

All appeared run very well,  I was able  to see and modify my databases using phpMyadmin ... For a week all run ok,  until I restarted the web server (httpd).

When I restart httpd, the process don't start. I get this error:

Syntax error on line 6 of /etc/httpd/conf.d/auth_mysql.conf:
Cannot load /etc/httpd/modules/mod_auth_mysql.so into server: /usr/lib64/mysql/libmysqlclient.so.10: symbol __fprintf_chk, version GLIBC_2.3.4 not defined in file libc.so.6 with link time reference.

So I removed  the removed mod_auth_mysql-20030510-5.x86_64.rpm and installed the newer  mod_auth_mysql-2.6.1-4.x86_64.rpm .

Now I can start httpd but I cannot see my databases using PHP  by phpMyadmin. When I try to see my databases, I receive the error “cannot load MySQL extension, please check PHP configuration”.

????

Any Idea ?!

Thanks

According to your description, this problem has nothing to do with MySQL server, but, may be with rpm packaging and dependencies tracking only (the well know problem with RPM as technology)...

I'd recommend you to verify PHP configuration (check, is it needed to change any directories, library versions etc according to the new MySQL version installed), as it is suggested. If it will not help, I think, you have to reinstall php-mysql-4.3.10-2.4 (or a newer package version) and it should pick a new configuration. Inform me about the results, please.

In the meantime I see no MySQL bugs described by this report, really.

Thanks Valeriy Kravchuk,

I think you are in right, It is a httpd-PHP problem.

I tried to reinstall php-mysql-4.3.10-2.4 but nothing is changed.

Inside the httpd error_log file there is this error:

PHP Warning:  Unknown(): Unable to load dynamic library '/usr/lib64/php4/mysql.so' - /usr/lib64/mysql/libmysqlclient.so.10: symbol __fprintf_chk, version GLIBC_2.3.4 not defined in file libc.so.6 with link time reference in Unknown on line 0

but both the dynamic libraries seem ok :

[root@caronte php4]# ls -l /usr/lib64/php4/
totale 1904
-rwxr-xr-x  1 root root   95648 21 dic  2004 imap.so
-rwxr-xr-x  1 root root   45600 21 dic  2004 ldap.so
-rwxr-xr-x  1 root root 1663888 21 dic  2004 mbstring.so
-rwxr-xr-x  1 root root   51680 21 dic  2004 mysql.so
-rwxr-xr-x  1 root root   63680 21 dic  2004 odbc.so

[root@caronte php4]# ls -l /usr/lib64/mysql/
totale 1024
lrwxrwxrwx  1 root root     26 20 set 22:59 libmysqlclient_r.so.10 -> libmysqlclient_r.so.10.0.0
-rwxr-xr-x  1 root root 238552  9 apr 01:37 libmysqlclient_r.so.10.0.0
lrwxrwxrwx  1 root root     24 20 set 22:59 libmysqlclient.so.10 -> libmysqlclient.so.10.0.0
-rwxr-xr-x  1 root root 233856  9 apr 01:37 libmysqlclient.so.10.0.0
-rw-r--r--  1 root root 555981 23 ago 14:30 mysqld.sym

If I query the rpm databases to find the pakages that contains the dynamic libraries, I get:

rpm -qf /usr/lib64/php4/mysql.so
php-mysql-4.3.10-2.4

[root@caronte php4]# rpm -qf /usr/lib64/mysql/libmysqlclient.so.10
mysqlclient10-3.23.58-6

I think that the problem should be the new libmysqlclient.so.10 installed with mysqlclient10-3.23.58-6. My httpd had run for a week with the old, original  mysqlclient10 library. When I restarted it, the new library had crashed the system.

When try to install the  newer  php-mysql-4.3.11-2.7.x86_64.rpm I get this dep. error:

[root@caronte mysql]# rpm -Uv --test php-mysql-4.3.11-2.7.x86_64.rpm 
error: Failed dependencies:
        php = 4.3.11-2.7 is needed by php-mysql-4.3.11-2.7

maybe  Should I have to update PHP from running version 4.3.10-2.4 to the newer 3.4.11-2.7 !! ??

I am sorry for this bug report to stall for so long. Can you, please, inform about its current status? Have you solved your MySQL 4.1 and PHP related problems?

I would like to add my similar experience in that I have tried to add php-mysql to my x86_64 FC3 server but the install balks at the requirement for MySQL-3... when I am running MySQL-4... (not at the server right now). It appears that the PHP4 mysql.so requires the libmysqlclient.so.10 delivered by MySQl 3... which indicates a packaging problem. I tried a RPM with --nodeps, but as expected the phpinfo() does not pick up mysql support. I plan to try PHP5 to see if it eleviates the situation.

After a failed attempt to instal php5 I reinstalled php4 and got upto speed with the mysqlclient10 rpm and made sure it was not post fedora core 3 (my level) else you get GLIBC_2.4 dependancy probs. However in my case the "php_sprintf" issue cropped up so I ended up taking out the php4 rpm builds for php-* and built from scratch using the latest stable php CVS snapshot.  Php now recognises MySQL and I can now progress to phpBB2 which is what started all this. I guess this all stems from the apparent unavailability of the AMD x86_64 compat rpms. I already use MySQL successfully in my own product (using Rexx scripts) so I am simply sharing my experience for others who maybe similarly stuck. Thanks for a great product.

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".