Debian + Apache + PHP + MySQL.so = Error
 

Hi there guys and girls :D




The basic problem

I'm trying to run phpMyAdmin which is a php admin script for MySQL database server.... it requires the following

Apache (Working)
PHP (Working, using version 4)
MySQL.so (Not working)

mysql.so is located at /user/lib/php4/20020429/mysql.so???

I currently have postgresql and phppgadmin installed and working

pgsql.so is located at /user/lib/php4/20010901/pgsql.so

In my php.ini file I have

extension=pgsql.so
extension=mysql.so




More in depth into the problem

When I try to run the script I get the following error message

"cannot load mysql extension;
please check PHP configuration
Documentation"

In the documentation it says

"Usually, the problem is solved by installing a software package called "PHP-MySQL" or something similar."

apt-get install php4-mysql
Reading Package Lists... Done
Building Dependency Tree... Done
php4-mysql is already the newest version.

:confused:




My troubleshooting so far

I've been googling and it looks as if the link to the mysql.so isn't working...

My current extentsion dir is commented out but the pgsql.so works?!
; extension_dir = ./

?!



Help :(

critical, looks like it's your case that the link is broken...i don't use php with postgree, but from my windows experience I know that you should copy mysql.so in the extension dir and uncomment the extension dir(it comes commented in php, but you MUST uncomment it for extensions 2 work).Otherwise, you could set the path 2 mysql.so somewhere in the file, usually down under the extension dir..good luck.tell me if it works.plz.

Hey there, thanks for the tips

I've changed my extension dir to /user/lib/php4 and also copied mysql.so to that directory

I created a phpinfo() dump here

I noticed that mysql.so doesn't appear under "additional modules"?

Still doesn't work...

I'm confused =)

I fixed the issue by doing the following

apt-get remove php4-mysql
apt-get remove php4-pgsql
apt-get remove php4

apt-get install php4
apt-get install php4-mysql
apt-get install php4-pgsql

:D

apt-get rocks!

yes, unfortunatley just for debian...it is true there is apt4rpm, but i downloaded it and guess what : more dependencies before instalation :D.