Details
-
New Feature
-
Resolution: Fixed
-
Major
-
None
-
None
-
Ubuntu 11.04+
Description
WMI Poller
Known Issues
- Under heavy dev, try at your own risk. That said, it doesn't do any irreversible data changes in Observium, so it's mostly harmless
- For wmi-common there are conflicts with existing SNMP pollers
- Event logs will show several entries for updated OS, possibly processor
- Consequently, generic info is still a work in progress
- MS SQL is still a work in progress, suggestions for counters welcome
- App definitions need to be added for MS SQL (only affects Apps overview page, ie. http://yourobserviumsite/apps/app=mssql/)
- App definitions need to be revisited for Exchange
- Display name option for apps has not been added to all areas where app_type is used
Database changes
update/101.sql
- Alters applications table: adds "app_name" column
- This allows customized app name display in HTML elements such as navbars
Changes to existing files
includes/defaults.inc.php
- Added config variable for WMIC executable directory
- Added config variables for WMI polling options
- Added WMI poller modules entries, default set to 0
includes/definitions/apps.inc.php
- Added app definition for Exchange
html/pages/device/appcs.inc.php
- Fixed bug where all instances of an application would be active on navbar (
OBSERVIUM-515) - Changed app navbar to display an application name (see DB changes)
- Changed app navbar to display app instance in parenthesis
Additions
- Three WMI poller modules that must be enabled in a device's modules page
WMI Poller for Generic Server Info
- Finally display correct CPU name!
- Updates the correct version of Windows
WMI Poller for Microsoft Exchange Counters
- Pollers for:
- ActiveSync
- Autodiscover
- Information Store
- Mailbox
- Offline Address Book
- Outlook Web App
- Transport Queues
- SMTP
WMI Poller for very basic MS SQL Counters
- Currently only polling:
- Current User Connections
- Buffers
Installation
FOLLOW AT YOUR OWN RISK:
See attached PDF
Attachments
Activity
wmi-008.patch
Changes
- Fixed a typo under MSSQL app page
- Fixed bug where WMI poller would check for config variables instead of local function variables
- Fixed MSSQL page so that only graphs with data are displayed
- Moved functions from includes/polling/wmi.inc.php to includes/wmi.inc.php (sid3windr's suggestion)
- Updated wmi_dbAppInsert to update app_name if it's empty in the database
- Updated MSSQL poller to provide an app name upon update
Thanks for the report, Anthony. I've fixed this in my dev setup already and just need to push out a patch. The issue stems from includes/polling/wmi.inc.php -> wmi_query(). It checks for global WMI config variables to be set rather than the local variables, which is definitely an oversight of mine when I added the override ability.
I've noticed one bug with this code from R4668
if you dont supply a default password in config.php (but do override the settings via the Web interface) then it tries to connect with the --no-pass flag in wmic eg
/bin/wmic --user=Administrator --no-pass --delimiter=## --namespace='root\CIMV2' -d2 //<HOSTNAMEREMOVED> "SELECT Name FROM Win32_ComputerSystem"
but as soon as you add a default username and pass in the config.php file it correctly uses the overridden settings, eg:
/bin/wmic --user=Administrator --password=<PASSREMOVED> --delimiter=## --namespace='root\CIMV2' -d2 //<HOSTNAMEREMOVED> "SELECT Name FROM Win32_ComputerSystem"
wmi-005.patch
wmi-006.patch
SHOULD work with Ubuntu+ svn patch
Additions
- Added CPU usage for MSSQL process
Changes
- Aesthetic enhancements
- Added memory cache to MSSQL
- Renamed 101.sql -> 103.sql to keep up with committed SQL updates
wmi-004.patch
Additions
- Added WMI "modules" to config
- Added control over which WMI modules are polled to the WMI section in the device edit page
- Created directories:
- includes/polling/storage
- Added files:
- includes/polling/os/wmi.inc.php
- includes/polling/processors/wmi.inc.php
- includes/polling/storage/wmi.inc.php
Changes
- Reverted back to a single global poller module that includes module files
- WMI Poller will check if a WMI module is enabled in config and device_attribs before polling
- Changed $config to $GLOBALS['config']
- Moved files:
- includes/polling/storage-hrstorage.inc.php => includes/polling/storage/hrstorage.inc.php
- Changed includes/polling/storage.inc.php to reflect above
- Various optimizations, less DB queries
I do strongly discourage the use of the above mentioned method to poll WMI counters and connect to WMI through RPC. Instead i would recommend using WinRM/WSMan to poll Windows host. It can be configured via GPO, the security is much better to handle. It can even be configured to use HTTP/Basic,Negotiate,Digest Auth instead to have KRB5 setup on *NIX host. The best thing is it can be implemented in Observium without sending the User to the dependency hell. From my experience it will bring the same benifits, but without the all the fiddeling.