Bug #52216 agent update installer creates wrong 'agent-mgmt-username = ...' entry in .ini
Submitted: 19 Mar 2010 12:55 Modified: 26 Mar 2010 12:57
Reporter: Carsten Segieth Email Updates:
Status: Closed Impact on me:
Category:MySQL Enterprise Monitor: Installing Severity:S2 (Serious)
Version: OS:Any
Assigned to: BitRock Merlin CPU Architecture:Any

[19 Mar 2010 12:55] Carsten Segieth
During an update from to the value 'agent-mgmt-username' is not created correct from the 'agent-mgmt-hostname' in the existing install. The following samples are all created with the same settings for user and password:

# fresh install
agent-mgmt-hostname = http://uuuu%40agent:pppp%40agent@qa-merlin.mysql.com:48080/heartbeat

# after update to
agent-mgmt-hostname = http://qa-merlin.mysql.com:48080/heartbeat
agent-mgmt-username = agent
agent-mgmt-password = pppp@agent

# fresh install
agent-mgmt-hostname = http://qa-merlin.mysql.com:48080/heartbeat
agent-mgmt-username = uuuu@agent
agent-mgmt-password = pppp@agent

Work around:
After updating the agent installaation edit the .ini file and fix the wrong password.

How to repeat:
- install    mysqlmonitoragent- --installdir D:\Merlin\inst\agent\\winxp\IBM --mysqlhost --mysqlport 3351 --mysqluser agent --mysqlpassword mysql --checkmysqlhost yes --managerhost qa-merlin.mysql.com --managerport 48080 --agentuser uuuu@agent --agentpassword pppp@agent --proxyport 44044 --mode unattended

- update to  mysqlmonitoragent- --installdir D:\Merlin\inst\agent\\winxp\IBM --mode unattended --enableaggregator 1 --aggregatorport 44400 --enableproxy 1 --createaccount 1 --rootuser root --rootpassword xxxx --servicename "MySQL Enterprise Monitor Agent - (upd"

- see that the agent cannot connect to the dashboard after update
- check mysql-monitor-agent.ini, compare user/password settings with version from before the update
[19 Mar 2010 12:59] Carsten Segieth
- related to: Bug#48219 MEM upgrader does not escape special characters
- but in my case the install works except of the wrong setting, and after the .ini was fixed the agent works.
[19 Mar 2010 22:01] Enterprise Tools JIRA Robot
Andy Bang writes: 
Sounds like the url-encoded @ sign (%40) is confusing the parser.
[25 Mar 2010 15:01] BitRock Merlin
Patch sent to Keith.
[25 Mar 2010 17:03] Enterprise Tools JIRA Robot
Keith Russell writes: 
Patch pushed to installer repository.
[25 Mar 2010 18:40] Enterprise Tools JIRA Robot
Keith Russell writes: 
Patch installed in versions =>
[26 Mar 2010 7:01] Carsten Segieth
looking at yesterday's build number I think build was meant, not 1611 ;-)
[26 Mar 2010 12:57] Enterprise Tools JIRA Robot
Carsten Segieth writes: 
OK in