Issues with mysql 2.7 gem

I’ve been trying to get a rails development setup running on my Leopard install. After managing to get the mysql gem installed without errors, I can’t use the gem in any projects.

When I run rake db:migrate, I get the following error:

G5:ag $ rake db:migrate(in /Users/xxx/Projects/ag)
dyld: lazy symbol binding failed: Symbol not found: _mysql_init
Referenced from: /Library/Ruby/Gems/1.8/gems/mysql-2.7/lib/mysql.bundle
Expected in: dynamic lookupdyld: Symbol not found: _mysql_init
Referenced from: /Library/Ruby/Gems/1.8/gems/mysql-2.7/lib/mysql.bundle
Expected in: dynamic lookup
Trace/BPT trap

If anyone knows what the problem is, and has a solution, please let me know by leaving a comment!

EDIT:Thanks to Chris for doing the hard and blogging about it on this blog post  which appears to solve this problem. I’ll post here again once I have tried this solution.