Issue migrating from 6.5 to 7.0

Moderator: crythias

Locked
hotkimchee
Znuny newbie
Posts: 11
Joined: 21 Aug 2024, 10:37
Znuny Version: 6.5
Real Name: Dan Chang

Issue migrating from 6.5 to 7.0

Post by hotkimchee »

Hello,

I am not that familiar with znuny and we recently setup OTRS 6.5.9. I ran into issues doing the migration and would appreciate some help. When I try to execute the following command, I get the errors below:

Code: Select all

[znuny@rt ~]$ scripts/MigrateToZnuny7_0.pl 
Can't locate Kernel/Config/Files/ZZZAAuto.pm in @INC (you may need to install the Kernel::Config::Files::ZZZAAuto module) (@INC contains: /opt/znuny/Custom /opt/znuny/Kernel/cpan-lib /opt/znuny /usr/share/perl5/vendor_perl/Text /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/znuny/Kernel/Config/Defaults.pm line 1984.
Can't locate Kernel/Config/Files/ZZZAAuto.pm in @INC (you may need to install the Kernel::Config::Files::ZZZAAuto module) (@INC contains: /opt/znuny/Custom /opt/znuny/Kernel/cpan-lib /opt/znuny /usr/share/perl5/vendor_perl/Text /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/znuny/Kernel/Config/Defaults.pm line 1984.

 Migration started ... 
Can't locate Kernel/Config/Files/ZZZAAuto.pm in @INC (you may need to install the Kernel::Config::Files::ZZZAAuto module) (@INC contains: /opt/znuny/Custom /opt/znuny/Kernel/cpan-lib /opt/znuny /usr/share/perl5/vendor_perl/Text /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/znuny/Kernel/Config/Defaults.pm line 1984.

 Checking requirements ... 

    Requirement check for: Check required Perl version ...
    Requirement check for: Check required database version ...
    Requirement check for: Check database charset ...
    Requirement check for: Check database default storage engine ...
    Requirement check for: Check required Perl modules ...
    Requirement check for: Check if database has been backed up ...

        Did you backup the database? [Y]es/[N]o: Y

    Requirement check for: Upgrade database structure ...
    Requirement check for: Migrate SysConfig settings ...

        Should the SysConfig be migrated? [Y]es/[N]o: Y


 Executing tasks ... 

    Step 1 of 22: Check required Perl version ...
    Step 2 of 22: Check required database version ...
    Step 3 of 22: Check database charset ...
    Step 4 of 22: Check database default storage engine ...
    Step 5 of 22: Check required Perl modules ...
    Step 6 of 22: Check if database has been backed up ...
    Step 7 of 22: Upgrade database structure ...
    Step 8 of 22: Rebuild configuration ...
Can't locate Kernel/Config/Files/ZZZAAuto.pm in @INC (you may need to install the Kernel::Config::Files::ZZZAAuto module) (@INC contains: /opt/znuny/Custom /opt/znuny/Kernel/cpan-lib /opt/znuny /usr/share/perl5/vendor_perl/Text /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/znuny/Kernel/Config/Defaults.pm line 1984.
    Step 9 of 22: Migrate SysConfig settings ...
Can't locate Kernel/Config/Files/ZZZAAuto.pm in @INC (you may need to install the Kernel::Config::Files::ZZZAAuto module) (@INC contains: /opt/znuny/Custom /opt/znuny/Kernel/cpan-lib /opt/znuny /usr/share/perl5/vendor_perl/Text /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/znuny/Kernel/Config/Defaults.pm line 1984.
Can't locate Kernel/Config/Files/ZZZAAuto.pm in @INC (you may need to install the Kernel::Config::Files::ZZZAAuto module) (@INC contains: /opt/znuny/Custom /opt/znuny/Kernel/cpan-lib /opt/znuny /usr/share/perl5/vendor_perl/Text /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/znuny/Kernel/Config/Defaults.pm line 1984.
ERROR: Znuny-znuny.Console.pl-Maint::Database::Check-10 Perl: 5.26.3 OS: linux Time: Wed Aug 21 08:25:57 2024

 Message: Can't locate Kernel/Config/Files/ZZZAAuto.pm in @INC (you may need to install the Kernel::Config::Files::ZZZAAuto module) (@INC contains: /opt/znuny/Custom /opt/znuny/Kernel/cpan-lib /opt/znuny /usr/share/perl5/vendor_perl/Text /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/znuny/Kernel/System/Main.pm line 86.


 Traceback (6018): 
   Module: Kernel::System::SysConfig::Migration::MigrateSysConfigSettings Line: 167
   Module: scripts::Migration::Znuny::MigrateSysConfigSettings::Run Line: 226
   Module: scripts::Migration::_ExecuteComponent Line: 166
   Module: scripts::Migration::Run Line: 76
   Module: scripts/MigrateToZnuny7_0.pl Line: 82

    Step 10 of 22: Migrate DBCRUD UUID columns ...
        Calendar::Plugin: Column dbcrud_uuid in table calendar_appointment_plugin...
            Column already exists
        OAuth2Token: Column dbcrud_uuid in table oauth2_token...
            Column already exists
        OAuth2TokenConfig: Column dbcrud_uuid in table oauth2_token_config...
            Column already exists
    Step 11 of 22: Migrate dynamic fields ...
    Step 12 of 22: Migrate notification events ...
    Step 13 of 22: Integrate Znuny-NoteToLinkedTicket ...
