Migration von Windows nach Linux (debian) + Aktualisierung = Probleme

Hilfe zu Znuny Problemen aller Art
Forum rules
Locked
cr1zz
Znuny newbie
Posts: 67
Joined: 03 Sep 2013, 12:14
Znuny Version: 3.2.10

Migration von Windows nach Linux (debian) + Aktualisierung = Probleme

Post by cr1zz »

Hallo zusammen,

im Zuge des Updates wollte ich auch endlich auf Linux wechseln.

Folgende Infos:

Altes OTRS (auf Windows 2008 R2 x64) -> 3.2.10
Neues OTRS (auf Debian Lenny) -> 4.0.8

Ich bin wie folgt vorgegangen:
  • Ich habe eine Sicherung der aktuellen Datenbank vorgenommen
  • Ich habe das Linux System aufgesetzt, OTRS via Sourcen installiert und den Webinstaller ausgeführt (Datenbank 'otrs')
  • Danach habe ich die Sicherung per

    Code: Select all

    mysql -u otrs -p otrs < Sicherung.sql
    zurückgespielt
  • Jetzt habe ich folgende Scripte ausgeführt:

    Code: Select all

    shell> cd /opt/otrs/
shell> bin/otrs.CheckDB.pl (hier musste ich noch alle Tabellen ins InnoDB Format umwandeln)
shell> cat scripts/DBUpdate-to-4.mysql.sql | mysql -p -f -u root otrs
    Hierbei traten folgende Fehler auf:
    ERROR 1091 (42000) at line 4: Can't DROP 'dynamic_field_value_field_values'; check that column
    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.
    ERROR 1050 (42S01) at line 38: Table 'personal_services' already exists
    ERROR 1050 (42S01) at line 51: Table 'system_maintenance' already exists
    ERROR 1005 (HY000) at line 66: Can't create table 'otrs.#sql-19aa_2d' (errno: 121)
    ERROR 1005 (HY000) at line 67: Can't create table 'otrs.#sql-19aa_2d' (errno: 121)
    ERROR 1005 (HY000) at line 68: Can't create table 'otrs.#sql-19aa_2d' (errno: 121)
    ERROR 1005 (HY000) at line 69: Can't create table 'otrs.#sql-19aa_2d' (errno: 121)
    ERROR 1005 (HY000) at line 70: Can't create table 'otrs.#sql-19aa_2d' (errno: 121)
  • Danach habe ich den Befehl

    Code: Select all

    shell> scripts/DBUpdate-to-4.pl
    ausgeführt.
    Folgende Fehler sind aufgetreten:
    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... done.

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

    Step 4 of 15: Migrate ProcessManagement EntityIDs... done.

    Step 5 of 15: Migrate ProcessManagement Dynamic Field Types... done.

    Step 6 of 15: Migrate ACLs stored in the DB... done.

    Step 7 of 15: Set service notifications... done.

    Step 8 of 15: Migrate Settings... done.

    Step 9 of 15: Uninstall Merged Feature Add-Ons... ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/Kernel/Config/Files/Support.xml!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/Kernel/Language/de_Support.pm!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/Kernel/Language/es_MX_Support.pm!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/Kernel/Modules/AdminSupport.pm!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/Kernel/Output/HTML/Standard/AdminSupport.dtl!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/Kernel/Output/HTML/Standard/AdminSupportLicenseText.dtl!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/Kernel/System/Support.pm!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/Kernel/System/Support/Database.pm!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/Kernel/System/Support/OS.pm!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/Kernel/System/Support/OTRS.pm!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/Kernel/System/Support/Webserver/IIS.pm!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/Kernel/System/Support/Webserver/Apache.pm!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/Kernel/System/Support/Database/oracle.pm!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/Kernel/System/Support/Database/mssql.pm!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/Kernel/System/Support/Database/postgresql.pm!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/Kernel/System/Support/Database/mysql.pm!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/Kernel/System/Support/Webserver.pm!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/Kernel/cpan-lib/Archive/Tar/Constant.pm!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/Kernel/cpan-lib/Archive/Tar/File.pm!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/Kernel/cpan-lib/Archive/Tar.pm!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    Notice: Backup for changed file: /opt/otrs/Kernel/cpan-lib/Linux/Distribution.pm.backup
    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: Can't remove file /opt/otrs/Kernel/cpan-lib/Linux/Distribution.pm, because it a framework file and no other one exists!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3424
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    ERROR: OTRS-DBUpdate-to-4.pl-32 Perl: 5.20.2 OS: linux Time: Thu Jun 11 13:14:12 2015

    Message: No such file: /opt/otrs/var/httpd/htdocs/skins/Agent/default/css/Support.Default.css!

    Traceback (7050):
    Module: Kernel::System::Package::_FileRemove Line: 3401
    Module: Kernel::System::Package::PackageUninstall Line: 1162
    Module: main::_UninstallMergedFeatureAddOns Line: 1503
    Module: scripts/DBUpdate-to-4.pl Line: 176

    Notice: DROP TABLE IF EXISTS support_bench_test
    done.

    Step 10 of 15: Migrate SysConfig settings from DT to Template::Toolkit... done.

    Step 11 of 15: Migrate Dynamic Field links from DT to Template::Toolkit... done.

    Step 12 of 15: Migrate Generic Agent Process Management Dynamic Fields ... done.

    Step 13 of 15: Migrate Notification (Event) Process Management Dynamic Fields ... done.

    Step 14 of 15: Clean up the cache... done.

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

    Migration completed!
  • Als letztes habe ich ausgeführt:

    Code: Select all

    shell> bin/otrs.RebuildConfig.pl
