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 по дате отправления: