RE: [Nagios-users] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Joy Sent: Tuesday, 21 February 2006 11:46 a.m. To: nagios-users@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.