Hello All,
First attempt at creating Icinga binary with IDOUtils; got
the basic Icinga working now trying for the tricky bit !
Below is the last few command prior to running the sql they
worked correct ie no errors.
Then loaded Midnight Commander and searched mysql.sql for
timedevents_i_id_idx and only found the one entry.
Included is the mysql code around the searched area.
Thoughts / fixes?
Many Thanks for the help.
[r...@centos ~]# cd /usr/src/icinga-1.2.1/module/idoutils/db/mysql
[r...@centos mysql]# /etc/init.d/mysqld start
Starting MySQL: [ OK ]
[r...@centos mysql]# mysql -u root -p icinga < mysql.sql
Enter password:
ERROR 1061 (42000) at line 1389: Duplicate key name
'timedevents_i_id_idx'
[r...@centos mysql]#
[r...@centos mysql]# mc
========================================================================
==============
mysql.sql [----] 13 L:[1373+16 1389/1559] *(62090/72042b)= t
116 0x74
PRIMARY KEY (`timeperiod_timerange_id`),
UNIQUE KEY `instance_id` (`timeperiod_id`,`day`,`start_sec`,`end_sec`)
) ENGINE=InnoDB COMMENT='Timeperiod definitions';
-- -----------------------------------------
-- add index (delete)
-- -----------------------------------------
-- for periodic delete
-- instance_id and
-- TIMEDEVENTS => scheduled_time
-- SYSTEMCOMMANDS, SERVICECHECKS, HOSTCHECKS, EVENTHANDLERS =>
start_time
-- EXTERNALCOMMANDS => entry_time
-- instance_id
CREATE INDEX timedevents_i_id_idx on icinga_timedevents(instance_id);
CREATE INDEX timedeventq_i_id_idx on
icinga_timedeventqueue(instance_id);
CREATE INDEX systemcommands_i_id_idx on
icinga_systemcommands(instance_id);
CREATE INDEX servicechecks_i_id_idx on
icinga_servicechecks(instance_id);
CREATE INDEX hostchecks_i_id_idx on icinga_hostchecks(instance_id);
CREATE INDEX eventhandlers_i_id_idx on
icinga_eventhandlers(instance_id);
CREATE INDEX externalcommands_i_id_idx on
icinga_externalcommands(instance_id);
-- time
CREATE INDEX timedevents_time_id_idx on
icinga_timedevents(scheduled_time);
CREATE INDEX timedeventq_time_id_idx on
icinga_timedeventqueue(scheduled_time);
CREATE INDEX systemcommands_time_id_idx on
icinga_systemcommands(start_time);
CREATE INDEX servicechecks_time_id_idx on
icinga_servicechecks(start_time);
CREATE INDEX hostchecks_time_id_idx on icinga_hostchecks(start_time);
CREATE INDEX eventhandlers_time_id_idx on
icinga_eventhandlers(start_time);
CREATE INDEX externalcommands_time_id_idx on
icinga_externalcommands(entry_time);
-- for starting cleanup - referenced in dbhandler.c:882
-- instance_id only
-- realtime data
CREATE INDEX programstatus_i_id_idx on
icinga_programstatus(instance_id);
CREATE INDEX hoststatus_i_id_idx on icinga_hoststatus(instance_id);
CREATE INDEX servicestatus_i_id_idx on
icinga_servicestatus(instance_id);
CREATE INDEX contactstatus_i_id_idx on
icinga_contactstatus(instance_id);
CREATE INDEX timedeventqueue_i_id_idx on
icinga_timedeventqueue(instance_id);
CREATE INDEX comments_i_id_idx on icinga_comments(instance_id);
CREATE INDEX scheduleddowntime_i_id_idx on
icinga_scheduleddowntime(instance_id);
1Help 2Save 3Mark 4Replac 5Copy 6Move 7Search 8Delete 9PullDn
10Quit
========================================================================
==============
Many Thanks
Kind Regards
Terry M. Fake
* VOIP Phone Systems * Firewalls
* UPS Power Protection
* MINDER Business * Competitive Information * AVG
Antivirus Software
Software Systems
<<image001.jpg>>
------------------------------------------------------------------------------ Increase Visibility of Your 3D Game App & Earn a Chance To Win $500! Tap into the largest installed PC base & get more eyes on your game by optimizing for Intel(R) Graphics Technology. Get started today with the Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs. http://p.sf.net/sfu/intelisp-dev2dev
_______________________________________________ icinga-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/icinga-users
