"Error: Mysql driver is NOT enabled" (editing suphp.conf, changing php binary)

0
votes

With this binary (PHP 5.3.10-1ubuntu3.26) :

application/x-httpd-suphp="php:/usr/bin/php-cgi

I have no problem.

But when I try to use this one which is an higher version of php (PHP 5.5.38) :

application/x-httpd-suphp="php:/usr/local/bin/php-cgi"

I get a problem on my Cakephp 2.x application :

Error: A Database connection using "Mysql" was missing or unable to connect. The database server returned this error: Selected driver is not enabled

Error: Mysql driver is NOT enabled

Notice: If you want to customize this error message, create app/View/Errors/missing_connection.ctp

Stack Trace

CORE/Cake/Model/ConnectionManager.php line 105 → DboSource->__construct(array) CORE/Cake/Model/Model.php line 3626 → ConnectionManager::getDataSource(string) CORE/Cake/Model/Model.php line 1155 → Model->setDataSource(string) CORE/Cake/Model/Model.php line 3653 → Model->setSource(string) CORE/Cake/Model/Model.php line 3031 → Model->getDataSource() CORE/Cake/Model/Model.php line 3003 → Model->_readDataSource(string, array) APP/Controller/AppController.php line 87 → Model->find(string, array) APP/Controller/HomeController.php line 10 → AppController->beforeFilter() [internal function] → HomeController->beforeFilter(CakeEvent) CORE/Cake/Event/CakeEventManager.php line 243 → call_user_func(array, CakeEvent) CORE/Cake/Controller/Controller.php line 676 → CakeEventManager->dispatch(CakeEvent) CORE/Cake/Routing/Dispatcher.php line 189 → Controller->startupProcess() CORE/Cake/Routing/Dispatcher.php line 167 → Dispatcher->_invoke(HomeController, CakeRequest) APP/webroot/index.php line 115 → Dispatcher->dispatch(CakeRequest, CakeResponse)

Does someone have an idea to resolve this ?

Thank you,

1
phpmysqlapachecakephp

1 Answers

1
votes

Check in the php.ini of your PHP5.5 installation weather the MySQL driver is loaded:

extension=mysqli.so
extension=mysql.so
extension=pdo_mysql.so

However, the original MySQL extension is in PHP5.5 deprecated, and will generate E_DEPRECATED errors when connecting to a database. Instead, use the MySQLi or PDO_MySQL extensions.