Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 8C4FF9FB251 for ; Mon, 5 Mar 2007 19:42:42 -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 10398-01 for ; Mon, 5 Mar 2007 19:42:34 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from weatherbeeta.com.au (218-214-212-153.people.net.au [218.214.212.153]) by postgresql.org (Postfix) with SMTP id 527D29FB1F6 for ; Mon, 5 Mar 2007 19:42:36 -0400 (AST) Received: (qmail 10054 invoked from network); 5 Mar 2007 23:42:34 -0000 X-NetworkBox-HamSign: 0101;OUT;wbeetaau1;2544834e1547dc937907d9a164e4b784; Received: from mail.weatherbeeta.com.au (10.10.0.2) by network-box.weatherbeeta.com.au with SMTP; 5 Mar 2007 23:42:34 -0000 Received: (qmail 28624 invoked by uid 1166); 6 Mar 2007 10:42:34 +1100 Received: from 172.20.0.155 by mail.weatherbeeta.com.au (envelope-from , uid 1165) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.6/2315. perlscan: 1.25-st-qms. Clear:RC:1(172.20.0.155):. Processed in 0.432607 secs); 05 Mar 2007 23:42:34 -0000 X-Antivirus-mail.weatherbeeta.com.au-Mail-From: phillip.smith@weatherbeeta.com.au via mail.weatherbeeta.com.au X-Antivirus-mail.weatherbeeta.com.au: 1.25-st-qms (Clear:RC:1(172.20.0.155):. Processed in 0.432607 secs Process 28612) Received: from it-phil.weatherbeeta.com.au (HELO wbaus090) (172.20.0.155) by mail.weatherbeeta.com.au with SMTP; 6 Mar 2007 10:42:32 +1100 From: "Phillip Smith" To: "'Moritz Bayer'" , Subject: Re: pg_hba.conf & putty Date: Tue, 6 Mar 2007 10:42:37 +1100 Organization: Weatherbeeta Pty Ptd Message-ID: <008701c75f7f$f5467830$9b0014ac@wbaus090> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0088_01C75FDC.28B6F030" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 Importance: Normal In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-Scanned-By-wbeetaau1: Virus scan performed by network-box X-Scanned-By-wbeetaau1: Scanner file id is wbeetaau1-1173138154.581-10048-000 X-Scanned-By-wbeetaau1: No known viruses found in message (received+scanned in 0.04/0.15 secs) X-Scanned-By-wbeetaau1: Spam-Check-Result: No, hits=0 required=7 tests= autolearn=no version=2.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.22 tagged_above=0 required=5 tests=AWL, BAYES_50, FORGED_RCVD_HELO, HTML_50_60, HTML_MESSAGE, NORMAL_HTTP_TO_IP X-Spam-Level: X-Archive-Number: 200703/15 X-Sequence-Number: 24839 This is a multi-part message in MIME format. ------=_NextPart_000_0088_01C75FDC.28B6F030 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit What address are you connecting to on your desktop computer? You should be using localhost:5432 which putty will redirect to the server via the SSH tunnel and the server will connect to PostgreSQL on your behalf. ~p -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Moritz Bayer Sent: Tuesday, 6 March 2007 10:31 To: pgsql-admin@postgresql.org Subject: [ADMIN] pg_hba.conf & putty dear list, I know there are already hunderts of posts about pg_hba.conf, but still after reading a few of them I still got troubles with this topic. I've got a vpn server with a ststic ip address, java apps are supposed to run there receiving data from a postgresql database. The database is running, but for changes on it I want to open a putty connection while using pgAdmin. In putty, I define a tunnel to port 5432, its displayed like this: Lserver.ip.address:5432 Thought this entries in my pg_hba.conf would do it: # "local" is for Unix domain socket connections only local all all md5 # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5 well, it doesn't. When i run pgAdmin with an open putty connection, it still says: error connecting to server. Any hints how I can find out whats still wrong? Thanks in advance, Mo *******************Confidentiality and Privilege Notice******************* The material contained in this message is privileged and confidential to the addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to such person, you may not copy or deliver this message to anyone, and you should destroy it and kindly notify the sender by reply email. Information in this message that does not relate to the official business of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall not be liable for direct, indirect or consequential loss arising from transmission of this message or any attachments ------=_NextPart_000_0088_01C75FDC.28B6F030 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

What address are you connecting to = on your desktop computer? You should be using localhost:5432 which putty will = redirect to the server via the SSH tunnel and the server will connect to = PostgreSQL on your behalf.

 

~p

 

-----Original Message-----
From: pgsql-admin-owner@postgresql.org = [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Moritz Bayer
Sent: Tuesday, 6 March = 2007 10:31
To: = pgsql-admin@postgresql.org
Subject: [ADMIN] = pg_hba.conf & putty

 

dear list,

I know there are already hunderts of posts about pg_hba.conf, but still = after reading a few of them I still got troubles with this topic.

I've got a vpn server  with a ststic ip address, java apps are = supposed to run there receiving data from a postgresql database.
The database is running, but for changes on it I want to open a putty connection while using pgAdmin.
In putty, I define a tunnel to port 5432, its displayed like this: Lserver.ip.address:5432

Thought this entries in my pg_hba.conf would do it:

# "local" is for Unix domain socket connections only
local   all         all           &nbs= p;            = ;       md5

# IPv4 local connections:
host    = all         all         127.0.0.1/32    &nbs= p;     md5

# IPv6 local connections:
host    = all         all         ::1/128           =     md5

well, it doesn't. When i run  pgAdmin with an open  putty = connection, it still says: error connecting to server.

Any hints how I can find out whats still wrong?

Thanks in advance,
Mo


=

=0A*******************Confidentiality and Privilege Notice*************= ******=0A

=0AThe material contained in this message is privileged and conf= idential to=0Athe addressee. If you are not the addressee indicated in this m= essage or=0Aresponsible for delivery of the message to such person, you may no= t copy=0Aor deliver this message to anyone, and you should destroy it and kind= ly=0Anotify the sender by reply email.=0A

=0AInformation in this message that do= es not relate to the official business=0Aof Weatherbeeta must be treated as ne= ither given nor endorsed by Weatherbeeta.=0AWeatherbeeta, its employees, contr= actors or associates shall not be liable=0Afor direct, indirect or consequenti= al loss arising from transmission of this=0Amessage or any attachments=0A
= ------=_NextPart_000_0088_01C75FDC.28B6F030--