Skip to main content

Hello I’ve upgrade my old CentOS7 with Centreon 22.04 to OL8 with Centreon 24.

I had to remove all mariadb, and centreon package to proceed the OS upgrade.

The database is now correctly configured, I have my old data, and want to make the Centreon Upgrade.

When I goes to page /install/upgrade, and start upgrade, I’m currently stuck at step 4: 22.10.30 to 23.04.0

When I check logs I see some errors:

sql-error.log

>

p2025-06-06T15:14:01+02:00] ERROR : OCentreonDb] Error while executing the simple query: SQLSTATES42S22]: Column not found: 1054 Unknown column 'sat.token_type' in 'where clause' | {"context":{"default":{"back_trace":{"file":"/usr/share/centreon/www/class/centreonDB.class.php","line":947,"class":null,"function":null},"request_infos":{"url":null,"http_method":null,"server":null,"referrer":null}},"exception":{"exception_type":"PDOException","file":"/usr/share/centreon/www/class/centreonDB.class.php","line":342,"code":"42S22","message":"SQLSTATES42S22]: Column not found: 1054 Unknown column 'sat.token_type' in 'where clause'","previous":null},"custom":{"db_name":"centreon","query":"DELETE st FROM security_token st\nWHERE st.expiration_date < UNIX_TIMESTAMP(NOW())\nAND EXISTS (\n    SELECT 1\n    FROM security_authentication_tokens sat\n    WHERE sat.provider_token_refresh_id = st.id\n    AND sat.token_type = 'auto'\n    LIMIT 1\n)","pdo_error_infos":o"42S22",1054,"Unknown column 'sat.token_type' in 'where clause'"],"pdo_error_code":"42S22"}}}
 

centreon-web

> -2025-06-06T15:25:01+02:00] INFO : TokenRemoval CRON: failed to delete old tokens | {"context":{"default":{"back_trace":{"file":"/usr/share/centreon/cron/outdated-token-removal.php","line":46,"class":null,"function":null},"request_infos":{"url":null,"http_method":null,"server":null,"referrer":null}},"exception":null,"custom":null}

 

How may I unstuck it ?

Hello 👋@Le_DOC 

Make sure you have a full backup and try

ALTER TABLE security_authentication_tokens ADD COLUMN token_type VARCHAR(255) DEFAULT NULL;

I see it here:

https://github.com/centreon/workflow-centreon/blob/23.04.x/centreon/www/install/createTables.sql#L2366

 

🤞


Hello,

Thanks for help, I have no more the error on sql-error.log, and have a new centreon-web.log with an info.

[2025-06-10T10:34:01+02:00] INFO : Deleting expired sessions | {"context":{"default":{"back_trace":{"file":"/usr/share/centreon/cron/outdated-token-removal.php","line":102,"class":null,"function":null},"request_infos":{"url":null,"http_method":null,"server":null,"referrer":null}},"exception":null,"custom":null}}
 

 

But the update process is still stuck. Is there a way to interrupt process, and launch it again ?


Bonjour,

En y regardant de plus pres (via la console debugger) j’ai une erreur 500 sur la page:

http://<host>/centreon/install/step_upgrade/process/process_step4.php

 

Coté logs, je n’ai que ces warnings:

o12-Jun-2025 10:14:10 Europe/Paris] PHP Warning:  Undefined array key "finish" in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 68
612-Jun-2025 10:14:10 Europe/Paris] PHP Warning:  Attempt to read property "value" on null in /usr/share/centreon/GPL_LIB/SmartyCache/compile/ac81e1f21d5b4453f8a41890089d1cc1725bf0e6_0.file.content.tpl.php on line 68
12-Jun-2025 10:15:53 Europe/Paris] PHP Warning:  Undefined array key "current" in /usr/share/centreon/www/install/step_upgrade/process/process_step4.php on line 32
e12-Jun-2025 10:15:53 Europe/Paris] PHP Warning:  Undefined array key "next" in /usr/share/centreon/www/install/step_upgrade/process/process_step4.php on line 33

 

Quelqu’un aurait un miracle ?


Reply