ich versuche aktuell unser Ticketsystem von LTS 6.0.48 auf LTS 6.5.1 zu heben. Das Ganze habe ich erstmal im Testsystem versucht und auch mit einem Klon vom Produktivsystem.
Grundsätzlich klappt erstmal alles nach Anleitung, aber ich habe nach dem Update das Problem, dass das Admin-Panel nicht mehr für meinen Account zur Verfügung steht.
Auffällig ist, dass das Migraktionsskript zwar durchläüuft, aber folgenden Output gibt:
Code: Select all
root@sdvhelpdesktest:/opt# sudo -u otrs /opt/otrs/scripts/MigrateToZnuny6_5.pl
Migration started ...
Checking requirements ...
Requirement check for: Check required Perl version ...
Requirement check for: Check required database version ...
Requirement check for: Check database charset ...
Requirement check for: Check required Perl modules ...
Requirement check for: Check if database has been backed up ...
Did you backup the database? [Y]es/[N]o: y
Requirement check for: Migrate SysConfig settings ...
Should the SysConfig be migrated? [Y]es/[N]o: y
Executing tasks ...
Step 1 of 18: Check required Perl version ...
Step 2 of 18: Check required database version ...
Step 3 of 18: Check database charset ...
Step 4 of 18: Check required Perl modules ...
Step 5 of 18: Check if database has been backed up ...
Step 6 of 18: Rebuild configuration ...
Step 7 of 18: Migrate SysConfig settings ...
Step 8 of 18: Migrate DBCRUD UUID columns ...
Calendar::Plugin: Column dbcrud_uuid in table calendar_appointment_plugin...
[Thu Feb 29 16:48:38 2024] MigrateToZnuny6_5.pl: DBD::mysql::db do failed: Table 'helpdesktest2.calendar_appointment_plugin' doesn't exist at /opt/znuny-6.5.1/Kernel/System/DB.pm line 497.
ERROR: MigrateToZnuny6_5.pl-80 Perl: 5.28.1 OS: linux Time: Thu Feb 29 16:48:38 2024
Message: Table 'helpdesktest2.calendar_appointment_plugin' doesn't exist, SQL: 'ALTER TABLE calendar_appointment_plugin ADD dbcrud_uuid VARCHAR (36) NULL'
Traceback (34391):
Module: Kernel::System::DBCRUD::CreateUUIDDatabaseTableColumn Line: 1727
Module: scripts::Migration::Znuny::MigrateDBCRUDUUIDColumns::Run Line: 62
Module: scripts::Migration::_ExecuteComponent Line: 167
Module: scripts::Migration::Run Line: 77
Module: /opt/otrs/scripts/MigrateToZnuny6_5.pl Line: 82
Column could not be created
OAuth2Token: Column dbcrud_uuid in table oauth2_token...
[Thu Feb 29 16:48:38 2024] MigrateToZnuny6_5.pl: DBD::mysql::db do failed: Table 'helpdesktest2.oauth2_token' doesn't exist at /opt/znuny-6.5.1/Kernel/System/DB.pm line 497.
ERROR: MigrateToZnuny6_5.pl-80 Perl: 5.28.1 OS: linux Time: Thu Feb 29 16:48:38 2024
Message: Table 'helpdesktest2.oauth2_token' doesn't exist, SQL: 'ALTER TABLE oauth2_token ADD dbcrud_uuid VARCHAR (36) NULL'
Traceback (34391):
Module: Kernel::System::DBCRUD::CreateUUIDDatabaseTableColumn Line: 1727
Module: scripts::Migration::Znuny::MigrateDBCRUDUUIDColumns::Run Line: 62
Module: scripts::Migration::_ExecuteComponent Line: 167
Module: scripts::Migration::Run Line: 77
Module: /opt/otrs/scripts/MigrateToZnuny6_5.pl Line: 82
Column could not be created
OAuth2TokenConfig: Column dbcrud_uuid in table oauth2_token_config...
[Thu Feb 29 16:48:38 2024] MigrateToZnuny6_5.pl: DBD::mysql::db do failed: Table 'helpdesktest2.oauth2_token_config' doesn't exist at /opt/znuny-6.5.1/Kernel/System/DB.pm line 497.
ERROR: MigrateToZnuny6_5.pl-80 Perl: 5.28.1 OS: linux Time: Thu Feb 29 16:48:38 2024
Message: Table 'helpdesktest2.oauth2_token_config' doesn't exist, SQL: 'ALTER TABLE oauth2_token_config ADD dbcrud_uuid VARCHAR (36) NULL'
Traceback (34391):
Module: Kernel::System::DBCRUD::CreateUUIDDatabaseTableColumn Line: 1727
Module: scripts::Migration::Znuny::MigrateDBCRUDUUIDColumns::Run Line: 62
Module: scripts::Migration::_ExecuteComponent Line: 167
Module: scripts::Migration::Run Line: 77
Module: /opt/otrs/scripts/MigrateToZnuny6_5.pl Line: 82
Column could not be created
Step 9 of 18: Migrate dynamic fields ...
Step 10 of 18: Migrate notification events ...
Step 11 of 18: Integrate Znuny-NoteToLinkedTicket ...
Step 12 of 18: Uninstall merged packages ...
Step 13 of 18: Initialize default cron jobs ...
Copying /opt/otrs/var/cron/aaa_base.dist to /opt/otrs/var/cron/aaa_base...
done.
Copying /opt/otrs/var/cron/otrs_daemon.dist to /opt/otrs/var/cron/otrs_daemon...
done.
Step 14 of 18: Clean up the cache ...
Step 15 of 18: Rebuild configuration another time ...
Step 16 of 18: Deploy ACLs ...
Step 17 of 18: Deploy processes ...
Step 18 of 18: Check invalid settings ...
Migration completed!
Code: Select all
...otrs/index.pl?Action=Admin
Der Apache gibt auch folgenden Output, was es dann auch erklärt:
Code: Select all
[Error][Kernel::System::Group::GroupDataList][Line:464]: Table 'helpdesktest2.permission_groups' doesn't exist, SQL: 'SELECT id, name, comments, valid_
Feb 29 16:53:04 sdvhelpdesktest OTRS-CGI-80[34746]: [Error][Kernel::System::Mention::GetUserMentions][Line:399]: Table 'helpdesktest2.mention' doesn't exist, SQL: '
SELECT user_id, ticket_id, article_id, create_time
FROM mention
WHERE user_id = ?
ORDER BY create_time ASC
'
Feb 29 16:53:05 sdvhelpdesktest OTRS-CGI-80[34746]: [Error][Kernel::System::Mention::GetUserMentions][Line:399]: Table 'helpdesktest2.mention' doesn't exist, SQL: '
SELECT user_id, ticket_id, article_id, create_time
FROM mention
WHERE user_id = ?
ORDER BY create_time ASC
'
Meine Frage ist aber nun, wie schaffe ich es, das ich die Migration ohne Fehler abschließen kann bzw. wie ist es mir nachträglich möglich, die DB zu reparieren?
Über jegliche Hinweise wäre ich sehr dankbar.
Wenn ihr noch weiteren Input braucht, gebt bitte Bescheid.
Grüße, Paul