From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0 ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id IPddEmyBf2G9DwEAgWs5BA (envelope-from ) for ; Mon, 01 Nov 2021 06:55:56 +0100 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0 with LMTPS id eKseDmyBf2GgBwAA1q6Kng (envelope-from ) for ; Mon, 01 Nov 2021 05:55:56 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id AB29436756 for ; Mon, 1 Nov 2021 06:55:55 +0100 (CET) Received: from localhost ([::1]:55076 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mhQIT-0002FL-PW for larch@yhetil.org; Mon, 01 Nov 2021 01:55:53 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:38512) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mhQHg-0002Es-Bf for emacs-orgmode@gnu.org; Mon, 01 Nov 2021 01:55:04 -0400 Received: from mail-il1-x133.google.com ([2607:f8b0:4864:20::133]:45748) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1mhQHe-0007dh-QY for emacs-orgmode@gnu.org; Mon, 01 Nov 2021 01:55:04 -0400 Received: by mail-il1-x133.google.com with SMTP id i12so11133473ila.12 for ; Sun, 31 Oct 2021 22:55:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:from:mime-version:subject:date:message-id :references:cc:in-reply-to:to; bh=+BHgRYGEmbIWfEITD1LdSSZA5HsNt10oL0H3939j+mo=; b=c1Mm0taACcMnC0Fs7aXeaZ66YBZ68lFLC8ADCHz7HntRLf0TZXXMaDvKoZS6dU8pgy +PLoc0BDzCSixd/h84mfyPnZaaLFu5MrojmaxjJcHk3R1T8hiCOMdt5Jq8cWzKqn4H2c xWjsp1qkXREwkJctYOYzTs8VM7vmBjWoIv9ShgC05A+3SKBYf1Ga3Fj0jv6gbZ5yd1fw nX3iH1KHPLfLziUsorSH0+dJDrXgNtXu58YF7kQsJiTGgzMcLsDHCkuW4rZAUS8qIfwp g4WiUnTBbC1Jkf94/A4vEv/YPFIP3zW4Njz3aQ9XtI2PDZnQ89FRJ+47BH4Jh+HizBvw hbwA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:content-transfer-encoding:from:mime-version :subject:date:message-id:references:cc:in-reply-to:to; bh=+BHgRYGEmbIWfEITD1LdSSZA5HsNt10oL0H3939j+mo=; b=hMt2qCM3NqUaSn7uJLGefy4bs9bmOqdPGif17FuSQLX5llyG078ZDUpzND6VUjD81H 1qW6BdVemS0QbjeYUA88BzEuj5IIoAginI9s/7QoSbRIvsx8XVbM0tn4FkavSeEc4dQ7 rMsSMvZDxaryQBBSCseDXfUc/umEbKq5xnAKUcag2fRSse8zdXKRfAHRvZG16AmN1fUM 9SqsAV5rDRUwvFR5yFshlg/5+QKobKQhJR+Pm6WYmmGx8IGDmEri6GdH326BtPjICd6t 9QN/86cWVinrlaDyyg+CmUl63LGH0Qp7iu6OQOFqFN2RAPpNO4Yf3Pm7bqroWGyeu6CG ZYAg== X-Gm-Message-State: AOAM530fW8DuSMTI07PfJDKoIklZiG9Autp5d54tf2qsKFzOmM8HAJKD gKE7ALOWBMAynoKe2GhTWx/TRnRA+A8= X-Google-Smtp-Source: ABdhPJz6K2DaCdOmFYxUWS8TR2eC1abgjTaxeWraygzIr/V3V4nMs9PvTatQj/pbbDLX3e3kGKAUYw== X-Received: by 2002:a05:6e02:2165:: with SMTP id s5mr17953361ilv.32.1635746101018; Sun, 31 Oct 2021 22:55:01 -0700 (PDT) Received: from smtpclient.apple ([2601:681:5500:dde0:c5f4:36da:7821:c0aa]) by smtp.gmail.com with ESMTPSA id a12sm7295296ilb.66.2021.10.31.22.55.00 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 31 Oct 2021 22:55:00 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: Rob Sargent Mime-Version: 1.0 (1.0) Subject: Re: Storing database credentials outside an org file Date: Sun, 31 Oct 2021 23:54:59 -0600 Message-Id: <2F165227-30A8-4D55-92C5-982A35F16F29@gmail.com> References: <87sfwg4jrr.fsf@gmail.com> In-Reply-To: <87sfwg4jrr.fsf@gmail.com> To: Tim Cross X-Mailer: iPhone Mail (18H17) Received-SPF: pass client-ip=2607:f8b0:4864:20::133; envelope-from=robjsargent@gmail.com; helo=mail-il1-x133.google.com X-Spam_score_int: -1 X-Spam_score: -0.2 X-Spam_bar: / X-Spam_report: (-0.2 / 5.0 requ) BAYES_20=-0.001, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: emacs-orgmode@gnu.org Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1635746155; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post:dkim-signature; bh=+BHgRYGEmbIWfEITD1LdSSZA5HsNt10oL0H3939j+mo=; b=RrQ9HpcVYq0BCfmCI1n5nzKa9dSpQ7fVhCleO9gR0i7IkLmToaUQjgvsaQYeUfRmGI74nJ /DrbtpEKtcPZ98xI12btlECj910CbSSKtklkK/ggzbWmff7qo0hnH6lGjTwLKTGZDFXI1g GrjRiv3Oqc80kCZXCAvJ597yv37gy2up1oTF1K1qnAKXMVuIAbMxmbAyCTTvwHpcRE7uwK Ib3paolRir969cEDcq4NhgVV7uZulAS/knmdoUED8FlQb0EidzgvydBWQa9msyXb4Y6A3J 0ItTjuUUVdch10rl7PCKLtBbNYSaEKxlW7ukDKjvYPmQR1+zVp9qplqe7ASrWA== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1635746155; a=rsa-sha256; cv=none; b=A4XB8YP7uisd1q/oi84komW/CJsxPkMpHEs/fSKz/EWZe7F3Y9eegL/8zPVoo2qg0JexzB t3JxZ4NgeVdG324WKebjN41D9v0bOMWKnjIVcjY4DJAN6WUy5pfU5CRIG49+xBrXlBhPtk 3m6vF+op/B/XNHiokxbcbiaZb+VQEQV5LRC431RkktuR2lXxkaphk6MyFsnaHtbOt/3cbb dDYbu+7RjI5rjk/sc9eKp9jUqW/sPbEGpKsOirkei2yAmIWAspRkQPnc27xaKV1R+T6/Ev EyizbYhu9Jg9XEQVS9mZKq01jmNzO+NCbinjlULU2XStGYiaaBB9nZGG8PppVQ== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=c1Mm0taA; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Spam-Score: -2.61 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=c1Mm0taA; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Queue-Id: AB29436756 X-Spam-Score: -2.61 X-Migadu-Scanner: scn0.migadu.com X-TUID: QXgckyxwnowz Most servers have a plain text file (permissions 004) that let you add name = and pass and db > On Oct 31, 2021, at 9:51 PM, Tim Cross wrote: >=20 > =EF=BB=BF > Mike Gauland writes: >=20 >> I often use an org file to record database queries, using sql source bloc= ks. >> I've been putting the database credentials in the file using header-args:= sql >> properties, but I'd prefer to have the credentials saved in a separate fi= le for >> security reasons. >>=20 >> Any ideas on how I could make this work? >=20 > It probably wouldn't be too hard to use the authinfo.gpg facility via > the auth-source library which is included in Emacs. In fact, I think > sql-mode might already have support for this built in. >=20