I'm not sure if this is a general bug or if I made a mistake while migrating from OTRS 6 to Znuny 6.4.5, but I have this issue:
I try to get a OAUTH2 token from Microsoft Azure App for the first time and while I'd expect Microsoft to ask me to sign in or (if I'm already signed) to grant permissions, I receive this error from Microsoft:
I double-checked SysConfig for having https enabled, having the FQDN and the ScriptAlias right, also I've double-checked my Azure App und have recreated another one (just to be sure )Sorry, but we’re having trouble signing you in.
AADSTS900144: The request body must contain the following parameter: 'client_id'.
After checking my apache logs I've found error messages in OAUTH2 module that the field "token_config_id" is missing in oauth2 table (MySQL).
So I had a look at the database table and - yes - I don't have this table. In my case it is just named "config_id".
Another issue I've seen is that I am not able to interact with my already created tokens.
For example while trying do delete them I receive this:
also using the OTRS Kernel modules for interacting with the OAUTH2 tokens are throwing errors regarding the missing field "token_config_id".Backend ERROR: OTRS-CGI-00 Perl: 5.30.0 OS: linux Time: Sat Jan 21 22:29:22 2023
Message: Error fetching token for token config with ID 1.
Module: Kernel::System::OAuth2Token::HasRefreshTokenExpired Line: 1107
Module: Kernel::Output::HTML::Notification::OAuth2TokenManagementTokenExpired::Run Line: 92
Module: Kernel::Output::HTML::Layout::NavigationBar Line: 3332
Module: Kernel::Output::HTML::Layout::ErrorScreen Line: 1018
Module: Kernel::Modules::AdminOAuth2TokenManagement::_DeleteTokenConfig Line: 162
Module: Kernel::Modules::AdminOAuth2TokenManagement::Run Line: 65
Module: Kernel::System::Web::InterfaceAgent::Run Line: 1144
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler Line: 39
Module: (eval) (v1.99) Line: 207
Module: ModPerl::RegistryCooker::run (v1.99) Line: 207
Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 173
Module: ModPerl::Registry::handler (v1.99) Line: 32
Is it safe just to rename the field to the value OTRS is trying to address?
Do you have an idea what to do here?
Everything else seems to work fine.
Any help is appreciated, thank you in advance!