From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: owner@emacsbugs.donarmstrong.com (Emacs bug Tracking System) Newsgroups: gmane.emacs.bugs Subject: bug#2313: marked as done (23.0.90; sql-sqlite: --password, --user, --server won't work with sqlite) Date: Sat, 14 Feb 2009 03:45:06 +0000 Message-ID: References: <200902122228.n1CMS8vN003708@zogzog.maillard.mobi> NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="----------=_1234583106-16230-2" X-Trace: ger.gmane.org 1234584282 17250 80.91.229.12 (14 Feb 2009 04:04:42 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Sat, 14 Feb 2009 04:04:42 +0000 (UTC) To: Glenn Morris Original-X-From: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane.org@gnu.org Sat Feb 14 05:05:55 2009 Return-path: Envelope-to: geb-bug-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by lo.gmane.org with esmtp (Exim 4.50) id 1LYBmH-0001IW-Mb for geb-bug-gnu-emacs@m.gmane.org; Sat, 14 Feb 2009 05:05:41 +0100 Original-Received: from localhost ([127.0.0.1]:46595 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LYBkx-0008Ed-QS for geb-bug-gnu-emacs@m.gmane.org; Fri, 13 Feb 2009 23:03:55 -0500 Original-Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1LYBko-00088e-JD for bug-gnu-emacs@gnu.org; Fri, 13 Feb 2009 23:03:46 -0500 Original-Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1LYBkn-00087Y-8z for bug-gnu-emacs@gnu.org; Fri, 13 Feb 2009 23:03:45 -0500 Original-Received: from [199.232.76.173] (port=39332 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LYBkn-00087D-2b for bug-gnu-emacs@gnu.org; Fri, 13 Feb 2009 23:03:45 -0500 Original-Received: from rzlab.ucr.edu ([138.23.92.77]:52961) by monty-python.gnu.org with esmtps (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1LYBke-0002PY-BN; Fri, 13 Feb 2009 23:03:36 -0500 Original-Received: from rzlab.ucr.edu (rzlab.ucr.edu [127.0.0.1]) by rzlab.ucr.edu (8.13.8/8.13.8/Debian-3) with ESMTP id n1E43YOp021580; Fri, 13 Feb 2009 20:03:34 -0800 Original-Received: (from debbugs@localhost) by rzlab.ucr.edu (8.13.8/8.13.8/Submit) id n1E3j6gN016428; Fri, 13 Feb 2009 19:45:06 -0800 X-Mailer: MIME-tools 5.420 (Entity 5.420) X-Loop: owner@emacsbugs.donarmstrong.com X-Emacs-PR-Message: closed 2313 X-Emacs-PR-Package: emacs X-detected-operating-system: by monty-python.gnu.org: GNU/Linux 2.6 (newer, 3) X-BeenThere: bug-gnu-emacs@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: "Bug reports for GNU Emacs, the Swiss army knife of text editors" List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane.org@gnu.org Errors-To: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.bugs:25304 Archived-At: This is a multi-part message in MIME format... ------------=_1234583106-16230-2 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Your message dated Fri, 13 Feb 2009 22:38:20 -0500 with message-id and subject line Re: 23.0.60; [PATCH] sql-sqlite doesn't work has caused the Emacs bug report #1904, regarding 23.0.90; sql-sqlite: --password, --user, --server won't work with= sqlite to be marked as done. This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact owner@emacsbugs.donarmstrong.com immediately.) --=20 1904: http://emacsbugs.donarmstrong.com/cgi-bin/bugreport.cgi?bug=3D1904 Emacs Bug Tracking System Contact owner@emacsbugs.donarmstrong.com with problems ------------=_1234583106-16230-2 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit Received: (at submit) by emacsbugs.donarmstrong.com; 12 Feb 2009 22:24:46 +0000 X-Spam-Checker-Version: SpamAssassin 3.2.5-bugs.debian.org_2005_01_02 (2008-06-10) on rzlab.ucr.edu X-Spam-Level: X-Spam-Bayes: score:0.5 Bayes not run. spammytokens:Tokens not available. hammytokens:Tokens not available. X-Spam-Status: No, score=0.1 required=4.0 tests=FOURLA,MURPHY_DRUGS_REL8 autolearn=no version=3.2.5-bugs.debian.org_2005_01_02 Received: from fencepost.gnu.org (fencepost.gnu.org [140.186.70.10]) by rzlab.ucr.edu (8.13.8/8.13.8/Debian-3) with ESMTP id n1CMOgg9004351 for ; Thu, 12 Feb 2009 14:24:43 -0800 Received: from mail.gnu.org ([199.232.76.166]:44122 helo=mx10.gnu.org) by fencepost.gnu.org with esmtp (Exim 4.67) (envelope-from ) id 1LXjxC-000490-1I for emacs-pretest-bug@gnu.org; Thu, 12 Feb 2009 17:22:42 -0500 Received: from Debian-exim by monty-python.gnu.org with spam-scanned (Exim 4.60) (envelope-from ) id 1LXjz4-00070r-PV for emacs-pretest-bug@gnu.org; Thu, 12 Feb 2009 17:24:41 -0500 Received: from ded1.conovae.com ([88.191.52.166]:46305 helo=mf1.conovae.net) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1LXjz4-00070c-58 for emacs-pretest-bug@gnu.org; Thu, 12 Feb 2009 17:24:38 -0500 Received: by mf1.conovae.net (Postfix, from userid 10) id A29452613F7; Thu, 12 Feb 2009 23:24:06 +0100 (CET) Received: from zogzog.maillard.mobi (IDENT:1000@localhost [127.0.0.1]) by zogzog.maillard.mobi (8.14.3/8.13.8) with ESMTP id n1CMS9MY003709 for ; Thu, 12 Feb 2009 23:28:09 +0100 Received: (from xma@localhost) by zogzog.maillard.mobi (8.14.3/8.13.8/Submit) id n1CMS8vN003708; Thu, 12 Feb 2009 23:28:08 +0100 Date: Thu, 12 Feb 2009 23:28:08 +0100 Message-Id: <200902122228.n1CMS8vN003708@zogzog.maillard.mobi> X-Authentication-Warning: zogzog.maillard.mobi: xma set sender to xma@gnu.org using -f From: Xavier Maillard To: emacs-pretest-bug@gnu.org Subject: 23.0.90; sql-sqlite: --password, --user, --server won't work with sqlite Organization: GNU's Not UNIX! User-Agent: Rmail in GNU Emacs 23.0.90.1 on GNU/Linux Jabber-ID: xma01@jabber.fr Reply-to: Xavier Maillard X-UUCPssh-Information: Please contact the ISP for more information X-UUCPssh: Found to be clean X-UUCPssh-SpamCheck: not spam, SpamAssassin (not cached, score=-4.245, required 6, ALL_TRUSTED -1.80, BAYES_00 -2.60, TW_GZ 0.08, TW_OG 0.08) X-UUCPssh-From: xma@gnu.org X-detected-operating-system: by monty-python.gnu.org: GNU/Linux 2.6 (newer, 3) when calling sql-sqlite, it asks for a user, a password, a host to connect to a database. Problem is sqlite3 (dunno for other sqlite versions) will refuse to do anything with these parameters and just dies. Here is the output of sqlite3 -help on my machine (slackware GNU/linux): Usage: sqlite3 [OPTIONS] FILENAME [SQL] FILENAME is the name of an SQLite database. A new database is created if the file does not previously exist. OPTIONS include: -init filename read/process named file -echo print commands before execution -[no]header turn headers on or off -bail stop after hitting an error -interactive force interactive I/O -batch force batch I/O -column set output mode to 'column' -csv set output mode to 'csv' -html set output mode to HTML -line set output mode to 'line' -list set output mode to 'list' -separator 'x' set output field separator (|) -nullvalue 'text' set text string for NULL values -version show SQLite version I guess this patch would be enough: *** /tmp/sql.el.orig 2009-02-12 23:22:31.000000000 +0100 --- /tmp/sql.el 2009-02-12 23:23:30.000000000 +0100 *************** *** 356,362 **** :sqli-prompt-length 0) (sqlite :font-lock sql-mode-sqlite-font-lock-keywords ! :sqli-login (user password server database) :sqli-connect sql-connect-sqlite :sqli-prompt-regexp "^sqlite> " :sqli-prompt-length 8) --- 356,362 ---- :sqli-prompt-length 0) (sqlite :font-lock sql-mode-sqlite-font-lock-keywords ! :sqli-login (database) :sqli-connect sql-connect-sqlite :sqli-prompt-regexp "^sqlite> " :sqli-prompt-length 8) *************** *** 2611,2622 **** (let ((params)) (if (not (string= "" sql-database)) (setq params (append (list sql-database) params))) - (if (not (string= "" sql-server)) - (setq params (append (list (concat "--host=" sql-server)) params))) - (if (not (string= "" sql-password)) - (setq params (append (list (concat "--password=" sql-password)) params))) - (if (not (string= "" sql-user)) - (setq params (append (list (concat "--user=" sql-user)) params))) (if (not (null sql-sqlite-options)) (setq params (append sql-sqlite-options params))) (set-buffer (apply 'make-comint "SQL" sql-sqlite-program --- 2611,2616 ---- and the mandatory ChangeLog entry: 2009-02-12 Xavier Maillard * sql.el (sql-connect-sqlite, sql-product-alist): user, password and server are irrelevant for sqlite, remove them. Hope that'll help In GNU Emacs 23.0.90.1 (i686-pc-linux-gnu, GTK+ Version 2.12.12) of 2009-02-10 on zogzog Windowing system distributor `The X.Org Foundation', version 11.0.10402000 configured using `configure '--without-xft'' Important settings: value of $LC_ALL: nil value of $LC_COLLATE: en_US.UTF-8 value of $LC_CTYPE: fr_FR.UTF-8 value of $LC_MESSAGES: en_US.UTF-8 value of $LC_MONETARY: fr_FR.UTF-8 value of $LC_NUMERIC: en_US.UTF-8 value of $LC_TIME: en_US.UTF-8 value of $LANG: en_US.UTF-8 value of $XMODIFIERS: nil locale-coding-system: utf-8-unix default-enable-multibyte-characters: t Major mode: Fundamental Minor modes in effect: t: t rcirc-track-minor-mode: t eev-mode: t shell-dirtrack-mode: t jabber-activity-mode: t auto-insert-mode: t global-hi-lock-mode: t hi-lock-mode: t show-paren-mode: t global-auto-revert-mode: t display-time-mode: t recentf-mode: t icomplete-mode: t desktop-save-mode: t auto-image-file-mode: t tooltip-mode: t mouse-wheel-mode: t menu-bar-mode: t file-name-shadow-mode: t global-font-lock-mode: t font-lock-mode: t global-auto-composition-mode: t auto-encryption-mode: t auto-compression-mode: t column-number-mode: t transient-mark-mode: t abbrev-mode: t Recent input: P . S . P . C-e : SPC f e e l SPC f r e e SPC t o SPC d i s t r i b u t e SPC t h i s SPC m e s s a g e SPC t o SPC t h e SPC * r i g h t * SPC e e v SPC l i s t SPC i f SPC a p p l i c a b l e . R e g a r d s , C-SPC C-w SPC SPC C-e " C-a C-c C-c M-x m y - s e n d M-x e m a c s - b u r e b u g r e p o r Recent messages: Wrote /home/xma/var/queue/out-1 Sending...done Sending out-1... Sending... Added to /home/xma/mail/OUT-SENT Sending...done Sending out-1...done All sent or no message to send. Making completion list... Killing buffer *Completions* Xavier -- http://www.gnu.org http://www.april.org http://www.lolica.org ------------=_1234583106-16230-2 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit Received: (at 1904-done) by emacsbugs.donarmstrong.com; 14 Feb 2009 03:40:25 +0000 X-Spam-Checker-Version: SpamAssassin 3.2.5-bugs.debian.org_2005_01_02 (2008-06-10) on rzlab.ucr.edu X-Spam-Level: X-Spam-Bayes: score:0.5 Bayes not run. spammytokens:Tokens not available. hammytokens:Tokens not available. X-Spam-Status: No, score=-3.0 required=4.0 tests=MURPHY_DRUGS_REL8, X_DEBBUGS_NO_ACK autolearn=ham version=3.2.5-bugs.debian.org_2005_01_02 Received: from fencepost.gnu.org (fencepost.gnu.org [140.186.70.10]) by rzlab.ucr.edu (8.13.8/8.13.8/Debian-3) with ESMTP id n1E3eMCM015900 for <1904-done@emacsbugs.donarmstrong.com>; Fri, 13 Feb 2009 19:40:23 -0800 Received: from rgm by fencepost.gnu.org with local (Exim 4.67) (envelope-from ) id 1LYBMC-0000fA-M4; Fri, 13 Feb 2009 22:38:20 -0500 From: Glenn Morris To: 1904-done@emacsbugs.donarmstrong.com Subject: Re: 23.0.60; [PATCH] sql-sqlite doesn't work References: <8763kgoe8f.fsf@cyd.mit.edu> X-Spook: quarter kilo class Blowfish nitrate War on Terrorism X-Ran: 5AH";65AdAwAR@5f!KBAxj?H+_O&BFw User-Agent: Gnus (www.gnus.org), GNU Emacs (www.gnu.org/software/emacs/) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Installed, given that it looks fine and two people have come up with the same solution. (Bugs 1904, 2313). ------------=_1234583106-16230-2--