I've a similar problem after upgrade mysql server, I get:
nagios: Error: Could not insert/update status record for program in table 'programstatus' of database 'nagios'
Lookin into mysql.log I see:
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')
If I execute this sql query from comman line I get:
mysql> 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(1105433780),FROM_UNIXTIME(1105433780),'8225','0',FROM_UNIXTIME(0),FROM_UNIXTIME(0),'1','1','1','1','0','0','1','0')
-> ;
ERROR 1048: Column 'last_command_check' cannot be null
I've debian testing up to date.
Regards.
-- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
