Quick Links

Re: Problem database access

From:	Yann Collavoli <cyann(at)cict(dot)fr>
To:	BRAHMA PRAKASH TIWARI <prakashr2n5(at)gmail(dot)com>
Cc:	Tommy Cheng <csckcac(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org, Marielle BONNARD <bonnard(at)cict(dot)fr>
Subject:	Re: Problem database access
Date:	2009-03-12 11:22:43
Message-ID:	49B8F083.4090204@cict.fr
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin

<!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, 
 
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:
<blockquote
cite="mid:2acc2c820903120310w48f01252r1d00e4374293902c(at)mail(dot)gmail(dot)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> </div>
<div> </div>
<div># "local" is for Unix domain socket connections only 
 local   all         all                               trust 
 
 
</div>
<div>On Thu, Mar 12, 2009 at 3:21 PM, Yann Collavoli <<a
moz-do-not-send="true" href="mailto:cyann(at)cict(dot)fr">cyann(at)cict(dot)fr</a>>
wrote: 
<blockquote>
<div>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:
<blockquote type="cite">Try this: 
host    toto     toto 0.0.0.0 0.0.0.0 md5 
 
<div>On Wed, Mar 11, 2009 at 9:02 PM, Yann Collavoli <<a
moz-do-not-send="true" href="mailto:cyann(at)cict(dot)fr">cyann(at)cict(dot)fr</a>>
wrote: 
<blockquote>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 (<a moz-do-not-send="true"
href="mailto:pgsql-admin(at)postgresql(dot)org">pgsql-admin(at)postgresql(dot)org</a>) 
To make changes to your subscription: 
<a moz-do-not-send="true"
href="http://www.postgresql.org/mailpref/pgsql-admin">http://www.postgresql.org/mailpref/pgsql-admin</a> 
</blockquote>
</div>
 
</blockquote>
 
 
<pre>--
Yann Collavoli

Tél : 05 61 36 60 20

Université Paul Sabatier
CICT
118, route de Narbonne
31062 Toulouse Cedex</pre>
</div>
</blockquote>
</div>
 
 
 
-- 
Brahma Prakash Tiwari 
Database Administrator 
iBoss Tech Solution Noida 
</blockquote>
 
 
<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>

Attachment	Content-Type	Size
unknown_filename	text/html	4.7 KB

In response to

Re: Problem database access at 2009-03-12 10:10:09 from BRAHMA PRAKASH TIWARI

Responses

Re: Problem database access at 2009-03-12 11:28:14 from Ashish Karalkar
Re: Problem database access at 2009-03-12 11:31:09 from BRAHMA PRAKASH TIWARI

Browse pgsql-admin by date

	From	Date	Subject
Next Message	Ashish Karalkar	2009-03-12 11:28:14	Re: Problem database access
Previous Message	Karsten Hilbert	2009-03-12 11:15:42	Re: Database separation for backup