hi all,
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:
http://wiki.rubyonrails.com/rails/pages/Mysql+Connection+Problems/
and I installed the mysql gem, however this does not seem to have fixed
the problem.
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
server.
#gem list
*** 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)
fcgi (0.8.6.1)
mysql (2.7)
rails (1.1.0, 1.0.0)
rake (0.7.0)
sources (0.0.1)
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.
Any Ideas?
Thanks,
~Ben