From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Martin Steffen Newsgroups: gmane.emacs.help,gmane.comp.db.postgresql.general Subject: failure to connect to postgres DB via pg.el Date: 07 Oct 2006 12:14:00 +0200 Organization: IFI UiO Norway Message-ID: NNTP-Posting-Host: main.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: sea.gmane.org 1160216744 26503 80.91.229.2 (7 Oct 2006 10:25:44 GMT) X-Complaints-To: usenet@sea.gmane.org NNTP-Posting-Date: Sat, 7 Oct 2006 10:25:44 +0000 (UTC) Cc: pgsql-general@postgresql.org Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Sat Oct 07 12:25:32 2006 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by ciao.gmane.org with esmtp (Exim 4.43) id 1GW9Mu-000343-PK for geh-help-gnu-emacs@m.gmane.org; Sat, 07 Oct 2006 12:25:21 +0200 Original-Received: from localhost ([127.0.0.1] helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1GW9Mu-0002zr-6h for geh-help-gnu-emacs@m.gmane.org; Sat, 07 Oct 2006 06:25:20 -0400 Original-Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1GW9Mg-0002x2-0u for help-gnu-emacs@gnu.org; Sat, 07 Oct 2006 06:25:06 -0400 Original-Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1GW9Mf-0002vn-Dp for help-gnu-emacs@gnu.org; Sat, 07 Oct 2006 06:25:05 -0400 Original-Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1GW9Mf-0002va-Bq for help-gnu-emacs@gnu.org; Sat, 07 Oct 2006 06:25:05 -0400 Original-Received: from [80.91.229.2] (helo=ciao.gmane.org) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA:32) (Exim 4.52) id 1GW9Tk-0001bw-D5 for help-gnu-emacs@gnu.org; Sat, 07 Oct 2006 06:32:24 -0400 Original-Received: from root by ciao.gmane.org with local (Exim 4.43) id 1GW9Mc-00030s-53 for help-gnu-emacs@gnu.org; Sat, 07 Oct 2006 12:25:02 +0200 Original-Received: from cm-84.209.8.188.chello.no ([84.209.8.188]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 07 Oct 2006 12:25:02 +0200 Original-Received: from msteffen by cm-84.209.8.188.chello.no with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 07 Oct 2006 12:25:02 +0200 X-Injected-Via-Gmane: http://gmane.org/ Original-To: help-gnu-emacs@gnu.org Original-Lines: 60 Original-X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: cm-84.209.8.188.chello.no User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.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:37876 gmane.comp.db.postgresql.general:77764 Archived-At: Hi, I recently stumbled over the following problem, recently because the setup worked fine for some years, only that when I changed recently to a new linux distribution (from Suse 10 to the latest Fedora core), things broke. The set-up is as follows: I got a postgres data base running on a linux machine (the data base works ok, it seems, as I can connect to it using the psql ``user interface'' to interact with it). I want to connect, however, via emacs, in particular, I used to use the package pg.el (Version: 0.10, 2002, it seems) for it. Now, part of the proper use of it is establishing the connection with the data base, which is done by: (setq myconnection (pg:connect "data-base-name" "user-name") ) Now: this connection does no longer work, i.e., I'm refused access, giving back the following verdict appended below the end of the article. Does anybody know how to repair that? I'm not sure where the problem lies (as said, the set-up worked with the same version of pg.el and basically the same emacs version before). There seem two possible sources: - either emacs/pg does no longer transmit my name properly (I remember I had problems with encodings some time ago) - or postgres applies tougher access restrictions on the new linux distribution, and therefore rejects me What is strange, however, is that I can access the running data base as "user-name" using the command-line tool psql just fine, without being rejected. Thanks, Martin signal(error ("Backend error: FATAL: Ident authentication failed for user \"user-name\"\n")) error("Backend error: %s" "FATAL: Ident authentication failed for user \"msteffen\"\n") byte-code("..... process connection pg:SM_USER pg:SM_OPTIONS pg:SM_UNUSED generate-new-buffer " *PostgreSQL*" nil open-network-stream "postgres" fboundp set-buffer-process-coding-system binary set-buffer-multibyte vector cl-struct-pgcon 1 pg:send-int 4 2 pg:send accept-process-output 0 error "pgcon-process accessing a non-pgcon" pg:read-char 69 "Backend error: %s" pg:read-string 4096 82 pg:read-net-int pg:initialize-parsers pg:exec "SET datestyle = 'ISO'" throw --cl-block-pg:connect-- 5 "Crypt authentication not supported" "Kerberos4 authentication not supported" "Kerberos5 authentication not supported" "Can't do that type of authentication: %s" "Problem connecting: expected an authentication response" pg:SM_TTY user-packet-length host port pg:StartupPacketSize pg:PG_PROTOCOL_63_MAJOR ...] 7)