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?
Anmelden nicht mehr möglich nach Upgrade
-
- Znuny ninja
- Posts: 1312
- Joined: 25 May 2012, 08:51
- Znuny Version: OTRS 4
- Real Name: Klaus Nehrer
Re: Anmelden nicht mehr möglich nach Upgrade
Prüfen, in welchen Zustand die DB ist. Gab es Fehlermeldungen?
Ggf. Backup wiederherstellen und das Upgrade wiederholen.
Ggf. Backup wiederherstellen und das Upgrade wiederholen.
Re: Anmelden nicht mehr möglich nach Upgrade
Ich habe keine Fehler wahrgenommen, wie würde man das konkret prüfen?
Re: Anmelden nicht mehr möglich nach Upgrade
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
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Re: Anmelden nicht mehr möglich nach Upgrade
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 )
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 )
-
- Znuny wizard
- Posts: 383
- Joined: 19 Feb 2009, 12:05
- Znuny Version: 5.0.9
- Real Name: Harald Zahn
- Company: Klinikum Augsburg
- Location: Augsburg
Re: Anmelden nicht mehr möglich nach Upgrade
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.
Produktiv: OTRS 5.0.9 , (ITSM 5.0.10) unter Ubuntu 14.04, mysql 5.5
Test: OTRS 5.0.8 , (ITSM 5.0.8), KIX unter Ubuntu 14.04, mysql 5.5
Test: OTRS 5.0.8 , (ITSM 5.0.8), KIX unter Ubuntu 14.04, mysql 5.5
Re: Anmelden nicht mehr möglich nach Upgrade
Ups, Quelle ist otrs-3.2.17-01
da muss ich wohl mal die richtige Anleitung suchen....
da muss ich wohl mal die richtige Anleitung suchen....
Re: Anmelden nicht mehr möglich nach Upgrade
scheint nun geklappt zu haben 3.2 -> 3.3 -> 4.0
Danke!
Danke!