Re: No entry to pg_hba.conf 10.17.11.16

From: "Roman Fail" <rfail(at)posportal(dot)com>
To: "Fabiano" <fcostola(at)osite(dot)com(dot)br>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: No entry to pg_hba.conf 10.17.11.16
Date: 2003-03-12 16:00:52
Message-ID: 9B1C77393DED0D4B9DAA1AA1742942DA3BCABA@pos_pdc.posportal.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I'm not a TCP/IP networking expert, but I'm pretty certain that 10.x.x.x addresses are the very definition of a private non-routable Class A network. Which means the subnet mask should be 255.0.0.0.

255.255.255.0 is the mask for Class C networks, which for private networks are generally defined as 192.168.x.x.

The first big question is can you ping the server from another machine on your private network? (Assuming ICMP8 is not blocked by a software firewall). If you can't ping it, then something is wrong with your network configuration. Are you able to access the server at the specified IP address through other services, such as telnet, ssh, ftp? (assumes that some of those daemons are running on the server)

Can the server ping itself? Does it's ethernet interface even work? Can it ping other hosts on the network? Keep asking questions like this and sooner or later you'll have your answer.

IP References:
http://www.oreilly.com/catalog/coreprot/chapter/appb.html
http://questy.com/tech/netw62.htm
http://www.sangoma.com/fguide.htm

Roman

>I do not know why the others has "USER" at pg_hba.conf. Maybe your
>version is 7.3. Mine is 7.2.
>
>Thanks for your suggestion but it have not worked. The mask I use is
>from my local network, and all the stations is with the same mask.
>
>I restarted the server many times using pg_ctl restart or stop and then
>start. I do not know what can I do.

>>>I put the following line at pg_hba.conf:
>>>
>>>local all 10.17.11.0 255.255.255.0 trust
>>>
>>>
>>
>>Mine has a "user" column, which yours skipped. It would be:
>>
>>local all all 10.17.11.0 255.255.255.0 trust
>>
>>You must also make sure you restart the server. Try connecting on localhost
>>or 127.0.0.1.
>>
>>PS, are you actually on a Class C network? If you are, then your subnet mask
>>might be 255.0.0.0, or something else entirely.
>>
>>-Keith

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2003-03-12 16:10:38 Re: No entry to pg_hba.conf 10.17.11.16
Previous Message Erich Titl 2003-03-12 15:27:25 Info