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 +L4WFA1kf2EY1QAAgWs5BA (envelope-from ) for ; Mon, 01 Nov 2021 04:50:37 +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 WK3bDw1kf2E/NQAA1q6Kng (envelope-from ) for ; Mon, 01 Nov 2021 03:50:37 +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 8F2F734DB4 for ; Mon, 1 Nov 2021 04:50:36 +0100 (CET) Received: from localhost ([::1]:56436 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mhOLC-0001M6-Tf for larch@yhetil.org; Sun, 31 Oct 2021 23:50:34 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:39688) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mhOKq-0001Ly-4a for emacs-orgmode@gnu.org; Sun, 31 Oct 2021 23:50:12 -0400 Received: from mail-pf1-x436.google.com ([2607:f8b0:4864:20::436]:43557) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1mhOKo-0004gX-Dy for emacs-orgmode@gnu.org; Sun, 31 Oct 2021 23:50:11 -0400 Received: by mail-pf1-x436.google.com with SMTP id o14so1706649pfu.10 for ; Sun, 31 Oct 2021 20:50:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=references:user-agent:from:to:subject:date:in-reply-to:message-id :mime-version; bh=Pkbligu+7Ci/rJsoVDbZoWrdmYd4wCMoFRHHoDWqCEg=; b=XWPMTUYdQ2GLbGQHtBlE73V2vV4ZIK2iW807ExALUEjqwAI+Au2jK83OqKGU6juhkt /5g7L2K8ODAyv2QOzfptP7SYfuTFpKQXZ/z9ttfdNNsrHzshXo8szRmwvMGnY2jOhT9W 18jSdIBG+HMElW3695bTVVbZMxrSnwYoijMbmgn5OrBgqL2gELskd4Lncrm3UcgWBBKQ g0HoPLPtav7ABKPRnOXWLYDBQLP6L1MobN5oZspVP5NFn6U6mYmyPQCL7JE9QJij+MHw PwmjatwEMd+cyMWWQm75Kvl9rR/mtG8V5qWhabBWWITGYS8+IqnGRsHQ6gHbmNdQ3ww7 jLVg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:references:user-agent:from:to:subject:date :in-reply-to:message-id:mime-version; bh=Pkbligu+7Ci/rJsoVDbZoWrdmYd4wCMoFRHHoDWqCEg=; b=b/15B0hjmC1QScETSb7h2kXVXKKiD1fs3JHlUjWy2VHv7n+DYyq1vtGgKFnAgq+ql4 PkDBa6wbBrSxAmxWolcl0zucGkZnDSLzODUydaLKWc1aSBv4/kdb8LNRqRxY/a0UE9wD K8yZCoorugmXXKAfxACU6BbMJgQ97oaWKIrceHfGPOpqsaqfAn7RK1uczV8NZmCO08nL 7VSoLpfzgpHJdK2HByXhpGMyBEA7l3KcBfPa/Kt7L9HPB46DGPj303WBkOTHX8OcEWHS 8b6htKYvF5hgo3vO/lJuZSSjz4zz+o9nmakuO4ycl1IhEML+TG/OEkqsEdIKsfPBY/Gu RnTA== X-Gm-Message-State: AOAM532o7WewmaFu10424jLcfETVl8DYqSAfqNrEVrqGxYAll4AR9Zib DBtfdMNStuogto67cW0LCCdnkQDrLPs= X-Google-Smtp-Source: ABdhPJzg5JfIrAGIQuWOzkA6jpFG+J1OlUF2T7pKsvKIcLOFjbrMFhay6ZRKK8Mo2t+aaAimJV+aZg== X-Received: by 2002:a63:7247:: with SMTP id c7mr20002460pgn.365.1635738608446; Sun, 31 Oct 2021 20:50:08 -0700 (PDT) Received: from dingbat (2001-44b8-31f2-bb00-27b4-e52b-0762-d22e.static.ipv6.internode.on.net. [2001:44b8:31f2:bb00:27b4:e52b:762:d22e]) by smtp.gmail.com with ESMTPSA id ls14sm2478913pjb.49.2021.10.31.20.50.07 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 31 Oct 2021 20:50:08 -0700 (PDT) References: User-agent: mu4e 1.7.4; emacs 28.0.60 From: Tim Cross To: emacs-orgmode@gnu.org Subject: Re: Storing database credentials outside an org file Date: Mon, 01 Nov 2021 14:33:12 +1100 In-reply-to: Message-ID: <87sfwg4jrr.fsf@gmail.com> MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=2607:f8b0:4864:20::436; envelope-from=theophilusx@gmail.com; helo=mail-pf1-x436.google.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, 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: , 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=1635738637; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=Pkbligu+7Ci/rJsoVDbZoWrdmYd4wCMoFRHHoDWqCEg=; b=JGkv5N7jkUaWI7yIpNNWJs7yHQoZUv3ntmsK73JZv2NOLRXLpVp2uGYeDWhnOUUWgiWodY 3ki4QuyFSFBN8wIKtLKFZDddAhxVVMU5bMsWHRyQxK3diin0w1qiqXxyQ1J2U5jeVu9foB vVgDwRP4SeUlq+QWJEXrAfGHJ9zpTidmndnaoK54bEhLRA6tvRUYUyybaFUZIG6zhLYZZ3 8kuKOPrGTUjKsjrXM25qg9VkQ83ERra3JuBMXxekQqyfwaUVDLaHKYPWH5dJeWggInXJf2 i596ELJmpb7fIp4xy1VrSdqXKqYs+wihzBpJ6wfafIGpc6E7jbgkcPO8Krgq+w== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1635738637; a=rsa-sha256; cv=none; b=V2r3OD3BsYbrc0pUsc7c6+sW1on/fM9rA4EeoZvcyp+rkIIjZ31NN3vtnnbAG4WwR0JT8t jQsEz6AFGxwa39gB82qtkuNEj3+0fB0hFfxR1UAp5RzBjKBGOHi8JCNBqW8jGAPcXhd+KD 7LlIbkwYh8gU7/Vhgao+SLYyIqcJ0cHBLnPc3m9ZoQ483RSofMV+CuBx2boAX9B+TwXv6V VYG0R26op/CtO0uynOaZ/mB00WfVBRvO5lxFILbWibl0tOZSiaPWgs3qBkTL3Hf+V/re0P 3p+J5BGbvPT97uKNT4qlgtfRt57DIsmmV1laHql9baHh+HuGazMFloXLjoyCZA== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=XWPMTUYd; 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.25 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=XWPMTUYd; 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: 8F2F734DB4 X-Spam-Score: -2.25 X-Migadu-Scanner: scn0.migadu.com X-TUID: 8xSmuogwaBXc Mike Gauland writes: > I often use an org file to record database queries, using sql source blocks. > 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 file for > security reasons. > > Any ideas on how I could make this work? 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.