Topic: MySQL not working after PHP update

[jbrice]

I have just used one of the available PHP update scripts on a V6.01 installation to move the PHP up to V4.3.10. This ran without any errors, but I now find that mysql is not available via PHP, and the logs show errors such as
"Unknown(): Unable to load dynamic library '/usr/lib/php4/mysql.so' - libmysqlclient.so.12: cannot open shared object file: No such file or directory in Unknown on line 0"
Interpreting this goes beyond my limited understanding of Linux, so I'm hoping someone can suggest a course of action to sort this out.
TIA
J.B.

[guest22]

I have just used one of the available PHP update scripts on a V6.01 installation to move the PHP up to V4.3.10.

Which one specifically ?

[jbrice]

I have just used one of the available PHP update scripts on a V6.01 installation to move the PHP up to V4.3.10.

Which one specifically ?

The one from here ISTR:
http://ergin.dyndns.org/download/php4.3.10-upgrade.sh

J.B.

[ergozd]

Hi there!

What version of MySQL you're running?

You can find out by...
# rpm -qa|grep MySQL
# rpm -qagrep mysql

PS : Missging file is included in MySQL-shared-compat RPM...

Best rgds, Ergin

[jbrice]

Hi there!

What version of MySQL you're running?

You can find out by...
# rpm -qa|grep MySQL
# rpm -qagrep mysql

PS : Missging file is included in MySQL-shared-compat RPM...

Best rgds, Ergin

Here is what it says...

Code: [Select]

# rpm -qa|grep MySQL
perl-DBD-MySQL-1.2219-6
# rpm -qa|grep mysql
mysql-3.23.56-1.73
mysqlclient9-3.23.22-8
mysql-devel-3.23.56-1.73
mysql-server-3.23.56-1.73
e-smith-mysql-1.10.0-02
php-mysql-4.3.10-3eo

J.B.

[ergozd]

Hi again!

PHP RPMS was built on a server with MySQL 4.0.xx and therefore requires libmysqlclient.so.12

Code: [Select]

# rpm -q --requires php-mysql
rpmlib(VersionedDependencies) <= 3.0.3-1
php = 4.3.10-3eo
perl
mysql
/bin/sh
/bin/sh
rpmlib(PayloadFilesHavePrefix) <= 4.0-1
rpmlib(CompressedFileNames) <= 3.0.4-1
ld-linux.so.2
libcrypt.so.1
libc.so.6
libm.so.6
libmysqlclient.so.12
libnsl.so.1
libnss_dns.so.2
libnss_files.so.2
libresolv.so.2
libz.so.1
libc.so.6(GLIBC_2.0)
libc.so.6(GLIBC_2.1.3)


HowTo solve the issue for you?

1 - Uninstall php RPMS and install DanBrowns instead.
http://ergin.dyndns.org/download/php4.3.10-upgrade_db.sh

2 - Upgrade your MySQL-server to version 4.0.xx
http://ergin.dyndns.org/download/MySQL-4_0_23.sh

3 - I am not really sure if this'll work BUT worth a shot if you don't wanna do either of above
Get mysql_12.tar and unpack it in /usr/lib/ and restart you httpd server.

Code: [Select]


# cd /root
# wget http://ergin.dyndns.org/download/mysql_12.tar
# cd /usr/lib/
# tar xvf /root/mysql_12.tar
# service httpd restart


Hope it helps, good luck...
Best rgds, Ergin

[jbrice]

Hope it helps, good luck...
Best rgds, Ergin

I very much appreciate your support, Ergin.
I'll try out those options tomorrow when I am at work and let you know what happens.
Regards,
J.B.

[jbrice]

HowTo solve the issue for you?

1 - Uninstall php RPMS and install DanBrowns instead.
http://ergin.dyndns.org/download/php4.3.10-upgrade_db.sh

2 - Upgrade your MySQL-server to version 4.0.xx
http://ergin.dyndns.org/download/MySQL-4_0_23.sh

3 - I am not really sure if this'll work BUT worth a shot if you don't wanna do either of above
Get mysql_12.tar and unpack it in /usr/lib/ and restart you httpd server.

Code:

# cd /root
# wget http://ergin.dyndns.org/download/mysql_12.tar
# cd /usr/lib/
# tar xvf /root/mysql_12.tar
# service httpd restart


Hope it helps, good luck...
Best rgds, Ergin

I have tried the above in the order shown, but with no cure. Some of the original modules would not uninstall because of reported dependencies, but updated the remainder. The sympton of no PHP-MySQL links remains the same, with logs showing a missing LDAP module in addition to the  missing MySQl module.
I think I'll give up on this one and re-install!
Many Thanks again for your help
J.B.

[ergozd]

Hi jbrice!

I have re-compiled RPMS so that they'll work with mysql-3.23.xx

Try upgrading with the script again. Hope it works better.

Best rgds, Ergin

[jbrice]

Hi jbrice!

I have re-compiled RPMS so that they'll work with mysql-3.23.xx

Try upgrading with the script again. Hope it works better.

Best rgds, Ergin

Ergin,
That's very good of you. I'm going to have to delay any more work on this system as I have lots of other things I must do.
Hopefully I'll get back to this project sometime soon.
Regards,
J.B.