Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 495FB9FB25F for ; Mon, 5 Mar 2007 20:17:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 26891-10 for ; Mon, 5 Mar 2007 20:17:29 -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 492579FB25E for ; Mon, 5 Mar 2007 20:17:31 -0400 (AST) Received: (qmail 20979 invoked from network); 6 Mar 2007 00:17:30 -0000 X-NetworkBox-HamSign: 0101;OUT;wbeetaau1;9d86a59fc2f09fc066c951d2558635e9; Received: from mail.weatherbeeta.com.au (10.10.0.2) by network-box.weatherbeeta.com.au with SMTP; 6 Mar 2007 00:17:29 -0000 Received: (qmail 2864 invoked by uid 1166); 6 Mar 2007 11:17:29 +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 1.107627 secs); 06 Mar 2007 00:17:29 -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 1.107627 secs Process 2848) Received: from it-phil.weatherbeeta.com.au (HELO wbaus090) (172.20.0.155) by mail.weatherbeeta.com.au with SMTP; 6 Mar 2007 11:17:26 +1100 From: "Phillip Smith" To: "'Moritz Bayer'" Cc: Subject: Re: pg_hba.conf & putty Date: Tue, 6 Mar 2007 11:17:36 +1100 Organization: Weatherbeeta Pty Ptd Message-ID: <00a901c75f84$d7b9fa80$9b0014ac@wbaus090> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00AA_01C75FE1.0B2A7280" 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-1173140249.994-20974-000 X-Scanned-By-wbeetaau1: No known viruses found in message (received+scanned in 0.07/0.17 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.069 tagged_above=0 required=5 tests=AWL, BAYES_40, FORGED_RCVD_HELO, HTML_MESSAGE, NORMAL_HTTP_TO_IP X-Spam-Level: X-Archive-Number: 200703/18 X-Sequence-Number: 24842 This is a multi-part message in MIME format. ------=_NextPart_000_00AA_01C75FE1.0B2A7280 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable I know your problem (I think) =20 Your SSH forward you said is defined as: Lserver.ip.address:5432 =20 So the requests will be coming from your server's IP address via the = eth0 interface. You need to change this to 127.0.0.1 to make it use the lo interface, and then the requests will come from 127.0.0.1 to match your pg_hba.conf =20 Cheers, ~p =20 =20 -----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:58 To: Phillip Smith Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] pg_hba.conf & putty =20 hello phillip, =20 yes, the connection i defined in pgadmin uses localhost:5432.=20 Still, no success :( 2007/3/6, Phillip Smith < phillip.smith@weatherbeeta.com.au>: 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. =20 ~p =20 -----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 =20 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.=20 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:=20 # "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.=20 Any hints how I can find out whats still wrong? Thanks in advance, Mo =20 *******************Confidentiality and Privilege = Notice*******************=20 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.=20 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=20 =20 =0A*******************Confidentiality and Privilege Notice*******************= =0A=0AThe material contained in this message is privileged and confidential to= =0Athe addressee. If you are not the addressee indicated in this message or= =0Aresponsible for delivery of the message to such person, you may not copy=0Aor= deliver this message to anyone, and you should destroy it and kindly=0Anotify= the sender by reply email.=0A=0AInformation in this message that does not relat= e to the official business=0Aof Weatherbeeta must be treated as neither given = nor endorsed by Weatherbeeta.=0AWeatherbeeta, its employees, contractors or as= sociates shall not be liable=0Afor direct, indirect or consequential loss aris= ing from transmission of this=0Amessage or any attachments=0A ------=_NextPart_000_00AA_01C75FE1.0B2A7280 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

I know your problem (I = think)

 

Your SSH forward you said is = defined as:

Lserver.ip.addres= s:5432

 

So the requests will be coming from = your server’s IP address via the eth0 interface… You need to change this to = 127.0.0.1 to make it use the lo interface, and then the requests will come from = 127.0.0.1 to match your pg_hba.conf

 

Cheers,

~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:58
To: Phillip Smith
Cc: = pgsql-admin@postgresql.org
Subject: Re: [ADMIN] = pg_hba.conf & putty

 

hello phillip,
 
yes, the connection i defined in pgadmin uses localhost:5432.

Still, no success :(




2007/3/6, Phillip Smith < phillip.smith@weatherbeeta.com.au>:

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<= /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   =        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

 

*******************Confidenti= ality 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 =

 


=

=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_00AA_01C75FE1.0B2A7280--