From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Robert Newsgroups: gmane.emacs.help Subject: Re: sql and auth-source Date: Fri, 27 Nov 2020 06:52:13 +0000 Message-ID: References: Reply-To: Robert Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="13662"; mail-complaints-to="usenet@ciao.gmane.io" Cc: "help-gnu-emacs@gnu.org" To: Jean Louis Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane-mx.org@gnu.org Fri Nov 27 07:53:01 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 1kiXcp-0003Sg-Vv for geh-help-gnu-emacs@m.gmane-mx.org; Fri, 27 Nov 2020 07:52:59 +0100 Original-Received: from localhost ([::1]:36102 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kiXcp-00014N-0m for geh-help-gnu-emacs@m.gmane-mx.org; Fri, 27 Nov 2020 01:52:59 -0500 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]:48564) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kiXcM-00012V-CP for help-gnu-emacs@gnu.org; Fri, 27 Nov 2020 01:52:30 -0500 Original-Received: from mail-02.mail-europe.com ([51.89.119.103]:43206) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kiXcJ-0006hQ-SU for help-gnu-emacs@gnu.org; Fri, 27 Nov 2020 01:52:30 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=protonmail.com; s=protonmail; t=1606459942; bh=8qTGpv3xD9kIchIJf6nXyuY8QUGWROkMeTiAOn4GdTc=; h=Date:To:From:Cc:Reply-To:Subject:In-Reply-To:References:From; b=pBKrjP349MARwN7YlML9SYjxD5DiNdfNTlOrbOieQ0j9EsHQ8O68+WhhtEeP8Z/9A +Wc+56b9D0chy85TiZQOn4+982DJiOHJDthe3zj8eVmcKUj5fWI7wIONctkO1aHiVz m0E8cI7IYCK3qRLHCvwn4xgELoJ1hWepqU0ADBtk= In-Reply-To: Received-SPF: pass client-ip=51.89.119.103; envelope-from=rchar@protonmail.com; helo=mail-02.mail-europe.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, SPF_HELO_NONE=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:125636 Archived-At: The ideal solution will include: - no passwords in init.el - I connect to the database using sql-connect or sql-postgres (usually Post= greSQL) - when connecting, I choose an alias to the database - I am only asked to enter a password in order to decrypt the authinfo wall= et file -- Robert Sent from ProtonMail, encrypted email based in Switzerland. =E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90 Original Me= ssage =E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90 On Friday, November 27, 2020 2:58 AM, Jean Louis wrote: > * Robert via Users list for the GNU Emacs text editor help-gnu-emacs@gnu.= org [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=3D"databasename" > export PGUSER=3D'username' > export PGCLIENTENCODING=3D'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