I'm having some serious problems here and I need it fixed ASAP.

I have a dedicated server running Fedora Core 3 that had PHP 4 installed. I ran 'yum update' which upgraded php4 to php5. I realized that php5 does not support mysql: --without-mysql is in the configure command when I put phpinfo() in a file.

I have wordpress domains that all say: Your PHP installation appears to be missing the MySQL which is required for WordPress.

I'm trying to figure out how to get mysql working with php5 or downgrade to php4. I tried removing php5, but yum wants to remove about 50 packages and the packages are very important and I cannot remove them.

I'm stuck here and I can't find any way to resolve this. Any help would be greatly appreciated.

How are your repositories setup?
The standard yum repositories in FC3 should not have PHP5.
So you may wish to contact your support provider to fix this.

Anyways, assuming your yum repository is fairly typical, I think the missing peice is probably the 'php-mysql' package.

# yum install php-mysql

Yes, I have tried that and the command ends with:

Parsing package install arguments
Nothing to do.

From what I can tell, the problem is that the PHP binary that was installed does not have mysql support. I've been trying various packages and compiling from source for the past several hours with no luck.

What is the output of:
# rpm -qa | grep 'php\|mysql'

I would be careful, if this is a production server then mixing installed RPM with compilation from source may lead to a mess.

Another idea is to find the SRC.RPM for the php5 you have installed and recompile that properly with MySQL support.

I have tried to compile the src.rpm with no luck. I always end up with configure errors.

How would I go about compiling from source?

rpmbuild --rebuild php.src.rpm

It runs for about a minute and here are the last couple lines of the output:

checking for MySQL support... yes, shared
checking for specified location of the MySQL UNIX socket... no
checking for MySQL UNIX socket location... no
checking for mysql_close in -lmysqlclient... no
checking for mysql_error in -lmysqlclient... no
configure: error: mysql configure failed. Please check config.log for more information.
error: Bad exit status from /var/tmp/rpm-tmp.12690 (%build)


RPM build errors:
Bad exit status from /var/tmp/rpm-tmp.12690 (%build)

Does PHP5 work with MySQL 4.1?

For compiling, you're missing mysql-devel.
# yum install mysql-devel

yum install mysql-devel
Setting up Install Process
Setting up Repos
psa-7.5 100% |=========================| 951 B 00:00
base 100% |=========================| 1.1 kB 00:00
atomic 100% |=========================| 951 B 00:00
updates-released 100% |=========================| 951 B 00:00
Reading repository metadata in from local files
psa-7.5 : ################################################## 116/116
base : ################################################## 2622/2622
atomic : ################################################## 284/284
updates-re: ################################################## 910/910
Parsing package install arguments
Nothing to do

You're right it is listed in your output above. My mistake.

I'm at a loss, not sure why your system is behaving as such.

It seems like it can't find the location of the mysql socket. Do I need MySQL5 or should it work with MySQL 4.1? I know MySQL is working fine independent of PHP.

Someone suggested I tell rpmbuild where my MySQL socket is: /var/lib/mysql/mysql.sock. Is this possible?

I think I've found a way to do this but I'm not sure how to do it. I believe I need to supply the configure command with MySQL's location with:

--with-mysql-dir=/var/lib/mysql/

How can I supply arguments to configure through rpmbuild?

Edit: Scratch that. Looks like that won't help.

It doesn't seem like it's going to be possible to fix this problem, so it looks like I'll have to have the dedicated server wiped and re-installed so I can re-configure everything from scratch. I guess I won't update with yum again.