From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Francis Devereux Newsgroups: gmane.emacs.bugs Subject: bug#11908: 24.1; "Unable to locate SQL program" when using sql-mysql with tramp and the client does not have the SQL program (but the server does) Date: Wed, 11 Jul 2012 12:33:27 +0100 Message-ID: <0C01659A-3017-4D3E-AE26-03DED52A29A7@devrx.org> NNTP-Posting-Host: plane.gmane.org Mime-Version: 1.0 (Apple Message framework v1278) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: dough.gmane.org 1342006496 27310 80.91.229.3 (11 Jul 2012 11:34:56 GMT) X-Complaints-To: usenet@dough.gmane.org NNTP-Posting-Date: Wed, 11 Jul 2012 11:34:56 +0000 (UTC) To: 11908@debbugs.gnu.org Original-X-From: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane.org@gnu.org Wed Jul 11 13:34:55 2012 Return-path: Envelope-to: geb-bug-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([208.118.235.17]) by plane.gmane.org with esmtp (Exim 4.69) (envelope-from ) id 1SovC0-0005pk-4c for geb-bug-gnu-emacs@m.gmane.org; Wed, 11 Jul 2012 13:34:52 +0200 Original-Received: from localhost ([::1]:34718 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1SovBz-0001OW-7w for geb-bug-gnu-emacs@m.gmane.org; Wed, 11 Jul 2012 07:34:51 -0400 Original-Received: from eggs.gnu.org ([208.118.235.92]:46523) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1SovBr-0001NE-IT for bug-gnu-emacs@gnu.org; Wed, 11 Jul 2012 07:34:49 -0400 Original-Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1SovBl-0005vc-10 for bug-gnu-emacs@gnu.org; Wed, 11 Jul 2012 07:34:43 -0400 Original-Received: from debbugs.gnu.org ([140.186.70.43]:51807) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1SovBk-0005vP-U8 for bug-gnu-emacs@gnu.org; Wed, 11 Jul 2012 07:34:36 -0400 Original-Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.72) (envelope-from ) id 1SovH0-0004vF-0t for bug-gnu-emacs@gnu.org; Wed, 11 Jul 2012 07:40:02 -0400 X-Loop: help-debbugs@gnu.org Resent-From: Francis Devereux Original-Sender: debbugs-submit-bounces@debbugs.gnu.org Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Wed, 11 Jul 2012 11:40:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 11908 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: X-Debbugs-Original-To: bug-gnu-emacs@gnu.org Original-Received: via spool by submit@debbugs.gnu.org id=B.134200676018863 (code B ref -1); Wed, 11 Jul 2012 11:40:01 +0000 Original-Received: (at submit) by debbugs.gnu.org; 11 Jul 2012 11:39:20 +0000 Original-Received: from localhost ([127.0.0.1]:33120 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.72) (envelope-from ) id 1SovGK-0004uA-Ap for submit@debbugs.gnu.org; Wed, 11 Jul 2012 07:39:20 -0400 Original-Received: from eggs.gnu.org ([208.118.235.92]:60941) by debbugs.gnu.org with esmtp (Exim 4.72) (envelope-from ) id 1SovGI-0004u3-4O for submit@debbugs.gnu.org; Wed, 11 Jul 2012 07:39:19 -0400 Original-Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1SovAu-0005lB-Ca for submit@debbugs.gnu.org; Wed, 11 Jul 2012 07:33:51 -0400 Original-Received: from lists.gnu.org ([208.118.235.17]:43402) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1SovAu-0005kv-9e for submit@debbugs.gnu.org; Wed, 11 Jul 2012 07:33:44 -0400 Original-Received: from eggs.gnu.org ([208.118.235.92]:46178) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1SovAp-0000sG-8z for bug-gnu-emacs@gnu.org; Wed, 11 Jul 2012 07:33:43 -0400 Original-Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1SovAh-0005gj-2p for bug-gnu-emacs@gnu.org; Wed, 11 Jul 2012 07:33:38 -0400 Original-Received: from moutng.kundenserver.de ([212.227.126.186]:51742) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1SovAg-0005c0-P6 for bug-gnu-emacs@gnu.org; Wed, 11 Jul 2012 07:33:31 -0400 Original-Received: from murr.brightoffice.local (no-dns-yet-88-98-41-121.zen.net.uk [88.98.41.121]) by mrelayeu.kundenserver.de (node=mreu2) with ESMTP (Nemesis) id 0MWOFC-1SIOlh3Iss-00XgqW; Wed, 11 Jul 2012 13:33:27 +0200 X-Mailer: Apple Mail (2.1278) X-Provags-ID: V02:K0:VUaHciGq6wi7pDSkM1J3TxfsCJ8RZOkhopY0C/lvsny Cj5njg7XoXfJTTdiJvxhaVVArAM0ZGVUl8Wvvk+NmRgIByZuea 8UjKeQU/Kgebe18uxU6UpD8fi1A//+aT3iKqwBhTfkMwfLj37C 6RRqDhHdEZViziIFdFAMsvpbGnUeHUk5HsBc1Vjf5d2jD2Q9nw +wojomRuSDyy26rnf47XKh3CWWNi6/ja+vRVevtSA4BGFd3DWf treNExvQv6gwoFaIa4b/xLMy/s2hrSfytUXEndMsaHAGF3xiWZ YoVejupUIKMdfMsa+VJSW1LhSeAIX3OtnRvkI3SlBxVMNwAH/g 2Du8FtF+nxECq2quaQmzLBDAFP2Bi9i2r0g8SouxdYeeZ1KWvG DW2o+69XcueNA== X-detected-operating-system: by eggs.gnu.org: Genre and OS details not recognized. X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6 (newer, 3) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.13 Precedence: list X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6 (newer, 2) X-Received-From: 140.186.70.43 X-BeenThere: bug-gnu-emacs@gnu.org List-Id: "Bug reports for GNU Emacs, the Swiss army knife of text editors" List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane.org@gnu.org Original-Sender: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.bugs:61815 Archived-At: Steps to reproduce: 1) Have a client machine (i.e. the machine running emacs) with no mysql executable on the PATH, and a server machine which does have mysql on the path. 2) C-x C-f /server: RETURN (to open a tramp dired buffer to the server) 3) M-x sql-mysql RETURN, and then fill in username/password/database, leave server blank 4) You get the message "Unable to locate SQL program 'mysql'" However, if you comment out the following lines in sql-comint in sql.el: ; (unless (executable-find program) ; (error "Unable to locate SQL program \'%s\'" program)) then it works - you get an SQLi buffer running mysql in an ssh session on the server. I'm running Emacs on OS X, server is running Debian GNU/Linux 6.0 (also happens with Red Hat servers). Can test with a GNU/Linux client if required. Francis In GNU Emacs 24.1.1 (x86_64-apple-darwin11.4.0, NS apple-appkit-1138.47) of 2012-06-10 on jupiter-wifi.repton.int Windowing system distributor `Apple', version 10.3.1138 Configured using: `configure '--with-ns'' Important settings: value of $LC_ALL: nil value of $LC_COLLATE: nil value of $LC_CTYPE: nil value of $LC_MESSAGES: nil value of $LC_MONETARY: nil value of $LC_NUMERIC: nil value of $LC_TIME: nil value of $LANG: en_GB.UTF-8 value of $XMODIFIERS: nil locale-coding-system: utf-8-unix default enable-multibyte-characters: t Major mode: Dired by date Minor modes in effect: shell-dirtrack-mode: t tooltip-mode: t mouse-wheel-mode: t tool-bar-mode: t menu-bar-mode: t file-name-shadow-mode: t global-font-lock-mode: t font-lock-mode: t blink-cursor-mode: t auto-composition-mode: t auto-encryption-mode: t auto-compression-mode: t line-number-mode: t transient-mark-mode: t Recent input: a s s e t b a n k _ M-x r e p o r t - e m Recent messages: Making completion list... Quit [3 times] Loading sql...done goto-history-element: Beginning of history; no preceding item Creating customization items... Creating customization items ...done Resetting customization items...done Creating customization setup...done Quit Login... sql-comint: Unable to locate SQL program 'mysql' Load-path shadows: None found. Features: (shadow sort mail-extr emacsbug message rfc822 mml mml-sec mm-decode mm-bodies mm-encode mail-parse rfc2231 mailabbrev gmm-utils mailheader sendmail rfc2047 rfc2045 ietf-drums mail-utils sql thingatpt cus-edit cus-start cus-load wid-edit help-mode easymenu view dired tramp-cache tramp-sh tramp tramp-compat auth-source eieio byte-opt bytecomp byte-compile cconv macroexp assoc gnus-util mm-util mail-prsvr password-cache shell pcomplete comint ansi-color ring format-spec advice help-fns advice-preload tramp-loaddefs regexp-opt time-date tooltip ediff-hook vc-hooks lisp-float-type mwheel ns-win tool-bar dnd fontset image fringe lisp-mode register page menu-bar rfn-eshadow timer select scroll-bar mouse jit-lock font-lock syntax facemenu font-core frame cham georgian utf-8-lang misc-lang vietnamese tibetan thai tai-viet lao korean japanese hebrew greek romanian slovak czech european ethiopic indian cyrillic chinese case-table epa-hook jka-cmpr-hook help simple abbrev minibuffer loaddefs button faces cus-face files text-properties overlay sha1 md5 base64 format env code-pages mule custom widget hashtable-print-readable backquote make-network-process ns multi-tty emacs)