Can't get PDO driver to work :(

bartclaeys

Trying to install Vanilla 2 locally using MAMP but get 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 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

So everything seems to be fine, but can't get it working

Linc

That's very odd since PDO installs with MAMP by default I believe.

Can you do a phpinfo() file and confirm the PDO section is present?

bartclaeys

phpinfo() gives me two sections:

PDO
PDO drivers: sqlite, sqlite2

and

pdo_sqlite
SQLite Library: 3.6.22

Tim

Until your phpinfo()'s PDO section contains the word 'mysql', you wont have any luck:

bartclaeys

Thanks for the screenshot Tim! No, I don't have 'mysql' in there

bartclaeys

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!