Archived community.zenoss.org | full text search
Skip navigation
Up to Discussions in zenoss-zenpacks
2444 Views 5 Replies Latest reply: Jul 9, 2012 7:26 AM by Kaya Saman RSS
Kaya Saman Rank: White Belt
Kaya Saman
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
    kerickson
    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.

  • Kaya Saman Rank: White Belt
    Kaya Saman
    12 posts since
    Jun 6, 2012
    Currently Being Moderated
    2. Jul 6, 2012 10:11 AM (in response to kerickson)
    Re: ZenPacks for monitoring SQL queries

    So does this mean that Zenoss is already supplied with Nagios plugins?

     

    On my system I have a whole bunch:

     

    [code]

    libexec]# ls

    check_apt      check_dhcp      check_dummy     check_http          check_imap    check_load      check_mysql        check_nt        check_oracle  check_real     check_snmp   check_tcp    check_wave

    check_breeze   check_dig       check_file_age  check_icmp          check_ircd    check_log       check_mysql_query  check_ntp       check_overcr  check_rpc      check_spop   check_time   negate

    check_by_ssh   check_disk      check_flexlm    check_ide_smart     check_jabber  check_mailq     check_nagios       check_ntp_peer  check_ping    check_sensors  check_ssh    check_udp    urlize

    check_clamd    check_disk_smb  check_ftp       check_ifoperstatus  check_ldap    check_mrtg      check_nntp         check_ntp_time  check_pop     check_simap    check_ssmtp  check_ups    utils.pm

    check_cluster  check_dns       check_hpjd      check_ifstatus      check_ldaps   check_mrtgtraf  check_nntps        check_nwstat    check_procs   check_smtp     check_swap   check_users  utils.sh

     

    [/code]

     

    which if these are already Nagios plugins makes the transition so much easier!

     

     

    I'm assuming running the checks are similar to the way you would run on Nagios?

     

     

    Thanks.

  • kerickson ZenossEmployee
    kerickson
    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
    bigegor
    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.

  • Kaya Saman Rank: White Belt
    Kaya Saman
    12 posts since
    Jun 6, 2012
    Currently Being Moderated
    5. Jul 9, 2012 7:26 AM (in response to bigegor)
    Re: ZenPacks for monitoring SQL queries

    Thanks, I have installed it.

     

    Now I've just got to figure out how to query the SQL clusters we have (MSSQL and MySQL).

     

    We use additional Perl scripts to monitor things as our Nagios setup is quite complex, so I really need to get a 100% fix for things.

More Like This

  • Retrieving data ...

Legend

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