Re: NASA needs Postgres - Nagios help

From the roll-your-own side, have you looked at an alternative Nagios
event broker called livestatus? It's written by Matthias Kettner as part
of his client-centric mk-check Nagios plugin suite.

At the moment it only brokers live data (hence livestatus), but it is
intended to replace NDO as the general event broker. You can read from
the socket and do whatever you want with the data...

http://mathias-kettner.de/checkmk_livestatus.html
http://nagios.larsmichelsen.com/mklivestatus-and-nagvis-making-the-ndo-needless/

On 2010-07-19 12:23:41PM -0700, Sean E. Connolly wrote:
>
>
> > NODutils however has no real working support for PostgreSQL, IDOutils (which I
> >mentioned elsewhere in the thread) from the icinga fork does have basic support.
>
> >The SQL queries used in NDOUtils are highly MySQL specific, mostly the ON
> >DUPLICATE KEY functionality based on unique constraints is a bunch of work to be
> >resolved. Next to that, the "normal" insert statements are not normalized
> >(insert into ... set >foo=bar instead of insert into ... () values ()), some
> >missing time conversion procedures and naturally the last insert id on MySQL,
> >which needs an adaption on sequences in Postgresql and Oracle.
>
> Fine, so there will be a lot of boring modifying of the src and associated
> scripts (if the license permits), but "Not Supported" doesn't mean it can't be
> done. It all depends on how much hacking one wants to do.
>
>
> >Which means, just by changing the .sql files and the column attributes, this
> >won't work. Not even the connection will happen since there is no C source code
> >for that available via #ifdef.
>
> Maybe I am reading it wrong, but nagios/ndoutils-1.4b9/src/db.c is loaded with
> #ifdef USE_PGSQL connection functions. Some of the PGSQL specific functions in
> ndo2db.c are commented out, but are at least there.
>
> Sean
>
>
>
>

--
===========================================================
Peter C. Lai | Bard College at Simon's Rock
Systems Administrator | 84 Alford Rd.
Information Technology Svcs. | Gt. Barrington, MA 01230 USA
peter AT simons-rock.edu | (413) 528-7428
===========================================================