Recover superadmin user that I changed accidentaly to postonly

carias · 2010-05-06 02:06:43

I was writing a manual for GLPI helpdesk and created a usar called super2 because I already have my super admin user called super to test functions. When I was creating the new user I checked for it and accidentaly let super-admin as post-only. Now I can not enter in GLPI. How can I revert this situation?

remi · 2010-05-06 07:01:45

You must edit the glpi_profiles table manually.

For GLPI 0.72.3 or 0.72.4 only :

REPLACE INTO `glpi_profiles` VALUES ('4','super-admin','central','0','w','w','w','w','w','w','w','w','w','w','w','w','w','w','w','w','1','w','r','w','r','w','w','w','w','w','w','w','w','w','w','w','w','w','r','w','w','w','w','w','w','r','w','w','w','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','3','8388674','0','0','w','w');

+

carias · 2010-05-06 14:40:59

Thank you for yor answer but sorry by my ignorance. Is glpi_profiles a table that I need to alter through MySQL commands?
How do I add a new user with super-admin profile if I only have admin users at this moment?
Thanks in advance again. I am very worried because GLPI is keeping information about 500 PC and I can not access it like super-admin user anymore.

yllen · 2010-05-07 11:04:10

carias wrote:

Is glpi_profiles a table that I need to alter through MySQL commands?

Yes (Remi give you the rignt command)

carias wrote:

How do I add a new user with super-admin profile if I only have admin users at this moment?

You alter glpi_profiles and you'll have your user "super-admin"

Forum GLPI-Project

Announcement

#1 2010-05-06 02:06:43

Recover superadmin user that I changed accidentaly to postonly

#2 2010-05-06 07:01:45

Re: Recover superadmin user that I changed accidentaly to postonly

#3 2010-05-06 14:40:59

Re: Recover superadmin user that I changed accidentaly to postonly

#4 2010-05-07 11:04:10

Re: Recover superadmin user that I changed accidentaly to postonly

Board footer