Database error when running Test


#1

Hello,

I thought my database connection was working after I was able to migrate
my schema to the database, but after I setup a simple test and ran rake
I get the following error:

/usr/local/bin/ruby -Ilib:test
“/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake/rake_test_loader.rb”
No such file or directory - /tmp/mysql.sock

My database.yml file looks like this:
development:
adapter: mysql
database: emporium_development
username: root
password: root
host: localhost
socket: /Applications/MAMP/tmp/mysql/mysql.sock

Im using MAMP as my database management system.

Can someone help please?


#2

Hey,
You’ll need to setup a test database as well if your trying to run
Unit Tests etc.
Rails uses different DB’s for dev, test and production

Convention would be the following:
test:
adapter: mysql
database: emporium_test
username: root
password: root
host: localhost
socket: /Applications/MAMP/tmp/mysql/mysql.sock

Add that to you database.yml file first and then make a new DB called
emporium_test and all should be fine.

Cam