Anmelden nicht mehr möglich nach Upgrade

[danet]

Nach dem Upgrade OTRS 3 -> 4 ist das Anmelden nicht mehr möglich.

folgendes steht im log /opt/otrs/var/log/SchedulerERR.log :

[Sun Jul 26 02:09:50 2015] otrs.Scheduler.pl: DBD::mysql::st execute failed: Table 'otrs.system_data' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 629.
ERROR: OTRS-otrs.Scheduler-08 Perl: 5.16.3 OS: linux Time: Sun Jul 26 02:09:50 2015

Message: Table 'otrs.system_data' doesn't exist, SQL: '
SELECT data_key, data_value
FROM system_data
WHERE data_key LIKE 'Registration::%'
'

Traceback (15183):
Module: Kernel::System::SystemData::SystemDataGroupGet Line: 243
Module: Kernel::System::Registration::RegistrationDataGet Line: 545
Module: Kernel::System::Scheduler::_SanityCheckSystemRegistration Line: 312
Module: Kernel::System::Scheduler::_SanityChecks Line: 304
Module: Kernel::System::Scheduler::Run Line: 99
Module: main::_Start Line: 477
Module: /opt/otrs/bin/otrs.Scheduler.pl Line: 156

Es wurde diese Anleitung verwendet:
http://otrs.github.io/doc/manual/admin/ ... ading.html

Hat jemand einen Tip?

[KlausNehrer]

Prüfen, in welchen Zustand die DB ist. Gab es Fehlermeldungen?
Ggf. Backup wiederherstellen und das Upgrade wiederholen.

[danet]

Ich habe keine Fehler wahrgenommen, wie würde man das konkret prüfen?

[jojo]

der Fehler sollte beim Datenbankupgrade von 3.3.x auf die 4.0.10 aufgetreten sein. Prüfen kannst Du das im Nachhinein nicht mehr. Also wie vorgeschlagen, zurück auf Los und nochmal

[danet]

ok, noch mal von vorne...

Bei Schritt 6.1 erhalte ich das hier:


# bin/otrs.CheckDB.pl
Trying to connect to database
DSN : DBI:mysql:database=otrs;host=localhost;
DatabaseUser: otrs

Connection successful!
# cat scripts/DBUpdate-to-4.mysql.sql | mysql -p -f -u admin otrs
Enter password:
ERROR 1091 (42000) at line 4: Can't DROP 'dynamic_field_value_field_values'; check that column/key exists
INFO: Foreign key constraint FK_ticket_valid_id_id does not exist, skipping.
INFO: Foreign key constraint FK_ticket_valid_id_id does not exist, skipping.
INFO: Foreign key constraint FK_ticket_history_valid_id_id does not exist, skipping.
INFO: Foreign key constraint FK_ticket_history_valid_id_id does not exist, skipping.

# sudo -u otrs scripts/DBUpdate-to-4.pl

Migration started...

Step 1 of 15: Refresh configuration cache...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry!
done.

Step 2 of 15: Check framework version... [Mon Jul 27 12:30:07 2015] DBUpdate-to-4.pl: Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAuto.pm line 7.
done.

Step 3 of 15: Migrate FontAwesome icons... done.

Step 4 of 15: Migrate ProcessManagement EntityIDs... [Mon Jul 27 12:30:07 2015] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs.acl' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 629.
ERROR: OTRS-DBUpdate-to-4.pl-08 Perl: 5.16.3 OS: linux Time: Mon Jul 27 12:30:07 2015

Message: Table 'otrs.acl' doesn't exist, SQL: '
SELECT id
FROM acl ORDER BY id'

Traceback (2119):
Module: Kernel::System::ACL::DB::ACL::ACLListGet Line: 743
Module: main::_MigrateProcessManagementEntityIDs Line: 705
Module: scripts/DBUpdate-to-4.pl Line: 121

[Mon Jul 27 12:30:07 2015] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs.acl_sync' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 629.
ERROR: OTRS-DBUpdate-to-4.pl-08 Perl: 5.16.3 OS: linux Time: Mon Jul 27 12:30:07 2015

Message: Table 'otrs.acl_sync' doesn't exist, SQL: '
SELECT COUNT(*)
FROM acl_sync'

Traceback (2119):
Module: Kernel::System::ACL::DB::ACL::ACLsNeedSync Line: 794
Module: main::_MigrateProcessManagementEntityIDs Line: 950
Module: scripts/DBUpdate-to-4.pl Line: 121

[Mon Jul 27 12:30:07 2015] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs.acl' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 629.
ERROR: OTRS-DBUpdate-to-4.pl-08 Perl: 5.16.3 OS: linux Time: Mon Jul 27 12:30:07 2015

Message: Table 'otrs.acl' doesn't exist, SQL: '
SELECT id
FROM acl WHERE valid_id IN (1)ORDER BY id'

Traceback (2119):
Module: Kernel::System::ACL::DB::ACL::ACLListGet Line: 743
Module: Kernel::System::ACL::DB::ACL::ACLDump Line: 860
Module: main::_MigrateProcessManagementEntityIDs Line: 1018
Module: scripts/DBUpdate-to-4.pl Line: 121

[Mon Jul 27 12:30:07 2015] DBUpdate-to-4.pl: DBD::mysql::db do failed: Table 'otrs.acl_sync' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 442.
ERROR: OTRS-DBUpdate-to-4.pl-08 Perl: 5.16.3 OS: linux Time: Mon Jul 27 12:30:07 2015

Message: Table 'otrs.acl_sync' doesn't exist, SQL: 'DELETE FROM acl_sync'

Traceback (2119):
Module: Kernel::System::ACL::DB::ACL::ACLsNeedSyncReset Line: 813
Module: main::_MigrateProcessManagementEntityIDs Line: 1026
Module: scripts/DBUpdate-to-4.pl Line: 121

Not a CODE reference at scripts/DBUpdate-to-4.pl line 1029.


Da läuft wohl was schief, hat jemand einen Tipp wie es weiter geht?

( verwendete Anleitung: http://otrs.github.io/doc/manual/admin/ ... ading.html )

[Hazet]

Welche Ursprungsversion nutzt Du genau? Ich denke, Du hast Update-Schritte übersprungen...

These instructions are for people upgrading OTRS from 3.3 to 4 or from a 4 to a later patchlevel release 4 and applies both for RPM and source code (tarball) upgrades.

If you are running a lower version of OTRS you have to follow the upgrade path to 3.3 first (1.1->1.2->1.3->2.0->2.1->2.2->2.3->2.4->3.0->3.1->3.2->3.3)! You need to perform a full upgrade to every version in between, including database changes and the upgrading perl script.

[danet]

Ups, Quelle ist otrs-3.2.17-01

da muss ich wohl mal die richtige Anleitung suchen....

[danet]

scheint nun geklappt zu haben 3.2 -> 3.3 -> 4.0

Danke!