Switching to ActiveRecord Session Store

rubyonrails-talk
1

I'm having a problem switching from cookie sessions (the default) to active record sessions.

I've created the sessions table via the rake task, uncommented the line

   config.action_controller.session_store = :active_record_store

in my environment.rb file, cleared out my browsers cookies, restarted the server (natch), but still the it's using cookie_store instead of active_record store. Just to be sure, I added puts statements in the initializer block of each separate store's ruby classes in vendor rails, and only "cookie_store initialized" come out.

What am I missing here? I've tried commenting out the secret key lines:

  #config.action_controller.session = {   # :session_key => '_sm_session',   # :secret => 'thisisJohnsSecretCodeItNeedsLotsofCharacters'   #}

but I immediately get server failures because the cookie store needs them and is still active. I also tried replacing the config.action_controller.session_store = :active_record_store line with :

ActionController::Base.session_store = :active_record_store ActionController::Base.session_options[:expire_after]=2.years

after the initializer block in environment.rb, but it apparently had no effect, still the cookie_store turns on.

So, any suggestions or guidance appreciated.

ps. The reason I'm trying to switch is that I'm trying to get Facebook Connect to work via Facebooker, and apparently it requires the activerecord session store to be used.

Thanks in advanced,

John

2

Hi John,

Hard to tell, but I'm wondering if you forgot to run rake:db:migrate after running rake db:sessions:create? The latter creates the migration file in db/migration/, and the former actually creates the table in the db. Check your db to make sure the sessions table does exist.

If you did and the tbl does exist, then it's hard to tell what's going on with your setup. If you can't find what the problem is, you could try the following test to see if you can't get db sessions working:

### rails version? $ rails --version Rails 2.2.2

### create a test proj: $ rails testsess ...

$ cd testsess/

$ cat config/database.yml development:   adapter: sqlite3   database: db/development.sqlite3   pool: 5   timeout: 5000 ...

### mod environment.rb to use db for sess data: $ cat config/environment.rb ...   config.action_controller.session_store = :active_record_store ...

### create sess and migrate: $ rake db:sessions:create ...

$ rake db:migrate ...

$ sqlite3 db/development.sqlite3 '.tables' schema_migrations sessions

$ sqlite3 db/development.sqlite3 '.schema sessions' CREATE TABLE "sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "session_id" varchar(255) NOT NULL, "data" text, "created_at" datetime, "updated_at" datetime); CREATE INDEX "index_sessions_on_session_id" ON "sessions" ("session_id"); CREATE INDEX "index_sessions_on_updated_at" ON "sessions" ("updated_at");

$ sqlite3 db/development.sqlite3 'select count(id) from sessions' 0

### create test controller and index: $ ./script/generate controller testsess ...

$ cat app/controllers/testsess_controller.rb class TestsessController < ApplicationController   def index     # test storing something in session ...     session[:ip] = request.remote_addr if not session[:ip]     @ip = session[:ip]   end end

$ cat app/views/testsess/index.html.erb Hi <%= @ip %>.

### start dev env and hit it with browser (or wget or ...): $ ./script/server -p 3044 -d ...

$ wget -o /dev/null -O - http://localhost:3044/testsess/ Hi 127.0.0.1.

### was sess data stored in db? $ sqlite3 db/development.sqlite3 'select count(id) from sessions' 1

### yes: $ sqlite3 db/development.sqlite3 'select id, updated_at from sessions' 1|2009-02-19 04:23:06

### done. $ kill `cat tmp/pids/mongrel.pid`

Jeff