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: | Raw Message | Whole Thread | 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 |