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 |
+----+-------+------------------------------+----------+---------------------+-----------+---------------------+-----------+
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.
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'
],
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?