Thread: Connection to a PG 8.0 Beta 1 win32 server

Secrétariat wrote:

>
> Hello !
>
> I've installed the Beta 1 on Win XP Pro, it seem working correctly.
> I load a database from Linux 7.4.3 with pgdumpall, it works too.
> But I can't connect from other PC over the LAN (I modified pg_hba.conf
> for the hosts).
> If I write in postgresql.conf :
> tcpip_socket = true
> port = 5432
> I can't connect from the LAN,  NEITHER from the local machine ?!
> Where I've made a mistake ?

Show us your pg_hba.conf, what is the exact error ?



Regards
Gaetano Mendola

> > >
> > > Hello !
> > >
> > > I've installed the Beta 1 on Win XP Pro, it seem working correctly.
> > > I load a database from Linux 7.4.3 with pgdumpall, it works too.
> > > But I can't connect from other PC over the LAN (I modified pg_hba.conf
> > > for the hosts).
> > > If I write in postgresql.conf :
> > > tcpip_socket = true
> > > port = 5432
> > > I can't connect from the LAN,  NEITHER from the local machine ?!
> > > Where I've made a mistake ?
> >
> > Show us your pg_hba.conf, what is the exact error ?
> >
Beta 1 Win32 server at 192.168.0.10,
W2k client at 192.168.0.11.
My pg_hba.conf :
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
local all all md5
# IPv4-style local connections
host all all 127.0.0.1     255.255.255.255 md5
host all all 192.168.0.0 255.255.255.255 md5
# IPv6-style local connections:
#host all all ::1/128 md5

 > > > > Hello !
> > > >
> > > > I've installed the Beta 1 on Win XP Pro, it seem
> working correctly.
> > > > I load a database from Linux 7.4.3 with pgdumpall, it works too.
> > > > But I can't connect from other PC over the LAN (I modified
> > > > pg_hba.conf for the hosts).
> > > > If I write in postgresql.conf :
> > > > tcpip_socket = true
> > > > port = 5432
> > > > I can't connect from the LAN,  NEITHER from the local machine ?!
> > > > Where I've made a mistake ?
> > >
> > > Show us your pg_hba.conf, what is the exact error ?
> > >
> Beta 1 Win32 server at 192.168.0.10,
> W2k client at 192.168.0.11.
> My pg_hba.conf :
> # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD local all all
> md5 # IPv4-style local connections
> host all all 127.0.0.1     255.255.255.255 md5
> host all all 192.168.0.0 255.255.255.255 md5

That should be:
host all all 192.168.0.0 255.255.255.0 md5

if you want the whole subnet. Or if you want just your W2k client:
host all all 192.168.0.11 255.255.255.255 md5

//Magnus

On 24/08/2004 08:23 Secrétariat wrote:
> host all all 127.0.0.1     255.255.255.255 md5
> host all all 192.168.0.0 255.255.255.255 md5

I think that line should be

host all all 192.168.0.0 255.255.255.0 md5

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for
Business             |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+

Secrétariat wrote:

>
>>>>Hello !
>>>>
>>>>I've installed the Beta 1 on Win XP Pro, it seem working correctly.
>>>>I load a database from Linux 7.4.3 with pgdumpall, it works too.
>>>>But I can't connect from other PC over the LAN (I modified pg_hba.conf
>>>>for the hosts).
>>>>If I write in postgresql.conf :
>>>>tcpip_socket = true
>>>>port = 5432
>>>>I can't connect from the LAN,  NEITHER from the local machine ?!
>>>>Where I've made a mistake ?
>>>
>>>Show us your pg_hba.conf, what is the exact error ?
>>>
>
> Beta 1 Win32 server at 192.168.0.10,
> W2k client at 192.168.0.11.
> My pg_hba.conf :
> # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
> local all all md5
> # IPv4-style local connections
> host all all 127.0.0.1     255.255.255.255 md5
> host all all 192.168.0.0 255.255.255.255 md5
> # IPv6-style local connections:
> #host all all ::1/128 md5

If you want allow all the network 192.168.0.0 then
your netmask have to be: 255.255.0.0



Regards
Gaetano Mendola