You're using 2.0.2 right? That is strange.<br><br>Matt<br><br><div class="gmail_quote">On Thu, May 1, 2008 at 1:05 PM, 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;">
Hmm, it looks like it's the REVERSE of what Matt said.<br>
<br>
"username" is the _correct_ key, NOT "user". I was using "user" because that's what was in the same file. Weird. "user" works for you guys rather than "username". My Rails installation wants "username", NOT "user". Very odd.<br>
<font color="#888888">
<br>
Jonathan</font><div><div></div><div class="Wj3C7c"><br>
<br>
Jonathan Rochkind wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
<br>
Jonathan Rochkind wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Sadly, no, it's "user". I guess I'll have to debug this the hard way. Stay tuned.<br>
<br>
Matt Mitchell wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Jonathan,<br>
<br>
I can't quite say for sure what happening but, in your database.yml file, is<br>
it possible you're using "username" instead of "user"?<br>
<br>
Matt<br>
<br>
On Thu, May 1, 2008 at 11:16 AM, Jonathan Rochkind <<a href="mailto:rochkind@jhu.edu" target="_blank">rochkind@jhu.edu</a>> wrote:<br>
<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Okay, this is weird.<br>
<br>
I have setup my database.yml file properly to point to my mysql instance,<br>
where i have created databases accessible to the user 'blacklight'. That is<br>
the user I specify in my database.yml. (I am experienced with Rails, I know<br>
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,<br>
since that's NOT the user I've specified in my database.yml. Hmm, maybe<br>
something in your environment that does a db connection with some different<br>
configured password or connection or something? Very weird. Let's check out<br>
the rake trace... Gives me no real hints. Included below in case it gives<br>
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 <br>
`real_connect'<br>
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:471:in <br>
`connect'<br>
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:165:in <br>
`initialize'<br>
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:88:in <br>
`new'<br>
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:88:in <br>
`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 <br>
`send'<br>
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:291:in <br>
`connection='<br>
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:259:in <br>
`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 <br>
`connection'<br>
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/migration.rb:294:in <br>
`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<br>
`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<br>
`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<br>
`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<br>
`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>
<br>
<br>
</blockquote>
<br>
------------------------------------------------------------------------ <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>
<br>
</blockquote>
<br>
</blockquote>
<br>
</blockquote>
<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>
</div></div></blockquote></div><br>