Forum: Ruby on Rails Old Rails app: strange problem with getaddrinfo

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Joshua M. (Guest)
on 2008-10-28 16:43
Hi all

I'm trying to get an old Rails App (RAILS_GEM_VERSION = '1.1.6') to work
again;

Strangely I get the following error on most pages, and I don't have any
idea where it could come from:

 SocketError in Startseite#index

Showing app/views/partials/_menu.rhtml where line #6 raised:

getaddrinfo: nodename nor servname provided, or not known

Extracted source (around line #6):

3:   unikat_subitems = []
4:
5:   shop_subitems = []
6:   produkt_typen_for_produkt('MassenArtikel').each do |id|
7:     produkt_typ = ProduktTyp.find_by_id(id)
8:     shop_subitems << {:caption => produkt_typ.name, :action =>
:produkt_typ, :id => produkt_typ}
9:   end

Trace of template inclusion: /app/views/layouts/public.rhtml

RAILS_ROOT: script/../config/..
Application Trace | Framework Trace | Full Trace

vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:111:in
`initialize'
vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:111:in `new'
vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:111:in
`real_connect'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:389:in
`connect'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:152:in
`initialize'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:82:in
`new'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:82:in
`mysql_connection'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:262:in
`send'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:262:in
`connection_without_query_cache='
vendor/rails/activerecord/lib/active_record/query_cache.rb:54:in
`connection='
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:230:in
`retrieve_connection'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in
`connection'
app/helpers/application_helper.rb:11:in `produkt_typen_for_produkt'
#{RAILS_ROOT}/app/views/partials/_menu.rhtml:6:in
`_run_rhtml_47app47views47partials47_menu46rhtml'
#{RAILS_ROOT}/app/views/layouts/public.rhtml:16:in
`_run_rhtml_47app47views47layouts47public46rhtml'

vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:111:in
`initialize'
vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:111:in `new'
vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:111:in
`real_connect'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:389:in
`connect'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:152:in
`initialize'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:82:in
`new'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:82:in
`mysql_connection'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:262:in
`send'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:262:in
`connection_without_query_cache='
vendor/rails/activerecord/lib/active_record/query_cache.rb:54:in
`connection='
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:230:in
`retrieve_connection'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in
`connection'
vendor/rails/actionpack/lib/action_view/base.rb:326:in `send'
vendor/rails/actionpack/lib/action_view/base.rb:326:in
`compile_and_render_template'
vendor/rails/actionpack/lib/action_view/base.rb:301:in `render_template'
vendor/rails/actionpack/lib/action_view/base.rb:260:in `render_file'
vendor/rails/actionpack/lib/action_view/base.rb:275:in `render'
vendor/rails/actionpack/lib/action_view/partials.rb:59:in
`render_partial'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:26:in
`benchmark'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/benchmark.rb:293:in
`measure'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/benchmark.rb:307:in
`realtime'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:26:in
`benchmark'
vendor/rails/actionpack/lib/action_view/partials.rb:58:in
`render_partial'
vendor/rails/actionpack/lib/action_view/base.rb:287:in `render'
vendor/rails/actionpack/lib/action_view/base.rb:326:in `send'
vendor/rails/actionpack/lib/action_view/base.rb:326:in
`compile_and_render_template'
vendor/rails/actionpack/lib/action_view/base.rb:301:in `render_template'
vendor/rails/actionpack/lib/action_view/base.rb:260:in `render_file'
vendor/rails/actionpack/lib/action_controller/layout.rb:254:in
`render_without_benchmark'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:50:in
`render'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/benchmark.rb:293:in
`measure'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:50:in
`render'
vendor/rails/actionpack/lib/action_controller/base.rb:1096:in
`perform_action_without_filters'
vendor/rails/actionpack/lib/action_controller/filters.rb:632:in
`call_filter'
vendor/rails/actionpack/lib/action_controller/filters.rb:638:in
`call_filter'
vendor/rails/actionpack/lib/action_controller/filters.rb:438:in `call'
vendor/rails/actionpack/lib/action_controller/filters.rb:637:in
`call_filter'
vendor/rails/actionpack/lib/action_controller/filters.rb:638:in
`call_filter'
vendor/rails/actionpack/lib/action_controller/filters.rb:438:in `call'
vendor/rails/actionpack/lib/action_controller/filters.rb:637:in
`call_filter'
vendor/rails/actionpack/lib/action_controller/filters.rb:619:in
`perform_action_without_benchmark'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:66:in
`perform_action_without_rescue'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/benchmark.rb:293:in
`measure'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:66:in
`perform_action_without_rescue'
vendor/rails/actionpack/lib/action_controller/rescue.rb:83:in
`perform_action'
vendor/rails/actionpack/lib/action_controller/base.rb:430:in `send'
vendor/rails/actionpack/lib/action_controller/base.rb:430:in
`process_without_filters'
vendor/rails/actionpack/lib/action_controller/filters.rb:624:in
`process_without_session_management_support'
vendor/rails/actionpack/lib/action_controller/session_management.rb:114:in
`process'
vendor/rails/actionpack/lib/action_controller/base.rb:330:in `process'
vendor/rails/railties/lib/dispatcher.rb:41:in `dispatch'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/rails.rb:76:in
`process'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/rails.rb:74:in
`synchronize'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/rails.rb:74:in
`process'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:159:in
`process_client'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:158:in
`each'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:158:in
`process_client'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:285:in
`run'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:285:in
`initialize'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:285:in
`new'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:285:in
`run'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:268:in
`initialize'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:268:in
`new'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:268:in
`run'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/configurator.rb:282:in
`run'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/configurator.rb:281:in
`each'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/configurator.rb:281:in
`run'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/bin/mongrel_rails:128:in
`run'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/command.rb:212:in
`run'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/bin/mongrel_rails:281
vendor/rails/activesupport/lib/active_support/dependencies.rb:488:in
`load'
vendor/rails/activesupport/lib/active_support/dependencies.rb:488:in
`load'
vendor/rails/activesupport/lib/active_support/dependencies.rb:342:in
`new_constants_in'
vendor/rails/activesupport/lib/active_support/dependencies.rb:488:in
`load'
vendor/rails/railties/lib/commands/servers/mongrel.rb:60
/Library/Ruby/Site/1.8/rubygems/custom_require.rb:27:in
`gem_original_require'
/Library/Ruby/Site/1.8/rubygems/custom_require.rb:27:in `require'
vendor/rails/activesupport/lib/active_support/dependencies.rb:495:in
`require'
vendor/rails/activesupport/lib/active_support/dependencies.rb:342:in
`new_constants_in'
vendor/rails/activesupport/lib/active_support/dependencies.rb:495:in
`require'
vendor/rails/railties/lib/commands/server.rb:39
script/server:3:in `require'
script/server:3

vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:111:in
`initialize'
vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:111:in `new'
vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:111:in
`real_connect'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:389:in
`connect'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:152:in
`initialize'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:82:in
`new'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:82:in
`mysql_connection'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:262:in
`send'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:262:in
`connection_without_query_cache='
vendor/rails/activerecord/lib/active_record/query_cache.rb:54:in
`connection='
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:230:in
`retrieve_connection'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in
`connection'
app/helpers/application_helper.rb:11:in `produkt_typen_for_produkt'
#{RAILS_ROOT}/app/views/partials/_menu.rhtml:6:in
`_run_rhtml_47app47views47partials47_menu46rhtml'
vendor/rails/actionpack/lib/action_view/base.rb:326:in `send'
vendor/rails/actionpack/lib/action_view/base.rb:326:in
`compile_and_render_template'
vendor/rails/actionpack/lib/action_view/base.rb:301:in `render_template'
vendor/rails/actionpack/lib/action_view/base.rb:260:in `render_file'
vendor/rails/actionpack/lib/action_view/base.rb:275:in `render'
vendor/rails/actionpack/lib/action_view/partials.rb:59:in
`render_partial'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:26:in
`benchmark'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/benchmark.rb:293:in
`measure'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/benchmark.rb:307:in
`realtime'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:26:in
`benchmark'
vendor/rails/actionpack/lib/action_view/partials.rb:58:in
`render_partial'
vendor/rails/actionpack/lib/action_view/base.rb:287:in `render'
#{RAILS_ROOT}/app/views/layouts/public.rhtml:16:in
`_run_rhtml_47app47views47layouts47public46rhtml'
vendor/rails/actionpack/lib/action_view/base.rb:326:in `send'
vendor/rails/actionpack/lib/action_view/base.rb:326:in
`compile_and_render_template'
vendor/rails/actionpack/lib/action_view/base.rb:301:in `render_template'
vendor/rails/actionpack/lib/action_view/base.rb:260:in `render_file'
vendor/rails/actionpack/lib/action_controller/layout.rb:254:in
`render_without_benchmark'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:50:in
`render'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/benchmark.rb:293:in
`measure'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:50:in
`render'
vendor/rails/actionpack/lib/action_controller/base.rb:1096:in
`perform_action_without_filters'
vendor/rails/actionpack/lib/action_controller/filters.rb:632:in
`call_filter'
vendor/rails/actionpack/lib/action_controller/filters.rb:638:in
`call_filter'
vendor/rails/actionpack/lib/action_controller/filters.rb:438:in `call'
vendor/rails/actionpack/lib/action_controller/filters.rb:637:in
`call_filter'
vendor/rails/actionpack/lib/action_controller/filters.rb:638:in
`call_filter'
vendor/rails/actionpack/lib/action_controller/filters.rb:438:in `call'
vendor/rails/actionpack/lib/action_controller/filters.rb:637:in
`call_filter'
vendor/rails/actionpack/lib/action_controller/filters.rb:619:in
`perform_action_without_benchmark'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:66:in
`perform_action_without_rescue'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/benchmark.rb:293:in
`measure'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:66:in
`perform_action_without_rescue'
vendor/rails/actionpack/lib/action_controller/rescue.rb:83:in
`perform_action'
vendor/rails/actionpack/lib/action_controller/base.rb:430:in `send'
vendor/rails/actionpack/lib/action_controller/base.rb:430:in
`process_without_filters'
vendor/rails/actionpack/lib/action_controller/filters.rb:624:in
`process_without_session_management_support'
vendor/rails/actionpack/lib/action_controller/session_management.rb:114:in
`process'
vendor/rails/actionpack/lib/action_controller/base.rb:330:in `process'
vendor/rails/railties/lib/dispatcher.rb:41:in `dispatch'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/rails.rb:76:in
`process'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/rails.rb:74:in
`synchronize'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/rails.rb:74:in
`process'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:159:in
`process_client'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:158:in
`each'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:158:in
`process_client'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:285:in
`run'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:285:in
`initialize'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:285:in
`new'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:285:in
`run'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:268:in
`initialize'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:268:in
`new'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:268:in
`run'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/configurator.rb:282:in
`run'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/configurator.rb:281:in
`each'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/configurator.rb:281:in
`run'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/bin/mongrel_rails:128:in
`run'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/command.rb:212:in
`run'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.4/bin/mongrel_rails:281
vendor/rails/activesupport/lib/active_support/dependencies.rb:488:in
`load'
vendor/rails/activesupport/lib/active_support/dependencies.rb:488:in
`load'
vendor/rails/activesupport/lib/active_support/dependencies.rb:342:in
`new_constants_in'
vendor/rails/activesupport/lib/active_support/dependencies.rb:488:in
`load'
vendor/rails/railties/lib/commands/servers/mongrel.rb:60
/Library/Ruby/Site/1.8/rubygems/custom_require.rb:27:in
`gem_original_require'
/Library/Ruby/Site/1.8/rubygems/custom_require.rb:27:in `require'
vendor/rails/activesupport/lib/active_support/dependencies.rb:495:in
`require'
vendor/rails/activesupport/lib/active_support/dependencies.rb:342:in
`new_constants_in'
vendor/rails/activesupport/lib/active_support/dependencies.rb:495:in
`require'
vendor/rails/railties/lib/commands/server.rb:39
script/server:3:in `require'
script/server:3

Request

Parameters: None

Show session dump

---
:positions: []

:bestell_positionen: []

flash: !map:ActionController::Flash::FlashHash {}


Response
Headers: {"Status"=>"200 OK", "cookie"=>[], "Cache-Control"=>"no-cache"}


Anyone has an idea?
Frederick C. (Guest)
on 2008-10-28 16:45
(Received via mailing list)
On 28 Oct 2008, at 14:43, Joshua M. wrote:

>
> SocketError in Startseite#index
>
It can't connect to the database.

Fred
Joshua M. (Guest)
on 2008-10-28 16:51
Frederick C. wrote:
> On 28 Oct 2008, at 14:43, Joshua M. wrote:
>
>>
>> SocketError in Startseite#index
>>
> It can't connect to the database.
>
> Fred

Yes, that seems to be the problem. But I double-checked my parameters
(which work for another, though newer RoR app), and it still gives the
same error.

My db params are:

development:
  adapter: mysql
  database: bergschmuck_development
  username: XXX
  password:
  socket: /tmp/mysql.sock
Joshua M. (Guest)
on 2008-10-28 19:55
Ah I had the RAILS_ENV=production set in environment.rb, THAT was the
problem... Another few hours wasted for nearly nothing lol. ;-)
This topic is locked and can not be replied to.