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

On Mon, 2002-04-22 at 12:32, Denny-Schierz wrote:
> Hi pgsql-admin,
>
> 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:

Does www-data exist as a postgres user?

I have tried to reproduce your problem, but I can't.

I don't have a password for www-data so I use sudo:

dstanawa(at)ciderbox:~$ sudo -u www-data psql -c "select version()"
template1
version
-----------------------------------------------------------------------
PostgreSQL 7.2.1 on powerpc-unknown-linux-gnu, compiled by GCC 2.95.4
(1 row)

dstanawa(at)ciderbox:~$ tail -11 /etc/postgresql/pg_hba.conf
local all ident
sameuser
#host all 127.0.0.1 255.0.0.0 trust
host all 0.0.0.0 0.0.0.0 reject

# If you want to allow non-local connections, you will need to change
'reject'
# to 'crypt' or some other suitable authentication method. (Debian
postgresql
# is not built with Kerberos authentication enabled.)
# To allow TCP/IP access, even from localhost, the postmaster must also
be
# started with the -i option or the option TCPIP_SOCKET must be set in
# /etc/postgresql/postgresql.conf.

dstanawa(at)ciderbox:~$ cat /etc/debian_version
3.0

> -----------------
> 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

Anyway.. you probably want to restore the database as a super user (EG:
User Postgres) The dump script should have

\connect - "www-data"
statements in it. It also may have some
\connect - "postgresql"
statements too. which could cause problems as user www-data

--
David Stanaway