bug#20288: 24.4; password management in sql-oracle

bug#20288: 24.4; password management in sql-oracle

[j-l.abraham]

=============================================
Following issue in "sql-oracle" appeared with Emacs 24.4.1 on Windows. No problems with 24.3.1 on Windows.
Once connected to oracle, while changing user with the "connect" command, the word "password" is missing and the password is displayed as clear text!

SQL> connect devel@xe<enter>
my_entered_password_is_clear_text!

expected behavior:
SQL> connect devel@xe<enter>
password displayed as dots in the echo area
=============================================



In GNU Emacs 24.4.1 (i686-pc-mingw32)
 of 2014-10-24 on LEG570
Windowing system distributor `Microsoft Corp.', version 6.1.7601
Configured using:
 `configure --prefix=/c/usr'

Important settings:
  value of $LANG: FRA
  locale-coding-system: cp1252

Major mode: Text

Minor modes in effect:
  show-paren-mode: t
  delete-selection-mode: t
  tooltip-mode: t
  electric-indent-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:
<left> <left> <left> <left> <left> <left> <left> <left> 
<left> <left> <left> <left> <left> <left> <left> <left> 
<left> <backspace> C-x C-s C-a C-k C-k C-y C-n C-n 
C-n C-n C-n C-n C-n C-n C-n C-n C-n C-y <up> <up> <up> 
<up> <up> <up> <up> <up> <up> <up> <up> <up> <delete> 
<delete> <delete> C-x C-s <down> <down> <down> <down> 
<down> <down> <down> <down> <down> <down> <down> <down> 
<down> <delete> <delete> <delete> <right> <right> <right> 
<right> <right> <right> <right> <right> <right> <right> 
<right> <right> <right> <right> <right> <right> <right> 
<right> <right> <right> <right> <right> <right> <right> 
<right> <right> <right> <right> <right> <right> <right> 
<right> <right> <left> SPC i n SPC S Q L <backspace> 
<backspace> <backspace> <backspace> t e h <backspace> 
<backspace> <backspace> SPC t h e SPC S Q L SPC b u 
f f e r <down> <down> <down> <down> <down> <down> <down> 
<down> <down> <down> <down> <down> <down> <down> <down> 
<down> <down> <down> <down> <down> <down> <down> <up> 
<up> <up> <up> <up> <up> <up> <up> <up> <up> <up> <up> 
<up> <up> <down> <down> <down> <down> <down> <up> <up> 
<up> <down> <down> <down> <down> <down> <down> <down> 
<down> <down> <down> <down> <down> <down> <down> <down> 
<down> <down> <down> <down> <down> <down> <down> <up> 
<help-echo> <down-mouse-1> <mouse-1> <wheel-up> <double-wheel-up> 
<triple-wheel-up> <triple-wheel-up> <triple-wheel-up> 
<triple-wheel-up> <triple-wheel-up> <triple-wheel-up> 
<triple-wheel-up> <triple-wheel-up> <triple-wheel-up> 
<triple-wheel-up> <triple-wheel-up> <triple-wheel-up> 
<triple-wheel-up> <triple-wheel-up> <triple-wheel-up> 
<wheel-down> <double-wheel-down> <triple-wheel-down> 
M-x b u g SPC SPC SPC <backspace> <backspace> <backspace> 
C-g <down-mouse-1> <mouse-1> <wheel-down> <wheel-down> 
M-x b u g SPC g n SPC SPC <backspace> <backspace> <backspace> 
SPC SPC <backspace> <backspace> <backspace> <backspace> 
<backspace> <backspace> <backspace> <backspace> <backspace> 
<backspace> <backspace> <backspace> C-g C-g C-h a b 
u g <return> <help-echo> <wheel-down> <wheel-down> 
<wheel-down> <wheel-down> <wheel-down> <wheel-down> 
<help-echo> C-x o C-x k <return> C-x C-s M-x r e p 
o r t SPC SPC SPC <return>

Recent messages:
Saving file c:/Users/jean-louis/AppData/Roaming/bug_report.txt...
Wrote c:/Users/jean-louis/AppData/Roaming/bug_report.txt
End of buffer [7 times]
byte-code: Beginning of buffer [5 times]
Making completion list...
Quit [3 times]
Type C-x 4 C-o RET to restore the other window.  
Saving file c:/Users/jean-louis/AppData/Roaming/bug_report.txt...
Wrote c:/Users/jean-louis/AppData/Roaming/bug_report.txt
byte-code: Beginning of buffer [2 times]

Load-path shadows:
None found.

