Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Trying to install Vanilla 2 locally using MAMP i got the error: "You must have the MySQL driver for PDO enabled in order for Vanilla to connect to your database".

When I check phpinfo() I see:

--with-pdo-mysql=shared,/Applications/MAMP/Library
--with-pdo-pgsql=shared,/Applications/MAMP/Library/pg

When I go and check out those paths I find the files:

libpq.5.dylib
libpq.dylib
libpq.5.2.dylib

When I check my php.ini file I see:

; Extensions
extension=pdo_mysql.so

In php.ini the path to the extension dir is correct (checked it manually):

extension_dir = "/Applications/MAMP/bin/php5.3/lib/php/extensions/no-debug-non-zts-20090626/"

In this folder I find the file:

pdo_mysql.so

phpinfo() gives me two sections:

PDO
PDO drivers: sqlite, sqlite2

and

pdo_sqlite
SQLite Library: 3.6.22 

So everything seems to be fine, but can't get the PDO MySQL driver working :(

share|improve this question
1  
Solved! phpinfo() showed: Loaded Configuration File : /Applications/MAMP/conf/php5.3/php.ini but that folder did not exist (instead /Applications/MAMP/conf/php5/php.ini) did exist. I've simply renamed the /php5/ folder to /php5.3/, restarted MAMP and everything worked! –  bart Jan 13 '11 at 21:05
add comment

1 Answer

Note that pdo_mysql != pdo_sqlite. It does not appear that it is loading the PDO MySQL driver that Vanilla is looking for. It wouldn't be the first time that PDO-MySQL hasn't worked properly on MAMP.

I know with WAMP it has pre-compiled all of the binaries for you; it might not work in your specific environment because of this. I would recommend compiling PHP and the PDO-mySQL extension manually to make sure it will work.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.