2013/7/19 Axel Braun <[email protected]> > Hi, > > I have a similar probem as reported recently on the list (unfortunately > without result) > > I have set up a new server (2.8.1) and configured it accordingly. The > server > is listening on 8000: > de-dd-srv-1325:~ # netstat -tupan | grep python > tcp 0 0 0.0.0.0:8000 0.0.0.0:* LISTEN > 6446/python > > Postgres is running: > de-dd-srv-1325:~ # ps aux | grep postgres > postgres 6040 0.0 0.4 93768 8260 ? S 11:21 0:00 > /usr/lib/postgresql92/bin/postgres -D /var/lib/pgsql/data > postgres 6041 0.0 0.0 62148 1260 ? Ss 11:21 0:00 postgres: > logger process > postgres 6043 0.0 0.0 93768 1432 ? Ss 11:21 0:00 postgres: > checkpointer process > postgres 6044 0.0 0.0 93768 1436 ? Ss 11:21 0:00 postgres: > writer process > postgres 6045 0.0 0.0 93768 1204 ? Ss 11:21 0:00 postgres: > wal > writer process > postgres 6046 0.0 0.1 94580 2676 ? Ss 11:21 0:00 postgres: > autovacuum launcher process > postgres 6047 0.0 0.0 62144 1472 ? Ss 11:21 0:00 postgres: > stats collector process > > ...and the role for user tryton was changed with a new password: > > srv-1325:~ # su postgres > postgres@de-dd-srv-1325:/root> psql -c "ALTER ROLE tryton WITH PASSWORD > 'DBAdminPasswort';" > ALTER ROLE > > So far so good. Nothing different to the various test installations I did > on > the same platform, except that I have a remote machine now and no local > client. > > When connecting from an external machine to create the first database I get > the error "Could not connect to server" > From the tryton user FAQ I found the postgres check: > > de-dd-srv-1325:~ # su tryton -s /bin/bash > tryton@de-dd-srv-1325:/root> psql -h localhost > psql: FATAL: Ident authentication failed for user "tryton" > > ...I was looking for this mysterious pg_hba.conf file but could not spot > it. > Any idea if this is the reason, or what to try? > > Thanks > Axel >
Could you give us your tryton.config and your /etc/postgresql/9.1/main/pg_hba.conf files? -- Jesús Martín Zikzakmedia SL Dr. Fleming, 28, baixos 08720 Vilafranca del Penedès ☏ 93 890 21 08
