MySQL Bugs: #26864: MA in 'Configure-service Mode' allows illegal characters as service name

Bug #26864	MA in 'Configure-service Mode' allows illegal characters as service name
Submitted:	6 Mar 2007 9:28	Modified:	12 May 2009 12:51
Reporter:	Heinz Schweitzer (Gold Quality Contributor)	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.10	OS:	Windows (XP)
Assigned to:		CPU Architecture:	Any
Tags:	qc

Description:
MA in 'Configure-service Mode' allows illegal characters as service name

MySQL Admininstrator 1.2.10

MySQL Server Information
--------------------------------------------------------------------------------
Connected to MySQL Server Instance
  Username:                root
  Hostname:                localhost
  Port:                    3306
--------------------------------------------------------------------------------
Server Information
  MySQL Version:           MySQL 5.0.27-community-nt via TCP/IP
  Network Name:            localhost
  IP:                      127.0.0.1
--------------------------------------------------------------------------------
Client Information
  Version:                 MySQL Client Version 5.1.11
  Network Name:            xxxxxxxxxxx
  IP:                      xxxxxxxxxxx
  Operating System:        Windows XP
  Hardware:                2x Intel(R) Core(TM)2 CPU         T7200  @ 2.00GHz, 2.0 GB RAM

How to repeat:
Start Administrator 1.2.10

When the login screen like in screen shot s1 pops up
press and hold the CTRL key so the cancel button changes to skip button.
Press skip button.

MA in Configure-service Mode pops up like in screen shot s2

In the upper left pane select 'Service control'.
In  the right pane activate the 'Configure Service' tab .
In there press the 'Install new Service' button at the bottom left.

A window with a default name already, pops up, asking for the name
like in screen shot s3.

NOTE: the text states only to enter characters or numbers etc ....

In this dialog now do the exact opposite enter funny characters and spaces
and press OK.

The name is accepted an shows up under 'Installed Services' like in 
screen shot s4

From here on you can work with this service without MA complaining about the name.

Suggested fix:
Check for syntactic correct service name and probably also
check for duplicate service name outside the realm of MA

s1

Attachment: s1.jpg (image/jpeg, text), 27.73 KiB.

s2

Attachment: s2.jpg (image/jpeg, text), 143.14 KiB.

s3

Attachment: s3.jpg (image/jpeg, text), 139.07 KiB.

s4

Attachment: s4.jpg (image/jpeg, text), 148.31 KiB.

Thank you for a bug report. Verified just as described.

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Administrator into MySQL Workbench. We won't fix this anymore in MySQL Administrator because it will be different in Workbench.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/