Problem database access

From: Yann Collavoli <cyann(at)cict(dot)fr>
To: pgsql-admin(at)postgresql(dot)org
Subject: Problem database access
Date: 2009-03-11 13:02:21
Message-ID: 49B7B65D.4090505@cict.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I am trying to install a postgresql 8.1 shared server. I want each user
to access only its own database through phpPgAdmin. For example, user
“toto” access a database named “toto”, etc.

I used these lines to create the user and his database :
bash-3.2$ createuser toto -P -D -A
Enter password FOR new role:
Enter it again:
Shall the new role be allowed TO CREATE more new roles? (y/n) n
CREATE ROLE
-bash-3.2$ createdb -O toto -E LATIN1 toto
CREATE DATABASE

This is the contents of the file pg_hba.conf :
# TYPE DATABASE USER CIDR-ADDRESS METHOD
LOCAL sameuser ALL md5
LOCAL ALL @admins md5

The “postgres” user (so the administrator of the database) can log in
phpPgAdmin (without any problem). This user can see all databases. When
the user”toto” logs in phpPgAdmin, the connection failed and I get the
following error message in the postgres logs :

FATAL: no pg_hba.conf entry FOR host "[local]", user "toto", DATABASE
"template1", SSL off

Do you have any idea about why it doesn’t work and how to correct it?

Thanks in advance for your help

Regards

Yann

--
Yann Collavoli

Tél : 05 61 36 60 20

Université Paul Sabatier
CICT
118, route de Narbonne
31062 Toulouse Cedex

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Yann Collavoli 2009-03-12 09:51:53 Re: Problem database access
Previous Message Scott Marlowe 2009-03-11 06:15:14 Re: any way to convert date via libpq?