Question

User is blocked

  • 6 April 2023
  • 2 replies
  • 270 views

Badge

Guys i just installed Centreon for testing on my lab, for whatever reason i was using the incorrect password for the user admin in the web access and now the user is bloqued . The version is v.22.04

Do you have any advise on how to unlock the user, i have access to the centos root without any problems.

Also, i am using Centos7 Vmware workstation so when i tried some command line like ; 

VALUES $2y$10$j7nGYTRR9gjcXpC9YIqR1uc5LDKbx1WJXJp7GIh/FpIJ3WoVbH9mO, <admin>, (SELECT UNIX_TIMESTAMP(NOW())));
bash: Erreur de syntaxe près du symbole inattendu « ( »
 

 INSERT INTO contact_password (password, contact_id, creation_date) VALUES ('$2y$10$j7nGYTRR9gjcXpC9YIqR1uc5LDKbx1WJXJp7GIh/FpIJ3WoVbH9mO', <admin>, (SELECT UNIX_TIMESTAMP(NOW())));
bash: Erreur de syntaxe près du symbole inattendu « ( »

update centreon.contact set login_attempts=NULL, blocking_time=NULL where contact_id=[change];

it simply doesn’t work, so help pretty please?


2 replies

Userlevel 3
Badge +6

Hi,

Try this:

use centreon;

select contact_id,contact_alias,blocking_time,login_attempts from contact where
contact_alias ='admin';

Then you’ll have the admin ID.

Update the contact:

update contact set blocking_time=NULL,login_attempts=NULL where contact_id='your admin ID from previous query';

Already used to unlock a blocked user.

No need to insert a new password.

Userlevel 5
Badge +11

Hi @DaFamo, did the solution you got from @MichaelW work for you? If yes, could you do us a solid and mark it as the "Best Answer"? That way, other folks who encounter the same issue can find the fix in a jiffy. Thanks 😉

Reply