# Db access problem

**URL:** <https://www.ruby-forum.com/t/db-access-problem/106688>\
**Category:** Rails\
**Created:** [June 13, 2007, 9:33am UTC](https://www.ruby-forum.com/t/db-access-problem/106688 "2007-06-13T09:33:10Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![darrenevans](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/87869e/32.png) [@darrenevans](https://www.ruby-forum.com/u/darrenevans)\
**Post date:** [June 13, 2007, 9:33am UTC](https://www.ruby-forum.com/t/db-access-problem/106688/1 "2007-06-13T09:33:10Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![darrenevans](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/87869e/32.png) [@darrenevans](https://www.ruby-forum.com/u/darrenevans)\
**Post date:** [June 13, 2007, 10:24pm UTC](https://www.ruby-forum.com/t/db-access-problem/106688/2 "2007-06-13T22:24:09Z")

</div>

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