I am getting an error when trying to connect to a mysql server on my
‘production’ linux server. The rails app works fine when connecting to
the ‘development’ mysql on my windows development server.
I have looked at the following wiki:
and I installed the mysql gem, however this does not seem to have fixed
The exact error message is as follows
Mysql::Error: Lost connection to MySQL server during query: SELECT
COUNT(*) FROM Orders
The following is my list of installed gems on the production linux
*** LOCAL GEMS ***
actionmailer (1.2.0, 1.1.5)
actionpack (1.12.0, 1.11.2)
actionwebservice (1.1.0, 1.0.0)
activerecord (1.14.0, 1.13.2)
activesupport (1.3.0, 1.2.5)
rails (1.1.0, 1.0.0)
The production server is running FC4.
I can connect to the production mysql server using the username and
password supplied in the rails app.
Don’t know if its relevant, but the webserver is running lighttpd.