Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 9AA749FB8E8 for ; Wed, 14 Feb 2007 08:30:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 33608-08 for ; Wed, 14 Feb 2007 08:30:45 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web27908.mail.ukl.yahoo.com (web27908.mail.ukl.yahoo.com [217.146.182.58]) by postgresql.org (Postfix) with SMTP id 6ABCA9FB8BD for ; Wed, 14 Feb 2007 08:30:49 -0400 (AST) Received: (qmail 62816 invoked by uid 60001); 14 Feb 2007 12:30:47 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.gr; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=vCRW1ceKiTugxYBDXkaJN7/3/F4eKkr+rTfP+nExt4eTZU1TDsGYQ2tswh4zRWeXMsV4zHrMds7P1cdMmHQasUkGXDqzxSp/fwhTn2Dj/JJUd2ijrxGxJXzf0Y/ym7aJDvrJiZELhTQQ9PA9XdmJqUC+Gsj2mdSZ0Hd2LoWhVSw= ; Message-ID: <20070214123047.62814.qmail@web27908.mail.ukl.yahoo.com> Received: from [139.91.254.18] by web27908.mail.ukl.yahoo.com via HTTP; Wed, 14 Feb 2007 12:30:47 GMT Date: Wed, 14 Feb 2007 12:30:47 +0000 (GMT) From: gpio Oxxce Subject: Re: possible Bug in windows version ? To: pgsql-admin@postgresql.org In-Reply-To: <45D2EAF9.4050301@mailnetwork.co.uk> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-892698538-1171456247=:62144" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.219 tagged_above=0 required=5 tests=AWL, BAYES_50, FROM_HAS_ULINE_NUMS, HTML_40_50, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200702/197 X-Sequence-Number: 24662 --0-892698538-1171456247=:62144 Content-Type: text/plain; charset=iso-8859-7 Content-Transfer-Encoding: 8bit Hi All, You have right, the windows firewall caused the problem !! Thx again George "Andy Shellam (Mailing Lists)" έγραψε: If you're running one of Windows XP SP2 or Windows Server 2003, the Windows Firewall will be blocking the connection. If you have the "Windows Firewall" option in Control Panel, check it's disabled, then try again. If that cures your problem, add an exception in for port 5432 before you turn the firewall back on. Andy. gpio Oxxce wrote: Hi Paul, All, My host pg_hba.conf: host all all 127.0.0.1/32 md5 host all all 192.168.1.1/32 trust host all all 192.168.1.2/32 trust and postgresql.conf: listen_addresses = '*' port = 5432 max_connections = 100 the 192.168.1.1 is also the server IP, and I am tryning to connect from the 192.168.1.2 with pgExlorer and pgAdmin but I get a message : "Cannot connect to Server. Connection timeout . Chech if the server is running and accepting TCP connections on 5432" I will try to setup the database and see if this happens also the binary distribution without the installer. Thx George Paul Lambert έγραψε: gpio Oxxce wrote: > Hi all, > > After downloading and installing the latest Postgresql server > (postgresql-8.2.3-1..zip > ) > I can not make it accept local IP connections! > I edit the |pg_hba.conf |file with > > host all all 192.168.100.1/32 trust > > but still I can't connect from 192.168.100.1 to the DB. > Also during the installation I checked the option "Accept TCP > connections.." (or something like that) > > Am I missing something or it is a possible bug ? > > Thanks > George > In putting in the above line did you replace the host line with address "127.0.0.1/32"? If so, that's probably your problem - it needs the 127* line. Is postmaster listening on the default port (5432) or did you change that during install? (Can check that in the postgresql.conf file in the same place as pg_hba.conf) How are you trying to connect? (pgAdminIII, some other program using the ODBC driver?) What error are you getting? NB: I get access denied if I put my servers IP address into the pg_hba.conf file and comment out the existing 127 address line. Local connections would not go out through the network and would thus not be seen by PG as coming from your 192/168 address. P.. -- Paul Lambert Database Administrator AutoLedgers ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings --------------------------------- Χρησιμοποιείτε Yahoo! Βαρεθήκατε τα ενοχλητικά μηνύ ματα (spam); Το Yahoo! Mail διαθέτει την καλύτερη δυνατή προστασία κατά των ενοχλητικών μηνυμάτων http://login.yahoo.com/config/mail?.intl=gr --------------------------------- Χρησιμοποιείτε Yahoo! Βαρεθήκατε τα ενοχλητικά μηνύ ματα (spam); Το Yahoo! Mail διαθέτει την καλύτερη δυνατή προστασία κατά των ενοχλητικών μηνυμάτων http://login.yahoo.com/config/mail?.intl=gr !DSPAM:37,45d2ce7b18511494436004! -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world" p: +44 (0) 121 288 0832/0839 m: +44 (0) 7818 000834 --------------------------------- Χρησιμοποιείτε Yahoo! Βαρεθήκατε τα ενοχλητικά μηνύ ματα (spam); Το Yahoo! Mail διαθέτει την καλύτερη δυνατή προστασία κατά των ενοχλητικών μηνυμάτων http://login.yahoo.com/config/mail?.intl=gr --------------------------------- Χρησιμοποιείτε Yahoo! Βαρεθήκατε τα ενοχλητικά μηνύ ματα (spam); Το Yahoo! Mail διαθέτει την καλύτερη δυνατή προστασία κατά των ενοχλητικών μηνυμάτων http://login.yahoo.com/config/mail?.intl=gr --0-892698538-1171456247=:62144 Content-Type: text/html; charset=iso-8859-7 Content-Transfer-Encoding: 8bit Hi All,

