error OTRS 6.0.37

Moderator: crythias

Post Reply
FSF
Znuny newbie
Posts: 31
Joined: 08 Dec 2022, 12:13
Znuny Version: 6.0.37
Real Name: Frederic

error OTRS 6.0.37

Post by FSF »

Hello
I have been using OTRS for a few years and until Monday I was running debian 10 with OTRS 6.0.35.
As I saw that Oauth2 had been implemented in OTRS I made an update
First an upgrade from debian 10 to debian 11 then an upgrade from OTRS 6.0.35 to 6.0.37

But I have a problem when configuring oauth2 in OTRS 6.0.37
After entering the requested information, as soon as I validate I get this error message

Code: Select all

An Error Occurred

Failed to add OAuth2 token configuration with name Microsoft365.

Please contact the administrator.
Error Details

Backend ERROR: OTRS-CGI-38 Perl: 5.32.1 OS: linux Time: Thu Dec 8 11:30:49 2022

 Message: Table 'otrs.oauth2_token_config' doesn't exist, SQL: 'INSERT INTO oauth2_token_config (name, config, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, '2022-12-08 11:30:49', ?, '2022-12-08 11:30:49', ?)'

 RemoteAddress: 172.16.10.10
 RequestURI: /otrs/index.pl

 Traceback (922): 
   Module: Kernel::System::OAuth2TokenConfig::ConfigAdd Line: 389
   Module: Kernel::Modules::AdminOAuth2TokenConfig::_SaveConfig Line: 341
   Module: Kernel::Modules::AdminOAuth2TokenConfig::Run Line: 49
   Module: Kernel::System::Web::InterfaceAgent::Run Line: 1172
   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
I would appreciate a hand in solving this

Thank you in advance

Best regards
wurzel
Znuny guru
Posts: 3224
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: error OTRS 6.0.37

Post by wurzel »

Hi,

obviously you are missing a table. It seems you missed something during upgrading.
Did you run the DBUpdate.pl script without errors?

Can you show your steps you did during upgrading?

Are you using OTRS 6? I doubt it. You have Znuny installed? We need some more infos about your config, please

Flo
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11

-- Ich beantworte keine Forums-Fragen PN - No PN please

I won't answer to unfriendly users any more. A greeting and regards are just polite.
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: error OTRS 6.0.37

Post by root »

FSF wrote: 09 Dec 2022, 09:39 Hello
I have been using OTRS for a few years and until Monday I was running debian 10 with OTRS 6.0.35.
As I saw that Oauth2 had been implemented in OTRS I made an update
First an upgrade from debian 10 to debian 11 then an upgrade from OTRS 6.0.35 to 6.0.37

But I have a problem when configuring oauth2 in OTRS 6.0.37
After entering the requested information, as soon as I validate I get this error message

Code: Select all

An Error Occurred

Failed to add OAuth2 token configuration with name Microsoft365.

Please contact the administrator.
Error Details

Backend ERROR: OTRS-CGI-38 Perl: 5.32.1 OS: linux Time: Thu Dec 8 11:30:49 2022

 Message: Table 'otrs.oauth2_token_config' doesn't exist, SQL: 'INSERT INTO oauth2_token_config (name, config, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, '2022-12-08 11:30:49', ?, '2022-12-08 11:30:49', ?)'

 RemoteAddress: 172.16.10.10
 RequestURI: /otrs/index.pl

 Traceback (922): 
   Module: Kernel::System::OAuth2TokenConfig::ConfigAdd Line: 389
   Module: Kernel::Modules::AdminOAuth2TokenConfig::_SaveConfig Line: 341
   Module: Kernel::Modules::AdminOAuth2TokenConfig::Run Line: 49
   Module: Kernel::System::Web::InterfaceAgent::Run Line: 1172
   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
I would appreciate a hand in solving this

Thank you in advance

Best regards
Hi,

It looks like you're not using Znuny since there is not OAuth in 6.0.37. I recommend contacting the vendor of this version.

- 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 ?
FSF
Znuny newbie
Posts: 31
Joined: 08 Dec 2022, 12:13
Znuny Version: 6.0.37
Real Name: Frederic

