Updating OTRS 5.0.28 to 6.0.27 fails

[drodralv]

Hello,

We duplicated our system for a parallel installation and was working fine. During the migration XML script, we detected that some perl modules were missing so were installed and re executed the script successfully. We have Oracle 12.1.0.1 and FS article storage

For the DBUpdate to-6-.pl script we received some errors:

Code: Select all

   Requirement check for: Check framework version ...
Global symbol "$Self" requires explicit package name at /opt/otrs/Kernel/Config/Files/ZZZOTRSLDAPAgentAuth.pm line 10.
Global symbol "$Self" requires explicit package name at /opt/otrs/Kernel/Config/Files/ZZZOTRSLDAPAgentAuth.pm line 14.

And also other 2 LDAP files.. with same errors. And then:

Code: Select all

Requirement check for: Upgrade database structure ...
Error: The following sequences with possible wrong names have been found. Please rename them manually.
se_change_freekey
se_change_freetext
se_change_wo_freekey
se_change_wo_freetext
se_scheduler_task_list
se_standard_response
se_standard_response_attace7
Error: The following triggers with possible wrong names have been found. Please rename them manually.
se_standard_response_attace7_t
se_standard_response_t

And then this one, were was stucked for almost 24 hoursoin Step 8...

Code: Select all

Total advisories found: 13

    WARNING: CPAN::Audit reported that one or more installed CPAN modules have known vulnerabilities (see above). Please note that there might be false positives for distributions patching Perl modules without changing their version number.

    Step 7 of 44: Check if database has been backed up ...
    Step 8 of 44: Upgrade database structure ...

There are some more errors Migrating ticket storage configuration

We have the doubts during preparation before DBUpdate script of the Perl configuration, something to add Load method in the files, we skipped that, does it need to be done somehow? not confident with that..

At this point, how can we fix it? needs to be restored again everything or we can redo some actions?

Thank you

[wurzel]

Hi,

which upgrade documentation did you follow?

We duplicated our system for a parallel installation and was working fine. During the migration XML script, we detected that some perl modules were missing so were installed and re executed the script successfully. We have Oracle 12.1.0.1 and FS article storage

which migration XML script did you use?
Can you show all steps you performed on the shell?

For the DBUpdate to-6-.pl script we received some errors:

Code: Select all

   Requirement check for: Check framework version ...
Global symbol "$Self" requires explicit package name at /opt/otrs/Kernel/Config/Files/ZZZOTRSLDAPAgentAuth.pm line 10.
Global symbol "$Self" requires explicit package name at /opt/otrs/Kernel/Config/Files/ZZZOTRSLDAPAgentAuth.pm line 14.

And also other 2 LDAP files.. with same errors. And then:

fix the files or remove them during upgrade.

Code: Select all

Requirement check for: Upgrade database structure ...
Error: The following sequences with possible wrong names have been found. Please rename them manually.
se_change_freekey
se_change_freetext
se_change_wo_freekey
se_change_wo_freetext
se_scheduler_task_list
se_standard_response
se_standard_response_attace7
Error: The following triggers with possible wrong names have been found. Please rename them manually.
se_standard_response_attace7_t
se_standard_response_t

this is database stuff, I can not help here. You have to ask a DBA.


And then this one, were was stucked for almost 24 hoursoin Step 8...

Code: Select all

Total advisories found: 13

    WARNING: CPAN::Audit reported that one or more installed CPAN modules have known vulnerabilities (see above). Please note that there might be false positives for distributions patching Perl modules without changing their version number.

    Step 7 of 44: Check if database has been backed up ...
    Step 8 of 44: Upgrade database structure ...

update your system with new/updated modules which fix security fixes.

There are some more errors Migrating ticket storage configuration

without showing the error it is a guessing.

We have the doubts during preparation before DBUpdate script of the Perl configuration, something to add Load method in the files, we skipped that, does it need to be done somehow? not confident with that..

please explain.

At this point, how can we fix it? needs to be restored again everything or we can redo some actions?

