MySQL Sockets


#1

Hello,

I’m trying to get a rails app running (on Amazon EC2 using Paul
Dowman’s ec2onrails)

The server is configured, but I can’t reach a page.
Going to the root page brings up the familiar ‘You’re riding Ruby on
Rails!’ screen, but accessing a known working path gives me the
default HTTP 500 Internal Server Error page.

Checking my logs, I see this on every attempted request:

Mysql::Error (Can’t connect to local MySQL server through socket ‘/tmp/
mysql.sock’ (2)):

My database.yml looks something like this:

production:
adapter: mysql
database: dbname
username: dbuser
password: dbpass
socket: /var/run/mysqld/mysqld.sock

I first got this error while running migrations, so I changed the
socket from the default /tmp/mysql.sock as it had been set on my local
machine to the above address. The migrations ran fine after that
changed, so I didn’t expect it to come up again, since that meant to
me that the database was being properly accessed.

Is there any other place I need to set this value? I only know of the
mysql socket from within database.yml so the above warning puzzles me
as it looks like it’s connecting through the wrong socket. Could there
be something unrelated causing this?

Thanks for any help