| From: | Sebastian Scarano <opensas(at)gmail(dot)com> | 
|---|---|
| To: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, pgsql-novice(at)postgresql(dot)org | 
| Subject: | Re: connecting to linux server from windows xp | 
| Date: | 2005-11-14 15:52:32 | 
| Message-ID: | d574718c0511140752m60a4a59uca871e1005a55999@mail.gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-novice | 
Hi
I think that the browser is adding some http:// stuff in front of my
ip addresses config.
I'll replace the dots "." with hypens "-". You'll see there's no
"http://" anywhere to be found...
---
tux data # cat pg_hba.conf | tail -n 9
# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
# "local" is for Unix domain socket connections only
local   all         all                               trust
# IPv4 local connections:
host    all         all         127-0-0-1/32          trust
host    all         all         192-168-0-0/16        password
# IPv6 local connections:
host    all         all         ::1/128               trus
---
From the windows xp guest I opend a shell and tried with
telnet tux 5432 but it couldn't connect
So I tried with telnet 192.168.103.1 5432 and it did connected for a
few seconds.
And the, back to pgadminIII, i replaced tux with the ip address and I
could connect!!!!
Anyway, I'd like to know why I can connect from a windowx xp client to
a postgresql server running con a windows xp with the server name, but
with a server running in linux I have to use the ip address
Saludos and thanks
Sas
On 11/14/05, A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)com> wrote:
> am  14.11.2005, um  6:17:49 -0300 mailte Sebastian Scarano folgendes:
> > With the help of Andreas, I could finally connect a from a guest xp
> running
> > with vmware inside a host xp machine
> >
> > Now I'm trying to do the same with a host gentoo box and a guest xp SP1
> >
> > this is my pg_hba.conf
> >
> > ---
> > tux data # cat pg_hba.conf | tail -n 8
> >
> > # "local" is for Unix domain socket connections only
> > local all all trust
> > # IPv4 local connections:
> > host all all 127.0.0.1/32 <http://127.0.0.1/32> trust
> > host all all 192.168.0.0/16 <http://192.168.0.0/16> md5
>                               ^^^^^^^^^^^^^^^^^^^^^^
>                               wrong syntax
>
>
> >
> > When I try to connect from the host using pgaminIII for windows, I get
> the
> > following error:
> >
> > "Server not listening"
>
> 1. wrong syntax in pg_hba.conf
> 2. check, if the server ist running (telnet server 5432, it should
>    connect for a few seconds)
>
> My guess: because the wrong syntax the server is not running.
>
>
> HTH, Andreas
> --
> Andreas Kretschmer    (Kontakt: siehe Header)
> Heynitz:  035242/47212,      D1: 0160/7141639
> GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
>  ===    Schollglas Unternehmensgruppe    ===
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel T. Staal | 2005-11-14 16:06:09 | Re: Application using PostgreSQL as a back end | 
| Previous Message | Marcus Engene | 2005-11-14 14:23:37 | oids and tsearch2 |