Details

    • New Feature
    • Resolution: Fixed
    • Major
    • None
    • None
    • Poller, Web Interface
    • 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

          [OBS-518] WMI Poller

          many thanks.
          this patches already commited, issue close.

          landy Mike Stupalov added a comment - many thanks. this patches already commited, issue close.

          Is this WMI poller available on the community edition? and if so what is needed to set it up?

          ChrisLall Christopher Lall added a comment - Is this WMI poller available on the community edition? and if so what is needed to set it up?

          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.

          rage1985 Sascha Schaal added a comment - 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.

          updated to 008

          adama Adam Armstrong added a comment - updated to 008
          highonmikey Mikey added a comment -

          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
          highonmikey Mikey added a comment - 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
          highonmikey Mikey added a comment -

          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.

          highonmikey Mikey added a comment - 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"

          anthonysomerset Anthony Somerset added a comment - 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"
          highonmikey Mikey added a comment - - edited

          wmi-007.patch

          This lets MS SQL actually function...

          highonmikey Mikey added a comment - - edited wmi-007.patch This lets MS SQL actually function...

          Patch 006 is now in SVN.

          adama Adam Armstrong added a comment - Patch 006 is now in SVN.
          highonmikey Mikey added a comment -

          Derp

          highonmikey Mikey added a comment - Derp

          People

            adama Adam Armstrong
            highonmikey Mikey
            Votes:
            0 Vote for this issue
            Watchers:
            11 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: