nagios-mysql upgrade woes!

Lewis Shobbrook lshobbrook at fasttrack.net.au
Tue Feb 1 01:56:25 CET 2005


Hi All,

I finally bit the bullet and upgraded from debian unstable release of
nagios-mysql 1.2 release to 1.3.  No complaints from the nagios init.d
start, nor syslog, but I get persistent errors, of the following...

Error: Could not insert/update status record for program in table
'programstatus' of database 'nagios'

I've double checked the table permissions added the nagios user to the
mysql group, even recereated the table and re-applied mysql permissions,
lock tables rights etc.  The mysql.log appears to show success...

050201 11:51:08     204 Query       LOCK TABLES programstatus WRITE,
hoststatus WRITE, servicestatus WRITE
                    204 Query       DELETE FROM programstatus
                    204 Query       DELETE FROM hoststatus
                    204 Query       DELETE FROM servicestatus
                    204 Query       INSERT INTO programstatus
(last_update,program_start,nagios_pid,daemon_mode,last_command_check,las
t_log_rotation,enable_notifications,execute_service_checks,accept_passiv
e_service_checks,enable_event_handlers,obsess_over_services,enable_flap_
detection,enable_failure_prediction,process_performance_data) VALUES
(FROM_UNIXTIME(1107219068),FROM_UNIXTIME(1107218543),'23373','0',FROM_UN
IXTIME(1107219067),FROM_UNIXTIME(0),'1','1','1','1','0','0','1','0')

Can't view anything via the web console just get ... Error: Could not
read host and service status information!

I am getting email alert notifications.

Anyone have any ideas here?

Thanks in advance.

Lewis Shobbrook Ba.Appl.Sci (Hon's), MCSE
IT Administrator
FastTrack Pty. Ltd.


-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
Tool for open source databases. Create drag-&-drop reports. Save time
by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
Download a FREE copy at http://www.intelliview.com/go/osdn_nl
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null





More information about the Users mailing list