From: | Barker <barkerds(at)snybufaf(dot)buffalostate(dot)edu> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | "IDENT authentication failed for user" on 7.2.1 but not on 7.1.3 |
Date: | 2002-08-08 02:15:34 |
Message-ID: | Pine.OSF.4.05.10208072210330.9071-100000@snybufaf.buffalostate.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I don't know if this is a bug with PostgreSQL or perhaps
something changed with RedHat 7.3
My application failed on RH 7.3, but worked fine on RH 7.2 & 7.1.
PostgreSQL 7.2.1 produced the following error message:
'FATAL 1: IDENT authentication failed for user "apache"'
but worked okay on PostgreSQL 7.1.3.
Two examples are provided below which demonstrate the problem:
1) NOT okay on RH 7.3, and
2) okay on RH 7.2
1. NOT OKAY ON RH 7.3
*
* $ psql --version
* psql (PostgreSQL) 7.2.1
*
* $ psql octave
* Welcome to psql, the PostgreSQL interactive terminal.
* ...
*
* octave=# \z
* Access privileges for database "octave"
* Table | Access privileges
* -------+--------------------------------
* form | {=,postgres=arwdRxt,apache=rw}
* use | {=,postgres=arwdRxt,apache=rw}
* (2 rows)
*
* octave=# \q
* $ psql -U apache octave
* psql: FATAL 1: IDENT authentication failed for user "apache"
2. OKAY ON RH 7.2
**
** $ psql --version
** psql (PostgreSQL) 7.1.3
**
** $ psql octave
** Welcome to psql, the PostgreSQL interactive terminal.
** ...
**
** octave=# \z
** Access permissions for database "octave"
** Relation | Access permissions
** ----------+-----------------------------------
** form | {"=","postgres=arwR","apache=rw"}
** use | {"=","postgres=arwR","apache=rw"}
** (2 rows)
**
** octave=# \q
** $ psql -U apache octave
** Welcome to psql, the PostgreSQL interactive terminal.
** ...
Any help will be appreciated.
Thanks,
Steve Barker
barkerds(at)snybufaf(dot)buffalostate(dot)edu
Buffalo State College
From | Date | Subject | |
---|---|---|---|
Next Message | Henry Mak | 2002-08-08 03:07:29 | Re: Bug #731: Same SQL produces different results before and after VACUUM FULL |
Previous Message | Tom Lane | 2002-08-08 02:09:09 | Re: followup question Bug #476: pg_dump error: dtoi4: integer out of range |