From: | Denny-Schierz <cuall(at)gmx(dot)de> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Linux user www-data has no access to amphora2 DB_New |
Date: | 2002-04-22 17:42:46 |
Message-ID: | 9138361611.20020422194246@gmx.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Guten Tag pgsql-admin,
sorry, for my first mail, i pressed the wrong button, here the full
mail:
i want to install the amphora2 light groupware software under Debian Woody
with pgsql 7.2.1. I have to restore a dump into the amphora2 DB that
i created before.:
-----------------
testlinux:/home/amphora2/inst# su www-data -s /bin/bash -c 'psql amphora2 < amphora2.0.dump'
-----------------
but postgres tells me:
-----------------
psql: FATAL 1: IDENT authentication failed for user "www-data"
-----------------
my pg_hba.conf:
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
-----------------
my pg_ident.conf:
# MAP IDENT PGUSERNAME
amphora www-data amphora
amphora root amphore
-----------------
the amphora DB setting:
Database setup:
Start postgres:
/etc/rc.d/init.d/postgresql start
Create postgres user amphora:
su - postgres -c "psql template1 -c 'CREATE USER amphora CREATEDB CREATEUSER;'"
Create database amphora2:
su - amphora -c "createdb amphora2"
Make sure amphora2 database is accessable by the user your webserver runs under:
Edit /var/lib/pgsql/data/pg_hba.conf and add these lines in front of other access control statements:
------------------
i don't know any more what i could do, here the orginal manuel:
http://devel.itmeedia.ee/beta/INSTALL
can anybody help?
--
Mit freundlichen Grüssen
Denny-Schierz mailto:cuall(at)gmx(dot)de
From | Date | Subject | |
---|---|---|---|
Next Message | David Stanaway | 2002-04-22 17:51:18 | Re: Linux user www-data has no access to amphora2 DB |
Previous Message | Tom Lane | 2002-04-22 17:40:21 | Re: An Analyze question |