"You are not permitted to access this section of Cacti"

[regdone]

Dear all,

Recently when I login Cacti with admin account, I can not see some link such as Device, User Management... (as attachment)

cacti_menu_error_1.png (6.23 KiB) Viewed 5029 times

When I type http://myip/cacti/host.php or http://myip/cacti/user_admin.php there is error message:
"You are not permitted to access this section of Cacti. If you feel that you need access to this particular section, please contact the Cacti administrator."
All my graphs running well, but I cannot add more devices or more users.
Anyone can help me?

Thanks,

[gandalf]

In this time, some realms are missing. In case you have a second if that is allowed to perform "User Management", you may add the missing realms there.
Else, see cacti.sql file and search for user_realm to find the id's required. Assuming, the admin account still has it's original id, you may simply add all those realms by using mysql cli
R.

[regdone]

Hi Gandalf,

Thanks for your reply.
I did a query that resulted in:

Code: Select all

mysql> select * from user_auth_realm;
+----------+---------+
| realm_id | user_id |
+----------+---------+
|        2 |       1 |
|        2 |       5 |
|        3 |       5 |
|        4 |       1 |
|        4 |       5 |
|        5 |       1 |
|        5 |       5 |
|        7 |       1 |
|        7 |       3 |
|        7 |       5 |
|        7 |       7 |
|        7 |       8 |
|        7 |       9 |
|        7 |      10 |
|        7 |      11 |
|        8 |       1 |
|        8 |       5 |
|        9 |       1 |
|       10 |       1 |
|       11 |       1 |
|       12 |       1 |
|       13 |       1 |
|       14 |       1 |
|       15 |       1 |
|       16 |       1 |
|       16 |       5 |
|       17 |       1 |
|       17 |       5 |
|       32 |       1 |
|       32 |       5 |
|      101 |       1 |
|      102 |       1 |
|      102 |       5 |
|      103 |       1 |
|      103 |       5 |
|      104 |       1 |
|      105 |       1 |
|      106 |       1 |
|      106 |       3 |
|      106 |       5 |
|      106 |       9 |
|      106 |      11 |
|      107 |       1 |
|      107 |       5 |
|      108 |       1 |
|      108 |       5 |
|      109 |       1 |
|      110 |       1 |
|      112 |       1 |
+----------+---------+

The admin id is 1, therefor I think there are no realm that admin account is missing.

[regdone]

Hi Gandalf,

Thank for again,
I then did an insert command:

mysql> insert into user_auth_realm value (1,1);

and I can show "User Management" menu again

Thank you very much !

[mrscary]

old topic.. but i tried to upgrade my setup to today to the latest... i got DB errors, so i went to reload an old version and now i cant login at all.
i cant even run the command listed here. i get insert into user_auth_realm value (1,1);
im running solo as of late due to corona.. so i need a bit of help.. id hate to think my db and everything in it is lost forever.

my database issues started at the end of the upgrade with ALTER TABLE aggregate_graphs ADD COLUMN gprint_format CHAR(2) default "" AFTER gprint_prefix'); giving me 2 tables it cant update.. and now i cant do squat with anything.

[TheWitness]

Yea, posting to an old topic not a good idea. What what version to what version?

[mrscary]

1.1.37 to 1.2.10