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