From xma@gnu.org Thu Feb 12 14:24:46 2009 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 From rgm@gnu.org Thu Feb 12 14:34:13 2009 Received: (at control) by emacsbugs.donarmstrong.com; 12 Feb 2009 22:34:13 +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=-2.0 required=4.0 tests=VALID_BTS_CONTROL 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 n1CMYApq006768 for ; Thu, 12 Feb 2009 14:34:12 -0800 Received: from rgm by fencepost.gnu.org with local (Exim 4.67) (envelope-from ) id 1LXk6M-0004W1-St; Thu, 12 Feb 2009 17:32:11 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <18836.41834.798554.599838@fencepost.gnu.org> Date: Thu, 12 Feb 2009 17:32:10 -0500 From: Glenn Morris To: control Subject: control message tags 2271 moreinfo reassign 2309 emacs,w32 merge 1904 2313 reassign 2310 spam reassign 2311 spam reassign 2312 spam From unknown Mon Aug 18 02:31:26 2025 Received: (at fakecontrol) by fakecontrolmessage; To: internal_control@debbugs.gnu.org From: $requester Subject: Internal Control Message-Id: bug archived. Date: Sat, 14 Mar 2009 14:24:09 +0000 User-Agent: Fakemail v42.6.9 # A New Hope # A log time ago, in a galaxy far, far away # something happened. # # Magically this resulted in the following # action being taken, but this fake control # message doesn't tell you why it happened # # The action: # bug archived. thanks # This fakemail brought to you by your local debbugs # administrator