You have right, the windows firewall caused the problem !!
Thx again

George

"Andy Shellam (Mailing Lists)" <andy.shellam-lists@mailnetwork.co.uk> έγραψε:
If you're running one of Windows XP SP2 or Windows Server 2003, the Windows Firewall will be blocking the connection.
If you have the "Windows Firewall" option in Control Panel, check it's disabled, then try again.

If that cures your problem, add an exception in for port 5432 before you turn the firewall back on.

Andy.


gpio Oxxce wrote:
Hi Paul, All,

My host   pg_hba.conf:
host     all         all         127.0.0.1/32                 md5
host    all         all          192.168.1.1/32          trust
host    all         all          192.168.1.2/32          trust

and postgresql.conf:
listen_addresses = '*'       
port = 5432               
max_connections = 100   

the 192.168.1.1 is also the server IP, and I am tryning to connect from the 192.168.1.2 with pgExlorer and pgAdmin  but I get a message :
"Cannot connect to Server. Connection timeout . Chech if the server is running and accepting TCP connections on 5432"

I will try to setup the database and see if this happens also the binary distribution without  the installer.

Thx
George


Paul Lambert <paul.lambert@autoledgers.com.au> έγραψε:
gpio Oxxce wrote:
> Hi all,
>
> After downloading and installing the latest Postgresql server
> (postgresql-8.2.3-1..zip
> )
> I can not make it accept local IP connections!
> I edit the |pg_hba.conf |file with
>
> host all all 192.168.100.1/32 trust
>
> but still I can't connect from 192.168.100.1 to the DB.
> Also during the installation I checked the option "Accept TCP
> connections.." (or something like that)
>
> Am I missing something or it is a possible bug ?
>
> Thanks
> George
>

In putting in the above line did you replace the host line with address
"127.0.0.1/32"? If so, that's probably your problem - it needs the 127*
line. Is postmaster listening on the default port (5432) or did you
change that during install? (Can check that in the postgresql.conf file
in the same place as pg_hba.conf)

How are you trying to connect? (pgAdminIII, some other program using the
ODBC driver?) What error are you getting?

NB: I get access denied if I put my servers IP address into the
pg_hba.conf file and comment out the existing 127 address line. Local
connections would not go out through the network and would thus not be
seen by PG as coming from your 192/168 address.

P..

--
Paul Lambert
Database Administrator
AutoLedgers


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings


Χρησιμοποιείτε Yahoo!
Βαρεθήκατε τα ενοχλητικά μηνύ ματα (spam); Το Yahoo! Mail διαθέτει την καλύτερη δυνατή προστασία κατά των ενοχλητικών μηνυμάτων
http://login.yahoo.com/config/mail?.intl=gr

Χρησιμοποιείτε Yahoo!
Βαρεθήκατε τα ενοχλητικά μηνύ ματα (spam); Το Yahoo! Mail διαθέτει την καλύτερη δυνατή προστασία κατά των ενοχλητικών μηνυμάτων
http://login.yahoo.com/config/mail?.intl=gr
!DSPAM:37,45d2ce7b18511494436004!


-- 
Andy Shellam
NetServe Support Team

the Mail Network
"an alternative in a standardised world"

p: +44 (0) 121 288 0832/0839
m: +44 (0) 7818 000834


Χρησιμοποιείτε Yahoo!
Βαρεθήκατε τα ενοχλητικά μηνύ ματα (spam); Το Yahoo! Mail διαθέτει την καλύτερη δυνατή προστασία κατά των ενοχλητικών μηνυμάτων
http://login.yahoo.com/config/mail?.intl=gr


Χρησιμοποιείτε Yahoo!
Βαρεθήκατε τα ενοχλητικά μηνύ ματα (spam); Το Yahoo! Mail διαθέτει την καλύτερη δυνατή προστασία κατά των ενοχλητικών μηνυμάτων
http://login.yahoo.com/config/mail?.intl=gr
--0-892698538-1171456247=:62144--