Comments - Installation Issues with PHP5
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.
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
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
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.
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?
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.
Look at that. So simple. Worked like a champ. Thanks so much. Alan
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.
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.
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?