Rails looking for development db in production

Hi there everyone,

On my production server I start the mongrel server as follows:

mongrel_rails start -e production -a 127.0.0.1 -p 3001 -d

However when going to the domain I get the following error:

#42000Unknown database 'satechevents_development'

Why is rails looking for the development database in production mode.

Thanks for the help, Schalk

Hi there everyone,

On my production server I start the mongrel server as follows:

mongrel_rails start -e production -a 127.0.0.1 -p 3001 -d

However when going to the domain I get the following error:

#42000Unknown database 'satechevents_development'

Assuming your database.yml is sane, are you sure that the requests are
actually going to that mongrel ? for example if you had a separate
mongrel already running in dev mode, then the second one would just
fail to start (possibly silently seing as you've passed -d).

Fred

Thanks Fred,

I will look into this. How can I ensure that all instances of mongrel is stopped?

Schalk

Frederick Cheung wrote:

Thanks Fred,

I will look into this. How can I ensure that all instances of
mongrel is stopped?

look at the output of ps ?

Fred

ps -ef | grep 'mongrel'

I've seen an issue before where non-root mysql accounts just don't work. Even with full GRANT on the database in question. I can't explain it. But for troubleshooting, try your root account in your production database.yml and retry. Secondly, in the same manner, database migrations sometimes give the same problem AFTER you get your app working. Lastly, you can try to give the production connection the path to your mysql.sock socket file. (find / -name mysql.sock) I've seen that cause issues as well.

Good luck. H