Upgrade 3.3 to 4.0*

Hilfe zu Znuny Problemen aller Art
Forum rules
Locked
mrm
Znuny newbie
Posts: 62
Joined: 11 Jan 2011, 19:09
Znuny Version: 3.0

Upgrade 3.3 to 4.0*

Post by mrm »

Hallo,

versuche gerade OTRS auf 5.x zu heben und bin beim Zwischenschritt 4.x.
Bei CheckModules.pl bekomme ich folgendes:

Code: Select all

-bash-4.1$ bin/otrs.CheckModules.pl
  o Apache2::Reload..................Not installed! Use: 'yum install "perl(Apache2::Reload)"' (optional - Avoids web server restarts on mod_perl.)
  o Archive::Tar.....................ok (v1.58)
  o Archive::Zip.....................Not installed! Use: 'yum install "perl(Archive::Zip)"' (required - Required for compressed file generation.)
  o Crypt::Eksblowfish::Bcrypt.......Not installed! Use: 'yum install "perl(Crypt::Eksblowfish::Bcrypt)"' (optional - For strong password hashing.)
  o Crypt::SSLeay....................ok (v0.57)
  o Date::Format.....................ok (v2.22)
  o DBI..............................ok (v1.609)
  o DBD::mysql.......................ok (v4.013)
  o DBD::ODBC........................Not installed! (optional - Required to connect to a MS-SQL database.)
  o DBD::Oracle......................Not installed! (optional - Required to connect to a Oracle database.)
  o DBD::Pg..........................Not installed! Use: 'yum install "perl(DBD::Pg)"' (optional - Required to connect to a PostgreSQL database.)
  o Encode::HanExtra.................ok (v0.23)
  o GD...............................ok (v2.44)
    o GD::Text.......................ok (v0.86)
    o GD::Graph......................ok (v1.44)
  o IO::Socket::SSL..................ok (v1.31)
  o JSON::XS.........................Not installed! Use: 'yum install "perl(JSON::XS)"' (optional - Recommended for faster AJAX/JavaScript handling.)
  o List::Util::XS...................ok (v1.21)
  o LWP::UserAgent...................ok (v6.06)
  o Mail::IMAPClient.................Not installed! Use: 'yum install "perl(Mail::IMAPClient)"' (optional - Required for IMAP TLS connections.)
    o IO::Socket::SSL................ok (v1.31)
  o ModPerl::Util....................ok (v2.000004)
  o Net::DNS.........................ok (v0.65)
  o Net::LDAP........................ok (v0.40)
  o PDF::API2........................Not installed! Use: 'yum install "perl(PDF::API2)"' (optional - Required for PDF output.)
  o Template.........................Not installed! Use: 'yum install "perl(Template)"' (required - Template::Toolkit, the rendering engine of OTRS.)
  o Template::Stash::XS..............Not installed! Use: 'yum install "perl(Template::Stash::XS)"' (required - The fast data stash for Template::Toolkit.)
  o Text::CSV_XS.....................Not installed! Use: 'yum install "perl(Text::CSV_XS)"' (optional - Recommended for faster CSV handling.)
  o Time::HiRes......................ok (v1.9721)
  o Time::Piece......................ok (v1.15)
  o XML::Parser......................ok (v2.36)
  o YAML::XS.........................Not installed! Use: 'yum install "perl(YAML::XS)"' (required - Very important)
m.E. sind alle geforderten Module installiert:

Code: Select all

cpan[2]> i Apache2::Reload
Module id = Apache2::Reload
    CPAN_USERID  PHRED (Fred Moyer <fred@redhotpenguin.com>)
    CPAN_VERSION 0.13
    CPAN_FILE    S/SH/SHAY/Apache-Reload-0.13.tar.gz
    MANPAGE      Apache2::Reload - Reload Perl Modules when Changed on Disk
    INST_FILE    /usr/local/lib64/perl5/Apache2/Reload.pm
    INST_VERSION 0.12
    
