From unknown Sun Jun 22 00:24:16 2025 X-Loop: help-debbugs@gnu.org Subject: bug#23242: [PATCH] ob-sql.el: set PGPASSWORD environment Resent-From: Andreas Gerler Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Fri, 08 Apr 2016 15:23:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 23242 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: patch To: 23242@debbugs.gnu.org Cc: Andreas Gerler X-Debbugs-Original-To: bug-gnu-emacs@gnu.org Received: via spool by submit@debbugs.gnu.org id=B.146012896919735 (code B ref -1); Fri, 08 Apr 2016 15:23:02 +0000 Received: (at submit) by debbugs.gnu.org; 8 Apr 2016 15:22:49 +0000 Received: from localhost ([127.0.0.1]:54721 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1aoYFF-00058F-2a for submit@debbugs.gnu.org; Fri, 08 Apr 2016 11:22:49 -0400 Received: from eggs.gnu.org ([208.118.235.92]:59213) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1aoUFD-0005oq-M6 for submit@debbugs.gnu.org; Fri, 08 Apr 2016 07:06:31 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1aoUF7-0000ew-Pr for submit@debbugs.gnu.org; Fri, 08 Apr 2016 07:06:26 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00 autolearn=disabled version=3.3.2 Received: from lists.gnu.org ([2001:4830:134:3::11]:49104) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1aoUF7-0000es-Mr for submit@debbugs.gnu.org; Fri, 08 Apr 2016 07:06:25 -0400 Received: from eggs.gnu.org ([2001:4830:134:3::10]:50177) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1aoUF6-00062u-Ob for bug-gnu-emacs@gnu.org; Fri, 08 Apr 2016 07:06:25 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1aoUF3-0000eN-I0 for bug-gnu-emacs@gnu.org; Fri, 08 Apr 2016 07:06:24 -0400 Received: from mail.bundesbrandschatzamt.de ([2a01:4f8:d13:18e::2]:45915) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1aoUF1-0000dy-JP for bug-gnu-emacs@gnu.org; Fri, 08 Apr 2016 07:06:21 -0400 Received: from marvin.bundesbrandschatzamt.de (ip1f121680.dynamic.kabel-deutschland.de [31.18.22.128]) (authenticated bits=0) by mail.bundesbrandschatzamt.de (8.13.8/8.13.8) with ESMTP id u38AOPKW025723 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 8 Apr 2016 10:24:35 GMT Received: from marvin.bundesbrandschatzamt.de (localhost [127.0.0.1]) by marvin.bundesbrandschatzamt.de (8.14.4/8.14.4) with ESMTP id u38AOOSD004463; Fri, 8 Apr 2016 10:24:24 GMT Received: (from baron@localhost) by marvin.bundesbrandschatzamt.de (8.14.4/8.14.4/Submit) id u38AOOZD004462; Fri, 8 Apr 2016 10:24:24 GMT From: Andreas Gerler Date: Fri, 8 Apr 2016 10:24:22 +0000 Message-Id: <1460111062-4420-1-git-send-email-baron@bundesbrandschatzamt.de> X-Mailer: git-send-email 2.4.5 X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x X-Received-From: 2001:4830:134:3::11 X-Spam-Score: -5.0 (-----) X-Mailman-Approved-At: Fri, 08 Apr 2016 11:22:47 -0400 X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -5.0 (-----) * postgresql: set environment variable PGPASSWORD if dbpassword was supplied --- lisp/ob-sql.el | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/lisp/ob-sql.el b/lisp/ob-sql.el index 6488afe..bd3a51e 100644 --- a/lisp/ob-sql.el +++ b/lisp/ob-sql.el @@ -141,8 +141,9 @@ This function is called by `org-babel-execute-src-block'." (org-babel-process-file-name in-file) (org-babel-process-file-name out-file))) (`postgresql (format - "psql --set=\"ON_ERROR_STOP=1\" %s -A -P \ + "%s psql --set=\"ON_ERROR_STOP=1\" %s -A -P \ footer=off -F \"\t\" %s -f %s -o %s %s" + (if dbpassword (concat "PGPASSWORD='" dbpassword "'") "") (if colnames-p "" "-t") (org-babel-sql-dbstring-postgresql dbhost dbuser database) -- 2.4.5 From unknown Sun Jun 22 00:24:16 2025 X-Loop: help-debbugs@gnu.org Subject: bug#23242: [PATCH] ob-sql.el: set PGPASSWORD environment Resent-From: Andreas Schwab Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Fri, 08 Apr 2016 15:47:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 23242 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: patch To: Andreas Gerler Cc: 23242@debbugs.gnu.org Received: via spool by 23242-submit@debbugs.gnu.org id=B23242.146013036332578 (code B ref 23242); Fri, 08 Apr 2016 15:47:02 +0000 Received: (at 23242) by debbugs.gnu.org; 8 Apr 2016 15:46:03 +0000 Received: from localhost ([127.0.0.1]:54765 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1aoYbj-0008TD-2h for submit@debbugs.gnu.org; Fri, 08 Apr 2016 11:46:03 -0400 Received: from mail-out.m-online.net ([212.18.0.9]:57622) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1aoYbg-0008Pp-PM for 23242@debbugs.gnu.org; Fri, 08 Apr 2016 11:46:01 -0400 Received: from frontend01.mail.m-online.net (unknown [192.168.8.182]) by mail-out.m-online.net (Postfix) with ESMTP id 3qhP1z4WS5z3hj06; Fri, 8 Apr 2016 17:45:59 +0200 (CEST) Received: from localhost (dynscan1.mnet-online.de [192.168.6.68]) by mail.m-online.net (Postfix) with ESMTP id 3qhP1z467kzvPsq; Fri, 8 Apr 2016 17:45:59 +0200 (CEST) X-Virus-Scanned: amavisd-new at mnet-online.de Received: from mail.mnet-online.de ([192.168.8.182]) by localhost (dynscan1.mail.m-online.net [192.168.6.68]) (amavisd-new, port 10024) with ESMTP id wwcHa9arhvYt; Fri, 8 Apr 2016 17:45:58 +0200 (CEST) X-Auth-Info: ph9N+26sLVeRTmwxiXSdZ0i5u//EhI7gy4X8vce8zYzWZG9Ar1LJ2QY4JC8/c7pw Received: from igel.home (ppp-88-217-23-82.dynamic.mnet-online.de [88.217.23.82]) by mail.mnet-online.de (Postfix) with ESMTPA; Fri, 8 Apr 2016 17:45:58 +0200 (CEST) Received: by igel.home (Postfix, from userid 1000) id 697282C31CC; Fri, 8 Apr 2016 17:45:58 +0200 (CEST) From: Andreas Schwab References: <1460111062-4420-1-git-send-email-baron@bundesbrandschatzamt.de> X-Yow: WHOA!! Ken and Barbie are having TOO MUCH FUN!! It must be the NEGATIVE IONS!! Date: Fri, 08 Apr 2016 17:45:58 +0200 In-Reply-To: <1460111062-4420-1-git-send-email-baron@bundesbrandschatzamt.de> (Andreas Gerler's message of "Fri, 8 Apr 2016 10:24:22 +0000") Message-ID: <87vb3s14uh.fsf@linux-m68k.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.0.92 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain X-Spam-Score: -0.7 (/) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -0.7 (/) Andreas Gerler writes: > (`postgresql (format > - "psql --set=\"ON_ERROR_STOP=1\" %s -A -P \ > + "%s psql --set=\"ON_ERROR_STOP=1\" %s -A -P \ > footer=off -F \"\t\" %s -f %s -o %s %s" > + (if dbpassword (concat "PGPASSWORD='" dbpassword "'") "") This will fail if dbpassword contains ?\'. Environment variables should be passed via process-environment. Andreas. -- Andreas Schwab, schwab@linux-m68k.org GPG Key fingerprint = 58CA 54C7 6D53 942B 1756 01D3 44D5 214B 8276 4ED5 "And now for something completely different." From unknown Sun Jun 22 00:24:16 2025 X-Loop: help-debbugs@gnu.org Subject: bug#23242: [PATCH] ob-sql.el: set PGPASSWORD environment Resent-From: npostavs@users.sourceforge.net Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Wed, 14 Jun 2017 23:57:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 23242 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: patch To: Andreas Gerler Cc: 23242@debbugs.gnu.org Received: via spool by 23242-submit@debbugs.gnu.org id=B23242.14974845672782 (code B ref 23242); Wed, 14 Jun 2017 23:57:02 +0000 Received: (at 23242) by debbugs.gnu.org; 14 Jun 2017 23:56:07 +0000 Received: from localhost ([127.0.0.1]:48118 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dLI8t-0000ij-Dx for submit@debbugs.gnu.org; Wed, 14 Jun 2017 19:56:07 -0400 Received: from mail-it0-f51.google.com ([209.85.214.51]:35584) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dLI8r-0000iC-MQ; Wed, 14 Jun 2017 19:56:06 -0400 Received: by mail-it0-f51.google.com with SMTP id m62so9241598itc.0; Wed, 14 Jun 2017 16:56:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=sender:from:to:cc:subject:references:date:in-reply-to:message-id :user-agent:mime-version; bh=mDBm7jfHGOVa37huSrZLFbEOfuDDvn86gWikyzUjKCE=; b=mXIIUEpA1Lk050Fm5n4xM+uEGF127WAEaFece+HFHxd3YqkATydK5GnWgxK+U+/FDx XUcv+j11H7LyxI9uKbesm0yJASr6+AlSbi2UNHgHW/c6jtWXGjRpx7K5D8yxusYD84lH GD65XDrv2XD6wLlCQFwDt+n8SdIeBwgHuj7ujpYZ0wJ1NnEUXVUWzyRUHkf5Hv9DE32q cyLnD+W8RdWp9MLqDcb8Fau9qME/PHz32JZCHehZJa3U+ZZ73wJTWUbq1gL0ksen7nnP mV+P9UrVcWo5M94A6OCQWnzVTEzJIH1I7XjNafua4gYuXuZGXFdPCYpVL4CLW2Hxsxt9 O0hQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:sender:from:to:cc:subject:references:date :in-reply-to:message-id:user-agent:mime-version; bh=mDBm7jfHGOVa37huSrZLFbEOfuDDvn86gWikyzUjKCE=; b=OixG23tLAzrBLG20goCvs4zs6mO+NO1XycTfSJTTZRQvFY9pKvmAHZbfSBkgqJ5ctW P9iSZLIxb428yNB2eqOMV7W/K58hHUK1yIiJQOKAtz8MCEcMJdNcRDZ8FHAih/Wo28Xn 3lKgRu8P5/VSi7TUKi1S7gl8EJmgLVineFJl+f0+NTyToxEYbUxu60xLph4lH82VX+ce N6uitcQG60P1SLUst9mUESDoxBP8SW6RipX5fDwWYwc/Jkj8dAl1P9egr1IuYxGjA4su vHCvG1lF/Ku5zf9sebMPsPF/dTtDy04OizyCk8OL5NAwCVQ001DU33EiNcYHwIFc7KXJ RwZw== X-Gm-Message-State: AKS2vOw2A82NapISsnsmApf/axvxb3g/6bm6Do1l/TaJP9evHsTM2/Vl nUsNdvIukzN2bifV X-Received: by 10.36.76.142 with SMTP id a136mr2747183itb.105.1497484560095; Wed, 14 Jun 2017 16:56:00 -0700 (PDT) Received: from zony ([45.2.7.65]) by smtp.googlemail.com with ESMTPSA id e12sm404512itd.0.2017.06.14.16.55.59 (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256); Wed, 14 Jun 2017 16:55:59 -0700 (PDT) From: npostavs@users.sourceforge.net References: <1460111062-4420-1-git-send-email-baron@bundesbrandschatzamt.de> Date: Wed, 14 Jun 2017 19:57:37 -0400 In-Reply-To: <1460111062-4420-1-git-send-email-baron@bundesbrandschatzamt.de> (Andreas Gerler's message of "Fri, 8 Apr 2016 10:24:22 +0000") Message-ID: <8760fyt95a.fsf@users.sourceforge.net> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.2.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain X-Spam-Score: -0.0 (/) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -0.0 (/) severity 23242 minor close 23242 quit Andreas Gerler writes: > * postgresql: set environment variable PGPASSWORD if dbpassword was supplied This has been implemented in the org-mode repository. 2016-09-17 08:34:59 (GMT) ob-sql: Add dbport and dbpassword options to postgresql * lisp/ob-sql.el (org-babel-sql-dbstring-postgresql): Add port parameter. (org-babel-execute:sql): Handle password and port in `postgresql' SQL engine. http://orgmode.org/cgit.cgi/org-mode.git/commit/?id=c257e31d10128f0c6705cee9586e9fc436ddfc28