Re: Problem database access

pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed

From: Yann Collavoli <cyann@cict.fr>
To: BRAHMA PRAKASH TIWARI <prakashr2n5@gmail.com>
Cc: Tommy Cheng <csckcac@gmail.com>
Cc: pgsql-admin@postgresql.org, Marielle BONNARD <bonnard@cict.fr>
Subject: Re: Problem database access
Date: Thu, 12 Mar 2009 12:22:43 +0100
Message-ID: <49B8F083.4090204@cict.fr> (raw)
In-Reply-To: <2acc2c820903120310w48f01252r1d00e4374293902c@mail.gmail.com>
References: <49B7B65D.4090505@cict.fr>
	<2267dd9e0903120226t66d02558pabc83cec2232a253@mail.gmail.com>
	<49B8DB39.1010601@cict.fr>
	<2acc2c820903120310w48f01252r1d00e4374293902c@mail.gmail.com>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi, <br>
<br>
If i add this line&nbsp; "local&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; trust", the user "toto" can log in
phpPgAdmin but he can see the others databases. Or, I want each user to
access only its own database through phpPgAdmin (for example, user
&#8220;toto&#8221; access only at the database named &#8220;toto&#8221;). I think it's possible
to do that but i don't understand how...<br>
<br>
Regards<br>
<br>
Yann<br>
<br>
BRAHMA PRAKASH TIWARI wrote:
<blockquote
 cite="mid:2acc2c820903120310w48f01252r1d00e4374293902c@mail.gmail.com"
 type="cite">
  <meta http-equiv="Context-Type"
 content="text/html; charset=windows-1252">
  <div>Hi you need to add following enty 100% it will resolve the
problem</div>
  <div>&nbsp;</div>
  <div>&nbsp;</div>
  <div># "local" is for Unix domain socket connections only<br>
&nbsp;local&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; trust<br>
  <br>
  <br>
  </div>
  <div>On Thu, Mar 12, 2009 at 3:21 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>
    <div>Hello,,<br>
    <br>
Thank you for your help but it doesn't work with the line :<br>
host&nbsp;&nbsp;&nbsp; toto &nbsp;&nbsp;&nbsp; toto 0.0.0.0 0.0.0.0 md5<br>
    <br>
I've got the same error message :<br>
FATAL:&nbsp; no pg_hba.conf entry for host "[local]", user "toto", database
"template1", SSL off<br>
    <br>
Yann<br>
    <br>
Tommy Cheng wrote:
    <blockquote type="cite">Try this:<br>
host&nbsp;&nbsp;&nbsp; toto &nbsp;&nbsp;&nbsp; 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
&#8220;toto&#8221; access a database named &#8220;toto&#8221;, 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 &#8220;postgres&#8221; user (so the administrator of the database) can log in
phpPgAdmin (without any problem). This user can see all databases. When
the user&#8221;toto&#8221; 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&#8217;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&eacute;l : 05 61 36 60 20<br>
        <br>
Universit&eacute; 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-admi...;
      </blockquote>
      </div>
      <br>
    </blockquote>
    <br>
    <br>
    <pre>-- 
Yann Collavoli

T&eacute;l : 05 61 36 60 20

Universit&eacute; Paul Sabatier
CICT
118, route de Narbonne
31062 Toulouse Cedex</pre>
    </div>
  </blockquote>
  </div>
  <br>
  <br>
  <br>
-- <br>
Brahma Prakash Tiwari<br>
Database Administrator<br>
iBoss Tech Solution Noida<br>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">-- 
Yann Collavoli

T&eacute;l : 05 61 36 60 20

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

view thread (8+ messages)  latest in thread

Message-ID: <49B8F083.4090204@cict.fr>
Permalink:  ../49B8F083.4090204@cict.fr/
Also on:    postgresql.org/message-id/49B8F083.4090204@cict.fr

 ·

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: cyann@cict.fr, prakashr2n5@gmail.com, csckcac@gmail.com, bonnard@cict.fr
  Subject: Re: Problem database access
  In-Reply-To: <49B8F083.4090204@cict.fr>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox