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 <cyann@xxxxxxx
<mailto:cyann@xxxxxxx>> 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 <cyann@xxxxxxx
<mailto:cyann@xxxxxxx>> 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@xxxxxxxxxxxxxx <mailto:pgsql-admin@xxxxxxxxxxxxxx>)
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/
/
/
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
