X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D31015E46FB for ; Thu, 19 Aug 2004 20:28:29 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 29290-01 for ; Thu, 19 Aug 2004 23:28:29 +0000 (GMT) Received: from post5.inre.asu.edu (post5.inre.asu.edu [129.219.110.120]) by svr1.postgresql.org (Postfix) with ESMTP id F2A875E46ED for ; Thu, 19 Aug 2004 20:28:25 -0300 (ADT) Received: from conversion.post5.inre.asu.edu by asu.edu (PMDF V6.1-1X6 #30769) id <0I2P00701VRNER@asu.edu> for pgsql-admin@postgresql.org; Thu, 19 Aug 2004 16:26:11 -0700 (MST) Received: from smtp.asu.edu (smtp.asu.edu [129.219.110.107]) by asu.edu (PMDF V6.1-1X6 #30769) with ESMTP id <0I2P004OOVRMKO@asu.edu>; Thu, 19 Aug 2004 16:26:10 -0700 (MST) Received: from moroni.pp.asu.edu (moroni.pp.asu.edu [129.219.69.200]) by smtp.asu.edu (8.12.10/8.12.10/asu_smtp_relay, nullclient, tcp_wrapped) with ESMTP id i7JNQ971001958; Thu, 19 Aug 2004 16:26:09 -0700 (MST) Received: by moroni.pp.asu.edu (Postfix, from userid 500) id 41605D3F; Thu, 19 Aug 2004 16:26:10 -0700 (MST) Date: Thu, 19 Aug 2004 16:26:10 -0700 From: David Bear Subject: Re: tunneling through ssh In-reply-to: <6619.1092878514@sss.pgh.pa.us> To: Tom Lane Cc: Steve Crawford , pgsql-admin@postgresql.org Reply-To: David.Bear@asu.edu Message-id: <20040819232610.GF23172@asu.edu> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-disposition: inline User-Agent: Mutt/1.4.1i References: <20040818231312.GA18227@asu.edu> <200408181621.24097.scrawford@pinpointresearch.com> <20040819005811.GC18227@asu.edu> <6619.1092878514@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/181 X-Sequence-Number: 14576 On Wed, Aug 18, 2004 at 09:21:54PM -0400, Tom Lane wrote: > David Bear writes: > > and on the ssh'd terminal tunnel session: > > -------- > > $ channel 3: open failed: administratively prohibited: open failed > > ------- > > Perhaps a firewalling problem? Look at your kernel packet filtering > setup ... it's not uncommon for even local-loopback traffic to be > aggressively filtered by default, and none of the people who set these > things up think port 5432 is a standard service :-( > thanks for all the suggestions. The solution was to tunnel 'localhost' -- the key is knowing which localhost localhost is referring too.. so, here's what I did. ssh -L 4001:localhost:5432 iddwb@dbsrv1 This allows postgresql to listen on the 'localhost' interface.. thanks for all the replies. -- David Bear phone: 480-965-8257 fax: 480-965-9189 College of Public Programs/ASU Wilson Hall 232 Tempe, AZ 85287-0803 "Beware the IP portfolio, everyone will be suspect of trespassing"