[Pkg-nagios-devel] Bug#289762: nagios-mysql bugs

[Antonio J. Torres]

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.