From: craig duncan <duncan@...>
Date: 2004-11-04T04:19:32+09:00
Subject: Re: Problem getting tiny RAILS demo working

craig duncan wrote:

> Vincent Foley wrote:
>
>> Is config/database.yml properly configured?  An authorization error
>> seems related to username and password.  Check out
>> http://www.rubyonrails.org/show/TutorialStepTwo to make sure your
>> PostgreSQL configuration is okay.
>>  
>>
> It is.  I can't figure out why ident authentication (postgres) doesn't 
> seem to work but when i make the first line in pg_hba.conf "host all 
> all trust" then every local user has access (e.g. psql <database> 
> postgres).  database.yml specifies user "postgres".  It really 
> shouldn't matter, though.  IDENT authentication shouldn't even be 
> being used.  I'm running ruby 1.8.2 on debian unstable, postgresql 
> 7.4.6.   I saw something somewhere about needing to run an IDENT 
> daemon, but could find no verification for that idea.  Anyway, as i 
> said, IDENT authentication shouldn't even be being used.
>
>
>
The reason why authentication is failing is because this fails:

psql -h localhost <database> postgres

without the "-h localhost" it works fine.   I can ping localhost.  I 
don't know why that doesn't work but that's what's keeping Rails 
(activerecord) from connecting to postgres.