Command Line and Delete and Home Keys
rob_mazur
knows the answer....
In some operating systems, the MySQL client (command line) does not
react to the HOME or DELETE keys. So in BASH shell while traversing
the file system, HOME gets you to the front of the line and DELETE
deletes characters to the right of the current position...as expected.
And in MySQL client in SuSE that works as expected also. But in
Solaris 10, Ubuntu, and OSX, the HOME key does nothing, and DELETE
inserts a ~. I think OSX is just a different animal anyway, but is
there a quick fix to get Ubuntu and Solaris 10 to do the same thing
with these keys in MySQL client as they do while traversing the file
system?
Thanks,
Rob
p.s. I started remapping keys in OSX to get the behavior I wanted,
but then "broke" other behavior that used the Ctrl, Alt, Apple key,
etc. Really, I am more interested in solving in Solaris and Ubuntu
anyway.
rob_mazur
> In some operating systems, the MySQL client (command line) does not
> react to the HOME or DELETE keys. So in BASH shell while traversing
> the file system, HOME gets you to the front of the line and DELETE
> deletes characters to the right of the current position...as expected.
>
Sorry, I just realized I probably should not simply say "operating
systems" or "SuSE" or "Ubuntu". Rather I am referring to Konsole in
SuSE and Gnome Terminal in Ubuntu and Solaris.
Thanks,
Rob
Jerry Stuckle
Sounds like you have a problem with Gnome Terminal.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstu...@attglobal.net
==================
houghi
>> Sorry, I just realized I probably should not simply say "operating
>> systems" or "SuSE" or "Ubuntu". Rather I am referring to Konsole in
>> SuSE and Gnome Terminal in Ubuntu and Solaris.
>
FYI: Konsole is KDE, not GNOME.
houghi
--
You can have my keyboard ...
if you can pry it from my dead, cold, stiff fingers
Jerry Stuckle
> Jerry Stuckle wrote:
>>> Sorry, I just realized I probably should not simply say "operating
>>> systems" or "SuSE" or "Ubuntu". Rather I am referring to Konsole in
>>> SuSE and Gnome Terminal in Ubuntu and Solaris.
>> Sounds like you have a problem with Gnome Terminal.
>
> FYI: Konsole is KDE, not GNOME.
>
> houghi
And he said he was having problems with Gnome Terminal.
houghi
> houghi wrote:
>> Jerry Stuckle wrote:
>>>> Sorry, I just realized I probably should not simply say "operating
>>>> systems" or "SuSE" or "Ubuntu". Rather I am referring to Konsole in
>>>> SuSE and Gnome Terminal in Ubuntu and Solaris.
>>> Sounds like you have a problem with Gnome Terminal.
>>
>> FYI: Konsole is KDE, not GNOME.
>
As well as with Konsole. So it seems not to be a Gnome, Gnome Terminal,
KDE, Konsole openSUSE or Ubuntu problem.
houghi
--
Usenet is like a herd of performing elephants with diarrhea - massive,
difficult to redirect, awe-inspiring, entertaining, and a source of
mind-boggling amounts of excrement when you least expect it.
rob_mazur
> Jerry Stuckle wrote:
> > And he said he was having problems with Gnome Terminal.
>
> As well as with Konsole. So it seems not to be a Gnome, Gnome Terminal,
> KDE, Konsole openSUSE or Ubuntu problem.
>
> houghi
Sorry for getting the issue confused, guys. My fault. My experience
is:
1) Konsole and KDE on SuSE....MySQL client works as expected (with
regard to Delete and Home key functionality)
2) Gnome Terminal on OpenSolaris 10, which uses Gnome, I have the
problem with MySQL client as described.
3) Gnome Terminal on Ubuntu 8.10, using Gnome, I have the problem with
MySQL client as described.
And in the case of #2 and #3 above, each of those is on more than one
machine. So sure, it may be a Gnome Terminal issue. But are there
any users of MySQL client here, using Gnome Terminal (I am hoping
there are many), that quickly get back to the beginning of a 2 or 3
line query, other than using the left arrow for 8 or 10 seconds?
And same question regarding Delete, so you don't have to scroll right
40 characters just to backspace 40 characters?
Thanks for any help guys,
Rob
houghi
> Sorry for getting the issue confused, guys. My fault. My experience
> is:
Sorry for misunderstanding.
> 1) Konsole and KDE on SuSE....MySQL client works as expected (with
> regard to Delete and Home key functionality)
To be 100% sure, you could install Gnome Terminal on openSUSE and see if
that does things wrong as well. If yes, then at least you can test it on
almost identical settings. If things do not go wrong, you can compare
the settings.
> 2) Gnome Terminal on OpenSolaris 10, which uses Gnome, I have the
> problem with MySQL client as described.
>
> 3) Gnome Terminal on Ubuntu 8.10, using Gnome, I have the problem with
> MySQL client as described.
>
> And in the case of #2 and #3 above, each of those is on more than one
> machine. So sure, it may be a Gnome Terminal issue. But are there
> any users of MySQL client here, using Gnome Terminal (I am hoping
> there are many), that quickly get back to the beginning of a 2 or 3
> line query, other than using the left arrow for 8 or 10 seconds?
I use Gnome Terminal on openSUSE, but I am not experienced enough to use
the MySQL on terminal. I just use it via PhpMyAdmin.
If you want, you could tell me what to do step by step and I could
verify, but I hope that somebody with more experience can help you out.
Jerry Stuckle
Rob, the terminal handles things like backspace keys, not MySQL. When
you hit enter, the entire line is sent to the underlying program (MySQL,
in this case).
It works when using Konsole and KDE. It fails when using Gnome on
several OS's. The MySQL client hasn't changed.
So where's the problem? Hint: Look for what is common in all failures
(Gnome Terminal) and what is common whether it works or fails (MySQL).
The problem is related to the product involved only in failures.
Quite basic debugging technique, actually.
rob_mazur
> Rob, the terminal handles things like backspace keys, not MySQL. When
> you hit enter, the entire line is sent to the underlying program (MySQL,
> in this case).
>
> It works when using Konsole and KDE. It fails when using Gnome on
> several OS's. The MySQL client hasn't changed.
>
> So where's the problem? Hint: Look for what is common in all failures
> (Gnome Terminal) and what is common whether it works or fails (MySQL).
> The problem is related to the product involved only in failures.
>
> Quite basic debugging technique, actually.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> ==================
Hi Jerry,
Thanks for taking the time to answer.
Yes, I completely agree with you in your summary, and I came into this
thread knowing that Gnome Terminal was the culprit. This is why I
stated at the beginning of the thread that I don't think it is
specifically a MySQL client issue.
Then why am I posting here, you ask? Because, it is only when I use
the MySQL client that this happens. Home and Delete work as expected
for me if I use Gnome Terminal for anything else that I do...except
MySQL client. And if that happens to me, then it might also have
happened to other MySQL users. Where can I ask other MySQL users a
question about this? Right here in this forum. What I was hoping for
was to have a few people say...."sure, that happened to me as well,
and this is how I altered of configured Gnome Terminal to resolve the
problem".
If I were to post to a Gnome-related forum, only a tiny percentage of
the readership would be MySQL users. Here, 100% of it is, and much if
it likely uses a flavor of Linux with Gnome. So, my hoped for hit
rate had a lot more potential here.
Thanks for your postings. I hope you don't find that my thread is too
disruptive.
Rob
Jerry Stuckle
Rob,
Well, that does make a huge difference - you didn't say that Gnome
Terminal works OK with other applications.
Personally, I don't use Gnome Terminal, so I can't help much there. But
from what you're saying, I guess it could be possible there is a
discrepancy between how MySQL client makes requests to the terminal and
other applications do.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstu...@attglobal.net
==================