MySql Status Data

[Steve Shipway]

I have uploaded to www.nagiosexchange.org a utility (in Perl) that will
regularly eat an archived Nagios log file from Nagios 1.x and install it
into a mysql database for subsequent reporting.  We're using it here in
beta.  Feel free to download it and try it, or modify for your own use.
 
You can get the documentation on the fields in the .log file from the
developer section of the nagios website.  Note that the .log file format
changes in Nagios 2.0 (an extra field was added)
 
Steve


  _____  

From: nagios-users-admin at lists.sourceforge.net
[mailto:nagios-users-admin at lists.sourceforge.net] On Behalf Of Stephen Joy
Sent: Tuesday, 21 February 2006 11:46 a.m.
To: nagios-users at lists.sourceforge.net
Subject: [Nagios-users] MySql Status Data


Hello All, 

I am trying to get Nagios V1.3 to write its status data to a MySql database
but am not yet quite there.

So far i have created the database 'nagios' and understand from the manual
that you must create the three tables (named programstatus, hoststatus, and
servicestatus) but what are the fields?? This does not seem to be covered in
the manual.

I have created the 3 tables with a single field (testing) in the hope the
nagios would define the tables itself but no luck.

At the moment my nagios.log looks like this;
----------------------------------------------------------------------------
----------------------------------------------------------------------------
--
[1140474946] Nagios 1.3 starting... (PID=19392)
[1140474946] Finished daemonizing... (New PID=19393)
[1140474946] Error: Could not insert/update status record for program in
table 'programstatus' of database 'nagios'
[1140474961] Error: Could not insert/update status record for program in
table 'programstatus' of database 'nagios'
----------------------------------------------------------------------------
----------------------------------------------------------------------------
--

If anyone knows what the fields should be or what to do next that would be
great.

Many Thanks,

Stephen Joy.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20060221/f9e742f1/attachment.html>