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
> To: Nagios Developers List
> 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
>>> >
>>> 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
>>> ------------------------------------------------------------------------
>>>
>>> ------------------------------------------------------------------------------
>>> 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
>>> [email protected]
>>> https://lists.sourceforge.net/lists/lis ... gios-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
>> [email protected]
>> https://lists.sourceforge.net/lists/lis ... gios-devel
>>
>>
>
>
>
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]