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

Reply via email to