Skip to main content
Solved

Migrate from 18.10 to 24.04

  • 25 July 2024
  • 5 replies
  • 73 views

I have an old centreon version 18.10 running on a centos7. I want to migrate to debian12 version 24.04.
I've followed the documentation (https://docs.centreon.com/docs/migrate/migrate-from-el-to-debian/) but during the upgrade process I get an error and it can't apply version 20.04.19 (see image). Nothing in the log files sql-error.log or upgrade.log as suggested.
Any ideas?
Thanks
Jean

 

5 replies

itoussies
Rank
Userlevel 3
Badge +11

Hi,

 

It seemed something went wrong with this part https://github.com/centreon/centreon/blob/develop/centreon/www/install/php/Update-20.04.19.php.

Try to check if the changes were applied in the centreon database and do them manually if not. Then, remove /usr/share/centreon/www/install/php/Update-20.04.19.php click on “Refresh” and refresh the page is necessary.

J
Badge +1

Perfect, thank you !
Indeed there are some migrations that do not pass.

P
Badge +3

I’m also runing Centos 7, Centreon  22.10.23 and migrating to Debian 12. following this doc (https://eu-central-1.protection.sophos.com?d=centreon.com&u=aHR0cHM6Ly9kb2NzLmNlbnRyZW9uLmNvbS9kb2NzL21pZ3JhdGUvbWlncmF0ZS1mcm9tLWVsLXRvLWRlYmlhbi8=&p=m&i=NjUxYjE0ZGYxYzYxZDgxNTllOTFmOGEz&t=RnNobXpOMERrRlhWcmc5MTJiR1Zjcmh4c2tmdVFicFA2c3dRL202RkpJRT0=&h=88fcea6c9b85405b8eb764d52b9d3a03&s=AVNPUEhUT0NFTkNSWVBUSVYWn6ZWBeZKPjNzkzQdWhFdbGNZl4fRoI54YpLY0mFdhQ).

But, the new server work fine until the Maria DB import steps… after that, I get auhtentication error "Error while searching authentication tokens" + "Error while searching for the widgets version of the Centreon platform"). Did you get also this errors ? any idea ? 

Thank you in advance,

Best regards

P
Badge +3

Let me say also that in 

/var/log/centreon/login.log:
2024-08-06 11:33:35|38|0|0|[local] [127.0.0.1] Authentication succeeded for 'centreon-gorgone'
2024-08-06 11:33:43|21|0|0|[local] [172.23.7.38] Authentication succeeded for 'XXXX'

-------------------
/var/log/centreon/centreon-web.log:
[2024-08-06T11:33:43+0200] [ERROR] [Core\Security\Authentication\Application\UseCase\Login\Login:166]: An error occurred during authentication {"trace":"PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sat.is_revoked' in 'where clause' in /usr/share/centreon/src/Core/Security/Authentication/Infrastructure/Repository/DbReadTokenRepositoryInterface.php:75\nStack trace:\n#0 /usr/share/centreon/src/Core/Security/Authentication/Infrastructure/Repository/DbReadTokenRepositoryInterface.php(75): PDOStatement->execute()\n#1 /usr/share/centreon/src/Core/Security/Authentication/Infrastructure/Repository/DbReadTokenRepositoryInterface.php(120): Core\\Security\\Authentication\\Infrastructure\\Repository\\DbReadTokenRepositoryInterface->findAuthenticationTokensByToken()\n#2 /usr/share/centreon/src/Core/Security/Authentication/Application/UseCase/Login/Login.php(112): Core\\Security\\Authentication\\Infrastructure\\Repository\\DbReadTokenRepositoryInterface->hasAuthenticationTokensByToken()\n#3 /usr/share/centreon/src/Core/Security/Authentication/Infrastructure/Api/Login/Local/LoginController.php(71): Core\\Security\\Authentication\\Application\\UseCase\\Login\\Login->__invoke()\n#4 /usr/share/centreon/vendor/symfony/http-kernel/HttpKernel.php(181): Core\\Security\\Authentication\\Infrastructure\\Api\\Login\\Local\\LoginController->__invoke()\n#5 /usr/share/centreon/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw()\n#6 /usr/share/centreon/vendor/symfony/http-kernel/Kernel.php(197): Symfony\\Component\\HttpKernel\\HttpKernel->handle()\n#7 /usr/share/centreon/api/index.php(47): Symfony\\Component\\HttpKernel\\Kernel->handle()\n#8 {main}"}
~

-------------------
/var/log/centreon/sql-error.log
empty

-------------------
/var/log/centreon/centAcl.log
empty

-------------------
/var/log/centreon-gorgone/gorgoned.log
2024-08-06 11:33:32 - ERROR - [core] Package 'gorgone::modules::core::action::hooks' already loaded
2024-08-06 11:33:35 - ERROR - [autodiscovery] -class- host discovery - cannot get platform versions - request error [code: '500'] [message: 'Error while searching for the widgets version of the Centreon platform']
2024-08-06 11:34:34 - ERROR - [autodiscovery] -class- host discovery - cannot get platform versions - request error [code: '500'] [message: 'Error while searching for the widgets version of the Centreon platform']
2024-08-06 11:35:34 - ERROR - [autodiscovery] -class- host discovery - cannot get platform versions - request error [code: '500'] [message: 'Error while searching for the widgets version of the Centreon platform']
2024-08-06 11:36:34 - ERROR - [autodiscovery] -class- host discovery - cannot get platform versions - request error [code: '500'] [message: 'Error while searching for the widgets version of the Centreon platform']
2024-08-06 11:37:34 - ERROR - [autodiscovery] -class- host discovery - cannot get platform versions - request error [code: '500'] [message: 'Error while searching for the widgets version of the Centreon platform']
~

-------------------

P
Badge +3

sorry I didn’t see that this issue was solved, I post a new one for me :-)

Centos 7, Centreon 22.10.23 to Debian 12 24.04.4 | Community

Sorry again

 

Reply


Terms & ConditionsCookie settings