Database access via Nagios

[Michael Friedrich]

-------- 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
> 


-- 
DI (FH) Michael Friedrich
michael.friedrich at univie.ac.at
Tel: +43 1 4277 14359

Vienna University Computer Center
Universitaetsstrasse 7 A-1010 Vienna, Austria

------------------------------------------------------------------------------
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