PDO loads fine in Magento but not in external CMS

Question

I am having a problem similar to https://stackoverflow.com/questions/2386575/the-pdo-extension-is-required-for-this-adapter-but-the-extension-is-not-loaded but not the same.

The Magento install is running fine but when I try to run:

require_once(APATH.MAGEPATH.'/app/Mage.php');
umask(0);
Mage::app();

in a directory outside of Magento I get the error:

Fatal error: Uncaught exception 'Zend_Db_Adapter_Exception' with message 'The PDO extension is required for this adapter but the extension is not loaded' in
/home/inzana/public_html/Store/lib/Zend/Db/Adapter/Pdo/Abstract.php:342 
Stack trace: #0 /home/inzana/public_html/Store/lib/Zend/Db/Adapter/Abstract.php(247): Zend_Db_Adapter_Pdo_Abstract->setFetchMode(2) 
#1 /home/inzana/public_html/Store/app/code/core/Mage/Core/Model/Resource.php(165): Zend_Db_Adapter_Abstract->__construct(Array) 
#2 /home/inzana/public_html/Store/app/code/core/Mage/Core/Model/Resource.php(110): Mage_Core_Model_Resource->_newConnection('pdo_mysql', Object(Mage_Core_Model_Config_Element)) 
#3 /home/inzana/public_html/Store/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(320): Mage_Core_Model_Resource->getConnection('core_write') 
#4 /home/inzana/public_html/Store/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(350): Mage_Core_Model_Resource_Db_Abstract->_getConnection('write') 
#5 /home/inzana/public_html/Store/app/code/core/Mage/Core/Model/R in /home/inzana/public_html/Store/lib/Zend/Db/Adapter/Pdo/Abstract.php on line 342

I am running phpinfo(INFO_GENERAL); followed by the code that causes the error on this page: http://inzanaranch.com/test

The local php.ini file includes:

extension=pdo.so
extension=pdo_sqlite.so
extension=sqlite.so
extension=pdo_mysql.so

I am a loss of where to go next. Any help appreciated.

Answer 1

When in doubt, add some temporary logging. There's something about your environment that's either turning PDO off, or there's a different PHP binary in your path when you're running it.

First, make sure you're using the PHP you think you are by running the following from the command line.

$ which php

This will tell you which PHP is in your path.

Next, open up lib/Zend/Db/Adapter/Pdo/Abstract.php and find the exception location

if (!extension_loaded('pdo')) {
    /**
     * @see Zend_Db_Adapter_Exception
     */
    #require_once 'Zend/Db/Adapter/Exception.php';
    throw new Zend_Db_Adapter_Exception('The PDO extension is required for this adapter but the extension is not loaded');
}

Then add some poor man's logging in front of the exception (Don't forget this is here, you'll want to remove this).

ob_start();
phpinfo();
echo "\n--------------------------------------------------\n";
print_r($_SERVER);
$message = ob_end_clean();
file_put_contents('/tmp/no-pdo.log',"\n",FILE_APPEND);

throw new Zend_Db_Adapter_Exception('The PDO extension is required for this adapter but the extension is not loaded');

Run your script.

Copy /tmp/no-pdo.log to your home directory, and then remove it and your logging code. The no-pdo.log will contain your PHP info at the time the error occurred. This will let you track down the problem — which is likely a rogue php.ini file.

Answer 2

Checking pdo extension installed or not

echo 'Checking pdo extension installed or not';
echo '<pre/>';
extension_loaded ('PDO' ); // returns boolean

// or

extension_loaded('pdo_mysql');

// or get all extensions and search for a specific one

print_r(get_loaded_extensions());  exit();

If installed then show in print result array like below

[41] => PDO    [42] => pdo_sqlite    [43] => pdo_mysql

Answer 3

Where are you calling require_once(APATH.MAGEPATH.'/app/Mage.php'); from?
Are you doing it as a different user?

Looking at the phpinfo() you posted, each user has their own php.ini - so I'm guessing wherever you are trying to include Mage.php from is using a different user, with a different php.ini that doesn't have the PDO extension loaded.