User is blocked

Hello @rusomenace 

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

Regards

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

@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

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

Hi, 

Tried to reset my admin password with the next command :

UPDATE contact SET contact_passwd=md5('toto') where contact_alias='admin';

but ==> Unknown column 'contact_passwd' in 'field list'

Checked the fields with “SELECT * FROM contact;” …did not find it.

Any help ?

Hi @BastienO 

From Centreon 22.04, the algorithm of password hash is in BCRYPT and no more in MD5.

If you need to hardcode a password directly in a database, the MD5('mypassword') function will no more work (the login will try to compare a MD5 password in database with a BCRYPT hash and your authentication will fail).

To avoid this, here is a pair of clear password => hash value. Be sure to write the hashed password in database.

Also the database structure has changed. Now the password are stored in a dedicate table, to update your user password use the following query:

MariaDB [centreon]> desc contact_password;
+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| id            | int(11) unsigned    | NO   | PRI | NULL    | auto_increment |
| password      | varchar(255)        | NO   |     | NULL    |                |
| contact_id    | int(11)             | NO   | MUL | NULL    |                |
| creation_date | bigint(20) unsigned | NO   | MUL | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+

INSERT INTO contact_password (password, contact_id, creation_date) VALUES (<your_encrypted_password, <contact_id>, (SELECT UNIX_TIMESTAMP(NOW())));

You can now login as usual with your credentials:

• username: <your_username>
• password: centreon

Warning: You will be able to connect to Centreon UI or API with this password, but it doesn’t follow any security policy so be sure to change it for a safer one when you are able to connect to Centreon.

Bonjour.

Je m’appel Laurent et je débute sur Centreon et je n’ai que très très peu de notion dans Mysql.
Je sais me connecte à ma DB centreon avec mysql en root.

Je suis dans le même cas que Rusomenace.
J’ai appliqué les 2 commandes données par @ponchoh et @sduret mais hélas, à chaque fois j’ai la même erreur.
 

Quand je tape : 

 update centreon.contact set login_attempts=NULL, blocking_time=NULL where contact_id = admin;

ou 

UPDATE contact SET contact_passwd = md5(mypwd) WHERE contact_alias = admin;

cela me répond : 

ERROR 1054 (42S22): Unknown column 'admin' in 'where clause'

Je ne sais pas comment interpréter cette réponse, je suis bloqué.

A savoir que c’est “admin” qui est bloqué à la page web de connexion à centreon.
Et bien entendu je n’ai qu’un seul utilisateur.

Merci d’avance pour votre aide.

J’ai réussi après plusieurs essai!!!

J’ai tapé ca : 

MariaDB [centreon]> update centreon.contact set login_attempts=NULL, blocking_time=NULL;

Ca a répondu : 

Query OK, 1 row affected (0.005 sec)
Rows matched: 4  Changed: 1  Warnings: 0

et j’ai récupéré mon accès  :)

Merci quand même de m’avoir lu ;)

update centreon.contact set login_attempts=NULL, blocking_time=NULL where contact_id = 'admin';

Merci pour votre explication :)

Laurent.

It’s OK I find it :

INSERT INTO contact_password (password, contact_id, creation_date) VALUES ('$2y$10$ubq1hJ9z3YPXBhejjae.Ie9u3AcMrwFNImPhOnnkLmEoNtwRGwNrC', 1, (SELECT UNIX_TIMESTAMP(NOW())));

It will be more easy for noob like me to have the full cmd line !