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: sql-postgresql authentication failure Date: Thu, 24 May 2007 17:04:23 -0500 Organization: Memorial University Message-ID: <877iqxlvyw.fsf@patagonia.sebmags.homelinux.org> NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: sea.gmane.org 1180044307 18055 80.91.229.12 (24 May 2007 22:05:07 GMT) X-Complaints-To: usenet@sea.gmane.org NNTP-Posting-Date: Thu, 24 May 2007 22:05:07 +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 00:05:01 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 1HrLQW-0005Nb-8r for geh-help-gnu-emacs@m.gmane.org; Fri, 25 May 2007 00:04:56 +0200 Original-Received: from localhost ([127.0.0.1] helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1HrLQZ-0005KI-6t for geh-help-gnu-emacs@m.gmane.org; Thu, 24 May 2007 18:04:59 -0400 Original-Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1HrLQJ-0005K2-W8 for help-gnu-emacs@gnu.org; Thu, 24 May 2007 18:04:44 -0400 Original-Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1HrLQH-0005Jp-Ns for help-gnu-emacs@gnu.org; Thu, 24 May 2007 18:04:42 -0400 Original-Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1HrLQH-0005Jm-Go for help-gnu-emacs@gnu.org; Thu, 24 May 2007 18:04:41 -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 1HrLQG-0004ie-Tk for help-gnu-emacs@gnu.org; Thu, 24 May 2007 18:04:41 -0400 Original-Received: from list by ciao.gmane.org with local (Exim 4.43) id 1HrLQA-00053C-MS for help-gnu-emacs@gnu.org; Fri, 25 May 2007 00:04:34 +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 00:04:34 +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 00:04:34 +0200 X-Injected-Via-Gmane: http://gmane.org/ Original-Lines: 58 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:Kldg4ZKcFaYJvNsBwtF1iMbH+fA= 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:44402 Archived-At: Hi, I'd like to use `sql.el' to connect to local postgresql databases. I'm accessing the server through my normal user account, although I've added myself as a super user in the postgresql server. In a shell, I can connect to a 'test' database with: ---<---------------cut here---------------start-------------->--- $ psql test Welcome to psql 8.2.4, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit test=# ---<---------------cut here---------------end---------------->--- However, when I try to do it from Emacs with `sql.el', I have: M-x sql-postgresql In the minibuffer: "User: myuser" "Database: test" "Server: localhost" "Password for user myuser: secret" and the message from the server: Password for user myuser: psql: FATAL: password authentication failed for user "myuser" Process SQL exited abnormally with code 2 Password for user sluque: psql: FATAL: password authentication failed for user "myuser" Process SQL exited abnormally with code 2 I'm using: ,-----[ psql --version ] | psql (PostgreSQL) 8.2.4 | contains support for command-line editing `----- Any ideas what might be wrong? Thanks. Cheers, -- Seb