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: 852747751.20020423094424@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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 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(at)gmx(dot)de

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ian Cass 2002-04-23 09:18:42 Postgres Performance
Previous Message Lonh SENG 2002-04-23 02:44:39 Postmaster's Buffer