Bug #40830 meta info does not show 'os_description' but only 'os_version'
Submitted: 18 Nov 2008 17:30 Modified: 5 Dec 2008 16:20
Reporter: Carsten Segieth Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Web Severity:S3 (Non-critical)
Version:2.0.0.7105 OS:Any
Assigned to: Josh Sled CPU Architecture:Any

[18 Nov 2008 17:30] Carsten Segieth
Description:
The Meta Info on the dashboard shows for 'OS' only what is stored as 'os_version' in the DB, but not the 'os_description'.

From this it is not easy to see that it's e.g. "SuSE 10.3" if only "2.6.22.17-0.1-default" is shown or "Microsoft Windows 2003" is currently shown as "Win32 5.2" only.

The needed strings are reported by the agent, so it looks to me a UI thing:
+-----------+---------------------+-----------------------+
| type_name | attribute_name      | value                 |
+-----------+---------------------+-----------------------+
| os        | os_arch             | x86_64                |
| os        | os_description      | SuSE 10.3             |
| os        | os_machine          | x86_64                |
| os        | os_name             | Linux                 |
| os        | os_patchlevel       | unknown               |
| os        | os_vendor           | SuSE                  |
| os        | os_vendor_code_name |                       |
| os        | os_vendor_name      | Linux                 |
| os        | os_vendor_version   | 10.3                  |
| os        | os_version          | 2.6.22.17-0.1-default |
+-----------+---------------------+-----------------------+
10 rows in set (6.14 sec)

How to repeat:
compare Meta Info on dashboard with e.g.
SELECT DISTINCT type_name, attribute_name, value FROM mem.inventory_types JOIN mem.inventory_instances ii USING (type_id) JOIN mem.inventory_attributes ia USING (type_id) JOIN mem.inventory_instance_attributes iia ON (iia.instance_id = ii.instance_id AND iia.attribute_id=ia.attribute_id) JOIN mem.dc_ng_string_now USING (instance_attribute_id) WHERE  attribute_name LIKE 'os%' AND instance_name = "ssh:{17:19:78:58:c7:37:86:7b:5c:a4:ab:80:33:62:d2:2c}.0" ORDER BY instance_name, attribute_name;

Suggested fix:
Show "os_description (os_version)" as it was in version 1.3.
[20 Nov 2008 18:40] Josh Sled
revno: 6498
revision-id: jsled@asynchronous.org-20081120182709-xuv09b0jh813kp7g
parent: eric@mysql.com-20081120172703-4tv19yd4nua46jju
committer: Josh Sled <jsled@asynchronous.org>
branch nick: 2.0
timestamp: Thu 2008-11-20 13:27:09 -0500
message:
  Bug#40830: include the server OS description in the meta info panel.
[25 Nov 2008 4:46] Marcos Palacios
Verified fixed in build 2.0.0.7105.
[26 Nov 2008 14:14] Tony Bedford
An entry has been added to the 2.0 changelog:

Meta Info on the Dashboard did not display information for the meta data os_description.
[28 Nov 2008 15:00] Carsten Segieth
re-opening as it looks to me that the presentation on the Meta Info is not correct. Instead showing (like in 1.3)

 Red hat Enterprise Linux 4 (Linux 2.6.9-22.0.2.ELsmp)
 Solaris 10 (Solaris 5.10)
 Microsoft Windows XP (Win32 5.1)
 Microsoft Windows Vista (Win32 6.0)
 Mac OSX Tiger (Mac OSX 10.4.11)

it shows in 2.0.0.7105

 Linux Red hat Enterprise Linux 4 (2.6.9-22.0.2.ELsmp)
 Solaris Solaris 10 (5.10)
 Win32 Microsoft Windows XP (5.1)
 Win32 Microsoft Windows Vista (6.0)
 MacOSX Mac OS X Leopard (10.5.5)
[28 Nov 2008 15:08] Carsten Segieth
... and in case of a remote agent, where no OS data is shown, the "OS" line shows a "()". Can this be suppressed?
[1 Dec 2008 17:49] Josh Sled
revno: 6519
revision-id: jsled@asynchronous.org-20081201164555-d1g6evuzyi7wxlt7
parent: jsled@asynchronous.org-20081201164452-he9suf343xtvjdy8
committer: Josh Sled <jsled@asynchronous.org>
branch nick: 2.0
timestamp: Mon 2008-12-01 11:45:55 -0500
message:
  Bug#40830: move OS name to its 1.3 location before the version, in parens; conditionalize the whole (osname version) section based on either being present.
[5 Dec 2008 16:20] Carsten Segieth
OK now in 2.0.0.7119