php failed to connect to MySql

php/mysql connectivity problem

[kennethckk]

Hi all,

I got Redhat9 installed on my server with an aim to support Apache Triad. Since the package already comes with php4.2.2/ Apache2.040 / MySql3.23.54a. Everything seems to be okey except php/mysql connectivity, the error message I got from phpMyAdmin was that php seemed unable to load the 'mysql.so' from the system.

I then tried to locate this mysql.so, I got this from the perl5 folder and have it copied to this directory 'extension=/usr/lib/php4/' but that doesnt help at all.

Also, from the php test script, I saw --with mysql=share,/usr. Does it mean that mysql already complied and should be working well with php without the need to dynamically load the mysql.so.

Can someone help to advise if anything is missed out to get it works?

Thanks in advance.

kennethckk

[MattyMoose]

It looks like you don't have the mysql client libraries installed.

To see if it's installed, run this at the command-line as root:

rpm -qa¦grep -i "mysql"

Let us know what it comes back with, but I can tell you that if it doesn't return anything like "mysql client libraries", then you need to install the MySQL client for PHP to use. It *SHOULD* have installed it when you installed PHP, but these things happen.

Oh, and I'd recommend going to a newer version of everything. PHP 4.2.2 is pretty out of date (4.3.8 was released last week, as well as PHP5), and there are newer, less bug-ridden versions of mysql (client/server) and I'd also update apache, especially if you're going to make it publically available. That'll reduce your chances of getting 0wned.

Someone did mention in here a little while ago that there is a site out there that has up-to-date RPMs of a standard LAMP setup. I can't remember the name of it, but hopefully someone remembers. :)

[kennethckk]

Thanks for the info.

I tried " rpm -q¦grep -i mysql " with response as follow;
rpmq: no argument given for query.

I tried another " rpm -ql mysql " with the following four files coming out under /usr/lib/mysql/ directory.

1. libmysqlclient_r.so.10
2. libmysqlclient_r.so.10.0.0
3. libmysqlclient.so.10
4. libmysqlclient.so.10.0.0

Having got these files, I dont know where should I put these files to get php/mysql connected. Should I copy all these files under /usr/lib/php4/ directory which I've specified "extension=/usr/lib/php4/ "in
php.ini conf file? If negative, where should I put to? Please advise. Thx a lot.

Cheers/kennethckk

[nobody]

I agree that it sounds like you're missing the client libraries.

You could try doing :
rpm -q mysql-client

to see if it's installed, and then try :
up2date --install mysql-client

to download/install them.

<cludge>You could also try linking a file called mysql.so to the mysql client library.. see if that wakes it up</cludge>

HTH

[MattyMoose]

whoops, that was my bad...

I meant "rpm -qa¦grep mysql", but nobody's idea was relevant as well... I've had to do that a few times as well with other programs... It gets kinda messy, and it's not really garanteed to do anything, but every once in a while, it's magic. ;)

[kennethckk]

Sorry for my belated response to the mails.

I finally get this thing resolved. Since I'm new to Linux/RH9, I missed to install both php-mysql-4.2.2-17 & mod_auth_mysql-basic authentication for Apache to work with mysql. These two packages can easily be loaded through RH9's application install/delete feature.

My sincere thanks to all to help me out to keep things moving.

I've just got the Apache Triad up and running on the linux box (I used to run on XP prof ) and now going to move my web application to this new platform.

Cheers and have a nice weekend.
Kennethckk