OS: Ubuntu 24.04
DB: MySQL 8.0.43
Perl 5.38
Znuny 7.1.7
ich wollte ganz gerne unsere Znuny-Installation von 7.1.7 auf 7.2.1 aktualisieren. Ich habe mich dazu an die Dokumentation von Znuny (Znuny Dokumentation) gehalten, die aber noch nicht ganz vollständig scheint.
Das MigrateToZnuny7_2.pl stürzt leider wegen einem Fehler im Skript ab. Bevor ich ein Issue auf Github eröffne, wollte ich gerne nochmal hier im Forum nachfragen, ob jemand auf ähnliche Probleme beim Update gestoßen ist oder bereits einen Workaround gefunden hat.
Hier einmal der Output vom MigrateToZnuny7_2.pl
Die Kurzform:
Code: Select all
root@otrs-dev:/opt/znuny# su -c 'scripts/MigrateToZnuny7_2.pl --verbose' - znuny
[...]
Step 7 of 23: Upgrade database structure ...
- Increase size of columns of database table search_profile.
- Create new communication channel Web.
- Create database table translation.
- Create database table article_color.
Can't use an undefined value as a HASH reference at /opt/znuny-7.2.1/Kernel/System/CommunicationChannel.pm line 475, <> line 3.
Code: Select all
Migration started ...
Checking requirements ...
Requirement check for: Check required Perl version ...
Installed Perl version: v5.38.2. Minimum required Perl version: v5.16.0.
Requirement check for: Check required Perl modules ...
Executing /opt/znuny/bin/znuny.CheckModules.pl to check for missing required modules.
o Apache::DBI......................ok (v1.12)
o Apache2::Reload..................ok (v0.13)
o Archive::Tar.....................ok (v2.40)
o Archive::Zip.....................ok (v1.68)
o Authen::SASL.....................ok (v2.1700)
o Crypt::Eksblowfish::Bcrypt.......ok (v0.009)
o Crypt::JWT.......................Not installed! To install, you can use: 'apt-get install -y libcrypt-jwt-perl'. (optional - JSON web token support.)
o Crypt::OpenSSL::X509.............ok (v1.915)
o CSS::Minifier::XS................ok (v0.13)
o Data::UUID.......................ok (v1.226)
o Date::Format.....................ok (v2.24)
o DateTime.........................ok (v1.65)
o DateTime::TimeZone.............ok (v2.62)
o DBI..............................ok (v1.643)
o DBD::mysql.......................ok (v4.052)
o DBD::ODBC........................Not installed! To install, you can use: 'apt-get install -y libdbd-odbc-perl'. (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! To install, you can use: 'apt-get install -y libdbd-pg-perl'. (optional - Required to connect to a PostgreSQL database.)
o Digest::SHA......................ok (v6.04)
o Encode::HanExtra.................ok (v0.23)
o Excel::Writer::XLSX..............ok (v0.95)
o Hash::Merge......................ok (v0.302)
o iCal::Parser.....................ok (v1.21)
o IO::Socket::SSL..................ok (v2.085)
o JavaScript::Minifier::XS.........ok (v0.15)
o Jq...............................Not installed! (optional - Support for extended condition checking via Jq for the generic interface.)
o JSON::XS.........................ok (v4.03)
o List::Util::XS...................ok (v1.63)
o LWP::UserAgent...................ok (v6.53)
o Mail::IMAPClient.................ok (v3.43)
o IO::Socket::SSL................ok (v2.085)
o Authen::NTLM...................ok (v1.09)
o ModPerl::Util....................ok (v2.000013)
o Moo..............................ok (v2.005005)
o Net::DNS.........................ok (v1.44)
o Net::LDAP........................ok (v0.68)
o Net::LDAP::Constant..............ok (v0.24)
o Net::SMTP........................ok (v3.15)
o Spreadsheet::XLSX................ok (v0.17)
o Template.........................ok (v2.27)
o Template::Stash::XS..............ok (undef)
o Text::Diff::FormattedHTML........ok (v0.08)
o Text::CSV_XS.....................ok (v1.53)
o Time::HiRes......................ok (v1.9775)
o Time::Piece......................ok (v1.3401_01)
o XML::LibXML......................ok (v2.0134)
o XML::LibXSLT.....................ok (v2.002001)
o XML::Parser......................ok (v2.47)
o YAML::XS.........................ok (v0.89)
Requirement check for: Check if database has been backed up ...
Warning: this script can make changes to your database which are irreversible.
Make sure you have properly backed up complete database before continuing.
Did you backup the database? [Y]es/[N]o: Y
Requirement check for: Check required database version ...
Installed database version: MySQL 8.0.43. Minimum required database version: 8.0.0.
Requirement check for: Check database default storage engine ...
The setting default_storage_engine is: InnoDB. Requirement check for: Check if CKEditor migration related entities have been backed up ...
Warning: preparing ckeditor migration data is automatic, meaning this step
will create a new table with prepopulated data for migration.
The step before is to backup/export all relevant entities that will be migrated.
Those includes: auto responses, standard templates,
processes (to migrate activity dialogs), ticket notifications,
appointment notifications, salutations and signatures.
It is possible to export them from GUI or by console command module "Admin::Object::Export".
A database backup should be created as an additional layer of data loss prevention.
The migration script should then be executed.
Make sure that all CKEditor entities content was migrated correctly by investigating them.
Important: migration of CKEditor content does not guarantee 100% success rate of migration.
Did you backup the CKEditor entities? [Y]es/[N]o: Y
Requirement check for: Upgrade database structure ...
Trying to connect to database 'DBI:mysql:database=znuny;host=127.0.0.1;' with user 'znuny'...
Connection successful.
Requirement check for: Check database charset ...
Requirement check for: Migrate SysConfig settings ...
Warning: The following SysConfig settings will be modified.
------------------------------------------------------------------------
Name: CustomerFrontend::Module###AjaxAttachment
Change name to: CustomerFrontend::Module###AJAXAttachment
------------------------------------------------------------------------
Name: Frontend::Module###AjaxAttachment
Change name to: Frontend::Module###AJAXAttachment
------------------------------------------------------------------------
Name: Loader::Agent::CommonJS###000-Framework
Update value(s):
thirdparty/jquery-validate-1.16.0/jquery.validate.js => thirdparty/jquery-validation-1.21.0/jquery.validate.js
------------------------------------------------------------------------
Name: Loader::Customer::CommonJS###000-Framework
Update value(s):
thirdparty/jquery-validate-1.16.0/jquery.validate.js => thirdparty/jquery-validation-1.21.0/jquery.validate.js
------------------------------------------------------------------------
Should the SysConfig be migrated? [Y]es/[N]o: Y
Executing tasks ...
Step 1 of 23: Check required Perl version ...
Step 2 of 23: Check required Perl modules ...
Step 3 of 23: Check if database has been backed up ...
Step 4 of 23: Check required database version ...
Step 5 of 23: Check database default storage engine ...
Step 6 of 23: Check if CKEditor migration related entities have been backed up ...
Step 7 of 23: Upgrade database structure ...
- Increase size of columns of database table search_profile.
- Create new communication channel Web.
- Create database table translation.
- Create database table article_color.
Can't use an undefined value as a HASH reference at /opt/znuny-7.2.1/Kernel/System/CommunicationChannel.pm line 475, <> line 3.