Hi
I have this RoR (2.3.16) app that has a simple agenda tool. Each customer
has their own individual database, and I have one central database with
login, passwd and the customer database name.
Something like this:
- main_database:
- users_table:
- login_field
- passwd_field
- database_name_field
- customer_db_1:
- tables ....
- customer_db_2:
- tables ...
So, after user authentication, I set the correspondent database connection
according each customer.
The problem is:
Customer 1 sometimes see records from customer 2, even being on different
databases.
I'm totally lost here... I just suspect that this could be a database
connection cache issue, since the SQL query is the same for every customer
(ie.: select * from agendas;) but the connection string is different for
each one.
Most of the time everything runs ok.. but some customers are getting this
strange behaviour.
Any idea of what could be happening?
Current env:
Passenger: 4.0.21
Apache/2.2.22 (Ubuntu)
ruby 1.8.7 (2012-02-08 patchlevel 358)
Thank you very much in advance for any help!!
Best regards
Paulo
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rubyonrails-talk/ff60e3ef-df0f-4150-b5fc-33c40deea136%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
