Archived community.zenoss.org | full text search
Skip navigation
2447 Views 5 Replies Latest reply: Jul 9, 2012 7:26 AM by Kaya Saman RSS
Kaya Saman Rank: White Belt 12 posts since
Jun 6, 2012
Currently Being Moderated

Jul 6, 2012 9:43 AM

ZenPacks for monitoring SQL queries

Hi,

 

I'm trying to replace Nagios with Zenoss and have installed 3.2.1 on CentOS 6.2.

 

 

Part of our Nagios infrastructure queries MySQL and MSSQL data sources and performs checks to see that everything is working.

 

 

To start with I am not sure which ZenPacks will do this, so could someone point me out into the right direction?

 

 

So far I am trying to Install the WMI Data Source ZenPack as precursor however I am hitting an error.

 

The link I am using is this:

 

docs/DOC-3392

 

and this version: ZenPacks.community.WMIDataSource-3.0.egg.zip

 

 

The error I am getting is this:

 

[code]

$ zenpack --install ZenPacks.community.WMIDataSource-3.0.egg

 

Link to http://pypi.python.org/simple/ZenPacks.community.SQLDataSource/ ***BLOCKED*** by --allow-hosts

 

Couldn't find index page for 'ZenPacks.community.SQLDataSource' (maybe misspelled?)

 

Link to http://pypi.python.org/simple/ ***BLOCKED*** by --allow-hosts

 

No local packages or download links found for ZenPacks.community.SQLDataSource>=2.0

Couldn't find index page for 'ZenPacks.community.SQLDataSource' (maybe misspelled?)

No local packages or download links found for ZenPacks.community.SQLDataSource>=2.0

ERROR:zen.ZenPackCmd:zenpack command failed

Traceback (most recent call last):

  File "/usr/local/zenoss/zenoss/Products/ZenUtils/zenpack.py", line 406, in <module>

    zp.run()

  File "/usr/local/zenoss/zenoss/Products/ZenUtils/zenpack.py", line 134, in run

    previousVersion= self.options.previousVersion)

  File "/usr/local/zenoss/zenoss/Products/ZenUtils/ZenPackCmd.py", line 240, in InstallEggAndZenPack

    zpDists = InstallEgg(dmd, eggPath, link=link)

  File "/usr/local/zenoss/zenoss/Products/ZenUtils/ZenPackCmd.py", line 303, in InstallEgg

    DoEasyUninstall(eggPath)

  File "/usr/local/zenoss/zenoss/Products/ZenUtils/ZenPackCmd.py", line 891, in DoEasyUninstall

    easy_install.main(args)

  File "/usr/local/zenoss/python/lib/python2.6/site-packages/setuptools-0.6c11-py2.6.egg/setuptools/command/easy_install.py", line 1712, in main

    with_ei_usage(lambda:

  File "/usr/local/zenoss/python/lib/python2.6/site-packages/setuptools-0.6c11-py2.6.egg/setuptools/command/easy_install.py", line 1700, in with_ei_usage

    return f()

  File "/usr/local/zenoss/python/lib/python2.6/site-packages/setuptools-0.6c11-py2.6.egg/setuptools/command/easy_install.py", line 1716, in <lambda>

    distclass=DistributionWithoutHelpCommands, **kw

  File "/usr/local/zenoss/python/lib/python2.6/distutils/core.py", line 152, in setup

    dist.run_commands()

  File "/usr/local/zenoss/python/lib/python2.6/distutils/dist.py", line 975, in run_commands

    self.run_command(cmd)

  File "/usr/local/zenoss/python/lib/python2.6/distutils/dist.py", line 995, in run_command

    cmd_obj.run()

  File "/usr/local/zenoss/python/lib/python2.6/site-packages/setuptools-0.6c11-py2.6.egg/setuptools/command/easy_install.py", line 211, in run

    self.easy_install(spec, not self.no_deps)

  File "/usr/local/zenoss/python/lib/python2.6/site-packages/setuptools-0.6c11-py2.6.egg/setuptools/command/easy_install.py", line 427, in easy_install

    return self.install_item(None, spec, tmpdir, deps, True)

  File "/usr/local/zenoss/python/lib/python2.6/site-packages/setuptools-0.6c11-py2.6.egg/setuptools/command/easy_install.py", line 478, in install_item

    self.process_distribution(spec, dist, deps)

  File "/usr/local/zenoss/python/lib/python2.6/site-packages/setuptools-0.6c11-py2.6.egg/setuptools/command/easy_install.py", line 519, in process_distribution

    [requirement], self.local_index, self.easy_install

  File "/usr/local/zenoss/python/lib/python2.6/site-packages/setuptools-0.6c11-py2.6.egg/pkg_resources.py", line 563, in resolve

    dist = best[req.key] = env.best_match(req, self, installer)

  File "/usr/local/zenoss/python/lib/python2.6/site-packages/setuptools-0.6c11-py2.6.egg/pkg_resources.py", line 799, in best_match

    return self.obtain(req, installer) # try and download/install

  File "/usr/local/zenoss/python/lib/python2.6/site-packages/setuptools-0.6c11-py2.6.egg/pkg_resources.py", line 811, in obtain

    return installer(requirement)

  File "/usr/local/zenoss/python/lib/python2.6/site-packages/setuptools-0.6c11-py2.6.egg/setuptools/command/easy_install.py", line 434, in easy_install

    self.local_index

  File "/usr/local/zenoss/python/lib/python2.6/site-packages/setuptools-0.6c11-py2.6.egg/setuptools/package_index.py", line 475, in fetch_distribution

    return dist.clone(location=self.download(dist.location, tmpdir))

AttributeError: 'NoneType' object has no attribute 'clone'

 

[/code]

 

Could someone please help me install this additionally?

 

Thanks!

  • kerickson ZenossEmployee 75 posts since
    Sep 14, 2009
    Currently Being Moderated
    1. Jul 6, 2012 10:01 AM (in response to Kaya Saman)
    Re: ZenPacks for monitoring SQL queries

    Most likely you can run the Nagios checks directly from within Zenoss. See docs/DOC-2514 for a writeup.

  • kerickson ZenossEmployee 75 posts since
    Sep 14, 2009
    Currently Being Moderated
    3. Jul 6, 2012 10:40 AM (in response to Kaya Saman)
    Re: ZenPacks for monitoring SQL queries

    Please search "zenoss nagios plugin guide".

  • bigegor ZenossMaster 208 posts since
    Apr 23, 2009
    Currently Being Moderated
    4. Jul 7, 2012 3:32 PM (in response to Kaya Saman)
    Re: ZenPacks for monitoring SQL queries

    Hi Kaya,

     

    --CUT from docs/DOC-3392 Start--

    REQUIREMENTS:

         Zenoss Version: 2.5, 3.0

         ZenPack Dependencies: SQL Data Source

         External Dependencies:

         Installation:

    --End--

     

    It means you must install SQL Data Source ZenPack first.

More Like This

  • Retrieving data ...

Legend

  • Correct Answers - 4 points
  • Helpful Answers - 2 points