Re: error OTRS 6.0.37

Post by FSF »

Hello to all

I'm an old OTRS user (I've been using it for 6-7 years) so I've always used only the free opensource version ,and I've only updated the versions when they were available, that's why I only have v6.0.35 and I've upgraded to community 6.0.37.
Now if there is a possibility to upgrade from 6.0.35 to znuny no problem, just tell me how to do it, I still have a backup of otrs 6.0.35.

here is how I updated to 6.0.37.

Code: Select all

shell> mkdir /home/user/backup_otrs_config
shell> mkdir /home/user/backup_otrs
shell> /etc/init.d/cron stop
shell> /etc/init.d/exim4 stop
shell> /etc/init.d/apache2 stop
shell> su -c "/opt/otrs/bin/Cron.sh stop" -s /bin/bash otrs
shell> su -c "/opt/otrs/bin/otrs.Daemon.pl stop" -s /bin/bash otrs
shell> cp /opt/otrs/Kernel/Config.pm /home/user/backup_otrs_config/Config.pm.save
shell> cp /opt/otrs/Kernel/System/GenericAgent.pm /home/user/backup_otrs_config/GenericAgent.pm.save
shell> cp /opt/otrs/Kernel/Config/Files/ZZZAuto.pm /home/user/backup_otrs_config/ZZZAuto.pm.save
shell> cd /opt/otrs/scripts
shell> ./backup.pl -d /home/user/backup_otrs/
shell> cd /opt
shell> rm -R otrs-old
shell> mv otrs otrs-old
shell> cd /home/user
shell>wget https://otrscommunityedition.com/download/otrs-community-edition-6.0.37.tar.gz /home/user/
shell> tar -xzf otrs-community-edition-6.0.37.tar.gz
shell> mv otrs-community-edition-6.0.37 /opt/otrs
shell> rm otrs-community-edition-6.0.37.tar.gz
shell> cp /home/user/backup_otrs_config/Config.pm.save /opt/otrs/Kernel/Config.pm
shell> cp /home/user/backup_otrs_config/ZZZAuto.pm.save /opt/otrs/Kernel/Config/Files/ZZZAuto.pm
shell> cd /opt/otrs/
shell> bin/otrs.SetPermissions.pl --web-group=www-data
shell> /opt/otrs/bin/otrs.CheckModules.pl
shell> su otrs
shell> /opt/otrs/bin/otrs.Console.pl Maint::Config::Rebuild
shell> /opt/otrs/bin/otrs.Console.pl Maint::Cache::Delete
shell> su
shell> /etc/init.d/cron start
shell> /etc/init.d/exim4 start
shell> /etc/init.d/apache2 start
shell> su -c "/opt/otrs/bin/Cron.sh start" -s /bin/bash otrs
shell> su -c "/opt/otrs/bin/otrs.Daemon.pl start" -s /bin/bash otrs
Thank you for your help.
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: error OTRS 6.0.37

Post by jojo »

