Forum GLPI-Project

EnTeR_1

Member

Registered: 2018-06-15

Posts: 1

I deleted the rights of the super administrator ))))

When installing the plugin, unfortunately the employee removed the rights of super administrator. Tried to restore, but does not come out.
The base is on MariaDB, version glpi 923

Friends tell me how to restore them?
System administrator on vacation at the moment there is no possibility to deploy a new database and roll the backup.

LaDenrée

HELPER

Registered: 2012-11-19

Posts: 6,168

Re: I deleted the rights of the super administrator ))))

/!\ be careful /!\
first  dump your database and make sure you can restore.

1) can you insert/update  yous database ?

2) did you erase a profile or user/profile associations ?

in database using phpmyadmin or command line  :

select * from glpi_profiles where id=4     : do you get 1 record ?

select * from glpi_users where name='SuperAdminLogin'  => get superadmin id

SELECT * FROM `glpi_profiles_users`  where users_id= 'super admin ID'

ONLY IF  YOU DONT GET RECORD FOR SUPERADMIN WITH PROFILES_ID=4

INSERT INTO `glpi_profiles_users` (users_id,profiles_id,is_dynamic,is_recursive,entities_id) values ( 'super admin ID',4,0,1,0)

then you should get in GLPI GUI rights for superadmin

---

Trouver la panne avant de réparer...
GLPI10.0.10 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.2 reports 1.16.0 formcreator 2.13.8, datainjection 2.13.4 fields 1.21.6