Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id A88C7633626 for ; Thu, 12 Mar 2009 08:28:24 -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 96598-09 for ; Thu, 12 Mar 2009 08:28:17 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail2.Synechron.com (mail2.synechron.com [220.225.40.41]) by mail.postgresql.org (Postfix) with ESMTP id 77160633468 for ; Thu, 12 Mar 2009 08:28:20 -0300 (ADT) Received: from [10.31.15.20] [10.31.15.20] by mail2.Synechron.com with ESMTP (SMTPD-9.10) id A1FA3085FC; Thu, 12 Mar 2009 16:58:58 +0530 Message-ID: <49B8F1CE.9020605@synechron.com> Date: Thu, 12 Mar 2009 16:58:14 +0530 From: Ashish Karalkar User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) MIME-Version: 1.0 To: Yann Collavoli CC: BRAHMA PRAKASH TIWARI , Tommy Cheng , pgsql-admin@postgresql.org, Marielle BONNARD Subject: Re: Problem database access References: <49B7B65D.4090505@cict.fr> <2267dd9e0903120226t66d02558pabc83cec2232a253@mail.gmail.com> <49B8DB39.1010601@cict.fr> <2acc2c820903120310w48f01252r1d00e4374293902c@mail.gmail.com> <49B8F083.4090204@cict.fr> In-Reply-To: <49B8F083.4090204@cict.fr> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.426 tagged_above=0 required=5 tests=AWL=-1.805, DNS_FROM_OPENWHOIS=2.431, SARE_BAYES_7x5=0.8, SARE_BAYES_8x5=0.8, SARE_BAYES_9x5=1.2 X-Spam-Level: *** X-Archive-Number: 200903/151 X-Sequence-Number: 31651 Yann Collavoli wrote: > Hi, > > If i add this line "local all all 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 > “toto” access only at the database named “toto”). I think it's > possible to do that but i don't understand how... > > Regards > > Yann > > BRAHMA PRAKASH TIWARI wrote: >> Hi you need to add following enty 100% it will resolve the problem >> # "local" is for Unix domain socket connections only >> local all all trust >> >> >> On Thu, Mar 12, 2009 at 3:21 PM, Yann Collavoli > > wrote: >> >> Hello,, >> >> Thank you for your help but it doesn't work with the line : >> host toto toto 0.0.0.0 0.0.0.0 md5 >> >> I've got the same error message : >> FATAL: no pg_hba.conf entry for host "[local]", user "toto", >> database "template1", SSL off >> >> Yann >> >> Tommy Cheng wrote: >>> Try this: >>> host toto toto 0.0.0.0 0.0.0.0 md5 >>> >>> On Wed, Mar 11, 2009 at 9:02 PM, Yann Collavoli >> > wrote: >>> >>> 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 >>> >>> >>> -- >>> Sent via pgsql-admin mailing list >>> (pgsql-admin@postgresql.org ) >>> To make changes to your subscription: >>> http://www.postgresql.org/mailpref/pgsql-admin >>> >>> >> >> >> -- >> Yann Collavoli >> >> Tél : 05 61 36 60 20 >> >> Université Paul Sabatier >> CICT >> 118, route de Narbonne >> 31062 Toulouse Cedex >> >> >> >> >> -- >> Brahma Prakash Tiwari >> Database Administrator >> iBoss Tech Solution Noida > > > -- > Yann Collavoli > > Tél : 05 61 36 60 20 > > Université Paul Sabatier > CICT > 118, route de Narbonne > 31062 Toulouse Cedex Look at pg_hba what it says. This will help you local /database/ /user/ /auth-method so local toto toto trust local toto1 toto1 trust local toto2 toto2 trust PS. Don't top post/ / /