Solved

Migrate centreon 2.8 to centreon 23.04

  • 10 September 2023
  • 15 replies
  • 245 views

Badge +3

Hello everyone,

I've installed a new Centreon version 23.04 to replace Centreon 2.8. I'm wondering how I can transfer hosts and services from the old instance to the new one.

I attempted to use Clapi with the following commands: 
1. `./centreon -u admin -p centreon -e > backup.txt` to export the configuration.
2. `scp backup.txt` to copy the exported file.

3. `./centreon -u admin -p centreon -i backup.txt`

However, I'm facing an issue: I can see hosts and services in the parameters, but I'm not able to see the objects to supervise.

Can someone please assist me with this?

icon

Best answer by Laurent 11 September 2023, 11:38

View original

15 replies

Userlevel 6
Badge +19

Hi @Paco you can follow this procedure: https://docs.centreon.com/docs/migrate/migrate-from-3-4/

Badge +3

hi @Laurent 

Thank you for your answer, it help me

I have another issue after upgrading and i don’t know where is the problem

Best regards

 

Userlevel 6
Badge +19

Hi @Paco ,

Edit /usr/share/centreon/www/install/php/Update-2.8.4.php file and execute manually SQL requests.

Then remove it and click on “Refresh”

Badge +3

Hi @Laurent 

I can’t find this path “ /usr/share/centreon/www/install/php/Update-2.8.4.php “ in the new centreon 23.04.

I don’t have the folder “install”.

Best regards

Userlevel 6
Badge +19

Hi @Paco if you don’t have the /usr/share/centreon/www/install on your new Centreon server (23.04.x), it means that you finished the update.

Badge +3

Thank you @Laurent 

I want to share with you “sql-error.log” me be you can help me to unlook this issue

Best regards

 

 

 

Userlevel 6
Badge +19

HI @Paco can you execute this SQL request on ‘centreon’ database:

ALTER TABLE `auth_ressource` ADD COLUMN `ar_sync_base_date` INT(11) DEFAULT 0

 

Badge +3

Hi @Laurent 

I have the same problem after applied ALTER TABLE `auth_ressource` ADD COLUMN `ar_sync_base_date` INT(11) DEFAULT 0

 

 

 

Userlevel 6
Badge +19

It will be hard to migrate from Centreon 2.8.2 to supported version.

How many host and services do you monitor?

Badge +3

I have 321 hosts and 324 services

I use only the Ping at the moment 

 

Userlevel 6
Badge +19

Maybe you can export host, hosttemplates, services, servicetemplates, commands, groups and timeperiods using CLAPI and import them into your new Centreon.

 

Badge +3

Hi @Laurent 

I don’t know clapi very well, I can export one user, service or all configuration but for export all users I can’t find the command in the documentation.

Have you one command for example ?

 

Best regards 

Userlevel 6
Badge +19

Hi @Paco you can find information here: https://docs.centreon.com/docs/api/clapi/#export

Badge +3

Thank you @Laurent 

I used clapi to export/import hosts and services,

everything woks very well 

Userlevel 6
Badge +19

Great job @Paco !

Reply