shell> bin/otrs.DeleteCache.pl

shell> cd /opt/otrs/var/cron
shell> for foo in *.dist; do cp $foo `basename $foo .dist`; done

/opt/otrs/bin/Cron.sh start
    bin/otrs.RebuildTicketIndex.pl
Soooo, scheinbar lief alles, jedoch versuchte ich grade in der Agent Overview den Head Kundennamen hinzuzufügen. Dies tut er leider nicht (in der Settings steht er jedoch als aktiv drin).

Was habe ich hier falsch gemacht oder übersehen?

Ich danke im Voraus!
Produktiv: OTRS 3.2.10 - OS: Windows Server 2008 R2 Datacenter - MySQL 5.1.51
Testing: OTRS 4.0.11 - OS: Debian Jessie - MySQL 5.5.43
Top
cr1zz
Znuny newbie
Posts: 67
Joined: 03 Sep 2013, 12:14
Znuny Version: 3.2.10

Re: Migration von Windows nach Linux (debian) + Aktualisierung = Probleme

Post by cr1zz »

Niemand eine Idee?

War denn der Migrationsprozess an sich korrekt?
Produktiv: OTRS 3.2.10 - OS: Windows Server 2008 R2 Datacenter - MySQL 5.1.51
Testing: OTRS 4.0.11 - OS: Debian Jessie - MySQL 5.5.43
Top
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: Migration von Windows nach Linux (debian) + Aktualisierung = Probleme

Post by RStraub »

Huhu,

der Migrationsprozess an sich war nicht korrekt :)

Du hast angenommen das du eine Datenbanksicherung in eine neuere Frameworkversion einspielen kannst, das ist aber nicht der Fall.

Um das ganze korrekt durchzuziehen müsstest du dem Migrationspfad folgen (ist in der UPGRADING.md beschrieben). Das sollte in deinem Fall sein:
3.2.x -> 3.3.[latest] -> 4.0.[latest]

DANACH kannst du dann einen Datenbank-dump in das neue Framework einspielen. Achte auch daraf Konfigurationsdateien zu übernehmen:
- Config.pm
- CronJobs
- ZZZAuto.pm
- [...]
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
Top
schulmann
Znuny wizard
Posts: 477
Joined: 20 Nov 2011, 16:08
Znuny Version: 6.5.11
Real Name: Schulmann

Re: Migration von Windows nach Linux (debian) + Aktualisierung = Probleme

Post by schulmann »

RStraub wrote:Um das ganze korrekt durchzuziehen müsstest du dem Migrationspfad folgen (ist in der UPGRADING.md beschrieben). Das sollte in deinem Fall sein:
3.2.x -> 3.3.[latest] -> 4.0.[latest]

DANACH kannst du dann einen Datenbank-dump in das neue Framework einspielen.
Alternativ kann man natürlich den Wechsel von Windows auf Linux mit der OTRS-Version 3.2.10 durchführen und danach OTRS upgraden.
Znuny6/Debian/ESXi
Top
Locked

Return to “Hilfe”