Bug #23291 mysql command line client text garbled and one crash
Submitted: 14 Oct 2006 12:40 Modified: 3 Jan 2007 8:39
Reporter: Dave Gibelli Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: Compiling Severity:S3 (Non-critical)
Version:5.0.26 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[14 Oct 2006 12:40] Dave Gibelli
Using the command line within mysql text gets garbled when the cursor keys are used.

I had one instance where mysql crashed taking the shell (bash) with it.

I compiled with the recommended configure options. 

I then tried the --without-readline option to configure but that failed with:

configure: error: Could not find system readline or libedit libraries
          Use --with-readline or --with-libedit to use the bundled
          versions of libedit or readline

Then I tried reconfiguring using --with-libedit but I get the same problem

How to repeat:
I am using a distribution of Knoppix 5.0 as my baseline with many addition packages.

shell> mysql

mysql> enter commands and the use up/down keys to get history

The text is garbled.
[14 Oct 2006 14:22] Dave Gibelli
There is a work around to this problem.

By downloading and installing http://directory.fsf.org/GNU/readline.html version 5.2 AND including the --without-readline configure directive with the other recommended options

I think it should be possible to compile MySQL without the --without-readline option but someone cleverer than me needs to think about this!
[16 Oct 2006 11:58] Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newr version, 5.0.26, and inform about the results.
[16 Oct 2006 12:31] Dave Gibelli
I stated the incorrect version in my initial report, I quoted v5.0.24, I was incorrect - see below output of mysqladmin --version

mysqladmin  Ver 8.41 Distrib 5.0.26, for pc-linux-gnu on i686

This is still a bug IMHO, because I had to specify --without-readline and download the current readline from gnu.
[24 Nov 2006 13:48] Valeriy Kravchuk
Sorry for a delay with this report. Please, send the results of:

mysql --version

I want to check how mysql command line client was built.
[24 Nov 2006 20:27] Dave Gibelli
mysql  Ver 14.12 Distrib 5.0.26, for pc-linux-gnu (i686) using readline 5.0
[3 Dec 2006 8:39] Valeriy Kravchuk
Please, send the exact ./configure command lines (and CFLAGS values) you used when compiling to get a proper mysql binary, and those to create a crashing one. I do not have any problems like you described with readline 5.0.
[4 Jan 2007 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".