When I run a command program (rails 3/ruby 1.9.2) as this:
class MsdsAttr < ActiveRecord::Base
include MsdsAttrModule
belongs_to :attribute_record, :polymorphic => true
has_many :attribute_values, :foreign_key => 'attribute_id'
has_many :alt_values, :as => :alternative
has_many :msds_ingredients
end
ActiveRecord::Base.establish_connection(
:adapter => "mysql",
:host => "localhost",
:database => "univ_parse_dev",
:user => "PZZ",
:password => "PZZ"
)
attr = MsdsAttr.find(:first)
I get the error below even though I didn't try to connect using root.
Running rails server/console etc doesn't have this problem ..
C:\inetpub\wwwroot\Larry\univ-parse>ruby db-test.rb
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/lib/
active_record/connect
ion_adapters/mysql_adapter.rb:614:in `real_connect': Access denied for
user 'roo
t'@'localhost' (using password: YES) (Mysql::Error)
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/connection_adapters/mysql_adapter.rb:614:in `connect'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/connection_adapters/mysql_adapter.rb:164:in `initialize'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/connection_adapters/mysql_adapter.rb:36:in `new'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/connection_adapters/mysql_adapter.rb:36:in `mysql_connection'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/connection_adapters/abstract/connection_pool.rb:229:in
`new_connection'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/connection_adapters/abstract/connection_pool.rb:237:in
`checkout_new_conne
ction'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/connection_adapters/abstract/connection_pool.rb:191:in `block (2
levels) i
n checkout'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/connection_adapters/abstract/connection_pool.rb:187:in `loop'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/connection_adapters/abstract/connection_pool.rb:187:in `block in
checkout'
from C:/Ruby192/lib/ruby/1.9.1/monitor.rb:201:in
`mon_synchronize'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/connection_adapters/abstract/connection_pool.rb:186:in
`checkout'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/connection_adapters/abstract/connection_pool.rb:94:in
`connection'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/connection_adapters/abstract/connection_pool.rb:317:in
`retrieve_connectio
n'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/connection_adapters/abstract/connection_specification.rb:97:in
`retrieve_c
onnection'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/connection_adapters/abstract/connection_specification.rb:89:in
`connection
'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/relation.rb:370:in `block in method_missing'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/relation.rb:125:in `scoping'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/relation.rb:370:in `method_missing'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/relation/query_methods.rb:182:in `build_arel'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/relation/query_methods.rb:149:in `arel'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/relation.rb:64:in `to_a'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/relation/finder_methods.rb:341:in `find_first'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/relation/finder_methods.rb:122:in `first'
from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/
lib/active_r
ecord/relation/finder_methods.rb:105:in `find'
from C:in `find'
from db-test.rb:18:in `<main>'
C:\inetpub\wwwroot\Larry\univ-parse>
