Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 7180F6339C8
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 12 Mar 2009 06:52:00 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 65696-06 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 12 Mar 2009 06:51:54 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from smtp1.cict.fr (smtp1.cict.fr [195.220.59.41])
	by mail.postgresql.org (Postfix) with ESMTP id 80CF562F435
	for <pgsql-admin@postgresql.org>; Thu, 12 Mar 2009 06:51:57 -0300 (ADT)
Received: from smtp1.cict.fr (localhost.localdomain [127.0.0.1])
	by smtp1.cict.fr (8.14.2/8.14.2) with ESMTP id n2C9psYB024848
	for <pgsql-admin@postgresql.org>; Thu, 12 Mar 2009 10:51:55 +0100
Received: from pc-yann.cict.fr (pc-yann.cict.fr [130.120.72.5])
	(authenticated bits=0)
	by smtp1.cict.fr (8.14.2/8.14.2) with ESMTP id n2C9prv2024845
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO);
	Thu, 12 Mar 2009 10:51:54 +0100
Message-ID: <49B8DB39.1010601@cict.fr>
Date: Thu, 12 Mar 2009 10:51:53 +0100
From: Yann Collavoli <cyann@cict.fr>
User-Agent: Thunderbird 2.0.0.19 (X11/20090105)
MIME-Version: 1.0
To: Tommy Cheng <csckcac@gmail.com>, pgsql-admin@postgresql.org
CC: Marielle BONNARD <bonnard@cict.fr>
Subject: Re: Problem database access
References: <49B7B65D.4090505@cict.fr>
	<2267dd9e0903120226t66d02558pabc83cec2232a253@mail.gmail.com>
In-Reply-To: <2267dd9e0903120226t66d02558pabc83cec2232a253@mail.gmail.com>
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.837 tagged_above=0 required=5 tests=AWL=-0.837,
	HTML_MESSAGE=0.001, MIME_HTML_ONLY=1.672
X-Spam-Level: 
X-Archive-Number: 200903/146
X-Sequence-Number: 31646

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hello,,<br>
<br>
Thank you for your help but it doesn't work with the line :<br>
host    toto     toto 0.0.0.0 0.0.0.0 md5<br>
<br>
I've got the same error message :<br>
FATAL:  no pg_hba.conf entry for host "[local]", user "toto", database
"template1", SSL off<br>
<br>
Yann<br>
<br>
Tommy Cheng wrote:
<blockquote
 cite="mid:2267dd9e0903120226t66d02558pabc83cec2232a253@mail.gmail.com"
 type="cite">
  <meta http-equiv="Context-Type" content="text/html; charset=UTF-8">
Try this:<br>
host    toto     toto 0.0.0.0 0.0.0.0 md5<br>
  <br>
  <div>On Wed, Mar 11, 2009 at 9:02 PM, Yann Collavoli <span>&lt;<a
 moz-do-not-send="true" href="mailto:cyann@cict.fr">cyann@cict.fr</a>&gt;</span>
wrote:<br>
  <blockquote>Hello,<br>
    <br>
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.<br>
    <br>
I used these lines to create the user and his database :<br>
bash-3.2$ createuser toto -P -D -A<br>
Enter password FOR new role:<br>
Enter it again:<br>
Shall the new role be allowed TO CREATE more new roles? (y/n) n<br>
CREATE ROLE<br>
-bash-3.2$ createdb -O toto -E LATIN1 toto<br>
CREATE DATABASE<br>
    <br>
This is the contents of the file pg_hba.conf :<br>
# TYPE DATABASE USER CIDR-ADDRESS METHOD<br>
LOCAL sameuser ALL md5<br>
LOCAL ALL @admins md5<br>
    <br>
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 :<br>
    <br>
FATAL: no pg_hba.conf entry FOR host "[local]", user "toto", DATABASE
"template1", SSL off<br>
    <br>
Do you have any idea about why it doesn’t work and how to correct it?<br>
    <br>
Thanks in advance for your help<br>
    <br>
Regards<br>
    <br>
Yann<br>
    <br>
-- <br>
Yann Collavoli<br>
    <br>
Tél : 05 61 36 60 20<br>
    <br>
Université Paul Sabatier<br>
CICT<br>
118, route de Narbonne<br>
31062 Toulouse Cedex<br>
    <br>
    <br>
-- <br>
Sent via pgsql-admin mailing list (<a moz-do-not-send="true"
 href="mailto:pgsql-admin@postgresql.org">pgsql-admin@postgresql.org</a>)<br>
To make changes to your subscription:<br>
    <a moz-do-not-send="true"
 href="http://www.postgresql.org/mailpref/pgsql-admin">http://www.postgresql.org/mailpref/pgsql-admin</a><br>
  </blockquote>
  </div>
  <br>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">-- 
Yann Collavoli

Tél : 05 61 36 60 20

Université Paul Sabatier
CICT
118, route de Narbonne
31062 Toulouse Cedex</pre>
</body>
</html>