NDO increase nagios_servicechecks/output size

[Gerd Mueller]

Already mentioned inside the TODO File :-)

1.  Change fields of type VARCHAR(255) to BLOBs.  VARCHAR fields were
    easier for me to debug things as I was developing this addon, but
    several text fields can be longer than 255 chars.  Nagios 3.0
    will allow multi-line plugin output, so this is especially important
    for future compatability.


Cheers Gerd



Am Donnerstag, den 13.09.2007, 15:08 +0200 schrieb Michael Streb:
> correction:
> 
> the same "problem" in:
> 
> nagios_statehistory
> nagios_eventhandlers
> nagios_notifications
> nagios_servicechecks
> nagios_servicestatus
> nagios_systemcommands
> nagios_eventhandlers
> nagios_hostchecks
> nagios_hoststatus
> 
> Regards,
> 
> Michael
> 
> 
> Am 13.09.2007 14:48 Uhr schrieb "Michael Streb" unter <mstreb at netways.de>:
> 
> > Hi Ethan,
> > Hi list,
> > 
> > recently went into problems with the "output" field in the
> > nagios_servicechecks table so i had a deeper look and it turned out that the
> > field size is set to "varchar(255)" only, i think this should be increased
> > to something like "varchar(4096)" to make use of the longer serviceoutput in
> > nagios3x.
> > 
> > I don`t know right now if 4k is the maximum serviceoutput in 3x.
> > 
> > Ethan it`s your turn. :)
> > 
> > Greetings,
> > 
> > Michael
> 
-- 
Gerd Mueller                  NETWAYS GmbH
Senior Systems Engineer       Deutschherrnstr. 47a
Fon. +49 911 92885-0          D-90429 Nuernberg
Fax. +49 911 92885-33              
gmueller at netways.de           http://www.netways.de     

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/