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

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