From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1.migadu.com ([2001:41d0:1008:1e59::1]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms1.migadu.com with LMTPS id cOAJLYRBYmbMkQAAA41jLg (envelope-from ) for ; Fri, 07 Jun 2024 01:08:52 +0200 Received: from aspmx1.migadu.com ([2001:41d0:403:4876::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1.migadu.com with LMTPS id yIftJoRBYmZXaQEA62LTzQ (envelope-from ) for ; Fri, 07 Jun 2024 01:08:52 +0200 X-Envelope-To: larch@yhetil.org Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=hotmail.com header.s=selector1 header.b=irquvoup; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; dmarc=pass (policy=none) header.from=hotmail.com; arc=pass ("microsoft.com:s=arcselector9901:i=1") ARC-Message-Signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1717715332; 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:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=Iu05AP8CjWMVwFOwFS/WBx4rro+sK1b06/f6ZABuymM=; b=MQHWoRCx+LWhDisrMzRRemOCO6ve1zm9S0wvuSvCUNm03yLLtqTNDHqxny/3mFwMJRZa4W NqtsSNY2QsidsD+fvJvc1lFWYDB0ByToBA7Jq0lvQBB27dIPLo1C4TcsiAVcA7hujMS6x0 Wh0mkWmEVQbnaqjgEuPSOJI8ez/yHyEpA/GdkYQ2QfL0lNGCMW1W1V7jcQpvAHhdg92dYU fm9mFWem1LqUxx2BD6hqPcN/jrTQ9skko/5hSqMwEN18VkgElm87doMa/GHm3CUgxIrPhp ta5WEwzwzEsGuQhiUY8OXhvsfWsBDcjAw8nGrXco3tVHRuL9oRsp5OkpmpLGfw== ARC-Authentication-Results: i=2; aspmx1.migadu.com; dkim=pass header.d=hotmail.com header.s=selector1 header.b=irquvoup; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; dmarc=pass (policy=none) header.from=hotmail.com; arc=pass ("microsoft.com:s=arcselector9901:i=1") ARC-Seal: i=2; s=key1; d=yhetil.org; t=1717715332; a=rsa-sha256; cv=pass; b=eQKSoPKLc/5wYpRJ0rALEpxE6wZOLa6NTVC0fpHx3CaRttqiN0hShYwYYZ+TdGI/n4eI8V 84IppUv1fnlZjSyjvwR+NdYEK/3ddpAT5cZCD6yE0u9d+IgtuPs0qdDB7kNgeZJrONea45 43lyHboHp5e3CZ45PFzVRfBfF0wu8wYiVw+L6G+4pAm+Eryd35/Qb1LmMCzOXlg5fnG0Jx o7zqB/8pnKAFwT5Y7LaCpF4RI3myMritIx40BnvtmDZbUrr1mDbN/NZR1UrU0Fl2ORe7b/ fahN2YFys7BMHkaYbPlbMOUVpbpeV0YIhYkRuT5Mq1vaDxR3bAFApYL9oya44A== 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 3C72B6F642 for ; Fri, 7 Jun 2024 01:08:52 +0200 (CEST) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1sFMCx-0006kP-Cc; Thu, 06 Jun 2024 19:07:47 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1sFMCv-0006je-Q3 for emacs-orgmode@gnu.org; Thu, 06 Jun 2024 19:07:45 -0400 Received: from mail-vi1eur03olkn2036.outbound.protection.outlook.com ([40.92.57.36] helo=EUR03-VI1-obe.outbound.protection.outlook.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1sFMCt-0000Qx-2g for emacs-orgmode@gnu.org; Thu, 06 Jun 2024 19:07:45 -0400 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=IYqH2Xq4Vc+Rjp2SS6tfIuvOMWWGI4UPzUQe2KsabxJhPRnZXMtk3ChW75vTxfEfLnxlCj2sWasCx8Lu/9b2+ytO0OBxnKIse63ep52cQFQQbmZbPQnTd3IzRC5P97mxJhvTWNCMN4ZFwEoH5xIi1HqQtnqpI7+13jEOcfCmPEX6X5L65JT3herh5sZc2/lbkKAS9JRPMRw6YqAY1YZ0CTd9Fsb172ZOe9SSXl9tHTGpSl/jSa1v6U/YSBNrOi79VVd+WezZ1vApD2m/+OXhWKqk01LcaI1BAoDRzUIPY4XYXmvrVkp4XphtWBu9MNRvGz7A2B6OblYtxj1ncsBqJg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=Iu05AP8CjWMVwFOwFS/WBx4rro+sK1b06/f6ZABuymM=; b=INOwPF26Asp8d2iy90ZZ6cNGJ7yM3YHTfWGlcqbiUYVtp6h520nLzeO3hQp47M2LD3U/AZjoq8LDlY10ng2Oq1BYDnQydA8Az4KDlYdjb72brAX0pViHrKvwCgWcr0dWn4ig9X5Tn2GuKLKmUSmpYltjcOB8BKSicPCxN1tkRaHsPSGV5k/PCn1LwVs2b9N6ZlbBvar+/sf4cDqLYaWMH1PdAgMGSug6XQmb4DFRQdDZC844nXhWAI6z1ohjJ9rIhE0mGE8LWo4LfiA3kfFpeipyHIMeak7IvrbetREHe5O+xnF43JB8nOzbpX7obpDbapec0BC9KN+cPCcLmsi0Ag== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=Iu05AP8CjWMVwFOwFS/WBx4rro+sK1b06/f6ZABuymM=; b=irquvoupY8Qy6YUE3jbOvaz/ziZmL3pf9piXewQj9H7lyOdFvZ9uCrQjO7+ujdq5peFwVKDix6UjRIPibLBr78Uq24fNFLGbSmvlmyAIzzeUWixNY0L8iSeDxJTcqpn8I7vR5tdVriaTY3lV897OzOcEsAfG3oZzTafL/2cYy9looCAmWIG8OErmKPv7s3sF7K2Y2ieMu2BKWOg9xn9FJtmHewvZ4MF6vkr2kkQVVIVmxqFbtfxvtZKuB6a2CmwgooEeSbDoZG4/0lvccQPpKMIJ9fcFT9yjCDcwUU81/OQC0D7Kd1eUlRnb5GlAVqYP/7z/j8NCL74nolFIyt/RsQ== Received: from DU2P193MB2422.EURP193.PROD.OUTLOOK.COM (2603:10a6:10:2fa::15) by VI1P193MB0623.EURP193.PROD.OUTLOOK.COM (2603:10a6:800:159::7) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7633.33; Thu, 6 Jun 2024 23:02:34 +0000 Received: from DU2P193MB2422.EURP193.PROD.OUTLOOK.COM ([fe80::7b29:997e:c9e6:12c]) by DU2P193MB2422.EURP193.PROD.OUTLOOK.COM ([fe80::7b29:997e:c9e6:12c%7]) with mapi id 15.20.7633.033; Thu, 6 Jun 2024 23:02:29 +0000 User-agent: mu4e 1.6.10; emacs 29.3 From: Andrea To: emacs-orgmode@gnu.org Subject: [BUG] ob-sql should escape the password [9.7.3 (9.7.3-2f1844 @ /home/andrea/.emacs.d/elpa/org-9.7.3/)] Date: Thu, 06 Jun 2024 23:58:51 +0100 Message-ID: Content-Type: text/plain X-TMN: [vtYNx4I52Fznx9WezfNcgLB/9P6EhV9yRmytyHXHdhA/Qvk0wwVdOkvRFhUEVbSy] X-ClientProxiedBy: LO4P265CA0044.GBRP265.PROD.OUTLOOK.COM (2603:10a6:600:2ac::23) To DU2P193MB2422.EURP193.PROD.OUTLOOK.COM (2603:10a6:10:2fa::15) X-Microsoft-Original-Message-ID: <877cf1vfnf.fsf@hotmail.com> MIME-Version: 1.0 X-MS-Exchange-MessageSentRepresentingType: 1 X-MS-PublicTrafficType: Email X-MS-TrafficTypeDiagnostic: DU2P193MB2422:EE_|VI1P193MB0623:EE_ X-MS-Office365-Filtering-Correlation-Id: 68460f14-91da-43fb-6cc6-08dc867cbd21 X-Microsoft-Antispam: BCL:0;ARA:14566002|461199019|440099019|3412199016; X-Microsoft-Antispam-Message-Info: ce3shdAN5WMOzyxFNXjWUS0YUMlkJZCvS+UiWG9+sQjt97XGburXguR71JHS5ZbyKk+M/DEeQccO86J6W+lFb9O6cxqMZavOvMZ1TFY9CvPxR2u3yfLbJ4isZxFcH7FZZzlrHzcBOmVQKL+DvbisuYcsq8cMF/55NbF59M738TmMjOlKh/zZjKxaFXgd2aE2XuXZ83yQLNQOmkPRo9oxhXfvdqiKW8XMH3ibPQnzy2cshX9crSlnzZ3ZlJsWn0LFNI4HTseVWOJytS7uI9j/Jl6tchO/+JqqN6coqR6a8X6xgxGBjsdc0pm/op/iRFhlMPhV3C6KVwIou6OBcZhvofjwdk0YbbArh9IqfcKQXwBwXhSpjtJjO8HM2sPVeVFFl3T+LP0zHdmxSmoGbKf/Cfp0U743zhrQHiCnAGjWhCQlW0njUKlTBihwunaOr5kAkFbij4g5KuUfxf2J0GN1K0c+AWPvKamkzcbNDFiIBcYBg5BfxY/ZL6kHAImDVYa0fbJNwVsazQmVwPSo9yRT5bHYicHbEf6U9aAR//a9Asye88KXEdpvOY0jkYtkfG2n X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?us-ascii?Q?BBFx52xhZlq0gKyQ15gpoc1SwDpiJEEXLLGgsRSE1upp7/PAZ/E4cyl5LitA?= =?us-ascii?Q?l5h3S4+nciKdrCVqa/dkB8JJZAJOhpg6pkNlAknEeIlWNgcuhVOtXZNNkd5z?= =?us-ascii?Q?YDp2kY78ExoFn/kBx2WEJ3DNfB5NSbWha8j1K16hKZhClmDhiPG4YDyGtBTX?= =?us-ascii?Q?4gWogohN06i0rGbKpzH3t4Vaa+rLR11JpvNbDxTFRcdaYJXTRuSaFvlSrdLN?= =?us-ascii?Q?92Tf5aUQ5eSmxSKfpv6rR/FN6FQntQj76UgLYEFIAledBv5wIEPkh4kcM5K/?= =?us-ascii?Q?HVwfzUz8osefI9ya+iNNiKxIagOoceVQh06SJDaQ4cVUA1blBXQ6SLh50hr7?= =?us-ascii?Q?nIkg+bwZ9r8VmvSmUVRqPOcBxsSLvR6J/GPvPgVtRWjfYT5n8+4DjLjbxeKG?= =?us-ascii?Q?Dx3y76VJoAN4Z8MTQbmcsxTDoVMD5avTpb+blwyqgSTfwUf9/Uv4uTR6xU1+?= =?us-ascii?Q?GLWr0dSlA3dyxesHxym6TskWehyUHCQyrN/P/t32LM9B5kxLpl3ROO0f4uey?= =?us-ascii?Q?JV61Xuk7nZnUTDZCKZEhrUUsPZ0hAGxmiJsjPdISeDF3PTOLWFJmVUeYFUQc?= =?us-ascii?Q?FDIIlnJ3FgHFQ9GVR1Us9/swzpxk7CTrUzQnx9fGpb0qj0iTf0N/LFH6Z5d5?= =?us-ascii?Q?+FKDaRprmBiGHgxik5vDF+Zi3D1zaonpZ8CE7xOWGGsfRnIjCfxmqzGKNmT1?= =?us-ascii?Q?3HjrPaA9WMPO3AXx1QtL20N+5QmP379erHmfnIgSJ6dZHKzYVj/nCYWUxYFx?= =?us-ascii?Q?viu/F/1KRPpVyqgo9e1ZY1QVQz6vTUISybVPjwJGdwWbNIm/GiizE9DtQA6t?= =?us-ascii?Q?NJQCPfpeoryJNLfLvdFLyLfvb73NT7oLZb3B06+IkdWdemVHL7+bnN3INWrV?= =?us-ascii?Q?xvBaqKwaCr+8WjmlS1Do7j9abkFAw9TQneuugV8+QQyRLhrEp0TRosVKyxpL?= =?us-ascii?Q?CgzqIlvbov906F1GTC6UzoA/YiaNb4V2MUL+sF+xWDxOOgpAXq+atfEDqWUj?= =?us-ascii?Q?WxA2cz9gohZAWoQ5ijK3HtZNd1mwibfMfdezM7rpvdRJBBeDaEMVkbAXdEMP?= =?us-ascii?Q?F1knIjomDsGi0xQtChjTvRpjTir4uKcB+EE+tG3KulEJZ/62hWDiiXuNE05J?= =?us-ascii?Q?Ip6hRB5UcyyzLoYcdtb9BTWMPc4hCURm9s9EN/3EZ2NwZnDSkbB/JzWTduXK?= =?us-ascii?Q?Y5p8rgerKaJvDb5CXNn4rCGSZqB2UbUENQdviMeWOx1QooHV2PiKgtfbd/Bg?= =?us-ascii?Q?4heGuRbPQeuIIAaUG7IpD3YknjSBib0dFWFNBckMEWKYNMDQ9KE52eX73VWn?= =?us-ascii?Q?vz+ohJRuz7MRHkJLHakdGAIo?= X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-80ceb.templateTenant X-MS-Exchange-CrossTenant-Network-Message-Id: 68460f14-91da-43fb-6cc6-08dc867cbd21 X-MS-Exchange-CrossTenant-AuthSource: DU2P193MB2422.EURP193.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 06 Jun 2024 23:02:28.9078 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-CrossTenant-Id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: VI1P193MB0623 Received-SPF: pass client-ip=40.92.57.36; envelope-from=andrea-dev@hotmail.com; helo=EUR03-VI1-obe.outbound.protection.outlook.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_MSPIKE_H2=-0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01 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-bounces+larch=yhetil.org@gnu.org X-Migadu-Country: US X-Migadu-Flow: FLOW_IN X-Spam-Score: -10.49 X-Migadu-Queue-Id: 3C72B6F642 X-Migadu-Scanner: mx10.migadu.com X-Migadu-Spam-Score: -10.49 X-TUID: MAAjgOYeHLOa Hello there, thanks for Org Mode! ob-sql.el has a function org-babel-execute:sql. This function extracts the password to connect to your database of choice as dbpassword. It then uses it like this: (if dbpassword (format "PGPASSWORD=%s " dbpassword) "") If the password contains an & character, the execution of a block fails. I solved like this: (if dbpassword (format "PGPASSWORD='%s' " dbpassword) "") Hope this is of help, Andrea Emacs : GNU Emacs 29.3 (build 1, x86_64-pc-linux-gnu, GTK+ Version 3.24.33, cairo version 1.16.0) of 2024-03-26, modified by Debian Package: Org mode version 9.7.3 (9.7.3-2f1844 @ /home/andrea/.emacs.d/elpa/org-9.7.3/)