Nagios storing data into PostgreSQL?

[larry johnson]

Thanks a lot both of you. I will try to use event handlers to fill stats in
PostgreSQL.
I also wonder whether is possible to write monitoring data (from nagios.log
?) into external database (MySQL or PostgreSQL)?
External db implies a base on a remote computer reachable over VPN.

Regards!

On Wed, Feb 9, 2011 at 12:23 AM, Mike Lindsey <mike-nagios at 5dninja.net>wrote:

>  Another potential option is setting ups a 'postgres' contact, with a
> custom notification command.  Pass the data you want to store, to the
> notification command, and let that dump the data to the database.
>
> This can potentially be as simple as a bash script that takes the input,
> builds a sql statement and echos it to the postgresql client binary.
>
>
> On 2/8/11 3:13 PM, Michael Friedrich wrote:
>
> On 07.02.2011 22:49, larry johnson wrote:
>
> Hello, i am newbie to linux/Nagios and need help to clear some doubts.
> I wander whether is possible to make Nagios writing notification (host
> up/host down, for example) into PostgreSQL database?
>
>
> if you write your own NEB broker module, and put that onto libpq or
> similar, the core will be able to, sure. Or you'll have a look at Icinga
> IDOUtils which support Postgresql quite a while now.
>
>  I found NDOUtils, but this addon does not suit me because i don't use
> MySQL.
>
>
> Well there aren't that much alternatives to that. Merlin supports MySQL and
> Oracle (in development on git). I'm not sure if the Centreon Broker is
> already released which *should* support more RDBMS.
>
> But for notifications only, why not using event handlers? then you could
> call scripts putting data into your rdbms the preferred way.
> http://nagios.sourceforge.net/docs/3_0/eventhandlers.html
>
> kind regards,
> Michael
>
>  Also found that this kind of storage is suported under Nagios 1.x, but
> what about 3.x?
> I run Nagios 3.2.3 (with 1.4.15 plugins) on openSUSE 11.3.
>
> Regards.**
>
>  Mike Lindsey
>
>
>
> ------------------------------------------------------------------------------
> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
> Pinpoint memory and threading errors before they happen.
> Find and fix more than 250 security defects in the development cycle.
> Locate bottlenecks in serial and parallel code that limit performance.
> http://p.sf.net/sfu/intel-dev2devfeb
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version (-v) and OS when
> reporting any issue.
> ::: Messages without supporting info will risk being sent to /dev/null
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20110210/5e5c3954/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null