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 04EFF5E37CE for ; Wed, 18 Aug 2004 21:59:08 -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 18044-08 for ; Thu, 19 Aug 2004 00:59:12 +0000 (GMT) Received: from post5.inre.asu.edu (post5.inre.asu.edu [129.219.110.120]) by svr1.postgresql.org (Postfix) with ESMTP id CF3DB5E37CB for ; Wed, 18 Aug 2004 21:59:02 -0300 (ADT) Received: from conversion.post5.inre.asu.edu by asu.edu (PMDF V6.1-1X6 #30769) id <0I2O007015D09E@asu.edu> for pgsql-admin@postgresql.org; Wed, 18 Aug 2004 17:58:12 -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 <0I2O006PL5CZMR@asu.edu>; Wed, 18 Aug 2004 17:58:12 -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 i7J0wB71021116; Wed, 18 Aug 2004 17:58:11 -0700 (MST) Received: by moroni.pp.asu.edu (Postfix, from userid 500) id 60B89D3D; Wed, 18 Aug 2004 17:58:11 -0700 (MST) Date: Wed, 18 Aug 2004 17:58:11 -0700 From: David Bear Subject: Re: tunneling through ssh In-reply-to: <200408181621.24097.scrawford@pinpointresearch.com> To: Steve Crawford Cc: pgsql-admin@postgresql.org Reply-To: David.Bear@asu.edu Message-id: <20040819005811.GC18227@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> 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/172 X-Sequence-Number: 14567 On Wed, Aug 18, 2004 at 04:21:24PM -0700, Steve Crawford wrote: > On Wednesday 18 August 2004 4:13 pm, David Bear wrote: > > I'm attempting to run pgsql through a tunnel. I'm using the default > > pg_hba.conf file for now which has the relevant information: > > > > ------------ > > local all all > > trust > > host all all 127.0.0.1 255.255.255.255 > > trust > > ------------ > > > > I assume this means that the back end will bind to 127.0.0.1:5432 > > since that seems to be the default port number. > > > > Yet, when trying to come through the tunnel I get this in my logs > > on the 'server' machine - the one running postgres backend. > > > > ----------- > > Aug 18 16:00:40 dbsrv1 sshd[41006]: error: connect_to ::1 port > > 5432: Connection refused > > Aug 18 16:00:40 dbsrv1 sshd[41006]: error: connect_to 127.0.0.1 > > port 5432: Connection refused > > Aug 18 16:00:40 dbsrv1 sshd[41006]: error: connect_to localhost > > port 5432: failed. > > ----------- > > > > Am I missing something obvious? > > Is PG set to accept tcp/ip connections? Check postgresql.conf for: > tcpip_socket=true > > 127.0.0.1 is connecting through tcp/ip, not local domain sockets. thanks for the info. I've check the postgresql.conf file and have the following lines: ---------- tcpip_socket = true max_connections = 40 port = 5432 virtual_host = '127.0.0.1' # what interface to listen on; defaults to any ---------- I assume I am binding to tcp socket 5432 as sockstat reveals: ---------- USER COMMAND PID FD PROTO LOCAL ADDRESS FOREIGN pgsql postgres 41229 3 tcp4 127.0.0.1:5432 *:* ---------- I still get the error: --------- $>psql -h localhost -p 4001 test1 psql: could not receive server response to SSL negotiation packet: No such file or directory --------- and on the ssh'd terminal tunnel session: -------- $ channel 3: open failed: administratively prohibited: open failed ------- Any other suggestions? > > Cheers, > Steve > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match -- 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"