Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Can't get PDO driver to work :(

edited January 2011 in Vanilla 2.0 - 2.8
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 :(

Comments

  • LincLinc Detroit Admin
    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?
  • phpinfo() gives me two sections:

    PDO
    PDO drivers: sqlite, sqlite2

    and

    pdo_sqlite
    SQLite Library: 3.6.22
  • TimTim Operations Vanilla Staff
    Until your phpinfo()'s PDO section contains the word 'mysql', you wont have any luck:

    image

    Vanilla Forums COO [GitHub, Twitter, About.me]

  • Thanks for the screenshot Tim! No, I don't have 'mysql' in there :(
  • 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!
Sign In or Register to comment.