ERROR: Znuny-znuny.Console.pl-Maint::Database::Check-10 Perl: 5.26.3 OS: linux Time: Wed Aug 21 08:25:58 2024

 Message: Settings must be array with data!

 Traceback (6018): 
   Module: Kernel::System::SysConfig::SettingsSet Line: 4640
   Module: scripts::Migration::Znuny::IntegrateZnunyNoteToLinkedTicket::_ArticleActionConfigAdd Line: 61
   Module: scripts::Migration::Znuny::IntegrateZnunyNoteToLinkedTicket::Run Line: 34
   Module: scripts::Migration::_ExecuteComponent Line: 166
   Module: scripts::Migration::Run Line: 76
   Module: scripts/MigrateToZnuny7_0.pl Line: 82




 Not possible to complete migration. Check previous messages for more information.
Thank you for your help.
Top
hotkimchee
Znuny newbie
Posts: 11
Joined: 21 Aug 2024, 10:37
Znuny Version: 6.5
Real Name: Dan Chang

Re: Issue migrating from 6.5 to 7.0

Post by hotkimchee »

Update:

I copied over the ZZZAAuto.pm to the new directory /opt/znuny/Kernel/Config/Files:

Code: Select all

[znuny@rt Files]$ cp ZZZAAuto.pm /opt/znuny/Kernel/Config/Files/
[znuny@rt Files]$ pwd
/opt/otrs/Kernel/Config/Files
[znuny@rt Files]$ cd /opt/znuny/Kernel/Config/Files/
[znuny@rt Files]$ ls
XML  ZZZAAuto.pm
[znuny@rt Files]$ ls -al
total 356
drwxrwsr-x 3 znuny apache     36 Aug 21 10:50 .
drwxrwsr-x 3 znuny apache     38 Aug 21 00:45 ..
drwxrwsr-x 2 znuny apache    157 Aug 21 00:45 XML
-rw-r----- 1 znuny apache 362765 Aug 21 10:50 ZZZAAuto.pm

And then I re-ran the script, it completed, but still having errors:

Code: Select all

[znuny@rt ~]$ scripts/MigrateToZnuny7_0.pl 

 Migration started ... 

 Checking requirements ... 

    Requirement check for: Check required Perl version ...
    Requirement check for: Check required database version ...
    Requirement check for: Check database charset ...
    Requirement check for: Check database default storage engine ...
    Requirement check for: Check required Perl modules ...
    Requirement check for: Check if database has been backed up ...

        Did you backup the database? [Y]es/[N]o: Yes

    Requirement check for: Upgrade database structure ...
    Requirement check for: Migrate SysConfig settings ...

        Should the SysConfig be migrated? [Y]es/[N]o: Yes


 Executing tasks ... 

    Step 1 of 22: Check required Perl version ...
    Step 2 of 22: Check required database version ...
    Step 3 of 22: Check database charset ...
    Step 4 of 22: Check database default storage engine ...
    Step 5 of 22: Check required Perl modules ...
    Step 6 of 22: Check if database has been backed up ...
    Step 7 of 22: Upgrade database structure ...
    Step 8 of 22: Rebuild configuration ...
    Step 9 of 22: Migrate SysConfig settings ...
    Step 10 of 22: Migrate DBCRUD UUID columns ...
        Calendar::Plugin: Column dbcrud_uuid in table calendar_appointment_plugin...
            Column already exists
        OAuth2Token: Column dbcrud_uuid in table oauth2_token...
            Column already exists
        OAuth2TokenConfig: Column dbcrud_uuid in table oauth2_token_config...
            Column already exists
    Step 11 of 22: Migrate dynamic fields ...
    Step 12 of 22: Migrate notification events ...
    Step 13 of 22: Integrate Znuny-NoteToLinkedTicket ...
    Step 14 of 22: Migrate groups ...
    Step 15 of 22: Cleanup orphaned mentions ...
    Step 16 of 22: Uninstall merged packages ...
    Step 17 of 22: Initialize default cron jobs ...
    Step 18 of 22: Clean up the cache ...
    Step 19 of 22: Rebuild configuration another time ...
    Step 20 of 22: Deploy ACLs ...
    Step 21 of 22: Deploy processes ...
    Step 22 of 22: Check invalid settings ...
