Comments - Installation Issues with PHP5

12 years, 7 months ago Alan Sawyer

I have an existing website that was working. I am use php 5.2, and it was mysql 5.0.77.

I want to use MariaDB so I uninstall mysql as instructed and installed mariadb. I have the database working fine, but the script I'm using is getting an error with the mysql_connect command. This is not a script I wrote, so I would prefer to not try option 1. Seems like option 4 would be best,k however I don't know exactly how to install my "original MySQL client library". Can someone help? Alan

 
12 years, 7 months ago Alan Sawyer

I am using Maria 5.3 and the exact error I'm getting is: Fatal error: Call to undefined function mysql_connect() in /home/mydomainname/public_html/_lib/prod/third/adodb/drivers/adodb-mysql.inc.php on line 365

 
12 years, 7 months ago Alan Sawyer

I think I'm needing to download and install an rpm package like: MySQL-client-5.5.15-1.rhel5.x86_64.rpm

However when I try installing that, it says that it conflicts with maridb.

I am slightly confused, so any help would be great.

I am using Centos 5 64 bit.

Alan

 
12 years, 7 months ago Alan Sawyer

Do I have to uninstall MariaDB client?? and then reinstall MySQL client?? and if so, is version 5.5 of MySQL Client the one I would want to use with MariaDB 5.3?

Alan

 
12 years, 7 months ago Brian Evans

Your PHP install is looking for a PHP function called mysql_connect. This is commonly found as an extension.

The package name in CentOS is php-mysql.

You can detect what extensions to PHP are installed by using phpinfo() OR 'php -i' from a shell.

 
12 years, 7 months ago Alan Sawyer

Look at that. So simple. Worked like a champ. Thanks so much. Alan

 
12 years, 3 months ago Ian Douglas

Excuse my ugnorance (new to CentOS, familiar with Gentoo), but what exactly do I need to reinstall?

I tried yum reinstall php php-cli php-mysql php-gd

but am still getting the 'minor version mismatch' error when running php scripts from the command line.

Thanks, Ian

 
12 years, 3 months ago Brian Evans

My previous comment was specifically directed to asawyer13.

If you are getting minor version mismatch, you must follow one of the recommendations in the answer.

With CentOS, you would need to recompile the php-mysql SRPM using rpmbuild or its yum equivalent.

Finding a CentOS RPM of PHP 5.3.x should also remove this issue as it should use mysqlnd driver.

 
12 years, 3 months ago Ian Douglas

Thanks, I was trying to do Option 3, but obviously not succeeding. I see in the ngingx error log there are also plenty of this mismatch messages.

Can you perhaps point out where I went wrong with the command I used?

Thanks :-)

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.