From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id oFKwB6y6ll+RMQAA0tVLHw (envelope-from ) for ; Mon, 26 Oct 2020 12:01:48 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0 with LMTPS id QGB1A6y6ll9CYQAA1q6Kng (envelope-from ) for ; Mon, 26 Oct 2020 12:01:48 +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 71E0F9403A0 for ; Mon, 26 Oct 2020 12:01:47 +0000 (UTC) Received: from localhost ([::1]:58654 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kX1C6-0007F9-Dl for larch@yhetil.org; Mon, 26 Oct 2020 08:01:46 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:40034) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kX1Ag-0007An-Q3 for Emacs-orgmode@gnu.org; Mon, 26 Oct 2020 08:00:18 -0400 Received: from mout.perfora.net ([74.208.4.196]:55937) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kX1Ad-0001MC-79 for Emacs-orgmode@gnu.org; Mon, 26 Oct 2020 08:00:18 -0400 Received: from [192.168.24.2] ([69.142.220.70]) by mrelay.perfora.net (mreueus004 [74.208.5.2]) with ESMTPSA (Nemesis) id 1MpE2t-1k2qpP2Uox-00qixL for ; Mon, 26 Oct 2020 13:00:12 +0100 From: Neil Cherry Subject: Re: ob-sql posgresql windows problems To: Org Mode References: <8ca746ff-f406-939f-59a0-2cd1f0dbecc3@linuxha.com> <87r1pnn94y.fsf@bzg.fr> Message-ID: Date: Mon, 26 Oct 2020 08:00:10 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.3.1 MIME-Version: 1.0 In-Reply-To: <87r1pnn94y.fsf@bzg.fr> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:Xrr89cEf7ofE3pSZliakykjMXuAtR1M8PtiL7eAITTvZ/K5gEsf VUhs/pEFbcKPHxfhm8dIDjRPHl39r5GIEPrGfPi7vkiRDKTI/EenCFLQkK1FbCYARtTHWTs 7pDSGshwVwUOLr3kRf2/NlzpkfEa5DgbE7qPl1TY1ihkRhqclYY+HAuqqUSxDp8EaXSog1e JuESUFWkZfu0emCyBWNPg== X-UI-Out-Filterresults: notjunk:1;V03:K0:3uPoqNcX3bA=:JIiA1rxJB+9xPOpFslEG+v d7cfFk6jwj46beFYzlbwWI0xMIPqCmDTK1dCES+X017k+ox+DzQdeyyeagNdI8daNWv7NHVmH ejp34C7okdJuJxNMzllrZNKnZ6aaiZzaPBhseeyvTYxGF64B8wjqReSRiWNMCdmAqyD2wyZbI vXlE7uuNcludpbLB5pZuXa71frLxsBcn++xs7G4JJ8kiDtzdmu5Qr7i2a9l6JvqMxcFQNTYRg MRj7IpcD6HqtoHy5k8KoRFiIbbMwX8Fe1xDyYWV+lOzREpmfWOtixbo4DSfGCwfLZOY1OWqE7 NYz+P1U6ansv4bqCe0OfgO0YQEhZwa7WrQej8U3YmeDNjQcu9dcgvjcwEwDpX5KzwjkkAGOyh J2V54pPt9Ls0mHqmMQRySJZSCsKDAho7FsSBgH+Kuc6xM3kgu2N1mG2wF98AYAU5e2Dz6XJql +JpoH1hqgg== Received-SPF: pass client-ip=74.208.4.196; envelope-from=ncherry@linuxha.com; helo=mout.perfora.net X-detected-operating-system: by eggs.gnu.org: First seen = 2020/10/26 08:00:12 X-ACL-Warn: Detected OS = Linux 2.2.x-3.x [generic] X-Spam_score_int: -40 X-Spam_score: -4.1 X-Spam_bar: ---- X-Spam_report: (-4.1 / 5.0 requ) BAYES_00=-1.9, NICE_REPLY_A=-2.167, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_PASS=-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.23 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-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; 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-Spam-Score: -1.01 X-TUID: zaE25ZhsUQm2 On 10/24/20 7:41 AM, Bastien wrote: > Hi Neil, > > Neil Cherry writes: > >> I'm on a Windows 10 System, I'm using ob-sql.el and when I C-c C-c >> on the src block I get: > > What version of Org are you using? M-x org-version RET > > Thanks, > Org mode version 9.1.9 (release_9.1.9-65-g5e4542 @ c:/Users/NC1951/Documents/emacs-26.1/share/emacs/26.1/lisp/org/) I did fix the issue by adding an if clause for Windows NT. It was caused by the PGPASSORD being used before the command when it shouldn't have been there. I have Postgres password file setup for the machine I want to access. Since the change it's been working very well. I think you're going to suggest that I upgrade my Windows machine to the latest. I'll need to find that command after I backup my machine. -- Linux Home Automation Neil Cherry ncherry@linuxha.com http://www.linuxha.com/ Main site http://linuxha.blogspot.com/ My HA Blog Author of: Linux Smart Homes For Dummies