"No Permission to use this frontend module" error after fresh install

Moderator: crythias

Post Reply
happyfeet
Znuny newbie
Posts: 4
Joined: 07 Oct 2021, 16:35
Znuny Version: 6.0.32
Real Name: Anton

"No Permission to use this frontend module" error after fresh install

Post by happyfeet »

Installed OTRS Community edition 6.0.32. Followed all steps in installer.pl and used existing database in AWS RDS.
All went successfully, and I was able to login to the site on otrs.domain.com/index.pl
And there I see red alert: (attachment 1)
"Don't use the Superuser account to work with ((OTRS)) Community Edition! Create new Agents and work with these accounts instead. "
If I click on it, I get message: (attachment 2)
" Message: No Permission to use this frontend module!"

I tried to switch databases, both use existing and creating new one. Mysql version is 8.0
Initially, had error that mysql files otrs-initial_insert.mysql.sql, otrs-schema-post.mysql.sql and otrs-schema.mysql.sql coudn't be applied to database, because it had statements like CREATE TABLE groups which I had to convert to CREATE TABLE `groups` to avoid errors.
But now, if check database, that seems fine:
mysql> select * from users;
+----+----------------+------------------------------------------------------------------+-------+------------+-----------+----------+---------------------+-----------+---------------------+-----------+
| id | login | pw | title | first_name | last_name | valid_id | create_time | create_by | change_time | change_by |
+----+----------------+------------------------------------------------------------------+-------+------------+-----------+----------+---------------------+-----------+---------------------+-----------+
| 1 | root@localhost | 0235b.....e2 | NULL | Admin | OTRS | 1 | 2021-10-07 10:26:31 | 1 | 2021-10-07 10:26:31 | 1 |
+----+----------------+------------------------------------------------------------------+-------+------------+-----------+----------+---------------------+-----------+---------------------+-----------+
1 row in set (0.00 sec)

mysql> select * from `groups`;
+----+-------+------------------------------+----------+---------------------+-----------+---------------------+-----------+
| id | name | comments | valid_id | create_time | create_by | change_time | change_by |
+----+-------+------------------------------+----------+---------------------+-----------+---------------------+-----------+
| 1 | users | Group for default access. | 1 | 2021-10-07 10:39:23 | 1 | 2021-10-07 10:39:23 | 1 |
| 2 | admin | Group of all administrators. | 1 | 2021-10-07 10:39:28 | 1 | 2021-10-07 10:39:28 | 1 |
| 3 | stats | Group for statistics access. | 1 | 2021-10-07 10:39:35 | 1 | 2021-10-07 10:39:35 | 1 |
+----+-------+------------------------------+----------+---------------------+-----------+---------------------+-----------+
3 rows in set (0.00 sec)
mysql> select * from `group_user`;
+---------+----------+----------------+---------------------+-----------+---------------------+-----------+
| user_id | group_id | permission_key | create_time | create_by | change_time | change_by |
+---------+----------+----------------+---------------------+-----------+---------------------+-----------+
| 1 | 1 | rw | 2021-10-07 10:26:31 | 1 | 2021-10-07 10:26:31 | 1 |
| 1 | 2 | rw | 2021-10-07 10:26:31 | 1 | 2021-10-07 10:26:31 | 1 |
| 1 | 3 | rw | 2021-10-07 10:26:31 | 1 | 2021-10-07 10:26:31 | 1 |
+---------+----------+----------------+---------------------+-----------+---------------------+-----------+
3 rows in set (0.00 sec)

Any idea what am I doing wrong?
You do not have the required permissions to view the files attached to this post.
skullz
Znuny superhero
Posts: 618
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: "No Permission to use this frontend module" error after fresh install

Post by skullz »

Mysql 8.0 not supported.
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:

Re: "No Permission to use this frontend module" error after fresh install

Post by reneeb »

Maybe switch to Znuny 6.1.x as that changed the tablename to avoid the conflict.
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
happyfeet
Znuny newbie
Posts: 4
Joined: 07 Oct 2021, 16:35
Znuny Version: 6.0.32
Real Name: Anton

Re: "No Permission to use this frontend module" error after fresh install

Post by happyfeet »

skullz wrote: 11 Oct 2021, 12:27 Mysql 8.0 not supported.
That fixed it, thanks.
reneeb wrote: 12 Oct 2021, 09:21 Maybe switch to Znuny 6.1.x as that changed the tablename to avoid the conflict.
Maybe we will try it too, thanks.
Post Reply