Skip site navigation (1) Skip section navigation (2)

Re: cannot connect using terminal nor pgaccess

From: "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Jaume Teixi <teixi(at)6tems(dot)com>, psql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: cannot connect using terminal nor pgaccess
Date: 2001-05-22 14:30:21
Message-ID: Pine.LNX.4.21.0105221027480.317-100000@aluminum.cs.pitt.edu (view raw or flat)
Thread:
Lists: pgsql-admin
On Mon, 21 May 2001, Peter Eisentraut wrote:

> Jaume Teixi writes:
> 
> > but why the tcp/ip also doesn't works ?
> >
> > teixi(at)thinkpad:~$ grep -v ^# /etc/postgresql/pg_hba.conf | grep -i host
> >
> > host         all         127.0.0.1     255.255.255.0       ident sameuser
>                                                                    ^^^^^^^^
> > host         all         0.0.0.0       0.0.0.0             reject
> 
> > teixi(at)thinkpad:~$ psql -d template1 -U postgres -h localhost -p 5432
>   ^^^^^                                  ^^^^^^^^
> > psql: IDENT authentication failed for user 'postgres'
> 
> "sameuser" means "same user".  Please read up on the details of ident
> authentication.
> 
> -- 
> Peter Eisentraut   peter_e(at)gmx(dot)net   http://funkturm.homeip.net/~peter
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
> 

I'm not that familiar with pg yet, but maybe his problem is with the auth line:
host         all         127.0.0.1     255.255.255.0       ident sameuser

How can an IP going through mask 255.255.255.0 yield x.x.x.1 ? Shouldn't the netmask be 255.255.255.255?

regards,
thalis


In response to

Responses

pgsql-admin by date

Next:From: Peter EisentrautDate: 2001-05-22 14:54:10
Subject: Re: cannot connect using terminal nor pgaccess
Previous:From: waheed rahmanDate: 2001-05-22 13:19:13
Subject: Please help me....

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group