oauth2 database Errors after Update

Moderator: crythias

Post Reply
kivide
Znuny newbie
Posts: 4
Joined: 03 Jun 2022, 10:48
Znuny Version: 6.3.1
Real Name: Kevin D

oauth2 database Errors after Update

Post by kivide »

Hi,

I updated our otrs installation from znuny 6.3.1 to 6.3.4, after the update / migration script we got the following Error Messages in the otrs log:

Code: Select all

[Mon Jul  4 10:52:42 2022][Error][Kernel::System::DBCRUD::MigrateUUIDDatabaseTableColumns][1800] Unknown column 'z4o_database_backend_uuid' in 'field list', SQL: 'SELECT z4o_database_backend_uuid FROM oauth2_token LIMIT 1'
[Mon Jul  4 10:52:42 2022][Error][Kernel::System::DBCRUD::MigrateUUIDDatabaseTableColumns][1800] Unknown column 'database_backend_uuid' in 'field list', SQL: 'SELECT database_backend_uuid FROM oauth2_token LIMIT 1'
[Mon Jul  4 10:52:42 2022][Error][Kernel::System::DBCRUD::MigrateUUIDDatabaseTableColumns][1800] Unknown column 'z4o_database_backend_uuid' in 'field list', SQL: 'SELECT z4o_database_backend_uuid FROM oauth2_token_config LIMIT 1'
[Mon Jul  4 10:52:42 2022][Error][Kernel::System::DBCRUD::MigrateUUIDDatabaseTableColumns][1800] Unknown column 'database_backend_uuid' in 'field list', SQL: 'SELECT database_backend_uuid FROM oauth2_token_config LIMIT 1'
We are not using oauth2 and the columns 'database_backend_uuid' and 'z4o_database_backend_uuid' are missing in the tables:

Code: Select all

mysql> show columns from oauth2_token;
+-------------------------------+--------------+------+-----+---------+----------------+
| Field                         | Type         | Null | Key | Default | Extra          |
+-------------------------------+--------------+------+-----+---------+----------------+
| id                            | int          | NO   | PRI | NULL    | auto_increment |
| token_config_id               | int          | NO   | UNI | NULL    |                |
| authorization_code            | text         | YES  |     | NULL    |                |
| token                         | text         | YES  |     | NULL    |                |
| token_expiration_date         | datetime     | YES  |     | NULL    |                |
| refresh_token                 | text         | YES  |     | NULL    |                |
| refresh_token_expiration_date | datetime     | YES  |     | NULL    |                |
| error_message                 | text         | YES  |     | NULL    |                |
| error_description             | text         | YES  |     | NULL    |                |
| error_code                    | varchar(250) | YES  |     | NULL    |                |
| create_time                   | datetime     | NO   |     | NULL    |                |
| create_by                     | int          | NO   | MUL | NULL    |                |
| change_time                   | datetime     | NO   |     | NULL    |                |
| change_by                     | int          | NO   | MUL | NULL    |                |
| dbcrud_uuid                   | varchar(36)  | YES  | UNI | NULL    |                |
+-------------------------------+--------------+------+-----+---------+----------------+

Code: Select all

mysql> show columns from oauth2_token_config;
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| id          | int          | NO   | PRI | NULL    | auto_increment |
| name        | varchar(250) | NO   | UNI | NULL    |                |
| config      | text         | NO   |     | NULL    |                |
| valid_id    | smallint     | NO   | MUL | NULL    |                |
| create_time | datetime     | NO   |     | NULL    |                |
| create_by   | int          | NO   | MUL | NULL    |                |
| change_time | datetime     | NO   |     | NULL    |                |
| change_by   | int          | NO   | MUL | NULL    |                |
| dbcrud_uuid | varchar(36)  | YES  | UNI | NULL    |                |
+-------------+--------------+------+-----+---------+----------------+
I cannot recall, if we got similiar messages after upgrading to 6.3.1. But we have no issues with the current system.

How can I resolve these error message, is it enough to create these columns?
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: oauth2 database Errors after Update

Post by root »

Hi,

This error message should not be seen again, it's related to the fact that Znuny support customer had access to the OAuth module for version 6.0 and checking and renaming these column is part of the migration. You can ignore them.

- 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 ?
Post Reply