Displaying 3 results from an estimated 3 matches for "ca_sandbox".
2006 Apr 18
2
Connecting to multiple databases with multiple database users
...ils are handled in the model classes, there simply IS
NO default db in my (?any?) multiple db setting)
webadmin_authentication_development:
adapter: mysql
database: ca_authentication
username: webadmin
password:
host: localhost
webadmin_sandbox_development:
adapter: mysql
database: ca_sandbox
username: webadmin
password:
host: localhost
webadmin_persistent_base_development:
adapter: mysql
database: ca_sandbox
username: webadmin
password:
host: localhost
customer_sandbox_development:
adapter: mysql
database: sandbox
username: customer
password:
host: localho...
2006 May 10
8
dynamic setting of username and password in database.yml
Hello
I''ve now read a lot about application-level authentication in Rails, but
I need to do database-level authentication.
The reason is that my database needs to have the current_user (database
current_user, not current_user defined in an ActiveRecord Model) set to
execute triggers for automatically updating audit tables. So it is not
enough to have a session check against a User
2006 Apr 18
7
Connecting to multiple databases
...orking with multiple databases would
be pretty useless, if one weren''t able to instantiate a new object via
such a shared connection (i.e. inserting rows)?
Any ideas more than welcome!"!!!
Detailed error message and code below
ERROR
-----------
Mysql::Error: #42S02Table ''ca_sandbox.web_ca_admin_sandbox_bases''
doesn''t exist: SHOW FIELDS FROM web_ca_admin_sandbox_bases
CODE
--------
class WebCaAdminSandboxBase < ActiveRecord::Base
establish_connection "webcaadmin_sandbox_#{RAILS_ENV}"
end
class Community < WebCaAdminSandboxBase
# This ca...