Database access via Nagios

[Mohammed Murphy]

Marc, Max, Michael et al,

Thank very much. The information and help has been invaluable.

Michael Friedrich wrote:
> -------- Original Message  --------
> Subject: Re: [Nagios-devel] Database access via Nagios
> From: Mohammed Murphy <mohammed.murphy at tandberg.com>
> To: Nagios Developers List <nagios-devel at lists.sourceforge.net>
> Date: 2010-03-16 17:26
>
>   
>> Thanks. I will take a look into the Event Broker stuff.
>>
>> But just out of interest, does anyone know how the NINJA and NBOARD web 
>> front-ends access stored Nagios data?
>>     
>
> Ninja is based on Merlin, which is an event broker module just like NDOUtils.
> Merlin uses the libdbi as rdbms abstraction layer, just like IDOUtils do. NDOUtils currently depend on mysql.h with no direct abstraction layer.
>
> libdbi is capable of adding mysql, postgres, mssql as libdbi-drivers. Oracle support is broken which is why IDOUtils use ocilib as Oracle abstraction layer.
> Furthermore the api of libdbi is a bit unstable, and does not support several features just like prepared statements.
>
> To answer your question, Merlin supports MySQL, regarding Postgres I haven't look at non-sql-standard queries. But by chance you will get that supported too.
>
> And well - if you try to support different RDBMS within your application, it will get tricky. If it's in C drop me an email off-list - I think there might be some coding hints availaible in other 
> locations.
>
> Kind regards,
> Michael
>
>
>
>   
>> This might give me a clue as to how to best tackle this task.
>>
>> Thanks again in advance.
>>
>> Marc Powell wrote:
>>     
>>> On Tue, Mar 16, 2010 at 8:58 AM, Mohammed Murphy 
>>> <mohammed.murphy at tandberg.com <mailto:mohammed.murphy at tandberg.com>> 
>>> wrote:
>>>
>>>      I need a way of accessing the underlying database
>>>     without actually knowing what it is. So the question is, does Nagios
>>>     have some library or functionality to cope with this scenario?
>>>
>>>
>>> Nagios provides an Event Broker interface that allows you to hook into 
>>> nagios using a generic interface but does not provide any kind of 
>>> database abstraction layer. That's up to you to create or find. 
>>> Depending on what your requirements are, the Event Broker API may suit 
>>> your needs. You can look at NDOUtils as an example of it's use.
>>>
>>> I'm not aware of any database agnostic libraries. Even on the surface, 
>>> every database is different and would require some difference in the 
>>> methods to access and talk to it so you going to have to have *some* 
>>> awareness of the databases that you'll be taking to and be able to 
>>> support them.
>>>
>>> -- 
>>> Marc
>>> formerly marc /at/ ena.com <http://ena.com>
>>> ------------------------------------------------------------------------
>>>
>>> ------------------------------------------------------------------------------
>>> Download Intel® Parallel Studio Eval
>>> Try the new software tools for yourself. Speed compiling, find bugs
>>> proactively, and fine-tune applications for parallel performance.
>>> See why Intel Parallel Studio got high marks during beta.
>>> http://p.sf.net/sfu/intel-sw-dev
>>> ------------------------------------------------------------------------
>>>
>>> _______________________________________________
>>> Nagios-devel mailing list
>>> Nagios-devel at lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/nagios-devel
>>>   
>>>       
>> ------------------------------------------------------------------------------
>> Download Intel® Parallel Studio Eval
>> Try the new software tools for yourself. Speed compiling, find bugs
>> proactively, and fine-tune applications for parallel performance.
>> See why Intel Parallel Studio got high marks during beta.
>> http://p.sf.net/sfu/intel-sw-dev
>> _______________________________________________
>> Nagios-devel mailing list
>> Nagios-devel at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/nagios-devel
>>
>>     
>
>
>   


------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev