# Firebird id\_session as sessions promary key **URL:** \ **Category:** Rails\ **Created:** [March 19, 2008, 5:49pm UTC](https://www.ruby-forum.com/t/firebird-id-session-as-sessions-promary-key/132393 "2008-03-19T17:49:25Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![linus](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/f4b2a3/32.png) [@linus](https://www.ruby-forum.com/u/linus)\ **Post date:** [March 19, 2008, 5:49pm UTC](https://www.ruby-forum.com/t/firebird-id-session-as-sessions-promary-key/132393/1 "2008-03-19T17:49:25Z")
Hello, At the end of the environment.rb I have: CGI::Session::ActiveRecordStore::Session.set\_primary\_key ‘ID\_SESSION’ puts CGI::Session::ActiveRecordStore::Session.primary\_key CGI::Session::ActiveRecordStore::Session.create(:session\_id =\> “12345”) puts CGI::Session::ActiveRecordStore::Session.find(:all).inspect This is requried, as I have to stick to the legacy db primary key storage. The values in environemnt seem to work, but the app fails with: =\> Booting Mongrel (use ‘script/server webrick’ to force WEBrick) =\> Rails application starting on [http://127.0.0.1:3000](http://127.0.0.1:3000) =\> Call with -d to detach =\> Ctrl-C to shutdown server \*\* Starting Mongrel listening at 127.0.0.1:3000 \*\* Starting Rails with development environment… ``` ******************************************************************* * config.breakpoint_server has been deprecated and has no effect. ``` - ``` ******************************************************************* ``` ::: Starting logging 5292 ::: ID\_SESSION [#\] \*\* Rails loaded. \*\* Loading any Rails specific GemPlugins \*\* Signals ready. INT =\> stop (no restart). \*\* Mongrel 1.1.2 available at 127.0.0.1:3000 \*\* Use CTRL-C to stop. e[4;36;1mCGI::Session::ActiveRecordStore::Session Columns (0.000000)e[0m e[0;1m SELECT r.rdb$field\_name, r.rdb$field\_source, f.rdb$field\_type, f.rdb$field\_sub\_type, f.rdb$field\_length, f.rdb$field\_precision, f.rdb$field\_scale, COALESCE(r.rdb$default\_source, f.rdb$default\_source) rdb$default\_source, COALESCE(r.rdb$null\_flag, f.rdb$null\_flag) rdb$null\_flag FROM rdb$relation\_fields r JOIN rdb$fields f ON r.rdb$field\_source = f.rdb$field\_name WHERE r.rdb$relation\_name = ‘SESSIONS’ ORDER BY r.rdb$field\_position e[0m e[4;35;1mCGI::Session::ActiveRecordStore::Session Load (0.000000)e[0m e[0mSELECT \* FROM sessions e[0m ons e[0m /!\ FAILSAFE /!\ Wed Mar 19 17:43:15 +0100 2008 Status: 500 Internal Server Error FireRuby::FireRubyException c:/ruby/lib/ruby/gems/1.8/gems/activerecord-firebird-adapter-1.0.0/lib/active\_record/connection\_adapters/firebird\_adapter.rb:584:in `each' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-firebird-adapter-1.0.0/lib/active_record/connection_adapters/firebird_adapter.rb:584:in `collect’ c:/ruby/lib/ruby/gems/1.8/gems/activerecord-firebird-adapter-1.0.0/lib/active\_record/connection\_adapters/firebird\_adapter.rb:584:in `select' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-firebird-adapter-1.0.0/lib/active_record/connection_adapters/firebird_adapter.rb:366:in `select\_all’ c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/base.rb:532:in `find_by_sql' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/base.rb:1233:in `find\_every’ c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/base.rb:1227:in `find_initial' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/base.rb:502:in `find’ c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action\_controller/session/active\_record\_store.rb:114:in `find_by_session_id' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/session/active_record_store.rb:80:in `find\_by\_session\_id’ c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action\_controller/session/active\_record\_store.rb:284:in `initialize' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/base.rb:1198:in `silence’ c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action\_controller/session/active\_record\_store.rb:284:in `initialize' c:/ruby/lib/ruby/1.8/cgi/session.rb:273:in `new’ c:/ruby/lib/ruby/1.8/cgi/session.rb:273:in `initialize_without_cgi_reader' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/cgi_ext/session.rb:39:in `initialize’ c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action\_controller/cgi\_process.rb:130:in `new' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/cgi_process.rb:130:in `session’ c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action\_controller/cgi\_process.rb:166:in `stale_session_check!' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/cgi_process.rb:114:in `session’ c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action\_controller/base.rb:1131:in `assign_shortcuts_without_flash' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/flash.rb:167:in `assign\_shortcuts’ c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action\_controller/base.rb:518:in `process_without_filters' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/filters.rb:685:in `process\_without\_session\_management\_support’ c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action\_controller/session\_management.rb:123:in `process' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:388:in `process’ c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action\_controller/dispatcher.rb:171:in `handle_request' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:115:in `dispatch’ c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action\_controller/dispatcher.rb:126:in `dispatch_cgi' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:9:in `dispatch’ c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.2-mswin32/bin/…/lib/mongrel/rails.rb:76:in `process' c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.2-mswin32/bin/../lib/mongrel/rails.rb:74:in `synchronize’ c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.2-mswin32/bin/…/lib/mongrel/rails.rb:74:in `process' c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.2-mswin32/lib/mongrel.rb:159:in `process\_client’ c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.2-mswin32/lib/mongrel.rb:158:in `each' c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.2-mswin32/lib/mongrel.rb:158:in `process\_client’ c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.2-mswin32/lib/mongrel.rb:285:in `run' c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.2-mswin32/lib/mongrel.rb:285:in `initialize’ c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.2-mswin32/lib/mongrel.rb:285:in `new' c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.2-mswin32/lib/mongrel.rb:285:in `run’ c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.2-mswin32/lib/mongrel.rb:268:in `initialize' c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.2-mswin32/lib/mongrel.rb:268:in `new’ c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.2-mswin32/lib/mongrel.rb:268:in `run' c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.2-mswin32/lib/mongrel/configurator.rb:282:in `run’ c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.2-mswin32/lib/mongrel/configurator.rb:281:in `each' c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.2-mswin32/lib/mongrel/configurator.rb:281:in `run’ c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.2-mswin32/bin/mongrel\_rails:128:in `run' c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.2-mswin32/lib/mongrel/command.rb:212:in `run’ c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.2-mswin32/bin/mongrel\_rails:281 c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active\_support/dependencies.rb:489:in `load' c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:489:in `load’ c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active\_support/dependencies.rb:342:in `new_constants_in' c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:489:in `load’ c:/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/commands/servers/mongrel.rb:64 c:/ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:27:in `gem_original_require' c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require’ c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active\_support/dependencies.rb:496:in `require' c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:342:in `new\_constants\_in’ c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active\_support/dependencies.rb:496:in `require' c:/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/commands/server.rb:39 c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem\_original\_require’ c:/ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:27:in `require' ./script/server:3 -e:2:in `load’ -e:2 Any ideas? Cheers, Tomasz