GNU bug report logs - #2313
23.0.90; sql-sqlite: --password, --user, --server won't work with sqlite

Previous Next

To add a comment to this bug, you must first unarchive it, by sending
a message to control AT debbugs.gnu.org, with unarchive 2313 in the body.
You can then email your comments to 2313 AT debbugs.gnu.org in the normal way.

Toggle the display of automated, internal messages from the tracker.

Message #5 received at submit <at> emacsbugs.donarmstrong.com (full text, mbox):

From: Xavier Maillard <xma <at> gnu.org>
To: emacs-pretest-bug <at> gnu.org
Subject: 23.0.90; sql-sqlite: --password, --user, --server won't work with sqlite
Date: Thu, 12 Feb 2009 23:28:08 +0100

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  <xma <at> gnu.org>

	* 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:
<down> <down> <down> <down> <down> <down> <down> <down> 
<down> <down> <down> <down> <down> <down> <down> <down> 
<down> <down> <down> <down> <down> <down> <down> <down> 
<down> <down> <down> <down> <down> <down> <down> <down> 
<down> <up> <return> <return> P . S . <left> <left> 
<left> <left> P . C-e <backspace> : 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 . <down> <down> <down> <down> <up> <up> <up> <up> 
<up> <up> <up> <up> <up> <up> <up> <up> <up> <up> <up> 
<up> <up> <up> <up> <up> <up> <down> <down> <down> 
<down> <down> <down> <down> <down> <down> <down> <down> 
<up> <return> R e g a r d s , <return> <up> <up> <up> 
<up> <up> <up> <up> <up> <up> <up> <up> <up> <up> <up> 
<up> <up> <up> <up> <up> <up> <up> <up> <up> <up> <up> 
<up> <up> <up> <up> <up> <up> <up> <up> <up> <up> <up> 
<up> <up> <up> <up> <up> <up> <up> <up> <up> <up> <up> 
<up> <up> <up> <up> <up> <up> <up> <up> <up> <up> <down> 
<down> C-SPC <right> C-w <backspace> SPC <backspace> 
<backspace> SPC <left> <left> <left> <left> C-e " <backspace> 
C-a <right> <right> <right> <right> <right> <backspace> 
C-c C-c M-x m y - s e n d <tab> <return> M-x e m a 
c s - b u <backspace> <backspace> r e <backspace> <backspace> 
<backspace> <backspace> <backspace> <backspace> <backspace> 
<backspace> b u g <backspace> <backspace> <backspace> 
r e p o <tab> r <tab> <return>

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

Previous Next

GNU bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997,2003 nCipher Corporation Ltd, 1994-97 Ian Jackson.