Question

User is blocked

  • 21 June 2022
  • 8 replies
  • 182 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.

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

 

Thanks


8 replies

Userlevel 3
Badge +10

Hello @rusomenace 

Just to confirm, do you want a solution to change the admin password without any access to the GUI?

Regards

Badge

Hello @sduret,

I have the same problem, the admin account is blocked after the installation.

I want to reset the password with the command line but i don’t know how to do.

Thanks

Userlevel 3
Badge +10

Hello
You can connect to the DB and execute this query:

USE centreon
UPDATE contact SET contact_passwd = md5('NEW_PASSWORD') WHERE contact_alias = 'CONTACT_ALIAS';

Regards

Badge

I'm new to Linux.
How can I connect to the Centreon database to execute the command you sent me?

Thanks

Regards

Userlevel 3
Badge +10

@AVAYER you can read this article:

https://dev.mysql.com/doc/refman/8.0/en/connecting.html

 

So for instance, you can use this ocmmand line:

mysql -h XX.XX.XX.XX -u centreon -ppassword

If the database is on localhost and you don’t have password for root user, you can simply use:

mysql -u root

Regards

hi @AVAYER and @rusomenace if you are blocked under the v.22.04

 

you can reset the user with the next query, make sure to use the right contact ID (replace [change] with the right number id.

 

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

 

 

Can I recommend to use the CentOS7 VMWare (OVA) images (https://download.centreon.com/) and follow the documentation https://docs.centreon.com/docs/installation/installation-of-a-central-server/using-virtual-machines/

Badge

I managed to successfully login to the web interface. Thanks a lot for your help

Badge +1

Hello,

 

If you want to desactivate the “blocking option” as me, you need to set “Time that must pass before new connection is allowed” to 0 minute.

Reply