cpan[3]> i Archive::Zip
Module id = Archive::Zip
    DESCRIPTION  Provides an interface to ZIP archive files
    CPAN_USERID  SMPETERS (Steve Peters <steve at fisharerojo dot org>)
    CPAN_VERSION 1.57
    CPAN_FILE    P/PH/PHRED/Archive-Zip-1.57.tar.gz
    DSLIP_STATUS RdpOp (released,developer,perl,object-oriented,Standard-Perl)
    MANPAGE      Archive::Zip - Provide an interface to ZIP archive files.
    INST_FILE    /usr/local/share/perl5/Archive/Zip.pm
    INST_VERSION 1.30
    
cpan[4]> i Template
Module id = Template
    DESCRIPTION  Extensive Toolkit for template processing
    CPAN_USERID  ABW (Andy Wardley <cpan@wardley.org>)
    CPAN_VERSION 2.26
    CPAN_FILE    A/AB/ABW/Template-Toolkit-2.26.tar.gz
    DSLIP_STATUS RdpO? (released,developer,perl,object-oriented,)
    MANPAGE      Template - Front-end module to the Template Toolkit
    INST_FILE    /usr/local/lib64/perl5/Template.pm
    INST_VERSION 2.26
    
cpan[5]> i Template::Stash::XS
Module id = Template::Stash::XS
    CPAN_USERID  ABW (Andy Wardley <cpan@wardley.org>)
    CPAN_VERSION undef
    CPAN_FILE    A/AB/ABW/Template-Toolkit-2.26.tar.gz
    MANPAGE      Template::Stash::XS - High-speed variable stash written in C
    INST_FILE    /usr/local/lib64/perl5/Template/Stash/XS.pm
    INST_VERSION undef
    
cpan[6]> i YAML::XS
Module id = YAML::XS
    CPAN_USERID  INGY (Ingy dot Net <ingy@cpan.org>)
    CPAN_VERSION 0.62
    CPAN_FILE    T/TI/TINITA/YAML-LibYAML-0.62.tar.gz
    MANPAGE      YAML::XS - Perl YAML Serialization using XS and libyaml
    INST_FILE    /usr/local/lib64/perl5/YAML/XS.pm
    INST_VERSION 0.41
Kann mir bitte helfen?
Vielen Dank
M.
VG,
M.
----
Mehrere OTRS Instanzen, alle > 3.x, eins davon mit Kix4OTRS, 2 davon mit ITSM-Modul
Top
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:
Contact reneeb

Re: Upgrade 3.3 to 4.0*

Post by reneeb »

Wie hast Du die Module installiert? Kannst Du mit

Code: Select all

perl -E 'say "@INC"'
schauen ob

Code: Select all

/usr/local/lib64/perl5/
dort zu finden ist? Du kannst auch einfach mal

Code: Select all

perl -MArchive::Zip -e 1
machen.
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Top
mrm
Znuny newbie
Posts: 62
Joined: 11 Jan 2011, 19:09
Znuny Version: 3.0

Re: Upgrade 3.3 to 4.0*

Post by mrm »

Perl Module habe ich nun installiert bekommen. Vorher hatte ich sie mit der CPAN Shell installiert, nun noch ein paar Repos hinzugefuegt und per YUM installiert, nun sieht das CheckModules wieder okay aus.
Nun habe ich ein Folgeproblem:

Code: Select all

-bash-4.1$ cat DBUpdate-to-4.mysql.sql |mysql -p -f -u root otrs
Enter password:
ERROR 1060 (42S21) at line 9: Duplicate column name 'disposition'
ERROR 1060 (42S21) at line 13: Duplicate column name 'disposition'
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.
ERROR 1091 (42000) at line 23: Can't DROP 'valid_id'; check that column/key exists
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 1091 (42000) at line 33: Can't DROP 'valid_id'; check that column/key exists
ERROR 1050 (42S01) at line 38: Table 'personal_services' already exists
ERROR 1091 (42000) at line 47: Can't DROP 'content_size'; check that column/key exists
ERROR 1050 (42S01) at line 51: Table 'system_maintenance' already exists
ERROR 1005 (HY000) at line 66: Can't create table 'otrs.#sql-792_5' (errno: 121)
ERROR 1005 (HY000) at line 67: Can't create table 'otrs.#sql-792_5' (errno: 121)
ERROR 1005 (HY000) at line 68: Can't create table 'otrs.#sql-792_5' (errno: 121)
ERROR 1005 (HY000) at line 69: Can't create table 'otrs.#sql-792_5' (errno: 121)
ERROR 1005 (HY000) at line 70: Can't create table 'otrs.#sql-792_5' (errno: 121)
Wurde schon einige Male gefragt, ich weiss, habe aber fuer mich keine passende Loesung gefunden.
Ich habe auch schon probiert, das als Source hinzuzufuegen:

