2 years ago

Using Datamapper MySQL w. Sinatra on OSX

 

Trying to set up Sinatra with Datamapper today, I was running into a lot of problems. I got errors when trying to install the mysql gem and the dm-mysql-adapter gem. When I actually managed to do it, Datamapper gave me the following error:

Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock'

I spent hours trying to fix it, but I finally suceeded. This is what worked for me:

  1. Uninstall Mysql on your computer (you also may need to do this)
  2. Uninstall the gems (sudo gem uninstall mysql, sudo gem uninstall dm-mysql-adapter)
  3. Download the latest mysql DMG from the MySQL website
  4. Install the gems (sudo gem install mysql, sudo gem install dm-mysql-adapter)
  5. Restart your computer
  6. Now do this to make the socket path work

That should hopefully make MySQL and Datamapper work. Connect like this in you app and you're good to go:

About Me

My name is Rune Madsen, and I'm a computational artist working in the fields of programming and graphic design. I write about design, art and any random thoughts I'm currently bouncing around in my head. New posts will be tweeted out from my Twitter account.