Restore your initial state, use the official doc from doc.otrs.org and show all steps you performed.


Florian

[drodralv]

Hi!

Thank you for answering.

We use this manual: https://doc.otrs.com/doc/manual/admin/6 ... ating.html
And the part of https://doc.otrs.com/doc/manual/develop ... tion-files for XML conversion and Load method to be included in pm files

So the part of the Load, we didn´t know how, and we didn´t change any pm file. And for the first try to migrate XML files:

bin/otrs.Console.pl Dev::Tools::Migrate::ConfigXMLStructure
Can't locate Moo.pm in @INC (@INC contains: /opt/otrs/Custom /opt/otrs/Kernel/cpan-lib /opt/otrs /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /opt/otrs/Kernel/cpan-lib/Math/Random/Secure/RNG.pm line 5.
BEGIN failed--compilation aborted at /opt/otrs/Kernel/cpan-lib/Math/Random/Secure/RNG.pm line 5.
Compilation failed in require at /opt/otrs/Kernel/cpan-lib/Math/Random/Secure.pm line 8.
BEGIN failed--compilation aborted at /opt/otrs/Kernel/cpan-lib/Math/Random/Secure.pm line 8.
Compilation failed in require at /opt/otrs/Kernel/System/Main.pm line 23.
BEGIN failed--compilation aborted at /opt/otrs/Kernel/System/Main.pm line 23.
Compilation failed in require at /opt/otrs/Kernel/System/ObjectManager.pm line 34.
BEGIN failed--compilation aborted at /opt/otrs/Kernel/System/ObjectManager.pm line 34.
Compilation failed in require at ./bin/otrs.Console.pl line 28.
BEGIN failed--compilation aborted at ./bin/otrs.Console.pl line 28.

So DBA told me that he installed missing perl module Moo. So run migration again successfully.

So in this step, should we move our converted XML files from otrs-old\Kernel\Config\Files\XML to otrs\Kernel\Config\Files\XML ? Before running DBUpdate script? Overwrite existing? or just leave during migration and original XML files from 6 version en later on overwrite the files with our converted files?

I´m adding the rest of the errors we received

Step 9 of 44: Migrate configuration ...
Attempt to reload Kernel/Config/Files/ZZZOTRSLDAPAgentAuth.pm aborted.
Compilation failed in require at /opt/otrs/Kernel/Config/Defaults.pm line 1972.
Attempt to reload Kernel/Config/Files/ZZZOTRSLDAPCustomerAuth.pm aborted.
Compilation failed in require at /opt/otrs/Kernel/Config/Defaults.pm line 1972.
Attempt to reload Kernel/Config/Files/ZZZOTRSLDAPCustomerUserInformation.pm aborted.
Compilation failed in require at /opt/otrs/Kernel/Config/Defaults.pm line 1972.
ERROR: OTRS-otrs.Console.pl-Dev::Code::CPANAudit-00 Perl: 5.16.3 OS: linux Time: Tue Jun 16 09:52:09 2020

Message: 'TemplateID' not found in select!

Traceback (43149):
Module: Kernel::System::SysConfig::ValueType::Select::EffectiveValueGet Line: 171
Module: Kernel::System::SysConfig::SettingEffectiveValueGet Line: 960
Module: Kernel::System::SysConfig::_DefaultSettingAddBulk Line: 6299
Module: Kernel::System::SysConfig::ConfigurationXML2DB Line: 2594
Module: scripts::DBUpdateTo6::Base::RebuildConfig Line: 81
Module: scripts::DBUpdateTo6::MigrateConfigEffectiveValues::Run Line: 48
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: ./scripts/DBUpdate-to-6.pl Line: 87

