BUG #1728: unable to connect from other stations

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

BUG #1728: unable to connect from other stations

Christian Mercure

The following bug has been logged online:

Bug reference:      1728
Logged by:          Christian Mercure
Email address:      [hidden email]
PostgreSQL version: 8.0
Operating system:   Windows XP
Description:        unable to connect from other stations
Details:

I am evaluating backend server to use with Microsoft Access.
I have installed MySQL and was easily able to connect to the server from
network stations using ODBC data source.

I am now evaluating PostGreSQL and cannot connect to it form other stations
on the network.
On the server I can create an ODBC file using localhost as the server name.
It works and my Access frontend can connect to the server tables.

When trying to connect from another station it does not work. I have tried
to replace the server name localhost with the name of my server (example:
DBSERVER), I have disable Windows XP firewall, I have put the following line
in pg_hba.conf

host all    all         192.168.1.1/192.168.1.255 md5

and the following line in postgresql.conf
listen_addresses = '*'

Nothing works. What is required to connect from other stations.
If I cannot resolved this issues I will go with MySQL.

Thanks

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
Reply | Threaded
Open this post in threaded view
|

Re: BUG #1728: unable to connect from other stations

Stephan Szabo
On Fri, 24 Jun 2005, Christian Mercure wrote:

>
> The following bug has been logged online:
>
> Bug reference:      1728
> Logged by:          Christian Mercure
> Email address:      [hidden email]
> PostgreSQL version: 8.0
> Operating system:   Windows XP
> Description:        unable to connect from other stations
> Details:
>
> I am evaluating backend server to use with Microsoft Access.
> I have installed MySQL and was easily able to connect to the server from
> network stations using ODBC data source.
>
> I am now evaluating PostGreSQL and cannot connect to it form other stations
> on the network.
> On the server I can create an ODBC file using localhost as the server name.
> It works and my Access frontend can connect to the server tables.
>
> When trying to connect from another station it does not work. I have tried
> to replace the server name localhost with the name of my server (example:
> DBSERVER), I have disable Windows XP firewall, I have put the following line
> in pg_hba.conf
>
> host all    all         192.168.1.1/192.168.1.255 md5

I think you'd want something like 192.168.1.0/24 or 192.168.1.1
255.255.255.0 there.  When I try something like the above I get

LOG:  invalid entry in file "/usr/local/pgsql-8.0/data/pg_hba.conf" at
line 74, token "192.168.0.1/192.168.0.255"
FATAL:  missing or erroneous pg_hba.conf file


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [hidden email])