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:inconnect’
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:innew’
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:innew_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:inblock (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:inblock 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:incheckout’
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:inretrieve_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:inconnection
’
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:inscoping’
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:inbuild_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:into_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:infirst’
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:infind’
from db-test.rb:18:in `’
C:\inetpub\wwwroot\Larry\univ-parse>