ph-lee

This articles is regarding Mac OS X 10.6 with mysql 5.1.37.

I followed this article at hivelogic.com which required compiling mysql from source. It mostly worked with a few hitches which I’d like to share.

After following the article and attempting to run my rails app the first problem I hit was…

uninitialized constant MysqlCompat::MysqlRes

this problem seemed to be that you need to specify the atchitecture as 64-bit when installing the mysql gem. So run the below command intead when install the mysql gem…

sudo env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql-
config=/usr/local/mysql/bin/mysql_config

Or if you already installed the gem just re-install with this command. The next problem was the following…

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I’d move a project from ubuntu onto the mac I couldn’t find the mysql socket to use as it was specifying the wrong location. On the mac the file can be found at

/tmp/mysql.sock

So you’ll need to modify your database.yml file accordingly to point to this location

Hope this helps.

Tags: database, database.yml, mac, mysql, rails, ror, snow leopard, ubuntu

This entry was posted on Friday, September 18th, 2009 at 5:11 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.