Features:
(shadow sort gnus-util mail-extr emacsbug message format-spec rfc822 mml
mml-sec mm-decode mm-bodies mm-encode mail-parse rfc2231 mailabbrev
gmm-utils mailheader sendmail rfc2047 rfc2045 ietf-drums mm-util
help-fns mail-prsvr mail-utils apropos whitespace help-mode misearch
multi-isearch sql view thingatpt comint ansi-color ring server info
todo-mode cl-loaddefs cl-lib timeclock icalendar diary-lib
diary-loaddefs cal-menu easymenu calendar cal-loaddefs smie image-file
saveplace tsdh-dark-theme paren delsel cus-start cus-load time-date
tooltip electric uniquify ediff-hook vc-hooks lisp-float-type mwheel
dos-w32 ls-lisp w32-common-fns disp-table w32-win w32-vars tool-bar dnd
fontset image regexp-opt fringe tabulated-list newcomment lisp-mode
prog-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 nadvice loaddefs button faces cus-face macroexp files
text-properties overlay sha1 md5 base64 format env code-pages mule
custom widget hashtable-print-readable backquote make-network-process
w32notify w32 multi-tty emacs)

Memory information:
((conses 8 145217 26771)
 (symbols 32 22298 0)
 (miscs 32 129 372)
 (strings 16 26084 6613)
 (string-bytes 1 759023)
 (vectors 8 21472)
 (vector-slots 4 1282775 41720)
 (floats 8 88 657)
 (intervals 28 4647 37)
 (buffers 508 17))

bug#20288: 24.4; password management in sql-oracle

[Eli Zaretskii]

> From: j-l.abraham@orange.fr
> Date: Thu, 09 Apr 2015 21:36:02 +0200
> 
> 
> =============================================
> Following issue in "sql-oracle" appeared with Emacs 24.4.1 on Windows. No problems with 24.3.1 on Windows.
> Once connected to oracle, while changing user with the "connect" command, the word "password" is missing and the password is displayed as clear text!
> 
> SQL> connect devel@xe<enter>
> my_entered_password_is_clear_text!
> 
> expected behavior:
> SQL> connect devel@xe<enter>
> password displayed as dots in the echo area
> =============================================

I cannot reproduce the problem you report.  I see the expected
behavior.


Do you see the problem in "emacs -Q"?

bug#20288: 24.4; password management in sql-oracle

[Eli Zaretskii]

> Date: Thu, 09 Apr 2015 22:51:01 +0300
> From: Eli Zaretskii <eliz@gnu.org>
> Cc: 20288@debbugs.gnu.org
> 
> > From: j-l.abraham@orange.fr
> > Date: Thu, 09 Apr 2015 21:36:02 +0200
> > 
> > 
> > =============================================
> > Following issue in "sql-oracle" appeared with Emacs 24.4.1 on Windows. No problems with 24.3.1 on Windows.
> > Once connected to oracle, while changing user with the "connect" command, the word "password" is missing and the password is displayed as clear text!
> > 
> > SQL> connect devel@xe<enter>
> > my_entered_password_is_clear_text!
> > 
> > expected behavior:
> > SQL> connect devel@xe<enter>
> > password displayed as dots in the echo area
> > =============================================
> 
> I cannot reproduce the problem you report.  I see the expected
> behavior.

Actually, it's quite possible that I didn't perform the same steps as
you.  Please provide a complete recipe starting from "emacs -Q" that
could be used to reproduce the problem.  For example, I'm sure that
"once connected to oracle" requires some commands to be type, please
show them.

bug#20288: 24.4; password management in sql-oracle

[Jean-Louis ABRAHAM]

