After a long day of uploading magento I’m confronted with the following error, there’s no way to proceed otherwise however I would appreciate knowing if there is something that I can modify in order to install.
UnixBox running Apache and Php 5
PHP Extension "pdo_mysql" must be loaded. Please set required permissions before clicking Continue
The server that it is running on contains the following information (maybe of use?)
PDO PDO support enabled PDO drivers sqlite2, sqlite
pdo_sqlite PDO Driver for SQLite 3.x enabled PECL Module version (bundled) 1.0.1 $Id: pdo_sqlite.c,v 22.214.171.124.2.1 2007/01/01 09:36:05 sebastian Exp $ SQLite Library 3.3.7
This program makes use of the Zend Scripting Language Engine: Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies with Zend Extension Manager v1.2.0, Copyright (c) 2003-2007, by Zend Technologies with Zend Optimizer v3.2.8, Copyright (c) 1998-2007, by Zend Technologies
Yes. But when I restarted apache it came up with that fault code error. Then I deleted the PDO_MYSQL.so and apache restarted fine. I am wondering if there is a compile problem with the latest version of PDO_MYSQL.so from the PHP.net website?
I ran into this issue as well…
I’m on a dedicated machine so I was able to handle this myself but the Solution was that I had to re-make PHP with the PDO_mysql extension. Just enabling the extension in PHP.ini doesn’t matter if it’s not installed in the first place. I was banging my head against a wall because I didn’t read carefully that my PHP info stated that Pdo WAS installed… but only for SQLite. This is because with PHP 5+ PDO comes activated DEFAULT but only with drivers for SQLite. SO ... what I had to do was install the PDO_mysql driver into PHP and it worked fine.
The command I used via EasyApache (For Cpanel Users) is:
So if you have Cpanel and SSH access or if you can get your host to re-install PHP (takes about 15 mins) here’s what you would do. (This is for CPANEL users):
That will rebuild PHP along with the drivers for PDO_mysql. Take note that it will rebuild the entire PHP installation so when it asks you for a New install choose the #7 option which is to use PREVIOUS values (that way all you are doing is UPDATING the installation with PDO_mysql rather than building from scratch.
I have gotten BlueHost to enable the pdo_mysql extension, and they provided me with a php.ini file, instructed me to add the extension=pdo_mysql.so to it, which I did, then said: “copy this file to all directories, including subdirectories, that have PHP files in them” Now, that seems like it shouldn’t be necessary, also because there are like 24000 files, and lots of directories, I don’t think it is even really do-able.
So, where do I place the php.ini file so that Magento sees it? I have it in the root with the index.php, and in the app/ directory as well. Where else should it be to be effective?
I have checked, in these two places it is still not making a difference. Still get the PHP Extension “pdo_mysql” must be loaded error message.
Anyone with a dedicated server running FreeBSD having installed PHP5 with ports will notice there is no way to add pdo_mysql by editting the php.ini file or in the list of options for ‘php5-extensions’ port.
You can easily correct this though by issuing the following commands in SSH as root;
make install clean
Now Magento will install
And if you get a ‘PDOException’ or ‘errno 12’ just drop the database, recreate it then reload the page it will fill in the tables.