Re: UNABLE TO CONNECT TO A DATABASE IN A WEB SERVER.
| От | Tony Day |
|---|---|
| Тема | Re: UNABLE TO CONNECT TO A DATABASE IN A WEB SERVER. |
| Дата | |
| Msg-id | AANLkTikE9-sBrWlP_LG7TrLv4gsrhEk7qAcRJnNb4PGt@mail.gmail.com обсуждение исходный текст |
| Ответ на | UNABLE TO CONNECT TO A DATABASE IN A WEB SERVER. (JORGE MALDONADO <jorgemal1960@gmail.com>) |
| Список | pgsql-novice |
Hi Jorge
I would perhaps try:
type=hostnossl, database=all, user=all, cidr-address=192.168.1.0/24, method=trust
Please keep in mind that I am also very much a novice so this is a case of the "blind trying to lead the blind ..." :-)
Regards, Tony
I would perhaps try:
type=hostnossl, database=all, user=all, cidr-address=192.168.1.0/24, method=trust
Please keep in mind that I am also very much a novice so this is a case of the "blind trying to lead the blind ..." :-)
Regards, Tony
On Thu, May 27, 2010 at 9:45 AM, JORGE MALDONADO <jorgemal1960@gmail.com> wrote:
I am writing a web app which should connect to a database in a server within my personal network but I am having trouble. I get the following error message:There is no record on pg_hba.conf for 192.168.1.77, user postgres, database restaurant, SSL inactive.I have checked the configuration files on the server machine as follows:* The listen_addresses parameter in postgresql.conf equals *.* The pg_hba.conf has an entry of type=host, database=all, user=all, IP-Address=192.168.1.77/32, Password=md5.I have tried changing the IP-Address to 192.168.1.0/24 and 192.168.0.0/16; also I tried Password=Trust and Password=Password.What else can I check?Respectfully,Jorge Maldonado
В списке pgsql-novice по дате отправления: