Unable to Switch Mysql database connection dynamically after login in rails 4?

Question

I am having different databases for each signup and there is one common Global database for sign in authentication..

What i need is After Logged in, user should be switched to other database and that switched database should be used throughout application until user logged out.

Right now when i switch database after logged in, it does connection with default database(database.yml) on every controller request.

possible duplicate of Connecting to multiple databases in ruby on rails — Norbert
– Norbert, Commented Sep 18, 2015 at 4:28

vishal dhanopia · Accepted Answer · 2015-09-18 04:39:43Z

2

Install the pg gem in your Gemfile

gem 'pg'

change the database.yml file to use your database ex.

adapter: postgresql database: db_name pool: timeout: host: localhost username: username password: password set your db_name, username, and password same as postgresql database.

Have fun..

answered Sep 18, 2015 at 4:39

vishal dhanopia

193 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Milind Patel Over a year ago

Hello vishal dhanopia, Thanks for your reply. But i have used mysql database.. so is it possible for Mysql?

Collectives™ on Stack Overflow

Unable to Switch Mysql database connection dynamically after login in rails 4?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related