Forum GLPI-Project

jupiranycarreira

Member

Registered: 2024-06-25

Posts: 2

I lost permissions on Super-admin profiles

A coworker with a super admin profile was able to disable all super admin permissions on the profiles.

From the looks of it, no other users in the company have access to the GLPI admin area to reverse the error, and unfortunately we haven't had a recent backup.

I was instructed to access phpMyAdmin, but I don't have the in-depth knowledge to make changes.

If there is a more didactic method to undo this error, I would be very grateful.

mmoral

Member

Registered: 2023-12-28

Posts: 50

Re: I lost permissions on Super-admin profiles

You can install a fresh GLPI on other computer.

Do the next select on the new DDBB: SELECT * FROM `glpi`.glpi_profilerights where profiles_id = 4;

The profile_id 4 is the Super-Admin profile

The result of the select you can insert on your ddbb, making a previous backup for security.

Later login with an user with the profile super-admin.
The default user glpi have this profile, you also can "restore" this user making a select on the new ddbb: SELECT * FROM `glpi`.glpi_users where name = "glpi";
The result of the select you can insert on your ddbb

I think this could be a possible solution.

sIBajHYG

Member

From: Mission [KS]

Registered: 2023-08-18

Posts: 75

Re: I lost permissions on Super-admin profiles

---

Linux ubuntu-22.04.2-live-server-amd64, PHP 8.1.2, Apache 2.4.52, MariaDB 10.6.12, GLPI 10.0.15.
GLPI Inventory 1.3.5, PHP SAML 1.3.0,  Oauth IMAP 1.4.3, Additional Fields, 1.21.8,Ticket Cleaner.