HostingRails.com

Yeah - welcome to the #1 Rails deployment issue. :)  Its probably a permissions issue or a typo along the way.  Create a test Rails app and compare what it gives you to what you have.  No logs will be dumped with this error.  

Actually made a bit of progress. A stupidity as expected was "development" instead of "production: in database.yml. (Still pulling my hairs out on this one).

Now the apps seems to run: (did tail -f on production.log) and get a password error when trying to connect. So I can smell the finish line .... (Unfortunatly can't get through port :2083 from office and cpanel proxy is a bit fuzzy to me).

Cheers / Christophe

Cool - let me know if you get this working or if you need any help.  

OK, it's official now: I am stuck. I can't connect to the database. (mysql or through rails app both fail).

To be honest, I don't really like the cpanel view named:
"MySQL Account Maintenance". It's not very intuitive to what should be done.

I followed all the steps: (In this order).  
- Created a database.
- Loaded SQL into database
- Created a user
- Assigned user to database.

Trying with mysql

user = [username]_database. (For some funny reason the error report leaves out a 'e' at the end of database
*****************
ERROR 1045 (28000): Access denied for user '=[username]_databas'@'localhost' (using password: YES)

Is there a tutorial on the cpanel/mysql stuff?

Cheers / Christophe

Did you restart fastcgi?  try also making a shorter database name - like db - so the resulting database is username_db (please remove your username above, BTW)

I believe I ran into this problem before and I fixed it by shortening the db name.  I think there is a limit to db name lengths...if so then cPanel should have told you that (maybe a problem with EDGE)

Cheers,

~William

Hello, tried what you suggest to shorten db name and db_username with no effect.  

There is a couple of strange things.
1. using: "mysql -u=[user_name]" gives an immidiate error (without specifying the DB or password).

ERROR 1045 (28000): Access denied for user '=[username]'@'localhost' (using password: NO)

2) Using php_admin I can do stuff with the database like loading SQL.
My hostingrails username is however not privileged to see or add DB users. (So I can't check if the user I created using cpanel is actually create).

It seems I have don't all correct? What could be the problem?  (Something with EDGE?).

BR / Christophe

Hmmm - try

mysql -u username_dbuser -pthepassword username_db

that is, be sure to prefix your username, and try specifying the database.  In the cPanel mySQL page it should give you php and perl code under the database that has a user correctly assigned to it.  

Rails can connect and app is up and running!
Nevermind mysql.... Thanks William!