From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: "Sebastian P. Luque" Newsgroups: gmane.emacs.help Subject: Re: sql-postgresql authentication failure Date: Fri, 25 May 2007 08:07:25 -0500 Organization: Memorial University Message-ID: <87bqg96ohe.fsf@patagonia.sebmags.homelinux.org> References: <87k5ux5v53.fsf@lion.rapttech.com.au> NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: sea.gmane.org 1180098529 30567 80.91.229.12 (25 May 2007 13:08:49 GMT) X-Complaints-To: usenet@sea.gmane.org NNTP-Posting-Date: Fri, 25 May 2007 13:08:49 +0000 (UTC) To: help-gnu-emacs@gnu.org Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Fri May 25 15:08:47 2007 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by lo.gmane.org with esmtp (Exim 4.50) id 1HrZXC-00011j-Hl for geh-help-gnu-emacs@m.gmane.org; Fri, 25 May 2007 15:08:46 +0200 Original-Received: from localhost ([127.0.0.1] helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1HrZXB-0000jw-Rz for geh-help-gnu-emacs@m.gmane.org; Fri, 25 May 2007 09:08:45 -0400 Original-Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1HrZWx-0000jr-RW for help-gnu-emacs@gnu.org; Fri, 25 May 2007 09:08:31 -0400 Original-Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1HrZWw-0000jf-Cb for help-gnu-emacs@gnu.org; Fri, 25 May 2007 09:08:31 -0400 Original-Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1HrZWw-0000jc-42 for help-gnu-emacs@gnu.org; Fri, 25 May 2007 09:08:30 -0400 Original-Received: from main.gmane.org ([80.91.229.2] helo=ciao.gmane.org) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1HrZWv-0005rZ-Mt for help-gnu-emacs@gnu.org; Fri, 25 May 2007 09:08:29 -0400 Original-Received: from list by ciao.gmane.org with local (Exim 4.43) id 1HrZWD-0007Gr-KQ for help-gnu-emacs@gnu.org; Fri, 25 May 2007 15:07:45 +0200 Original-Received: from s01060015e975d7fb.wp.shawcable.net ([24.77.75.70]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 25 May 2007 15:07:45 +0200 Original-Received: from spluque by s01060015e975d7fb.wp.shawcable.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 25 May 2007 15:07:45 +0200 X-Injected-Via-Gmane: http://gmane.org/ Original-Lines: 39 Original-X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: s01060015e975d7fb.wp.shawcable.net User-Agent: Gnus/5.110006 (No Gnus v0.6) Emacs/22.0.990 (gnu/linux) Cancel-Lock: sha1:ZAeQVS/n0HmnWDTgYZwWqKo+ccA= X-detected-kernel: Linux 2.6, seldom 2.4 (older, 4) X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.help:44431 Archived-At: On Fri, 25 May 2007 15:28:56 +1000, Tim X wrote: [...] > the second method may work and is easier, but no guarantee. It is > possible that if you set specific switches, the psql client that sql > mode uses will use local non-password based authentication. While > sql-mode will still prompt you for the username/password, this > information will be ignored by the psql client and you will get > authenticated.based on the user that is running the psql client (i.e. > you). Thanks for your comments Tim. This is very much what I'd like to do, i.e. I don't want to modify the way I access the server. I presume you mean one can put these switches in sql-postgres-options, but I don't see any options in 'man psql' that would allow for this scenario. What particular options would you use? Below is my /etc/postgresql/8.2/main/pg_hba.conf file: ---<---------------cut here---------------start-------------->--- # Database administrative login by UNIX sockets local all postgres ident sameuser # TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all ident sameuser # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5 ---<---------------cut here---------------end---------------->--- Thanks again, -- Seb