Connecting to sessions table in another database

rubyonrails-talk
1

I have two applications, appA and appB. I want to use single sign on for both the apps. Meaning, if a user logs in to appA, he dont have to login to appB and conversely, if a user logged out of appA, it logs him out of appB too. Just like in google's various products.

I created the sessions table in appA. How do i access the sessions table in appB. I tried to put ActiveRecord::Base.establish_connection :appA in the config\initializers\session_store.rb of appB, but that connects the whole appB application to appA database. I only want to access the sessions table.

How do i do it?

database.yml of appB has: appA:   adapter: mysql   database: appa_dev   pool: 5   username: app_user   password: app_pwd   host: localhost Thanks, Pratik

2

... I do not have an answer to your specific question, but I have 2 Rails apps that share the session and thus feature a single sign-on. But I use session in cookies, not session in a db table.

3

I have two applications, appA and appB. I want to use single sign on

for both the apps.

Meaning, if a user logs in to appA, he dont have to login to appB and

conversely, if a user logged out of appA, it logs him out of appB too.

Just like in google’s various products.

I created the sessions table in appA. How do i access the sessions

table in appB.

I tried to put ActiveRecord::Base.establish_connection :appA in the

config\initializers\session_store.rb of appB,

but that connects the whole appB application to appA database. I only

want to access the sessions table.

How do i do it?

database.yml of appB has:

appA:

adapter: mysql

database: appa_dev

pool: 5

username: app_user

password: app_pwd

host: localhost

Thanks,

Pratik

Pratik, have you considered OpenID or CAS? If not, I would like into those as possible

solutions as well.

Good luck,

-Conrad

4

Then you need to use establish_connection *only* in the model that's accessing that table.