| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-05-22 14:54:10 | Re: cannot connect using terminal nor pgaccess |
| Previous Message | waheed rahman | 2001-05-22 13:19:13 | Please help me.... |