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?
Upgrade to 7.0 Fails
Moderator: crythias
-
- 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
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.
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.
-
- Znuny superhero
- Posts: 635
- 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
My Github
OTRS CE/LTS Discord Channel
Cant Update Package Anymore ? Check This
Professional OTRS, Znuny & OTOBO services: efflux.de/en
Free and premium add-ons: English
OTRS CE/LTS Discord Channel
Cant Update Package Anymore ? Check This
Professional OTRS, Znuny & OTOBO services: efflux.de/en
Free and premium add-ons: English
-
- 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
I get package already installed...
-
- 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
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?
-
- 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
anybody found a solution to this issue? i am now officially stuck between 6.5.1 and 7.0
-
- 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
nevermind
rerun the set permissions script and ran UpgradeAll again and this time it worked.
now the migration script completes.
rerun the set permissions script and ran UpgradeAll again and this time it worked.
now the migration script completes.