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 1.10.2.6.2.1 2007/01/01 09:36:05 sebastian Exp $ SQLite Library 3.3.7
Zend Information
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
Okay I have been trying to get this stuff installed but have been running into problems. I have been using this URL as reference for installing PDO and PDO_MYSQL:
Is that the right thing to do for both of those extensions? I can do that for PDO no problem but when I try that with PDO_MYSQL and then try to restart apache here is the error that I get:
/etc/init.d/httpd: line 83: 18100 Segmentation fault $HTTPD -DSSL
/etc/init.d/httpd start: httpd could not be started
Are you using shared hosting or local server (ex. WAMP/XAMMP) ? If local server than you must restart the Apache but not only by ending it but also by killing process (ex. Task Manager in Windows) .
Please check also with phpinfo if those modules are in use.
Okay I have been trying to get this stuff installed but have been running into problems. I have been using this URL as reference for installing PDO and PDO_MYSQL:
Is that the right thing to do for both of those extensions? I can do that for PDO no problem but when I try that with PDO_MYSQL and then try to restart apache here is the error that I get:
/etc/init.d/httpd: line 83: 18100 Segmentation fault $HTTPD -DSSL
/etc/init.d/httpd start: httpd could not be started
I also added these 2 lines to the PHP.ini File:
extension=pdo.so
extension=pdo_mysql.so
Any ideas would be awesome.
I am also getting a segmentation fault error when restarting apache...but its a little different:
httpd[23077]: segfault at 00000020abef8f07 rip 00000020abef8f07 rsp 00000000006e6ad0 error 14
is your server 32bit or 64bit architecure? because i think this may be a problem with 64bit servers.
has anybody gotten POD_MYSQL to work on 64bit server?
A.Piotrowski (Lento.pl) - 08 September 2007 10:45 AM
Are you using shared hosting or local server (ex. WAMP/XAMMP) ? If local server than you must restart the Apache but not only by ending it but also by killing process (ex. Task Manager in Windows) .
Please check also with phpinfo if those modules are in use.
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:
“--with-pdo-mysql”
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.
Hi all. I’m from Italy.
I’m new and i’m trying to install Magento in remote.
I’ve received the same error on my server and i’d like to ask you how to make Magento working with my hosting plan…
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;
cd /usr/ports/databases/php5-pdo_mysql/
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.