thr3ads.net - Rails - Db access problem [Jun 2007]

If this information is useful, please help other people find it:
Share via:

Darren Evans

2007-Jun-13 07:33 UTC

Db access problem

I access a Db on a server externally. My scripts worked before, but they
do not work on the new server. I''m quite new to this and wondered where
I am going wrong.

The error I have is:

Mysql::Error: Lost connection to MySQL server during query: SET NAMES
''utf8''

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connect
ion_adapters/abstract_adapter.rb:120:in `log''

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connect
ion_adapters/mysql_adapter.rb:184:in `execute''

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connect
ion_adapters/mysql_adapter.rb:331:in `connect''

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connect
ion_adapters/mysql_adapter.rb:87:in `initialize''

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connect
ion_adapters/mysql_adapter.rb:36:in `new''

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connect
ion_adapters/mysql_adapter.rb:36:in `mysql_connection''

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connect
ion_adapters/abstract/connection_specification.rb:251:in `send''

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connect
ion_adapters/abstract/connection_specification.rb:251:in
`connection_without_query_cache=''

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/query_c
ache.rb:54:in `connection=''

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connect
ion_adapters/abstract/connection_specification.rb:220:in
`retrieve_connection''

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connect
ion_adapters/abstract/connection_specification.rb:78:in `connection''

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb
:1278:in `sanitize_sql''

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb
:1278:in `collect''

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb
:1278:in `sanitize_sql''

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb
:1062:in `add_conditions!''

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb
:1012:in `construct_finder_sql''

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb
:924:in `find_every''

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb
:381:in `find''

#{RAILS_ROOT}/app/controllers/login_controller.rb:226:in
`set_session_initial''

#{RAILS_ROOT}/app/controllers/login_controller.rb:24:in `login''

-e:4:in `load''

-e:4

The code causing the problem is:

def set_session_initial

session[:content]=Content.find(:all, :order => "identity",
:conditions
=>
["language_id", session[:language_id]])

session[:user_id] = nil

session[:districts]=District.find(:all, :order =>
"district_name").map{|u|
[u.district_name, u.id]}

session[:languages]=Language.find(:all, :order =>
"language_name").map{|u|
[u.language_name, u.id]}

end

Does anyone have an idea why this is not working? The database and
tables are in UTF 8.

Thanks

Darren

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Darren Evans

2007-Jun-13 20:24 UTC

head link

Re: Db access problem

Just to close this & hopefully this can benefit someone sometime....

My database.yml file contained:

development:
  adapter: mysql
  database: xxx
  username: xxx
  password: xxx
  host:     xxx
  encoding: utf8

I needed to add:
  socket: /tmp/mysql.sock

I have no idea why, just a small fish out of depth....

Drove me mad, happens often to me with RoR, but sorted now.

Darren


-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Rails - Jun 2007 - Db access problem

Db access problem

Re: Db access problem