X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 33E2D9DCD12 for ; Thu, 16 Feb 2006 13:29:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40889-09 for ; Thu, 16 Feb 2006 13:29:26 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from post5.inre.asu.edu (post5.inre.asu.edu [129.219.110.120]) by postgresql.org (Postfix) with ESMTP id 65D649DCD01 for ; Thu, 16 Feb 2006 13:29:25 -0400 (AST) Received: from conversion.post5.inre.asu.edu by asu.edu (PMDF V6.1-1X6 #30769) id <0IUS00801J49GZ@asu.edu> for pgsql-admin@postgresql.org; Thu, 16 Feb 2006 10:26:33 -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 <0IUS006LUJ48H6@asu.edu>; Thu, 16 Feb 2006 10:26:32 -0700 (MST) Received: from teancum.pp.asu.edu (teancum.pp.asu.edu [129.219.69.212]) by smtp.asu.edu (8.12.10/8.12.10/asu_smtp_relay, nullclient, tcp_wrapped) with ESMTP id k1GHQLj5019386; Thu, 16 Feb 2006 10:26:31 -0700 (MST) Received: by teancum.pp.asu.edu (Postfix, from userid 1000) id 4433DEAB; Thu, 16 Feb 2006 10:26:21 -0700 (MST) Date: Thu, 16 Feb 2006 10:26:21 -0700 From: David Bear Subject: Re: hba conf ident sameuser not working In-reply-to: <21927.1140055241@sss.pgh.pa.us> To: Tom Lane Cc: David.Bear@asu.edu, Peter Eisentraut , pgsql-admin@postgresql.org Reply-to: David.Bear@asu.edu Message-id: <20060216172621.GB15469@asu.edu> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-disposition: inline User-Agent: Mutt/1.5.9i References: <20060215031605.GH14507@asu.edu> <200602151127.36955.peter_e@gmx.net> <20060216003610.GD11620@asu.edu> <21927.1140055241@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.39 required=5 tests=[AWL=-0.090, DNS_FROM_RFC_ABUSE=0.479, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.39 X-Spam-Level: X-Archive-Number: 200602/199 X-Sequence-Number: 20620 On Wed, Feb 15, 2006 at 09:00:41PM -0500, Tom Lane wrote: > David Bear writes: > > now, back on teancum that has the tunnel on port 6666, I do this: > > > iddwb@teancum:~> psql -p 6666 -h localhost -U tlhowell > > psql: FATAL: Ident authentication failed for user "tlhowell" > > iddwb@teancum:~> psql -p 6666 -h localhost -U iddwb > > psql: FATAL: Ident authentication failed for user "iddwb" > > I'm afraid you're kind of stuck on getting that to work. In the cases > that work, psql is executing on the server side of the ssh connection. > Here, you want it to work on the client side. The problem is that the > Postgres server is going to see that TCP connection as originating from > a server-side sshd daemon process, and so ident is quite properly going > to fail unless the requested database username matches whatever sshd is > running as. > > You could possibly get it to work if you could get sshd to run the > daemon subprocess as yourself instead of root ... dunno enough about > ssh to know if that's possible. thats the path I was thinking along... Thanks. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend -- 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"