Upgrade Centreon 2.7

[joschi99]

Upgrade Centreon 2.7

[joschi99]

On existing system check the tables centreon.timeperiod_exclude_relations and centreon.timeperiod_exclude_relations about possible constraint issues during SQL update script Update-DB-2.6.6_to_2.7.0-RC1.sql:

ALTER TABLE timeperiod_exclude_relations
ADD FOREIGN KEY (timeperiod_id)
REFERENCES timeperiod(tp_id) ON DELETE CASCADE;

ALTER TABLE timeperiod_exclude_relations
ADD FOREIGN KEY (timeperiod_exclude_id)
REFERENCES timeperiod(tp_id) ON DELETE CASCADE;

Remove the unwanted lines with

delete
from timeperiod_exclude_relations
where timeperiod_id not in
(
 select tp_id from timeperiod   
)

and

delete
from timeperiod_include_relations
where timeperiod_id not in
(
 select tp_id from timeperiod   
)

[joschi99]

Central Server

Centreon packages updated with yum.

• Centreon database upgrade
• New widgets installed yum install centreon-widget*
• Widgets upgrade
• Timezone settings checked (user, hosts, general)
• ACL checked
• Centreon settings checked and completed
• Centreon-NagVis module deactivated (at the moment not compatible with centreon 2.7.x)

Poller

Centreon packaged uppdated with yum

• communication between central & poller checked
• config reload/restart checked

[joschi99]

Central server and poller are working at the moment.