Re: Linux user www-data has no access to amphora2 DB - Mailing list pgsql-admin

From Denny-Schierz
Subject Re: Linux user www-data has no access to amphora2 DB
Date
Msg-id 852747751.20020423094424@gmx.de
Whole thread Raw
In response to Re: Linux user www-data has no access to amphora2 DB  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Guten Tag Tom Lane,

Am Montag, 22. April 2002 um 19:56 schrieben Sie:

TL> Denny-Schierz <cuall@gmx.de> writes:
>> testlinux:/home/amphora2/inst# su  www-data -s /bin/bash -c 'psql amphora2 < amphora2.0.dump'
>> psql: FATAL 1:  IDENT authentication failed for user "www-data"

>> local        amphora2   ident           amphora
>> local        all                                           ident sameuser
>> host         all         127.0.0.1     255.0.0.0           ident sameuser
>> host         all         0.0.0.0       0.0.0.0             reject

TL> Did you provide an ident map called amphora?  If so, what users does it
TL> accept?

TL> I suspect you really want to remove that first pg_hba line, and let the
TL> "ident sameuser" policy apply to local connections to all databases.

TL>                         regards, tom lane

 i did only this, what stands in the INSTALL (
 http://devel.itmeedia.ee/beta/INSTALL ) from amphopra, i never
 used postgres before. If i'm understand  the pg_ident.conf, it maps
 from the www-data user (unix user) to the amphora user (postgres in
 template 1). So i think, that the postgres user amphora has no rights
 to the amphora2DB, allright? How can i resolve it.?

 cu

--
Mit freundlichen Grüssen
Denny-Schierz                            mailto:cuall@gmx.de


pgsql-admin by date:

Previous
From: "Lonh SENG"
Date:
Subject: Postmaster's Buffer
Next
From: "Ian Cass"
Date:
Subject: Postgres Performance