It seems that you are using the Fork from Centuran from Poland, which choosen the name: OTRS Community Edition (https://otrscommunityedition.com) but is not from the manufactor of OTRS the OTRS group.

Currently there are several forks of OTRS, with different vendors, at least:
  • Znuny (based on OTRS 6)
  • OTOBO (based on OTRS 6)
  • Centuran (based on OTRS 6)
  • KIX (based on OTRS 5)

OTRS 6, also named OTRS Community Edition 6 is end of life since end of 2020 and was replaced by OTRS 7 and OTRS 8. Last version is 6.0.30. No security updates are available since then.

So, for your special question you should check if Centuran has a forum or offers support.
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
FSF
Znuny newbie
Posts: 31
Joined: 08 Dec 2022, 12:13
Znuny Version: 6.0.37
Real Name: Frederic

Re: error OTRS 6.0.37

Post by FSF »

OK so to be clear, as I had not seen this story of fork, I am blocked and therefore can not do anything with my server (since I am also blocked with oauth2)

The only solution would be to reinstall everything from scratch with the znuny version for example if I want to stay with the otrs interface that I know, and of course I will then lose all my support history.
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: error OTRS 6.0.37

Post by jojo »

check if followed the instructions for the update. it seems that you forgot at least to run the migration script itself and upgrading of packages.

Can be found in the documentation: https://otrscommunityedition.com/doc/ma ... ating.html
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
wurzel
Znuny guru
Posts: 3224
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: error OTRS 6.0.37

Post by wurzel »

Hi,

restore your backup and do a test migration first.

reinstalling/new installation should not be necessary.

Flo
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11

-- Ich beantworte keine Forums-Fragen PN - No PN please

I won't answer to unfriendly users any more. A greeting and regards are just polite.
FSF
Znuny newbie
Posts: 31
Joined: 08 Dec 2022, 12:13
Znuny Version: 6.0.37
Real Name: Frederic

Re: error OTRS 6.0.37

Post by FSF »

Hello
Sorry to come back to you so late, but I've been very sick (covid)
Here I am again, ready to try to set up a solution

As I always keep track of what I do on my servers here is how I updated OTRS 6.0.35 to OTRS 6.0.37

Code: Select all

shell> mkdir /home/user/backup_otrs_config
shell> /etc/init.d/cron stop
shell> /etc/init.d/exim4 stop
shell> /etc/init.d/apache2 stop
shell> su otrs
shell> cd /opt/otrs/
shell> bin/Cron.sh stop
shell> bin/otrs.Daemon.pl stop
shell> su
shell> cp /opt/otrs/Kernel/Config.pm /home/user/backup_otrs_config/Config.pm.save
shell> cp /opt/otrs/Kernel/System/GenericAgent.pm /home/user/backup_otrs_config/GenericAgent.pm.save
shell> cp /opt/otrs/Kernel/Config/Files/ZZZAuto.pm /home/user/backup_otrs_config/ZZZAuto.pm.save
shell> cd /opt/otrs/scripts
shell> ./backup.pl -d /home/user/backup_otrs/
shell> cd /opt
shell> rm -R otrs-old
shell> mv otrs otrs-old
shell> cd /home/user
shell> wget https://otrscommunityedition.com/download/otrs-community-edition-6.0.37.tar.gz /home/user/
shell> tar -xzf otrs-community-edition-6.0.37.tar.gz
shell> mv otrs-community-edition-6.0.37 /opt/otrs
shell> rm otrs-community-edition-6.0.37.tar.gz
shell> cp /home/user/backup_otrs_config/Config.pm.save /opt/otrs/Kernel/Config.pm
shell> cp /home/user/backup_otrs_config/ZZZAuto.pm.save /opt/otrs/Kernel/Config/Files/ZZZAuto.pm
shell> cd /opt/otrs/
shell> bin/otrs.SetPermissions.pl --web-group=www-data
shell> /opt/otrs/bin/otrs.CheckModules.pl
shell> su otrs
shell> /opt/otrs/bin/otrs.Console.pl Maint::Config::Rebuild
shell> /opt/otrs/bin/otrs.Console.pl Maint::Cache::Delete
shell> su
shell> /etc/init.d/exim4 start
shell> /etc/init.d/apache2 start
shell> su -c "/opt/otrs/bin/Cron.sh start" -s /bin/bash otrs
shell> su -c "/opt/otrs/bin/otrs.Daemon.pl start" -s /bin/bash otrs
So did I forget a command during this migration from 6.0.35 to 6.0.37?

So now that I have restored my 6.0.35 version, can I switch to znuny, or should I stay on the community edition, or should I remount the server from scratch?

I am lost with all the forks, so I don't know which one I should go for?

Thank you all for your help and best wishes for 2023.
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: error OTRS 6.0.37

Post by root »

FSF wrote: 06 Jan 2023, 11:34 I am lost with all the forks, so I don't know which one I should go for?
Hi,

The fork you're using to download is not Znuny. I recommend asking the provider of this fork instead.

- 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 ?
FSF
Znuny newbie
Posts: 31
Joined: 08 Dec 2022, 12:13
Znuny Version: 6.0.37
Real Name: Frederic

Re: error OTRS 6.0.37

Post by FSF »

Hello
Ok, I'll do it differently and open a new topic
Thank you
Post Reply