Bug #441 WinMySQLAdmin
Submitted: 17 May 2003 8:38 Modified: 11 Jun 2003 17:58
Reporter: Miguel Solorzano Email Updates:
Status: Closed
Category:Client Severity:S3 (Non-critical)
Version:1.4 OS:Microsoft Windows (Windows)
Assigned to: Miguel Solorzano Target Version:

[17 May 2003 8:38] Miguel Solorzano
Description:
Description: remark 1:
When the buttons on the title area of the WinMySQLadmin window are used in the normal
way, the result of
closing the window will be shutdown of the tool.
Compare this situation with for example the icons for Virus Scanner and Fire Wall in the
system tray 
of the Windows screen. You do not stop the Virus Scanner or Fire Wall by opening and
closing a window
for that tool.

How-To-Repeat: remark 1:
When the WinMySQLadmin window is opened with the SHOW ME button on the icon in the system
tray
of the Microsoft Windows screen, than you would expect that this window is closed with
the X button
at the top right corner of this window.
But the result of the X button is stoppage of the tool,so the MySQL icon is removed from
the 
system tray of the Windows screen.
You get the same result when you use the "system button" (MySQL icon) on the lop left
corner of this
window, and than select "close".

Fix: remark 1:
The X button at the top right corner of the WinMySQLadmin window should be identical to
the HIDE ME button,
so it should NOT be identical to the SHUTDOWN THIS TOOL button.
The same applies to the MySQL button at the top left corner of the window.

Description: remark 2:
The traffic light icon gives the impression that it gives a real-time indication of the
status
of the MySQL server, because the colour of the traffic light changes to red when the
button 
STOP THE SERVICE is used, and changes to green when the button START THE SERVICE is
used.
But this impression is not true, because it does not gives the correct indication when
the server
is started or stopped with commands on the MS-DOS window.

How-To-Repeat: remark 2:
Start with a normal situation, so the traffic light is green and the MySQL server is
working.
Give command NET STOP MYSQL on the MS-DOS command line with prompt C:\MySQL\bin>
The MySQL server is stopped, but the MySQL traffic light remains green in the system tray
of Microsoft Windows.
In this situation I would expect a red traffic light, just like the situation where the
STOP THE SERVICE button
on the WinMySQLadmin tool was used.
Give command NET START MYSQL on the MS-DOS command line with prompt C:\MySQL\bin>
Now the green traffic light is showing the correct colour.

Fix: remark 2:
no information.

Description: remark 3:
Window ERR FILE shows an empty window, and the button REFRESH THE LAST DATA FROM
MYSQL.ERR FILE does not 
give any result.

How-To-Repeat: remark 3:
see description

Fix: remark 3:
The correct path and file name on my PC are:
C:\MySQL\data\ton-lvpcruf4206.err
The WinMySQLadmin tool can find the correct filename in field LOCAL HOST NAME on window
ENVIRONMENT.
The value "ton-lvpcruf4206" in this example is system name of my PC, as defined at
installation of Windows XP,
and correctly shown on the ENVIRONMENT window in the tool.

Description: remark 4:
The identification line in the window gives "WinMySQLadmin Ver 1.4 for
Win95/Win98/NT/Win2000".
Is there any specific reason why "Win XP" is not mentioned here? 

Synopsis:	WinMySQLadmin.exe version 1.4 is very confusing to use
Submitter-Id:	a-m-blom@hetnet.nl
Originator:	Ton Blom
Organization:   not applicable
MySQL support:  [none ]
Severity:	[non-critical]
Priority:	[medium]
Category:	[WinMySQLadmin]
Class:		[ sw-bug ]
Release:	mysql-4.0.12

Exectutable:   [mysqld-max-nt]
Environment:   <Personal Computer Fujitsu Siemens MS-6391>
System:        <Microsoft Windows XP Home Edition version 5.1.2600 service pack 1 build
2600>
Compiler:      VC++ 6.0
Architecture:  i

How to repeat:
[11 Jun 2003 17:58] Miguel Solorzano
Some notes about the fixes:

1- Remark #3. The log error file now is verified in the below order:
   \data\mysql.err
   \data\hostname.err
   \custom.err file

   The last option will be work if the user edit the path with a
   new key under the WinMySQLAdmin section.
   The key is called log-error.

2- For the tool to catch the server started from the command prompt
   needs to have the user name and password in the same section
   mentioned in the note 1. Otherwise only will work through the
   queries made to SCM when the server is started as service.
   The reason of this limitation is the current code used for presents
   memory leakage, so the complete fix for the remark #2 will stays
   suspense until I find a solution without this problem.