Jonathan,<br><br>I can't quite say for sure what happening but, in your database.yml file, is it possible you're using "username" instead of "user"?<br><br>Matt<br><br><div class="gmail_quote">On Thu, May 1, 2008 at 11:16 AM, Jonathan Rochkind <<a href="mailto:rochkind@jhu.edu">rochkind@jhu.edu</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Okay, this is weird.<br>
<br>
I have setup my database.yml file properly to point to my mysql instance, where i have created databases accessible to the user 'blacklight'. That is the user I specify in my database.yml. (I am experienced with Rails, I know how it works).<br>
<br>
Yet, when I run the rake db:migrate, I get:<br>
Access denied for user 'root'@'localhost' (using password: YES)<br>
<br>
<br>
I don't know why it's trying to connect with that user in the first place, since that's NOT the user I've specified in my database.yml. Hmm, maybe something in your environment that does a db connection with some different configured password or connection or something? Very weird. Let's check out the rake trace... Gives me no real hints. Included below in case it gives someone else hints. I don't get it.<br>
<br>
[jrochki1@testbox rails]$ rake db:migrate --trace<br>
(in /home/jrochki1/blacklight/rails)<br>
** Invoke db:migrate (first_time)<br>
** Invoke environment (first_time)<br>
** Execute environment<br>
** Execute db:migrate<br>
rake aborted!<br>
Access denied for user 'root'@'localhost' (using password: YES)<br>
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:471:in `real_connect'<br>
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:471:in `connect'<br>
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:165:in `initialize'<br>
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:88:in `new'<br>
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:88:in `mysql_connection'<br>
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:291:in `send'<br>
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:291:in `connection='<br>
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:259:in `retrieve_connection'<br>
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in `connection'<br>
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/migration.rb:294:in `migrate'<br>
/usr/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/tasks/databases.rake:85<br>
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `call'<br>
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `execute'<br>
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `each'<br>
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `execute'<br>
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:508:in `invoke_with_call_chain'<br>
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in `synchronize'<br>
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in `invoke_with_call_chain'<br>
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:494:in `invoke'<br>
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1931:in `invoke_task'<br>
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `top_level'<br>
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `each'<br>
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `top_level'<br>
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in `standard_exception_handling'<br>
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1903:in `top_level'<br>
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1881:in `run'<br>
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in `standard_exception_handling'<br>
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1878:in `run'<br>
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/bin/rake:31<br>
/usr/bin/rake:16:in `load'<br>
/usr/bin/rake:16<br>
<br>
<br>
-- <br>
Jonathan Rochkind<br>
Digital Services Software Engineer<br>
The Sheridan Libraries<br>
Johns Hopkins University<br>
410.516.8886 rochkind (at) <a href="http://jhu.edu" target="_blank">jhu.edu</a><br>
<br>
_______________________________________________<br>
Blacklight-development mailing list<br>
<a href="mailto:Blacklight-development@rubyforge.org" target="_blank">Blacklight-development@rubyforge.org</a><br>
<a href="http://rubyforge.org/mailman/listinfo/blacklight-development" target="_blank">http://rubyforge.org/mailman/listinfo/blacklight-development</a><br>
</blockquote></div><br>