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! <div class="gmail_quote">On Wed, Feb 9, 2011 at 12:23 AM, Mike Lindsey <<a href="mailto:mike-nagios@5dninja.net">mike-nagios@5dninja.net</a>> wrote: <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"> <div text="#000000" bgcolor="#ffffff"> 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.<div class="im"> On 2/8/11 3:13 PM, Michael Friedrich wrote: <blockquote type="cite"> <tt>On 07.02.2011 22:49, larry johnson wrote:</tt> <blockquote type="cite"><tt>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? </tt></blockquote> <tt> 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. </tt> <blockquote type="cite"><tt>I found NDOUtils, but this addon does not suit me because i don't use MySQL. </tt></blockquote> <tt> 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. <a href="http://nagios.sourceforge.net/docs/3_0/eventhandlers.html" target="_blank">http://nagios.sourceforge.net/docs/3_0/eventhandlers.html</a> kind regards, Michael </tt> <blockquote type="cite"><tt>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.</tt></blockquote> </blockquote> </div><pre cols="72">Mike Lindsey</pre> </div> ------------------------------------------------------------------------------ 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. <a href="http://p.sf.net/sfu/intel-dev2devfeb" target="_blank">http://p.sf.net/sfu/intel-dev2devfeb</a> _______________________________________________ Nagios-users mailing list <a href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net</a> <a href="https://lists.sourceforge.net/lists/listinfo/nagios-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagios-users</a> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null </blockquote></div>