[-- Attachment #1: Type: text/plain, Size: 2269 bytes --]

Hi Eli

 

The complete recipe is:

 

In Win7/64:

Start/run/cmd

 

In the cmd box I enter:
emacs -Q

In Emacs 24.4.1:

M-x sql-oracle
User: 
Password: 

Database: 

The *SQL* buffer looks like:

SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 9 23:07:25 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> host
Microsoft Windows [version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. Tous droits r serv s.

exit
c:\Users\jean-louis\AppData\Roaming>exit

SQL>



The problem is that after I enter the "host" command the prompt doesn't display, only after I hit the  key

 

I could reproduce the behavior on 2 Win7/64 bits environments, whether calling Emacs with either "runemacs" or "emacs -Q".

 

Regards

Jean-Louis

 

 

> Message du 09/04/15 21:56
> De : "Eli Zaretskii" 
> A : j-l.abraham@orange.fr
> Copie à : 20288@debbugs.gnu.org
> Objet : Re: bug#20288: 24.4; password management in sql-oracle
> 
> > Date: Thu, 09 Apr 2015 22:51:01 +0300
> > From: Eli Zaretskii 
> > Cc: 20288@debbugs.gnu.org
> > 
> > > From: j-l.abraham@orange.fr
> > > Date: Thu, 09 Apr 2015 21:36:02 +0200
> > > 
> > > 
> > > =============================================
> > > Following issue in "sql-oracle" appeared with Emacs 24.4.1 on Windows. No problems with 24.3.1 on Windows.
> > > Once connected to oracle, while changing user with the "connect" command, the word "password" is missing and the password is displayed as clear text!
> > > 
> > > SQL> connect devel@xe
> > > my_entered_password_is_clear_text!
> > > 
> > > expected behavior:
> > > SQL> connect devel@xe
> > > password displayed as dots in the echo area
> > > =============================================
> > 
> > I cannot reproduce the problem you report. I see the expected
> > behavior.
> 
> Actually, it's quite possible that I didn't perform the same steps as
> you. Please provide a complete recipe starting from "emacs -Q" that
> could be used to reproduce the problem. For example, I'm sure that
> "once connected to oracle" requires some commands to be type, please
> show them.
>

[-- Attachment #2: Type: text/html, Size: 3035 bytes --]

bug#20288: 24.4; password management in sql-oracle

[Eli Zaretskii]

> Date: Thu, 9 Apr 2015 23:26:21 +0200 (CEST)
> From: Jean-Louis ABRAHAM <j-l.abraham@orange.fr>
> Cc: 20288@debbugs.gnu.org
> 
> In the cmd box I enter:
> emacs -Q
> 
> In Emacs 24.4.1:
> 
> M-x sql-oracle
> User: <oracle user>
> Password: <password>
> Database: <dbname>
> 
> The *SQL* buffer looks like:
> 
> SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 9 23:07:25 2015
> 
> Copyright (c) 1982, 2014, Oracle. All rights reserved.
> 
> Connected to:
> Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
> 
> SQL> host
> Microsoft Windows [version 6.1.7601]
> Copyright (c) 2009 Microsoft Corporation. Tous droits r serv s.
> 
> exit
> c:\Users\jean-louis\AppData\Roaming>exit
> 
> SQL>
> 
> The problem is that after I enter the "host" command the prompt doesn't
> display, only after I hit the <enter> key

Most probably, a buffering issue.  Is there a command-line switch for
sqlplus that causes it to use unbuffered I/O?  Or maybe some variable
you can set once connected to SQL?

But if you are saying that Emacs 24.3 on the same system and with the
same version of SQL didn't have that problem, then I don't see how's
that possible due to buffering.  Maybe I'm missing something.

bug#20288: 24.4; password management in sql-oracle

[Jean-Louis ABRAHAM]

[-- Attachment #1: Type: text/plain, Size: 2071 bytes --]

"Is there a command-line switch for
> sqlplus that causes it to use unbuffered I/O? Or maybe some variable
> you can set once connected to SQL?"

 

=> I don't know, I've not set any special settings.

 

"But if you are saying that Emacs 24.3 on the same system and with the
> same version of SQL didn't have that problem, then I don't see how's
> that possible due to buffering. Maybe I'm missing something"

 

=> Could it be a problem in the "comint" functions?

=> I can reproduce the problem a french and swiss-german Windows Version: May be language settings matter?

 

> Message du 10/04/15 09:40
> De : "Eli Zaretskii" 
> A : "Jean-Louis ABRAHAM" 
> Copie à : 20288@debbugs.gnu.org
> Objet : Re: bug#20288: 24.4; password management in sql-oracle
> 
> > Date: Thu, 9 Apr 2015 23:26:21 +0200 (CEST)
> > From: Jean-Louis ABRAHAM 
> > Cc: 20288@debbugs.gnu.org
> > 
> > In the cmd box I enter:
> > emacs -Q
> > 
> > In Emacs 24.4.1:
> > 
> > M-x sql-oracle
> > User: 
> > Password: 
> > Database: 
> > 
> > The *SQL* buffer looks like:
> > 
> > SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 9 23:07:25 2015
> > 
> > Copyright (c) 1982, 2014, Oracle. All rights reserved.
> > 
> > Connected to:
> > Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
> > 
> > SQL> host
> > Microsoft Windows [version 6.1.7601]
> > Copyright (c) 2009 Microsoft Corporation. Tous droits r serv s.
> > 
> > exit
> > c:\Users\jean-louis\AppData\Roaming>exit
> > 
> > SQL>
> > 
> > The problem is that after I enter the "host" command the prompt doesn't
> > display, only after I hit the key
> 
> Most probably, a buffering issue. Is there a command-line switch for
> sqlplus that causes it to use unbuffered I/O? Or maybe some variable
> you can set once connected to SQL?
> 
> But if you are saying that Emacs 24.3 on the same system and with the
> same version of SQL didn't have that problem, then I don't see how's
> that possible due to buffering. Maybe I'm missing something.
>

[-- Attachment #2: Type: text/html, Size: 2784 bytes --]

bug#20288: 24.4; password management in sql-oracle

[Eli Zaretskii]

> Date: Fri, 10 Apr 2015 12:16:01 +0200 (CEST)
> From: Jean-Louis ABRAHAM <j-l.abraham@orange.fr>
> Cc: 20288@debbugs.gnu.org
> 
> "Is there a command-line switch for
> > sqlplus that causes it to use unbuffered I/O? Or maybe some variable
> > you can set once connected to SQL?"
> 
> => I don't know, I've not set any special settings.

I didn't say you were, I was saying you should try to.

> "But if you are saying that Emacs 24.3 on the same system and with the
> > same version of SQL didn't have that problem, then I don't see how's
> > that possible due to buffering. Maybe I'm missing something"
> 
> => Could it be a problem in the "comint" functions?

I really won't know.  Does Emacs 24.3 indeed work correctly on the
same system?

> => I can reproduce the problem a french and swiss-german Windows Version: May
> be language settings matter?

Unlikely.