Installation problems

[Ben Butler]

Hi,

I am having a few problems get Nagios up and running on a Debian box with
MySQL.  Software was installed using APT.

I have successfully got the web interface setup, database schema created, it
logging data to SQL and when clicking on a CGI item in the web interface it
issues a select statement to MySQL.

What I am finding puzzling is the below debug from MySQL.

Why is it deleting all existing row data from these three tables prior to
inserting the new data.  Surely this can not be the correct behaviour?

Kind Regards

Ben
                     45 Query       UNLOCK TABLES
050322 12:37:27      45 Query       LOCK TABLES programstatus WRITE,
hoststatus WRITE, servicestatus WRITE
                     45 Query       DELETE FROM programstatus
                     45 Query       DELETE FROM hoststatus
                     45 Query       DELETE FROM servicestatus
                     45 Query       INSERT INTO programstatus
(last_update,program_start,nagios_pid,daemon_mode,last_command_check,last_lo
g_rotation,enable_notifications,execute_service_checks,accept_passive_servic
e_checks,enable_event_handlers,obsess_over_services,enable_flap_detection,en
able_failure_prediction,process_performance_data) VALUES
(FROM_UNIXTIME(1111495047),FROM_UNIXTIME(1111490022),'1041','1',FROM_UNIXTIM
E(1111495046),FROM_UNIXTIME(0),'1','1','1','1','0','0','1','0')
                     45 Query       INSERT INTO hoststatus
(host_name,host_status,last_update,last_check,last_state_change,problem_ackn
owledged,time_up,time_down,time_unreachable,last_notification,current_notifi
cation,notifications_enabled,event_handler_enabled,checks_enabled,flap_detec
tion_enabled,is_flapping,percent_state_change,scheduled_downtime_depth,failu
re_prediction_enabled,process_performance_data,plugin_output) VALUES
('gw','UP',FROM_UNIXTIME(1111495047),FROM_UNIXTIME(1111490322),FROM_UNIXTIME
(1111490322),'0','0','0','0',FROM_UNIXTIME(0),'0','1','0','1','0','0','0.000
000','0','1','1','\(Host assumed to be up\)')
                     45 Query       INSERT INTO servicestatus
(host_name,service_description,service_status,last_update,current_attempt,ma
x_attempts,state_type,last_check,next_check,should_be_scheduled,check_type,c
hecks_enabled,accept_passive_checks,event_handler_enabled,last_state_change,
problem_acknowledged,last_hard_state,time_ok,time_warning,time_unknown,time_
critical,last_notification,current_notification,notifications_enabled,latenc
y,execution_time,flap_detection_enabled,is_flapping,percent_state_change,sch
eduled_downtime_depth,failure_prediction_enabled,process_performance_data,ob
sess_over_service,plugin_output) VALUES
('gw','PING','OK',FROM_UNIXTIME(1111495047),'1','3','HARD',FROM_UNIXTIME(111
1494739),FROM_UNIXTIME(1111495039),'1','ACTIVE','1','0','0',FROM_UNIXTIME(11
11490322),'0','OK','0','0','0','0',FROM_UNIXTIME(0),'0','0','0','4','0','0',
'0.000000','0','1','1','1','PING OK - Packet loss = 0%, RTA = 2\.41 ms')

Kind Regards

Ben Butler
++++++++++++++++++++++++++++++++++++++
C2 Internet Ltd
Alvaston House
Alvaston Business Park
Nantwich
Cheshire
CW5 6PF
W http://www.c2internet.net/
T +44-(0)845-658-0020
F +44-(0)845-658-0070

All quotes & services from C2 are bound by our standard terms and conditions
which are available on our website at:

http://www.c2internet.net/legal/main.htm#tandc



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
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