Upgrade to 7.0 Fails

Moderator: crythias

Post Reply
griff6r
Znuny newbie
Posts: 18
Joined: 09 Jun 2022, 21:48
Znuny Version: 6.3
Real Name: Michael Griffith
Company: Rome Health

Upgrade to 7.0 Fails

Post by griff6r »

I'm attempting to upgrade from 6.5 to 7.0. I've followed the official Znuny guide but the migration is erroring out with the following error:

Migration started ...
[Tue Apr 4 09:57:30 2023] MigrateToZnuny7_0.pl: DBI connect('database=znuny;host=127.0.0.1;','znuny',...) failed: Access denied for user 'znuny'@'localhost' (using password: YES) at /opt/znuny/Kernel/System/DB.pm line 209.
ERROR: MigrateToZnuny7_0.pl-10 Perl: 5.26.3 OS: linux Time: Tue Apr 4 13:57:30 2023

Message: Access denied for user 'znuny'@'localhost' (using password: YES)

The thing is that the user was always 'otrs' and not 'znuny' and the database name isn't 'znuny' but 'otrs2.' I created the 'znuny@localhost' account in MariaDB and granted all privileges to 'otrs2' database but still get the same result.

It looks to me that the database configuration didn't carry over. Which configuration file must I change to edit these settings?
griff6r
Znuny newbie
Posts: 18
Joined: 09 Jun 2022, 21:48
Znuny Version: 6.3
Real Name: Michael Griffith
Company: Rome Health

Re: Upgrade to 7.0 Fails

Post by griff6r »

Okay, so I edited /opt/znuny/Config.pm file with appropriate DB, DB User and Password settings and was able to authenticate with MariaDB and initialize the migration, but get the following output...

Executing tasks ...

Step 1 of 19: Check required Perl version ...
Step 2 of 19: Check required database version ...
Step 3 of 19: Check database charset ...
Step 4 of 19: Check required Perl modules ...
Step 5 of 19: Check if database has been backed up ...
Step 6 of 19: Upgrade database structure ...
Step 7 of 19: Rebuild configuration ...
Step 8 of 19: Migrate SysConfig settings ...
ERROR: Znuny-znuny.Console.pl-Maint::Database::Check-22 Perl: 5.26.3 OS: linux Time: Tue Apr 4 14:46:38 2023

Message: Setting ITSMChange::NumberGenerator Effective value is not correct: Kernel::System::ITSMChange::Number::DateChecksum doesn't satisfy ValueFilter(Kernel/System/ITSMChange/Number/*.pm)!

Traceback (4031050):
Module: Kernel::System::SysConfig::ConfigurationDeploy Line: 3474
Module: Kernel::System::SysConfig::SettingsSet Line: 4676
Module: Kernel::System::SysConfig::Migration::MigrateSysConfigSettings Line: 367
Module: scripts::Migration::Znuny::MigrateSysConfigSettings::Run Line: 224
Module: scripts::Migration::_ExecuteComponent Line: 167
Module: scripts::Migration::Run Line: 77
Module: /opt/znuny/scripts/MigrateToZnuny7_0.pl Line: 82

Step 9 of 19: 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 10 of 19: Migrate dynamic fields ...
Step 11 of 19: Migrate notification events ...
Step 12 of 19: Integrate Znuny-NoteToLinkedTicket ...
ERROR: Znuny-znuny.Console.pl-Maint::Database::Check-22 Perl: 5.26.3 OS: linux Time: Tue Apr 4 14:46:39 2023

Message: Setting ITSMChange::NumberGenerator Effective value is not correct: Kernel::System::ITSMChange::Number::DateChecksum doesn't satisfy ValueFilter(Kernel/System/ITSMChange/Number/*.pm)!

Traceback (4031050):
Module: Kernel::System::SysConfig::ConfigurationDeploy Line: 3474
Module: Kernel::System::SysConfig::SettingsSet Line: 4676
Module: scripts::Migration::Znuny::IntegrateZnunyNoteToLinkedTicket::_ArticleActionConfigAdd Line: 60
Module: scripts::Migration::Znuny::IntegrateZnunyNoteToLinkedTicket::Run Line: 33
Module: scripts::Migration::_ExecuteComponent Line: 167
Module: scripts::Migration::Run Line: 77
Module: /opt/znuny/scripts/MigrateToZnuny7_0.pl Line: 82




Not possible to complete migration. Check previous messages for more information.
skullz
Znuny superhero
Posts: 618
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: Upgrade to 7.0 Fails

Post by skullz »

Reinstall the addon, in this case ITSM

viewtopic.php?p=176787#p176787
griff6r
Znuny newbie
Posts: 18
Joined: 09 Jun 2022, 21:48
Znuny Version: 6.3
Real Name: Michael Griffith
Company: Rome Health

Re: Upgrade to 7.0 Fails

Post by griff6r »

I get package already installed...
Lumin669
Znuny newbie
Posts: 5
Joined: 29 Nov 2022, 19:49
Znuny Version: 6.4.4
Real Name: Lumin Rassmus

Re: Upgrade to 7.0 Fails

Post by Lumin669 »

Hi, I got the same problem. Reinstalling the package is not possible since the version (6.5.1) does not match with the newest version. Where can I find the ITSM-Packages for the Znuny 7?
alexandrumateescu
Znuny newbie
Posts: 6
Joined: 26 Mar 2019, 12:17
Znuny Version: 6.0.17
Company: Retail in Motion

Re: Upgrade to 7.0 Fails

Post by alexandrumateescu »

anybody found a solution to this issue? i am now officially stuck between 6.5.1 and 7.0
alexandrumateescu
Znuny newbie
Posts: 6
Joined: 26 Mar 2019, 12:17
Znuny Version: 6.0.17
Company: Retail in Motion

Re: Upgrade to 7.0 Fails

Post by alexandrumateescu »

nevermind

rerun the set permissions script and ran UpgradeAll again and this time it worked.

now the migration script completes.
Post Reply