Hi,
I''ve got an app that talks to two databases on a given MySQL server.
When I run in development mode, pointing to the MySQL server running
on localhost (127.0.0.1),
I am able to access both databases without any problem. The relevant
yaml looks like this:
(names have been changed to protect the innocent)
development:
adapter: mysql
database: dev
username: username
password: password
hostname: 127.0.0.1
dev2:
adapter: mysql
database: dev2
username: username
password: password
hostname: 127.0.0.1
When I change the environment to "production", I am unable to access
the database that is *not* named "production". I get an error that
reads "Mysql::Error: Unknown database ''prod2''". The
production part
of the yaml looks like:
production:
adapter: mysql
database: prod
username: username
password: password
hostname: db.prod.mycompany.com
prod2:
adapter: mysql
database: prod2
username: username
password: password
hostname: db.prod.mycompany.com
When I change the "development" and "dev2" to point to the
production
server and tables, I get the same error.
This leads me to believe that the dev and prod mysql servers are
configured differently, but I wanted to double check and see if anyone
has seen this problem before (and that it might be rails).
Anyone?
Thanks,
-kevin
--~--~---------~--~----~------------~-------~--~----~
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
