You are not logged in.
- Topics: Active | Unanswered
Announcement
Download last stable version of GLPI - What can you do for GLPI ? : Contribute
Pages: 1
Topic closed
#1 2012-04-30 14:56:14
- andres87
- Member
- Registered: 2012-04-30
- Posts: 19
problem with super-admin glpi
Hi, I just installed the windows server 2003 glpi in Joomla integrated with what they use the same database.
Well my problem is this: I deleted the user super-admin 'glpi' accidentally so now I can only connect as a user-only post.
I'd like to give me a solution as quickly as possible.
thanks
Offline
#2 2012-04-30 15:31:28
- yllen
- GLPI-DEV
- From: Sillery (51)
- Registered: 2008-01-14
- Posts: 15,278
Re: problem with super-admin glpi
Version of GLPI used ?
CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6 - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)
Offline
#3 2012-04-30 18:10:04
- andres87
- Member
- Registered: 2012-04-30
- Posts: 19
Re: problem with super-admin glpi
the version 0.83.1
Offline
#4 2012-05-02 09:05:38
- yllen
- GLPI-DEV
- From: Sillery (51)
- Registered: 2008-01-14
- Posts: 15,278
Re: problem with super-admin glpi
SQL request to execute
INSERT INTO `glpi_users` VALUES ('2','glpi','0915bd0a5c6e56d8f38ca2b390857d4949073f41','','','','',NULL,'0',NULL,'0','20','1',NULL,'0','1','2012-04-05 20:32:00','2010-05-06 09:31:04',NULL,'0','0','0','0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6 - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)
Offline
#5 2012-05-02 09:18:17
- andres87
- Member
- Registered: 2012-04-30
- Posts: 19
Re: problem with super-admin glpi
Thanks, but can u finish the command line, please?
Last edited by andres87 (2012-05-02 09:42:56)
Offline
#6 2012-05-02 10:25:05
- yllen
- GLPI-DEV
- From: Sillery (51)
- Registered: 2008-01-14
- Posts: 15,278
Re: problem with super-admin glpi
Sorry, bug in copy/paste
INSERT INTO `glpi_users` VALUES ('2','glpi','0915bd0a5c6e56d8f38ca2b390857d4949073f41','','','','',NULL,'0',NULL,'0','20','1',NULL,'0','1','2012-04-05 20:32:00','2010-05-06 09:31:04',NULL,'0','0','0','0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6 - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)
Offline
#7 2012-05-02 10:39:18
- andres87
- Member
- Registered: 2012-04-30
- Posts: 19
Re: problem with super-admin glpi
ok but I copy and pasted it but I get the following error and that I have created the user glpi. The problem I can not go to the user as super-admin glpi as glpi modify the user to make super-admin and change the profile to be super-admin in my server preferences glpi or where glpi_users table field has to be modified?
Last edited by andres87 (2012-05-02 12:07:44)
Offline
#8 2012-05-02 12:44:40
- yllen
- GLPI-DEV
- From: Sillery (51)
- Registered: 2008-01-14
- Posts: 15,278
Re: problem with super-admin glpi
For the profile :
INSERT INTO `glpi_profiles_users` VALUES ('2','2','4','0','1','0');
CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6 - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)
Offline
#9 2012-05-02 13:19:52
- andres87
- Member
- Registered: 2012-04-30
- Posts: 19
Re: problem with super-admin glpi
Thanks you, thanks I've been very helpful
Offline
#10 2012-05-02 15:50:43
- yllen
- GLPI-DEV
- From: Sillery (51)
- Registered: 2008-01-14
- Posts: 15,278
Re: problem with super-admin glpi
OK, i close
CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6 - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)
Offline
Pages: 1
Topic closed