search

centreon / centreon-archived

Centreon is a network, system and application monitoring tool. Centreon is the only AIOps Platform Providing Holistic Visibility to Complex IT Workflows from Cloud to Edge.
https://www.centreon.com
GNU General Public License v2.0
574 stars 240 forks source link

Upgrade from Centreon 2.8.26 to 18.10 #7298

Closed burncycl closed 5 years ago

burncycl commented 5 years ago

BUG REPORT INFORMATION

Prerequisites

Versions

[root@Master-AWS_us-east-1 ~]# rpm -qa | grep centreon
centreon-common-18.10.3-5.el7.centos.noarch
centreon-trap-18.10.3-5.el7.centos.noarch
centreon-connector-perl-18.10.0-2.el7.centos.x86_64
centreon-web-18.10.3-5.el7.centos.noarch
centreon-widget-live-top10-cpu-usage-18.10.0-6.el7.centos.noarch
centreon-plugin-Network-Cisco-Standard-Snmp-20190221-145606.el7.centos.noarch
centreon-plugin-Applications-Protocol-Ldap-20190221-145606.el7.centos.noarch
centreon-widget-hostgroup-monitoring-18.10.0-6.el7.centos.noarch
centreon-plugin-Hardware-Printers-Generic-Snmp-20190221-145606.el7.centos.noarch
centreon-release-18.10-2.el7.centos.noarch
centreon-engine-daemon-18.10.0-4.el7.centos.x86_64
centreon-broker-cbd-18.10.1-1.el7.centos.x86_64
centreon-widget-engine-status-18.10.0-9.el7.centos.noarch
centreon-broker-influxdb-18.10.1-1.el7.centos.x86_64
centreon-broker-storage-18.10.1-1.el7.centos.x86_64
centreon-perl-libs-18.10.3-5.el7.centos.noarch
centreon-broker-cbmod-18.10.1-1.el7.centos.x86_64
centreon-connector-ssh-18.10.0-2.el7.centos.x86_64
centreon-license-manager-common-18.10.2-1.el7.centos.noarch
centreon-base-config-centreon-engine-18.10.3-5.el7.centos.noarch
centreon-widget-service-monitoring-18.10.2-1.el7.centos.noarch
centreon-widget-global-health-18.10.0-8.el7.centos.noarch
centreon-plugin-Applications-Monitoring-Centreon-Central-20190221-145606.el7.centos.noarch
centreon-plugin-Applications-Protocol-Http-20190221-145606.el7.centos.noarch
centreon-plugin-Applications-Databases-Mysql-20190221-145606.el7.centos.noarch
centreon-plugin-Applications-Protocol-Ftp-20190221-145606.el7.centos.noarch
centreon-plugin-Operatingsystems-Windows-Snmp-20190221-145606.el7.centos.noarch
centreon-plugin-Applications-Monitoring-Centreon-Map4-Jmx-20190221-145606.el7.centos.noarch
centreon-broker-core-18.10.1-1.el7.centos.x86_64
centreon-widget-live-top10-memory-usage-18.10.0-6.el7.centos.noarch
centreon-widget-graph-monitoring-18.10.0-6.el7.centos.noarch
centreon-plugin-Operatingsystems-Linux-Snmp-20190221-145606.el7.centos.noarch
centreon-plugin-Applications-Monitoring-Centreon-Poller-20190221-145606.el7.centos.noarch
centreon-clib-18.10.0-2.el7.centos.x86_64
centreon-engine-extcommands-18.10.0-4.el7.centos.x86_64
centreon-connector-18.10.0-2.el7.centos.x86_64
centreon-license-manager-18.10.2-1.el7.centos.noarch
centreon-widget-servicegroup-monitoring-18.10.0-6.el7.centos.noarch
centreon-plugin-Applications-Protocol-Dns-20190221-145606.el7.centos.noarch
centreon-plugin-Applications-Monitoring-Centreon-Database-20190221-145606.el7.centos.noarch
centreon-broker-18.10.1-1.el7.centos.x86_64
centreon-engine-18.10.0-4.el7.centos.x86_64
centreon-poller-centreon-engine-18.10.3-5.el7.centos.noarch
centreon-pp-manager-18.10.4-1.el7.centos.noarch
centreon-widget-host-monitoring-18.10.1-1.el7.centos.noarch
centreon-plugin-Hardware-Ups-Standard-Rfc1628-Snmp-20190221-145606.el7.centos.noarch

Operating System

[root@Master-AWS_us-east-1 etc]# rpm -q centos-release centos-release-7-6.1810.2.el7.centos.x86_64

Linux Master-AWS_us-east-1.centreon.cloud.webroot.com 3.10.0-693.21.1.el7.x86_64 #1 SMP Wed Mar 7 19:03:37 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux

AWS EC2 Environment

Description

Upgrade from 2.8.26 to 18.10 during GUI install of Database.

createTables.sql Line 20:Cannot execute query : CREATE TABLE `acl_actions` ( `acl_action_id` int(11) NOT NULL AUTO_INCREMENT, `acl_action_name` varchar(255) DEFAULT NULL, `acl_action_description` varchar(255) DEFAULT NULL, `acl_action_activate` enum('0','1','2') DEFAULT NULL, PRIMARY KEY (`acl_action_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Reference Screenshot: https://burncycl.net/for_github/2019-03-18_centreon_database_upgrade.png

Steps to Reproduce

Upgrade Centreon from 2.8.26 to 18.10

systemctl stop cbd
systemctl stop centengine
yum remove centreon
yum install centos-release-scl -y
wget http://yum.centreon.com/standard/18.10/el7/stable/noarch/RPMS/centreon-release-18.10-2.el7.centos.noarch.rpm -O /tmp/centreon-release-18.10-2.el7.centos.noarch.rpm
yum -y install --nogpgcheck /tmp/centreon-release-18.10-2.el7.centos.noarch.rpm
yum clean all
yum update centreon*
echo "date.timezone = Europe / Paris"> /etc/opt/rh/rh-php71/php.d/php-timezone.ini
systemctl enable rh-php71-php-fpm
systemctl start rh-php71-php-fpm
systemctl stop mysqld
yum update
systemctl daemon-reload
systemctl start mysqld
systemctl status mysqld
systemctl restart httpd
systemctl restart cbd
systemctl restart centengine

Describe the received result

Error

createTables.sql Line 20:Cannot execute query : CREATE TABLE `acl_actions` ( `acl_action_id` int(11) NOT NULL AUTO_INCREMENT, `acl_action_name` varchar(255) DEFAULT NULL, `acl_action_description` varchar(255) DEFAULT NULL, `acl_action_activate` enum('0','1','2') DEFAULT NULL, PRIMARY KEY (`acl_action_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Reference Screenshot: https://burncycl.net/for_github/2019-03-18_centreon_database_upgrade.png

Describe the expected result

Cleanly upgrades Centreon Database.

adr-mo commented 5 years ago

Hi @burncycl,

Thanks for the feedback :100:

Your screenshot shows an installation step error not an upgrade.

The issue might be related to the line yum remove centreon

What is this line for ?

Regards,

adr-mo commented 5 years ago

Hi @burncycl,

Your issue might be related to this issue https://github.com/centreon/centreon/issues/7317

The 18.10.4 has been released could you try to do the update again it should work now.

If it is the case, I'll close this issue.

Regards,

burncycl commented 5 years ago

Resolved with fix. Thanks.