Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: jbrice on February 21, 2005, 10:28:23 AM

Title: MySQL not working after PHP update
Post by: jbrice on February 21, 2005, 10:28:23 AM

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.

Title: Re: MySQL not working after PHP update
Post by: guest22 on February 21, 2005, 01:00:00 PM

Quote from: "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 ?

Title: Re: MySQL not working after PHP update
Post by: jbrice on February 21, 2005, 01:58:19 PM

Quote from: "guest22"

Quote from: "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.

Title: MySQL not working after PHP update
Post by: ergozd on February 21, 2005, 02:50:14 PM

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

Title: MySQL not working after PHP update
Post by: jbrice on February 21, 2005, 03:12:58 PM

Quote from: "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

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.

Title: MySQL not working after PHP update
Post by: ergozd on February 21, 2005, 06:25:21 PM

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

Title: MySQL not working after PHP update
Post by: jbrice on February 21, 2005, 08:37:29 PM

Quote

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.

Title: MySQL not working after PHP update
Post by: jbrice on February 22, 2005, 11:02:16 AM

Quote

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.

Title: MySQL not working after PHP update
Post by: ergozd on February 22, 2005, 03:23:04 PM

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

Title: MySQL not working after PHP update
Post by: jbrice on February 22, 2005, 03:30:43 PM

Quote

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.