From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Xavier Maillard Newsgroups: gmane.emacs.bugs,gmane.emacs.pretest.bugs Subject: bug#2313: 23.0.90; sql-sqlite: --password, --user, --server won't work with sqlite Date: Thu, 12 Feb 2009 23:28:08 +0100 Organization: GNU's Not UNIX! Message-ID: <200902122228.n1CMS8vN003708@zogzog.maillard.mobi> Reply-To: Xavier Maillard , 2313@emacsbugs.donarmstrong.com NNTP-Posting-Host: lo.gmane.org X-Trace: ger.gmane.org 1234478672 10620 80.91.229.12 (12 Feb 2009 22:44:32 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Thu, 12 Feb 2009 22:44:32 +0000 (UTC) To: emacs-pretest-bug@gnu.org Original-X-From: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane.org@gnu.org Thu Feb 12 23:45:46 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 1LXkJL-00045k-MC for geb-bug-gnu-emacs@m.gmane.org; Thu, 12 Feb 2009 23:45:36 +0100 Original-Received: from localhost ([127.0.0.1]:58674 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LXkI1-00006z-RB for geb-bug-gnu-emacs@m.gmane.org; Thu, 12 Feb 2009 17:44:13 -0500 Original-Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1LXkHR-0008Hx-Qv for bug-gnu-emacs@gnu.org; Thu, 12 Feb 2009 17:43:37 -0500 Original-Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1LXkHQ-0008HA-Tc for bug-gnu-emacs@gnu.org; Thu, 12 Feb 2009 17:43:37 -0500 Original-Received: from [199.232.76.173] (port=57489 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LXkHQ-0008Gu-HS for bug-gnu-emacs@gnu.org; Thu, 12 Feb 2009 17:43:36 -0500 Original-Received: from rzlab.ucr.edu ([138.23.92.77]:51101) by monty-python.gnu.org with esmtps (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1LXkHP-0008Ht-RW for bug-gnu-emacs@gnu.org; Thu, 12 Feb 2009 17:43: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 n1CMhYpw009196; Thu, 12 Feb 2009 14:43:34 -0800 Original-Received: (from debbugs@localhost) by rzlab.ucr.edu (8.13.8/8.13.8/Submit) id n1CMU3ke005701; Thu, 12 Feb 2009 14:30:03 -0800 X-Loop: owner@emacsbugs.donarmstrong.com Resent-From: Xavier Maillard Resent-To: bug-submit-list@donarmstrong.com Resent-CC: Emacs Bugs Resent-Date: Thu, 12 Feb 2009 22:30:03 +0000 Resent-Message-ID: Resent-Sender: owner@emacsbugs.donarmstrong.com X-Emacs-PR-Message: report 2313 X-Emacs-PR-Package: emacs X-Emacs-PR-Keywords: Original-Received: via spool by submit@emacsbugs.donarmstrong.com id=B.12344774864358 (code B ref -1); Thu, 12 Feb 2009 22:30:03 +0000 Original-Received: (at submit) by emacsbugs.donarmstrong.com; 12 Feb 2009 22:24:46 +0000 X-Spam-Bayes: score:0.5 Bayes not run. spammytokens:Tokens not available. hammytokens:Tokens not available. Original-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 Original-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 Original-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 Original-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 Original-Received: by mf1.conovae.net (Postfix, from userid 10) id A29452613F7; Thu, 12 Feb 2009 23:24:06 +0100 (CET) Original-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 Original-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 X-Authentication-Warning: zogzog.maillard.mobi: xma set sender to xma@gnu.org using -f User-Agent: Rmail in GNU Emacs 23.0.90.1 on GNU/Linux Jabber-ID: xma01@jabber.fr 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) X-detected-operating-system: by monty-python.gnu.org: GNU/Linux 2.6 (newer, 3) Resent-Date: Thu, 12 Feb 2009 17:43:37 -0500 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:25256 gmane.emacs.pretest.bugs:23908 Archived-At: 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