hi antonio, On Tue, Jan 11, 2005 at 12:42:06PM +0100, Antonio J. Torres wrote: > I've a similar problem after upgrade mysql server, I get: > > INSERT INTO programstatus > (last_update,program_start,nagios_pid,daemon_mode,last_command_check,last_log_rotation,enable_notifications,execute_service_checks,accept_passive_service_checks,enable_event_handlers,obsess_over_services,enable_flap_detection,enable_failure_prediction,process_performance_data) > > VALUES > (FROM_UNIXTIME(1105433795),FROM_UNIXTIME(1105433780),'8225','0',FROM_UNIXTIME(1105433794),FROM_UNIXTIME(0),'1','1','1','1','0','0','1','0')
from what i've read, the problem is that in the latest version of mysql-server, the behavior of FROM_UNIXTIME() has changed, which is what's causing this problem. there were two suggestions i made to phillip (downgrading and trying the nagios-mysql on my p.d.o page), could you try both of them and let us know if they work? sean --
signature.asc
Description: Digital signature