Hi When strting my application I have three text boxes Username, password and company name A user on providing all these goes to user controller login_process action..That means in my application database.yml have no relevance .It is as def login_process ActiveRecord::Base.establish_connection( :adapter => 'postgresql', :host => '192.168.1.9', :username => 'postgres', :password => 'password', :database => 'gatekeeper' ) @the_site = Site.find_by_site_code(params[:company][:whichCompany])
#This sites table contains information of to which different databases to connect,the adapter using,IPaddress of database server etc based on company
ActiveRecord::Base.establish_connection( :adapter => @the_site.db_adapter, :host => @the_site.db_host, :username => @the_site.db_user, :password => @the_site.db_pw, :database => @the_site.db_name ) -----code continues end So what I am doing is suppose a user say user1 with password pass1 and gives company1 then it first connects to gatekeeper database and from that based on site code gets adapter,host,db_user,db_pw and db_name information and reconnected to that db(for example say appl_db on host 192.168.1.45) as above...And I could successfully do it Now my problem is suppose a second user say user2 with passord pass2 and company company2 connects to the server(surely this user has a sepearate db since he belongs to a differnt company say for example appl_db2 on some other host) what happens is now the already logined first user's (user1) database connection information changes to that of second. That is the last login users information.. I think I can make you understand the problem..Please help..Why this happens..How to solve this?
Thanks in advance Sijo