Re: sql-mode password display

[Kevin Rodgers]

rb wrote:
> Kevin Rodgers <ihs_4664@yahoo.com> writes:
>>What happens if you don't enter your password when prompted by M-x
>>sql-mysql, i.e. just type RET?
>
> Thank you for the suggestion,
>
> Without password, the server rejects the connection attempt - it is
> configured to require passwords.

I was hoping it would prompt you and comint would DTRT.

>>M-: (string-match comint-password-prompt-regexp "Enter password: ") RET
>>returns nil, so I would try
>>
>>(setq comint-password-prompt-regexp
>>       "\\(\\([Oo]ld \\|[Nn]ew \\|'s \\|login \\|Kerberos \\|CVS
>>\\|UNIX \\| SMB \\|^\\)[Pp]assword\\( (again)\\)?\\|pass
>>phrase\\|\\(Enter\\|Repeat\\) pass ?\\(word\\|phrase\\)\\)\\( for
>>[^:]+\\)?:\\s *\\'")
>
> that is what the value of comint-password-prompt-regexp already is, as
> mentioned:

Not in Emacs 21.3, where its default value fails the test that I
mentioned:

>>M-: (string-match comint-password-prompt-regexp "Enter password: ") RET

But changing its value as above causes that test to succeed.

>> > Within the shell, any other commands requiring a password (ssh, 
rlogin,
>> > su, etc), the password is [properly] not displayed.

I know.  That's because their password prompts satisfy the string-match
test above, so when comint-watch-for-password-prompt is called via
comint-output-filter-functions it sends your password to the sql process
without echoing it in the buffer.

--
Kevin Rodgers