Bug #46757 Edit user dialog has wrong check against special chars in pwd for role='agent'
Submitted: 17 Aug 2009 9:50 Modified: 6 Nov 2009 14:05
Reporter: Carsten Segieth Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Web Severity:S3 (Non-critical)
Version:2.0.6.7159 OS:Any
Assigned to: Josh Sled CPU Architecture:Any

[17 Aug 2009 9:50] Carsten Segieth
Description:
When trying to change the password for the agent user in the UI to a password that contains e.g. a '@' (and which works fine for connecting the agent with the dashboard) an error message is shown:

 An Error Occurred

    * U0160 The following characters are invalid in an agent password: !*'();:@&=+$,/?%#[]

This check is not (no longer) valid. For the user role 'manager' the check is not performed (which is correct).

Problem can be seen also in 2.1.0.1093. 

How to repeat:
- on the first setup page use a password that contains special chars like '@'
- connect an agent to the dashboard using this pwd
- on the dashboard 
  - open: Settings --> Manage Users
  - select the user with role = 'agent' and click 'edit user'
  - enter a password that contains a '@'
  - see "wrong" error message

Suggested fix:
no longer perform the check
[17 Aug 2009 10:08] Enterprise Tools JIRA Robot
Eric Herman writes: 
please double-check against: http://bugs.mysql.com/bug.php?id=37172
[23 Oct 2009 19:52] Enterprise Tools JIRA Robot
Josh Sled writes: 
revno: 7587
revision-id: jsled@asynchronous.org-20091023194933-2j4hhqe0vw0e64x1
parent: jsled@asynchronous.org-20091023183944-69jz60a5hims81l6
committer: Josh Sled <jsled@asynchronous.org>
branch nick: local
timestamp: Fri 2009-10-23 15:49:33 -0400
message:
  EM-3524, EM-2663 related: no longer filter "reserved" agent password characters.
[23 Oct 2009 19:53] Enterprise Tools JIRA Robot
Josh Sled writes: 
this just got pushed, so it'll be part of 2.2alpha1
[26 Oct 2009 13:01] Enterprise Tools JIRA Robot
Keith Russell writes: 
Patch installed in versions => 2.2.0.1518.
[26 Oct 2009 22:34] Enterprise Tools JIRA Robot
Marcos Palacios writes: 
Verified fixed in Monitor build 2.2.0.1518.
[6 Nov 2009 14:05] Tony Bedford
An entry has been added to the 2.2.0 changelog:

        When trying to change the password for the agent user in the
        Dashboard to a password that contained a @ or
        other special character, the following error message was
        displayed:

An Error Occurred

    * U0160 The following characters are invalid in an agent password:

!*'();:@&=+$,/?%#[]
[8 Jan 2010 19:30] Donna Harmon
Workaround: Change Role to dba, change password, save changes, then change role back to agent.