[Catalyst] [OT] can't connect to postgresql ...

Daniel McBrearty danielmcbrearty at gmail.com
Thu Jun 8 16:57:07 CEST 2006


thanks ...

not only that but if you update to 8.1 it uses the same /var/log
folder stuff, but a *different* conf file and /etc/init.d ...

seems ok now.

On 6/8/06, Krzysztof Krzyzaniak <eloy at kofeina.net> wrote:
> Daniel McBrearty wrote:
> > so I created a user for my app to connect as, set a password ...
> >
> > CREATE ROLE someone LOGIN PASSWORD 'password';
> >
> > yet I can't connnect with my modwl OR from the command line:
> >
> > daniel at roomatthetop:~/work/trunk/Engoi$ psql -Usomeone engoi -W
> > Password for user someone:
> > psql: FATAL:  Ident authentication failed for user "someone"
> >
> > I've been looking at the postgres manual for the last hour ... time to
> > go for a walk in the sun I think.
> >
> > Any ideas though? what simple, essential, slightly obscure step have I
> > missed ... ?
>
> You have set ident as authentication method (it's default in
> postgresql). You have to edit pg_hba.conf file and set proper method for
> your database (password, md5):
>
> http://www.postgresql.org/docs/8.1/interactive/client-authentication.html
>
>   eloy
> --
> -------e-l-o-y---------------------------e-l-o-y- at -k-o-f-e-i-n-a-.-n-e-t------
>
>        jak to dobrze, że są oceany - bez nich byłoby jeszcze smutniej
>
> _______________________________________________
> Catalyst mailing list
> Catalyst at lists.rawmode.org
> http://lists.rawmode.org/mailman/listinfo/catalyst
>


-- 
Daniel McBrearty
email : danielmcbrearty at gmail.com
www.engoi.com : the multi - language vocab trainer
BTW : 0873928131


More information about the Catalyst mailing list