Code: Select all

-bash-4.1$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.1.73 Source distribution
[...]
mysql> use otrs;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> source /opt/otrs/scripts/DBUpdate-to-4.mysql.sql
Query OK, 737 rows affected (0.06 sec)
Records: 737  Duplicates: 0  Warnings: 0

Query OK, 737 rows affected (0.07 sec)
Records: 737  Duplicates: 0  Warnings: 0

ERROR 1060 (42S21): Duplicate column name 'disposition'
ERROR 1060 (42S21): Duplicate column name 'disposition'
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)
Statement prepared

+------------------------------------------------------------------------------+
| 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. |
+------------------------------------------------------------------------------+
1 row in set (0.00 sec)

ERROR 1091 (42000): Can't DROP 'valid_id'; check that column/key exists
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)
Statement prepared

+--------------------------------------------------------------------------------------+
| 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. |
+--------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

ERROR 1091 (42000): Can't DROP 'valid_id'; check that column/key exists
Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1050 (42S01): Table 'personal_services' already exists
ERROR 1091 (42000): Can't DROP 'content_size'; check that column/key exists
ERROR 1050 (42S01): Table 'system_maintenance' already exists
ERROR 1005 (HY000): Can't create table 'otrs.#sql-792_7' (errno: 121)
ERROR 1005 (HY000): Can't create table 'otrs.#sql-792_7' (errno: 121)
ERROR 1005 (HY000): Can't create table 'otrs.#sql-792_7' (errno: 121)
ERROR 1005 (HY000): Can't create table 'otrs.#sql-792_7' (errno: 121)
ERROR 1005 (HY000): Can't create table 'otrs.#sql-792_7' (errno: 121)
mysql>
Das PL Script faellt damit ebenfalls auf die Schn... :

Code: Select all

-bash-4.1$ ./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... [Wed Apr 13 11:16:40 2016] 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... [Wed Apr 13 11:16:40 2016] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs.acl' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 584.
ERROR: OTRS-DBUpdate-to-4.pl-20 Perl: 5.10.1 OS: linux Time: Wed Apr 13 11:16:40 2016

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

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

[Wed Apr 13 11:16:40 2016] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs.acl_sync' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 584.
ERROR: OTRS-DBUpdate-to-4.pl-20 Perl: 5.10.1 OS: linux Time: Wed Apr 13 11:16:40 2016

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

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

[Wed Apr 13 11:16:40 2016] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs.acl' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 584.
ERROR: OTRS-DBUpdate-to-4.pl-20 Perl: 5.10.1 OS: linux Time: Wed Apr 13 11:16:40 2016

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

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

[Wed Apr 13 11:16:40 2016] 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-20 Perl: 5.10.1 OS: linux Time: Wed Apr 13 11:16:40 2016

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

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

Not a CODE reference at ./DBUpdate-to-4.pl line 1021.
Jemand ne Idee dazu?

M.
VG,
M.
----
Mehrere OTRS Instanzen, alle > 3.x, eins davon mit Kix4OTRS, 2 davon mit ITSM-Modul
Top
mrm
Znuny newbie
Posts: 62
Joined: 11 Jan 2011, 19:09
Znuny Version: 3.0

Re: Upgrade 3.3 to 4.0*

Post by mrm »

Ich bin gerade nochmal nach Anleitung Step fuer Step durchgegangen. Leider ende ich immer noch mit dem selben Fehler.
Hat jemand eine Idee dazu?
VG,
M.
----
Mehrere OTRS Instanzen, alle > 3.x, eins davon mit Kix4OTRS, 2 davon mit ITSM-Modul
Top
Locked

Return to “Hilfe”