| 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: | |
| Category: | MySQL Enterprise Monitor: Web | Severity: | S3 (Non-critical) |
| Version: | 2.0.0.7105 | OS: | Any |
| Assigned to: | Josh Sled | CPU Architecture: | Any |
[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

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.