From mboxrd@z Thu Jan 1 00:00:00 1970 From: Barbara Shirtcliff Subject: Bug: babel can't locate psql [8.2.10 (release_8.2.10 @ /Applications/Emacs.app/Contents/Resources/lisp/org/)] Date: Fri, 07 Oct 2016 09:53:35 -0700 Message-ID: Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:33577) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bsYPV-0002Ta-4j for emacs-orgmode@gnu.org; Fri, 07 Oct 2016 12:54:14 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1bsYPR-0006Za-3b for emacs-orgmode@gnu.org; Fri, 07 Oct 2016 12:54:13 -0400 Received: from mail-pf0-x22e.google.com ([2607:f8b0:400e:c00::22e]:35717) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bsYPQ-0006ZT-TO for emacs-orgmode@gnu.org; Fri, 07 Oct 2016 12:54:09 -0400 Received: by mail-pf0-x22e.google.com with SMTP id 128so7216342pfz.2 for ; Fri, 07 Oct 2016 09:54:08 -0700 (PDT) Received: from m007-pdx.local (c-76-115-187-62.hsd1.or.comcast.net. [76.115.187.62]) by smtp.gmail.com with ESMTPSA id c27sm15315988pfe.6.2016.10.07.09.54.06 for (version=TLS1 cipher=AES128-SHA bits=128/128); Fri, 07 Oct 2016 09:54:06 -0700 (PDT) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: "Emacs-orgmode" To: emacs-orgmode@gnu.org Remember to cover the basics, that is, what you expected to happen and what in fact did happen. You don't know how to make a good report? See http://orgmode.org/manual/Feedback.html#Feedback Your bug report will be posted to the Org-mode mailing list. ------------------------------------------------------------------------ Executing a block of psql produces the error: "/bin/bash: psql: command not found". Bash is able to find psql. So is M-: (executable-find "psql"). I have a brew-installed psql in the standard brew-installed location for my computer, at /usr/local/bin/psql. As far as I can tell, the location of psql is hard-coded into ob-sql.el and is not configurable. The command that ob-sql logs in the *Messages* buffer works in an emacs shell session. But that, of course, is not the point. Emacs : GNU Emacs 24.5.1 (x86_64-apple-darwin13.4.0, NS apple-appkit-1265.21) of 2015-04-10 on builder10-9.porkrind.org Package: Org-mode version 8.2.10 (release_8.2.10 @ /Applications/Emacs.app/Contents/Resources/lisp/org/) current state: ============== (setq org-tab-first-hook '(org-hide-block-toggle-maybe org-src-native-tab-command-maybe org-babel-hide-result-toggle-maybe org-babel-header-arg-expand) org-speed-command-hook '(org-speed-command-default-hook org-babel-speed-command-hook) org-occur-hook '(org-first-headline-recenter) org-metaup-hook '(org-babel-load-in-session-maybe) org-confirm-shell-link-function 'yes-or-no-p org-after-todo-state-change-hook '(org-clock-out-if-current) org-from-is-user-regexp "\\" org-src-mode-hook '(org-src-babel-configure-edit-buffer org-src-mode-configure-edit-buffer) org-agenda-before-write-hook '(org-agenda-add-entry-text) org-babel-pre-tangle-hook '(save-buffer) org-mode-hook '(#[nil "\300\301\302\303\304$\207" [org-add-hook change-major-mode-hook org-show-block-all append local] 5] #[nil "\300\301\302\303\304$\207" [org-add-hook change-major-mode-hook org-babel-show-result-all append local] 5] org-babel-result-hide-spec org-babel-hide-all-hashes) org-ctrl-c-ctrl-c-hook '(org-babel-hash-at-point org-babel-execute-safely-maybe) org-cycle-hook '(org-cycle-hide-archived-subtrees org-cycle-hide-drawers org-cycle-hide-inline-tasks org-cycle-show-empty-lines org-optimize-window-after-visibility-change) org-babel-tangle-lang-exts '(("python" . "py") ("emacs-lisp" . "el")) org-confirm-elisp-link-function 'yes-or-no-p org-metadown-hook '(org-babel-pop-to-session-maybe) org-babel-load-languages '((sql . t)) org-clock-out-hook '(org-clock-remove-empty-clock-drawer) )