How to update oreon-1.3.3 to oreon-1.4 ?

From Wiki Centreon

We will try to help you in a short tutorial.

• Before you begin, make a backup copy of your actual oreon directory and database:

   $> cp -rp oreon oreon-old

   $> /usr/bin/mysqldump -u root -p oreon > oreon-old.sql

• Download oreon-1.4.tar.gz and copy oreon-1.4.tar.gz to your server. Here we put oreon-1.4.tar.gz in /root

• unzip oreon-1.4.tar.gz :

   $> tar -xvzf oreon-1.4.tar.gz

• launch upgrade script :

   $> cd /root/oreon-1.4
   $>./upgrade.sh

• Answer to all questions for upgrading your version.

• login to mysql, create ods database and create tables :

consider : ods = table for oreon data storage, root = login mysql for root, mysql-password = mysql password, oreon = oreon user mysql.

   $>mysql -u root -p
   mysql> CREATE DATABASE `ods` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
   mysql> GRANT ALL PRIVILEGES ON `ods` . * TO 'oreon'@'localhost'; 
   mysql> exit 
   $> mysql -u root -p -B ods < ./www/install/createTablesODS.sql

• After all this request, add in oreon.conf.php file in www directory of oreon this line :

  $conf_oreon['ods'] = "ods";

juste after

  $conf_oreon['db'] = "oreon";

• create conf file for perl scripts ($oreon/ODS/etc/conf.pm) :

   $mysql_user = "oreon";
   $mysql_passwd = "oreon-pwd";
   $mysql_host = "localhost";
   $mysql_database_oreon = "oreon";
   $mysql_database_ods = "ods";
   1;

• Update Oreon Data Storage configuration

   $>mysql -u root -p
   mysql> use ods
   mysql> update config set nagios_log_file = '/usr/local/nagios/var/nagios.log', `RRDdatabase_path` = '/usr/local/oreon/OreonDataStorage/', `average` = NULL , `drop_file` = '/usr/local/nagios/var/service-perfdata.tmp', `perfdata_file` = '/usr/local/nagios/var/service-perfdata' LIMIT 1;
   mysql> exit

Where /usr/local/nagios/ is nagios installation folder, /usr/local/nagios/var/nagios.log is nagios.log file, etc.

• Install process-service-perfdata file

    $>cp /root/oreon-1.4/Plugins/process-service-perfdata /usr/local/nagios/libexec
    $>dos2unix /usr/local/nagios/libexec/process-service-perfdata

• If your system doesn't recognized dos2unix (on my Debian it was true), type this :

    $>apt-get install sysutils

Now you can go on oreon interface to finish update by web browser.

http://your_oreon_ip/oreon/