MySQL Bugs: #34010: "Unlimited" license ignore the unlimited flag when reporting Product Information

Bug #34010	"Unlimited" license ignore the unlimited flag when reporting Product Information
Submitted:	23 Jan 2008 16:17	Modified:	23 Jul 2008 13:31
Reporter:	Sloan Childers	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Web	Severity:	S2 (Serious)
Version:	1.2 GA, 1.3J beta	OS:	Any
Assigned to:	Sloan Childers	CPU Architecture:	Any

Description:
Hi,

Today I was pointed to an issue where a platinum unlimited customer was getting the following warning from MEM 1.2:
===========
Your Subscription Needs to be Updated

* You are currently monitoring 1 host, however your subscription covers
only 0. Your subscription needs to be updated to cover at least
1 additional host.
===========

Upon inspection, the license shows a literal value of 'Unlimited' which when cast to an integer is 0. The full license is here: https://intranet.mysql.com/secure/paste/displaypaste.php?codeid=3248

How do we want to indicate that a license is for "Unlimited" amount of servers?

Best Regards,
-- 
Bryan Alsdorf, Manager of Support Systems
MySQL AB, www.mysql.com 

** reproduced by Sloan in the current 1.3J code base

How to repeat:
Install an unlimited license while monitoring at least one mysqld instance and visit the Product Information page.

Suggested fix:
Use the com.mysql.merlin.ui.helper.AccountStatus.isUnlimited flag.

Nothing has changed in the license format from our end, looks like in the the customer SKU was setup wrong. From a little research it seems the "Platinum Unlimited" SKU was not setup when this customer bought it so they were setup as normal platinum with "Unlimited" for the server count.

The customer has now been updated to "Platinum Unlimited" so this problem should go away. I wouldn't risk your release for this patch, but include it in anything after 1.3j (still look for "Unlimited" in the SKU though as well).

Don't worry, I will only change the license format working with the Merlin team, never just for fun.

/bryan

Looks like we are safe for now.  Let us leave this one open to re-address in 2.0.

Is this still occurring? We never have found how to reproduce it reliably. Any guidance appreciated.

Fix committed server side to return a valid integer if the license count is the string "unlimited".  We may want further UI polish to display "Unlimited" instead of a number but we will no longer inappropriately nag an unlimited customer.

Verified fixed in ver. 2.0.0.7001. The UI displays "unlimited" for 'Hosts' under Product Information.

An entry was added to the 2.0 changelog:

Platinum Unlimited customers sometimes received a warning stating incorrectly that their subscription supported zero hosts.