Attempt to reload Kernel/Config/Files/ZZZOTRSLDAPAgentAuth.pm aborted.
Compilation failed in require at /opt/otrs/Kernel/Config/Defaults.pm line 1972.
Attempt to reload Kernel/Config/Files/ZZZOTRSLDAPCustomerAuth.pm aborted.
Compilation failed in require at /opt/otrs/Kernel/Config/Defaults.pm line 1972.
Attempt to reload Kernel/Config/Files/ZZZOTRSLDAPCustomerUserInformation.pm aborted.
Compilation failed in require at /opt/otrs/Kernel/Config/Defaults.pm line 1972.
Attempt to reload Kernel/Config/Files/ZZZOTRSLDAPAgentAuth.pm aborted.
Compilation failed in require at /opt/otrs/Kernel/Config/Defaults.pm line 1972.
Attempt to reload Kernel/Config/Files/ZZZOTRSLDAPCustomerAuth.pm aborted.
Compilation failed in require at /opt/otrs/Kernel/Config/Defaults.pm line 1972.
Attempt to reload Kernel/Config/Files/ZZZOTRSLDAPCustomerUserInformation.pm aborted.
Compilation failed in require at /opt/otrs/Kernel/Config/Defaults.pm line 1972.
Step 10 of 44: Refresh configuration cache after migration of OTRS 5 settings ...
Step 11 of 44: Migrating ticket storage configuration ...
Attempt to reload Kernel/Config/Files/ZZZOTRSLDAPAgentAuth.pm aborted.
Compilation failed in require at /opt/otrs/Kernel/Config/Defaults.pm line 1972.
Attempt to reload Kernel/Config/Files/ZZZOTRSLDAPCustomerAuth.pm aborted.
Compilation failed in require at /opt/otrs/Kernel/Config/Defaults.pm line 1972.
Attempt to reload Kernel/Config/Files/ZZZOTRSLDAPCustomerUserInformation.pm aborted.
Compilation failed in require at /opt/otrs/Kernel/Config/Defaults.pm line 1972.
Attempt to reload Kernel/Config/Files/ZZZOTRSLDAPAgentAuth.pm aborted.
Compilation failed in require at /opt/otrs/Kernel/Config/Defaults.pm line 1972.
Attempt to reload Kernel/Config/Files/ZZZOTRSLDAPCustomerAuth.pm aborted.
Compilation failed in require at /opt/otrs/Kernel/Config/Defaults.pm line 1972.
Attempt to reload Kernel/Config/Files/ZZZOTRSLDAPCustomerUserInformation.pm aborted.
Compilation failed in require at /opt/otrs/Kernel/Config/Defaults.pm line 1972.
[Tue Jun 16 12:03:26 2020] DBUpdate-to-6.pl: Use of uninitialized value $DefaultSetting{"Name"} in concatenation (.) or string at /opt/otrs/Kernel/System/SysConfig/DB.pm line 1700.
ERROR: OTRS-otrs.Console.pl-Dev::Code::CPANAudit-00 Perl: 5.16.3 OS: linux Time: Tue Jun 16 10:03:26 2020

Message: Setting Ticket::Article::Backend::MIMEBase::ArticleStorage does not exists!

Traceback (43149):
Module: Kernel::System::SysConfig::SettingUpdate Line: 454
Module: scripts::DBUpdateTo6::Base::SettingUpdate Line: 664
Module: scripts::DBUpdateTo6::MigrateTicketStorageModule::Run Line: 51
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: ./scripts/DBUpdate-to-6.pl Line: 87


Error:Unable to migrate Ticket::StorageModule.




Not possible to complete migration, check previous messages for more information.

Thank you a lot

[drodralv]

One additional point. We do use FS articlestorage and is under /srv/otrssd/articles .DBA told me that seems script didnt get that configuration from ZZZAuto.pm where is:

Code: Select all

$Self->{'ArticleDir'} =  '/srv/otrssd/articles';
$Self->{'Ticket::StorageModule'} =  'Kernel::System::Ticket::ArticleStorageFS';
$Self->{'Ticket::IndexModule'} =  'Kernel::System::Ticket::IndexAccelerator::StaticDB';
$Self->{'Ticket::ArchiveSystem'} =  '1';