Skip to main content

Hello Centreon addicts,

 

We were using Centreon 2.8.32 community edition for about 3 years and were very happy with it to manage our infra, so we decided to buy a License for upgrade to the latest version and use the commercial plugins.

BUT, migration is really not an easy way, I’ve first tried to follow the migration path on Centreon Web Site (https://docs.centreon.com/fr/docs/migrate/migrate-from-3-4/) but we follow a lot of issues with the database that cannot pass the UPGRADE - 22.04.1 step…

Then I tried to use the Export feature on the old one but it stays running for days without evolution, then I decided tu use centreon-clapi -e from command-line, and ther a very enormous file is generated (more than 50GB !!!) but it does not reach the end of the export and fails with that error message:
 A critical diagnostic event occurred in the memory device. Retry operation. <br/>--Novell NMS trap annotation<br/>Variables:<br/>  1: alertSystem<br/>  2: alertTableIndexOID<br/>  3: alertMessage<br/>  4: alertCurrentStatus<br/>  5: alertPreviousStatus<br/>  6: alertData<br/>

The TRAP section contains millions of lines…

How could I export ALL the old Centreon config WITHOUT the TRAP section to get a more convenient export-file I could try to import on the NEW Centreon 24.04.2 Licensed server ?
Or if you have another idea that could help us migrating this Centreon that could help me ?
Thanks a lot for all your great work !

Hello,

You must give more information on your setup, like an idea on number of host/service/….

2.8.32 is very old, I think no one remember of to properly handle this version. (I had one, but I forgot, it’s too old).

If the setup is not very big I will suggest to restart from scratch as the plugins you are using must be not compatible with current OS or language.

I suggest to only export hostname, IP, frequencies, hostgroups,… simples things like that, and and re-do the others from 0.

You will save you a lot of headaches.

Cheers

The setup is quite huge…

Around 500 hosts and 5000 services !
Could really not restart from scratch !

The exact error I get when trying to export ‘SERVICE’ with centreon-clapi is:
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATESHY000]: General error: 2006 MySQL server has gone away' in /usr/share/centreon/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /usr/share/centreon/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /usr/share/centreon/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#2 /usr/share/centreon/lib/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#3 /usr/share/centreon/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT * FROM t...', Array)
#4 /usr/share/centreon/lib/Centreon/Object/Object.php(100): Zend_Db_Adapter_Pdo_Abstract->query('SELECT * FROM t...', Array)
#5 /usr/share/centreon/lib/Centreon/Object/Object.php(298): Centreon_Object->getResult('SELECT * FROM t...', Array, 'fetchAll')
#6 /usr/share/centreon/www/class/centreon-clapi/centreonTrap.class.php(365): Centreon_Object->getList('*', -1, 0, NULL, NULL, Array)
#7 /usr/share/centreon/www/class/centreon-clapi/ce in /usr/share/centreon/lib/Zend/Db/Statement/Pdo.php on line 234
 

How could I fix it to get a correct export file and try to import it in my new Centreon ?

No idea ?
I expected to get more efficient support when going to Licensed mode with Centreon !!!

Reply


Terms & ConditionsCookie settings