Blog of Auzigog – Jeremy Blanchard

I recently started working my way into the world of the PHP framework Symfony. While following the superb Jobeet tutorial, I encountered an error involving PDO_MYSQL and Mac OS X. I spent an hour trying to trace down the problem and another hour finding a solution. And as always, when something takes me too long to solve, I write a guide for it!

The setup

I tried to run this command while following the Jobeet tutorial:

php symfony propel:insert-sql

The error

>> schema    converting "/Users/eyeRmonkey/w...obeet/config/schema.yml" to XML
>> schema    putting /Users/eyeRmonkey/works...eet/config/generated-schema.xml
>> propel    Running "insert-sql" phing task
Execution of target "insert-sql" failed for the following reason: /Users/eyeRmonkey/workspace/jobeet/lib/vendor/symfony/lib/plugins/sfPropelPlugin/lib/vendor/propel-generator/build-propel.xml:275:1:  [wrapped: could not find driver]
   [phing] /Users/eyeRmonkey/workspace/jobeet/lib/vendor/symfony/lib/plugins/sfPropelPlugin/lib/vendor/propel-generator/build-propel.xml:275:1:  [wrapped: could not find driver]

 Some problems occurred when executing the task:
   build-propel.xml:275:1:  [wrapped: could not find driver]
   If the exception message is not clear enough, read the output of the task for more information  

The root problem

The distribution of PHP that comes with OS X doesn’t have the pdo_mysql.so library loaded. You can determine this by looking at output from php -m.

The solution

After much searching, I finally discovered the proper way to compile the pdo_mysql.so library. This all assumes that you have PHP and MySQL installed the same way I do. (source)

Compiling PDO_MYSQL:

1. Download PDO_MYSQL
2. Run the following commands (replacing x.x.x with the version of PDO_MYSQL that you downloaded)

cd ~/Downloads/PDO_MYSQL-x.x.x/PDO_MYSQL-x.x.x
phpize
./configure '--with-pdo-mysql=shared,/usr/local/mysql'
make
sudo make install

Updating your PHP configuration:
Now add the following two lines to the file /etc/php.ini under the “Dynamic Extensions” section:

extension_dir = "/usr/lib/php/extensions/no-debug-non-zts-20060613"
extension=pdo_mysql.so

Save the file and you’re done.

The conclusion

Many people had this problem. It shouldn’t take hours of detailed searching to find a solution. Back to Symfony!

Computers, Guides, Programming code, Guides, mysql, osx, php, Programming, server