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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.042 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.