Admin tab disappeared and no tickets

[Nickcarter]

Hello guys.
I know, this topic has been handled several times, but none of what you wrote helped me to solve this issue.
I am migrating an old Community edistion from 4.0.30 directly to 5.0.42 and i'm stuck here. I will go to 6.x later.
I used this guide : https://ww.sd.vc/wp/2015/10/21/upgradin ... om-4-to-5/

As i wrote in the title, dashboard admin tab disappeared. Here some debug i made:

- otrs/index.pl?Action=Admin No Permission to use this frontend module
- SQL group list

Code: Select all

mysql> SELECT * FROM `groups`where name='admin';
+----+-------+------------------------------+----------+---------------------+-----------+---------------------+-----------+
| id | name  | comments                     | valid_id | create_time         | create_by | change_time         | change_by |
+----+-------+------------------------------+----------+---------------------+-----------+---------------------+-----------+
|  2 | admin | Group of all administrators. |        1 | 2015-03-13 16:18:05 |         1 | 2015-03-13 16:18:05 |         1 |
+----+-------+------------------------------+----------+---------------------+-----------+---------------------+-----------+

- Sql User List (my user are 1-superuser and 2-everyday user)

Code: Select all

mysql> SELECT * FROM `group_user`where group_id=2;
+---------+----------+----------------+------------------+---------------------+-----------+---------------------+-----------+
| user_id | group_id | permission_key | permission_value | create_time         | create_by | change_time         | change_by |
+---------+----------+----------------+------------------+---------------------+-----------+---------------------+-----------+
|       1 |        2 | rw             |                1 | 2015-03-13 16:18:05 |         1 | 2015-03-13 16:18:05 |         1 |
|       2 |        2 | rw             |                1 | 2015-03-13 17:04:27 |         1 | 2015-03-13 17:04:27 |         1 |
|       6 |        2 | rw             |                1 | 2018-06-26 10:25:01 |         2 | 2018-06-26 10:25:01 |         2 |
|       8 |        2 | rw             |                1 | 2023-02-10 18:50:01 |         1 | 2023-02-10 18:50:01 |         1 |
+---------+----------+----------------+------------------+---------------------+-----------+---------------------+-----------+
4 rows in set (0.00 sec)

- adding manually the group from console:

Code: Select all

otrs@linux:~$ bin/otrs.Console.pl Admin::Group::UserLink --user-name "nick" --group-name "admin" --permission ro
Error: Group admin does not exist.

What the....******

performing a select it exists!

and since things are getting weirdier i rebuilded/delete cach several times.

i had also a look at viewtopic.php?p=75735#p75735 and i went commando in searching for "Admin-Area" in ZZZAAuto.pm :

Code: Select all

$Self->{'Frontend::Module'}->{'Admin'} =  {
  'Description' => 'Admin-Area',
  'Group' => [
    'admin'
  ],

This part is totally missing.

Well i'm lost, and i have not any other ideas. I also tried to add manually via SQL an user, setting group id= 2. The user logs in but no admin area.

Should i attach ZZZAAuto.pm?

[root]

Hi,

I would try first if some change in the system configuration broke something. to figure this out:

1) Move Kernel/Config/Files/ZZZAuto.pm away (don't delete it, these are your changes)
2) Rebuild the configuration again: bin/otrs.Console.pl Maint::Config::Rebuild
3) Delete the cache bin/otrs.Console.pl Maint::Cache::Delete
4) Restart the webserver
5) Log in

If you can log in, then there are some changes in the system configuration (ZZZAuto.pm) which may be odd.

- Roy

[jojo]

did you also switched to MySQL 8?

[Nickcarter]

did you also switched to MySQL 8?

mysql --version
mysql Ver 8.0.32-0ubuntu0.22.04.2 for Linux on x86_64 ((Ubuntu))

[Nickcarter]

Hi,

I would try first if some change in the system configuration broke something. to figure this out:

1) Move Kernel/Config/Files/ZZZAuto.pm away (don't delete it, these are your changes)
2) Rebuild the configuration again: bin/otrs.Console.pl Maint::Config::Rebuild
3) Delete the cache bin/otrs.Console.pl Maint::Cache::Delete
4) Restart the webserver
5) Log in

If you can log in, then there are some changes in the system configuration (ZZZAuto.pm) which may be odd.

- Roy

hello, i have already tried it. Anyway i tried again, and no luck.

What do you mean with odd changes ?

What is the difference between ZZZAuto.pm and ZZZAAuto.pm ? Asking this since ZZZAAuto is not present in the updated version.

i moved the ZZZAuto.pm from the previous installation to the new one during the upgrade process.

Also: i did some investigation . The Admin-Area is no present in the current installation directory, but it was in the old installation in ZZZAAuto.pm
In the new installation i found "Admin Area" without the -

Code: Select all

x@linux:/opt/otrs.produzione/Kernel/Config/Files# grep Admin-Area /opt/otrs/Kernel/Config/Files/ZZZ*
x@linux:/opt/otrs.produzione/Kernel/Config/Files# grep Admin-Area ZZZ*
ZZZAAuto.pm:  'Description' => 'Admin-Area',
x@linux:/opt/otrs.produzione/Kernel/Config/Files#

[jojo]

mysql --version
mysql Ver 8.0.32-0ubuntu0.22.04.2 for Linux on x86_64 ((Ubuntu))

OTRS 5 and 6 do not support MySQL 8

[Nickcarter]

mysql --version
mysql Ver 8.0.32-0ubuntu0.22.04.2 for Linux on x86_64 ((Ubuntu))

OTRS 5 and 6 do not support MySQL 8

so, should i go further on update to znuny 6.0 + 6.1 + 6.2 + 6.3 + 6.4 not skipping a single subversion ?

[wurzel]

Hi,

you have to update your OTRS on mysql <8

Flo