Re: Problem database access

Поиск
Список
Период
Сортировка
От Yann Collavoli
Тема Re: Problem database access
Дата
Msg-id 49B8DB39.1010601@cict.fr
обсуждение исходный текст
Ответ на Problem database access  (Yann Collavoli <cyann@cict.fr>)
Ответы Re: Problem database access  (BRAHMA PRAKASH TIWARI <prakashr2n5@gmail.com>)
Список pgsql-admin
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.0md5<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"> Try this:<br /> host    toto    
toto0.0.0.0 0.0.0.0 md5<br /><br /><div>On Wed, Mar 11, 2009 at 9:02 PM, Yann Collavoli <span><<a
href="mailto:cyann@cict.fr"moz-do-not-send="true">cyann@cict.fr</a>></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
userand 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
-Ototo -E LATIN1 toto<br /> CREATE DATABASE<br /><br /> This is the contents of the file pg_hba.conf :<br /> # TYPE
DATABASEUSER 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
postgreslogs :<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
yourhelp<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 href="mailto:pgsql-admin@postgresql.org"
moz-do-not-send="true">pgsql-admin@postgresql.org</a>)<br/> To make changes to your subscription:<br /><a
href="http://www.postgresql.org/mailpref/pgsql-admin"
moz-do-not-send="true">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>

В списке pgsql-admin по дате отправления:

Предыдущее
От: Yann Collavoli
Дата:
Сообщение: Problem database access
Следующее
От: BRAHMA PRAKASH TIWARI
Дата:
Сообщение: Re: Problem database access