Rails - Nov 2006 - Database.yml not being parsed correctly?

Hi,

I''m having a problem that''s driving me crazy here. I have my
database.yml file setup apparently correctly, like this:

development:
  adapter: mysql
  database: site_development
  username: site
  host: 127.0.0.1

Test and production are similar. So it seems to be correct. But
whenever I run my application, I get this error:

#42000Access denied for user ''''@''localhost''
to database
''site_development''

It seems Rails is trying to use a blank username, even though my
database.yml file says otherwise. Also, "rake migrate" complains about
the same thing.

I found out that if I completely erase the "username: site" line, it
WORKS, though I can''t tell what username it would be using.

The databases are set on MySQL, I have the user ''site'' and
grants. I
have no user with a null name or a blank string or whatever. I''ve
checked this via the mysql.user table.

So, has anyone ever been through this? I''ve tried google and the irc
channel, but with no luck.

Thanks in advance,
Marcelo Alvim.


--~--~---------~--~----~------------~-------~--~----~
 You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

> Hi,
>
> I''m having a problem that''s driving me crazy here. I have
my
> database.yml file setup apparently correctly, like this:
>
> development:
>  adapter: mysql
>  database: site_development
>  username: site
>  host: 127.0.0.1
Any chance you have tabs in there instead of spaces?  Also, what happens 
if at the command line you type:

    mysql -h 127.0.0.1 -u site -D site_development

Does it work?
> I found out that if I completely erase the "username: site" line,
it
> WORKS, though I can''t tell what username it would be using.
It will use the username of hte process calling it.  So in this case 
whomever is running your webrick/mongrel/fastcgi processes.

-philip

--~--~---------~--~----~------------~-------~--~----~
 You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---