From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Jean Louis Newsgroups: gmane.emacs.help Subject: Re: sql and auth-source Date: Fri, 27 Nov 2020 04:58:56 +0300 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="6627"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Mutt/2.0 (3d08634) (2020-11-07) Cc: "help-gnu-emacs@gnu.org" To: Robert Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane-mx.org@gnu.org Fri Nov 27 03:03:38 2020 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane-mx.org Original-Received: from lists.gnu.org ([209.51.188.17]) by ciao.gmane.io with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kiT6n-0001bV-P7 for geh-help-gnu-emacs@m.gmane-mx.org; Fri, 27 Nov 2020 03:03:37 +0100 Original-Received: from localhost ([::1]:37276 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kiT6m-0002o5-Qo for geh-help-gnu-emacs@m.gmane-mx.org; Thu, 26 Nov 2020 21:03:36 -0500 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]:49640) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kiT6A-0002nj-QN for help-gnu-emacs@gnu.org; Thu, 26 Nov 2020 21:02:58 -0500 Original-Received: from static.rcdrun.com ([95.85.24.50]:35851) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kiT68-0001Be-UX for help-gnu-emacs@gnu.org; Thu, 26 Nov 2020 21:02:58 -0500 Original-Received: from localhost ([::ffff:41.202.241.56]) (AUTH: PLAIN admin, TLS: TLS1.2,256bits,ECDHE_RSA_AES_256_GCM_SHA384) by static.rcdrun.com with ESMTPSA id 00000000002C000B.000000005FC05E4E.000027C1; Fri, 27 Nov 2020 02:02:53 +0000 Content-Disposition: inline In-Reply-To: Received-SPF: pass client-ip=95.85.24.50; envelope-from=bugs@gnu.support; helo=static.rcdrun.com X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane-mx.org@gnu.org Original-Sender: "help-gnu-emacs" Xref: news.gmane.io gmane.emacs.help:125606 Archived-At: * Robert via Users list for the GNU Emacs text editor [2020-11-26 18:20]: > Hello, > > how to configure the sql mode to work with a wallet file? > A code example would be very helpful. > > I found function sql-auth-source-search-wallet, but i don't know how to use it. > https://git.savannah.gnu.org/cgit/emacs.git/tree/lisp/progmodes/sql.el#n736 What you configure is .authinfo then how I understand, the sql-mode would search for user/password and server datails in .authinfo by using that function. Unless you are programming you need not use that function. And function is prefixed sql- only because it belongs to sql mode, not that it is doing any SQL itself. I have not configured authinfo as I mostly work with local database. Instead I have configured environment variables: export PGDATABASE="databasename" export PGUSER='username' export PGCLIENTENCODING='UTF8' You better say what you wish to achieve, do you wish to remember credentials for remote databases? File ~/.authinfo is in format: host localhost port port-number user user-ID password password