error OTRS 6.0.37

[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]

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

[root]

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

[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]

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.

[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]

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

[wurzel]

Hi,

restore your backup and do a test migration first.

reinstalling/new installation should not be necessary.

Flo

[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]

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

[FSF]

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