Can't locate Kernel/Config/Files/ZZZACL.pm in @INC (you may need to install the Kernel::Config::Files::ZZZACL module) (@INC contains: /opt/znuny/Custom /opt/znuny/Kernel/cpan-lib /opt/znuny /usr/share/perl5/vendor_perl/Text /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/znuny/Kernel/Config/Defaults.pm line 1984.
Can't locate Kernel/Config/Files/ZZZProcessManagement.pm in @INC (you may need to install the Kernel::Config::Files::ZZZProcessManagement module) (@INC contains: /opt/znuny/Custom /opt/znuny/Kernel/cpan-lib /opt/znuny /usr/share/perl5/vendor_perl/Text /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/znuny/Kernel/Config/Defaults.pm line 1984.



 Migration completed!
Top
root
Administrator
Posts: 4243
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:
Contact root

Re: Issue migrating from 6.5 to 7.0

Post by root »

Hi,

Do not copy the ZZZAAuto.pm, this file is generated from the database. Since this is an upgrade, have you changed the Home setting in Kernel/Config.pm?

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
Top
hotkimchee
Znuny newbie
Posts: 11
Joined: 21 Aug 2024, 10:37
Znuny Version: 6.5
Real Name: Dan Chang

Re: Issue migrating from 6.5 to 7.0

Post by hotkimchee »

Hi Roy,

Thank you for that. I ended up removing that file and then changed the Home setting in Kernel/Config.pm. I had modified it in "/opt/otrs" and not in "/opt/znuny". After making those changes I re-ran the the script:

Code: Select all

[znuny@rt ~]$ scripts/MigrateToZnuny7_0.pl 

 Migration started ... 

 Checking requirements ... 

    Requirement check for: Check required Perl version ...
    Requirement check for: Check required database version ...
    Requirement check for: Check database charset ...
    Requirement check for: Check database default storage engine ...
    Requirement check for: Check required Perl modules ...
    Requirement check for: Check if database has been backed up ...

        Did you backup the database? [Y]es/[N]o: Yes

    Requirement check for: Upgrade database structure ...
    Requirement check for: Migrate SysConfig settings ...

        Should the SysConfig be migrated? [Y]es/[N]o: Yes


 Executing tasks ... 

    Step 1 of 22: Check required Perl version ...
    Step 2 of 22: Check required database version ...
    Step 3 of 22: Check database charset ...
    Step 4 of 22: Check database default storage engine ...
    Step 5 of 22: Check required Perl modules ...
    Step 6 of 22: Check if database has been backed up ...
    Step 7 of 22: Upgrade database structure ...
    Step 8 of 22: Rebuild configuration ...
    Step 9 of 22: Migrate SysConfig settings ...
    Step 10 of 22: Migrate DBCRUD UUID columns ...
        Activity: Column dbcrud_uuid in table activity...
            Column successfully created
        Calendar::Plugin: Column dbcrud_uuid in table calendar_appointment_plugin...
            Column already exists
        OAuth2Token: Column dbcrud_uuid in table oauth2_token...
            Column already exists
        OAuth2TokenConfig: Column dbcrud_uuid in table oauth2_token_config...
            Column already exists
    Step 11 of 22: Migrate dynamic fields ...
    Step 12 of 22: Migrate notification events ...
    Step 13 of 22: Integrate Znuny-NoteToLinkedTicket ...
    Step 14 of 22: Migrate groups ...
    Step 15 of 22: Cleanup orphaned mentions ...
    Step 16 of 22: Uninstall merged packages ...
    Step 17 of 22: Initialize default cron jobs ...
    Step 18 of 22: Clean up the cache ...
    Step 19 of 22: Rebuild configuration another time ...
    Step 20 of 22: Deploy ACLs ...
    Step 21 of 22: Deploy processes ...
    Step 22 of 22: Check invalid settings ...



 Migration completed!
It looks like it worked and I was able to go to the URL, but now it hangs after trying to login.
Thank you for all your help
Top
hotkimchee
Znuny newbie
Posts: 11
Joined: 21 Aug 2024, 10:37
Znuny Version: 6.5
Real Name: Dan Chang

Re: Issue migrating from 6.5 to 7.0

Post by hotkimchee »

I rebooted the server and tried again. It looks like it's working now. Thank you so much for your help
Top
Locked

Return to “Help”