[Trac] Configuring trac user in postgres

[Bryan Dyck]

On Tuesday, July 04, 2006, at 07:32AM, ian docherty <ian at ecisecurity.com> wrote:

<snip>

>On trying to run trac I get the error in my log file:-
>
>PythonHandler trac.web.modpython_frontend: OperationalError: FATAL:  
>Ident authentication failed for user "trac"\n
>
>My pg_hba.conf file contains the following.
>
>local   all         trac                              password
>
>(although I have tried 'trust' and 'md5' as well with no success)
>If I test access to the database from the command line with:-
>
>psql -U trac -W payex
>
>I supply the password and am able to log into postgres and inspect the 
>database with no problems.
>
>My database setup in my trac config file is
>
>database = postgres://trac:secret@localhost/payex

Hmm...

It looks like your pg_hba.conf file only specifies Unix socket connections, but you've specified a TCP connection string in your Trac configuration. You'll have to either enable them or change your connection string to point to the path to the socket.

To enable TCP connections for localhost, add something like the following to your pg_hba.conf:

host    all    trac    127.0.0.1    password

You can get more info on authentication here:

http://www.postgresql.org/docs/8.1/static/client-authentication.html

Cheers,
b