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

Re: Linux user www-data has no access to amphora2 DB

From: Denny-Schierz <cuall(at)gmx(dot)de>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Linux user www-data has no access to amphora2 DB
Date: 2002-04-23 07:44:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Guten Tag Tom Lane,

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

TL> Denny-Schierz <cuall(at)gmx(dot)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           ident sameuser
>> host         all             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 ( ) 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.?


Mit freundlichen GrĂ¼ssen
Denny-Schierz                            mailto:cuall(at)gmx(dot)de

In response to

pgsql-admin by date

Next:From: Ian CassDate: 2002-04-23 09:18:42
Subject: Postgres Performance
Previous:From: Lonh SENGDate: 2002-04-23 02:44:39
Subject: Postmaster's Buffer

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