Re: [PATCH/PULL] New plugin: check_dbi

Hi,

I have a test case, that you may like to test. as well as if your plugin could do this it wud be grt. i have been looking  for a while to do the following:


My Oracle DB server details



operating System: Solaris

database: oracle
IP: 192.168.1.2 (not real ip)


My Nagios Server details
OS : Ubuntu
i have configured nagios 3.x


i connect to my db server from my nagios  as follow:


 ssh -Y [email protected]
Password: xxxxxxxxx
[root@vboxdb /]# su - oracle


Sun Microsystems Inc.   SunOS 5.10      Generic January 2005
[oracle@vboxdb ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed May 30 04:53:48 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production



what i want to do i will list below ;



SQL> select current_utilization, max_utilization, limit_value from v$resource_limit where resource_name =’sessions’;



CURRENT_UTILIZATION   MAX_UTILIZATION     LIMIT_VALUE

——————- —————          ————————-                     ————— 

386                 404                                                1528



if the current utilization reaches 1500 alert critical, 1450 warning state.
else normal.


can you tell me how i can use your plugin to do this. 

by the way i've tried to compile your plugin. but i am getting errors saying common.h not found.

regards
Nashrah




-------------------------------------------------------------------------------------------------------------------------------------------------------

Date: Fri, 8 Jun 2012 11:30:33 +0200
From: [email protected]
To: nagiosplug-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Subject: Re: [Nagiosplug-devel] [PATCH/PULL] New plugin: check_dbi

Hi,
 
On Wed, Jun 06, 2012 at 12:38:42PM +0200, Holger Weiß wrote:
> * Sebastian Harl <[email protected]> [2012-06-06 11:55]:
> > On Fri, Apr 08, 2011 at 11:45:11AM +0200, Sebastian Harl wrote:
> > > The latest version of the plugin can be found at
> > > <http://oss.teamix.org/projects/nagiosplug/repository/entry/plugins/check_dbi.c?rev=sh%2Fcheck_dbi>.
> > > 
> > > I'm looking forward to comments, suggestions and (of course) patches :-)
> > 
> > As there are rumours about a new release, I'd like to point out this new
> > plugin again. Any feedback about whether this is interesting for the
> > nagiosplugins project and/or needs some more work would be appreciated.
> > If you prefer a Github pull request instead, I'd be happy to do that as
> > well.
> 
> While we currently don't have the resources to include many new plugins,
> I think this one _is_ interesting.  At first glance, the code looks fine
> to me.  If you (or someone else) provide some test cases for this
> plugin, and if nobody objects, I'd consider it for inclusion.
 
I've added a few test-cases and opened a pull request on Github. Imho,
that should be used for further comments, objections, etc. ;-)
 
> This won't make it into the upcoming release, but we could probably
> import it right afterwards.
 
Great! :-)
 
Cheers,
Sebastian
 
-- 
Sebastian "tokkee" Harl +++ GnuPG-ID: 0x8501C7FC +++ http://tokkee.org/
 
Those who would give up Essential Liberty to purchase a little Temporary
Safety, deserve neither Liberty nor Safety.         -- Benjamin Franklin
 

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________________
Nagios Plugin Development Mailing List Nagiosplug-devel-5NWGOfrQmneRv+LV9MX5upmplPMkL2fr@public.gmane.orget
Unsubscribe at https://lists.sourceforge.net/lists/listinfo/nagiosplug-devel
::: Please include plugins version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/

_______________________________________________________
Nagios Plugin Development Mailing List Nagiosplug-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Unsubscribe at https://lists.sourceforge.net/lists/listinfo/nagiosplug-devel
::: Please include plugins version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null