<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">Hello All,<DIV><BR class="khtml-block-placeholder"></DIV><DIV>I am trying to get Nagios V1.3 to write its status data to a MySql database but am not yet quite there.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>So far i have created the database 'nagios' and understand from the manual that you must create the <FONT class="Apple-style-span" face="Arial" size="3"><SPAN class="Apple-style-span" style="font-size: 13px;">three tables (named </SPAN></FONT><FONT class="Apple-style-span" face="Arial" size="3"><SPAN class="Apple-style-span" style="font-size: 13px;"><B>programstatus</B></SPAN></FONT><FONT class="Apple-style-span" face="Arial" size="3"><SPAN class="Apple-style-span" style="font-size: 13px;">, </SPAN></FONT><FONT class="Apple-style-span" face="Arial" size="3"><SPAN class="Apple-style-span" style="font-size: 13px;"><B>hoststatus</B></SPAN></FONT><FONT class="Apple-style-span" face="Arial" size="3"><SPAN class="Apple-style-span" style="font-size: 13px;">, and </SPAN></FONT><FONT class="Apple-style-span" face="Arial" size="3"><SPAN class="Apple-style-span" style="font-size: 13px;"><B>servicestatus</B></SPAN></FONT><FONT class="Apple-style-span" face="Arial" size="3"><SPAN class="Apple-style-span" style="font-size: 13px;">)</SPAN><FONT class="Apple-style-span" face="Helvetica"> but what are the fields?? This does not seem to be covered in the manual.</FONT></FONT></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>I have created the 3 tables with a single field (testing) in the hope the nagios would define the tables itself but no luck.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>At the moment my nagios.log looks like this;</DIV><DIV>----------------------------------------------------------------------------------------------------------------------------------------------------------</DIV><DIV>[1140474946] Nagios 1.3 starting... (PID=19392)</DIV><DIV>[1140474946] Finished daemonizing... (New PID=19393)</DIV><DIV>[1140474946] Error: Could not insert/update status record for program in table 'programstatus' of database 'nagios'</DIV><DIV>[1140474961] Error: Could not insert/update status record for program in table 'programstatus' of database 'nagios'</DIV><DIV>----------------------------------------------------------------------------------------------------------------------------------------------------------</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>If anyone knows what the fields should be or what to do next that would be great.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Many Thanks,</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Stephen Joy.</DIV></BODY></HTML>