I’m trying to migrate an old Centreon 19.10.23 running on CentOS7 to 24.04 running on almalinux 8.
I have followed the procedure here : https://docs.centreon.com/fr/docs/migrate/migrate-from-el-to-el/
The problem occures during the web upgrade : 20.04.18 to 20.04.19 There is no active transaction
In the sql-error.log :
2024-08-22 14:00|0|0|TokenRemoval CRON: failed to delete old tokens
2024-08-22 15:00|0|0|Deleting expired refresh tokens
2024-08-22 15:00|0|0|SQLSTATE[42S02]: Base table or view not found: 1146 Table 'centreon.security_authentication_tokens' doesn't exist QUERY : DELETE st FROM security_token st
WHERE st.expiration_date < UNIX_TIMESTAMP(NOW())
AND EXISTS (
SELECT 1
FROM security_authentication_tokens sat
WHERE sat.provider_token_refresh_id = st.id
AND sat.token_type = 'auto'
LIMIT 1
)
This table does not exist.
I tried to use the solution proposed here :
to create the missing tables. it works fine for security_token but there’s an error when I try to create security_authentication_tokens : ERROR 1005 (HY000): Can't create table `centreon`.`security_authentication_tokens` (errno: 150 "Foreign key constraint is incorrectly formed")
I’m blocked here. Any idea ?
Regards,
JF
