Did you, by any chance, play in the NBA in the 70s and 80s? Sorry you
probably get that a lot.
The connection in hijack_db never gets called if it's an unknown
database. I'm no expert either, but it appears that at some point
before ApplicationController starts handling the request, Rails is
doing something with the query cache and it needs to establish a
connection for that. That's where the unknown db error is raised so I
need to catch it there, lower down.
On Nov 15, 5:35 pm, "Bill Walton" <[EMAIL PROTECTED]> wrote:
> Hi Rich,
>
> Rich wrote:
>
> > I just do this in my hijack_db method:
>
> > return unless request.subdomains.first
> > db_name = "#{request.subdomains.first}_#{RAILS_ENV}"
> > ActiveRecord::Base.establish_connection
> > (ActiveRecord::Base.configurations[RAILS_ENV].merge({ 'database' =>
> > db_name }))
>
> > My problem happens when someone hits a subdomain that doesn't exist.
> > It tries to connect to a database that doesn't exist and throws the
> > Mysql::Error 'Unknown database ..."
>
> > I have a fix for this but I'm wondering if it's a hack
>
> 'Hack' can have such a negative connotation. I like 'monkey patch' better
> ;-)
>
> > My fix/hack is that I just wrap the connection method in
> > ConnectionPool in a begin/rescue and catch the unknown
> > database error and "revert" the database in the connection
> > specification to the one from database.yml so that (assuming
> > the database.yml has a valid db) the next request will succeed.
>
> I'm wondering why the same result couldn't be had by wrapping the connection
> in your hijack_db method. I don't know enough about the nitty-gritty of
> connections, so plz take this as a question that, if you've got time, I'm
> interested in. I've got a project that might want this same sort of db
> setup (one per subdomain).
>
> Thanks,
> Bill
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
