Hello,
I need your help, the password of my centreon has expired, so I have to change it but when I try to change it I get an error "Width must be an integer"
centreon 22.04
Solved
can't change password
Best answer by Ov3rFlo
Hi,
To change the default password, connect to your server as root and run this command:
[root@centreon-central ~]# mariadb -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 14
Server version: 10.5.15-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> use centreon;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [centreon]> INSERT INTO contact_password (password, contact_id, creation_date) VALUES ('$2y$10$ubq1hJ9z3YPXBhejjae.Ie9u3AcMrwFNImPhOnnkLmEoNtwRGwNrC', 1, (SELECT UNIX_TIMESTAMP(NOW())));
Query OK, 1 row affected (0.002 sec)
Now you can connect to Centreon with the login/password: admin/centreon
Don't forget to change this password by editing your profile !
+14👋
or
Regarding the error, does the new password match your “password security policy” ?
🤞
+21Hi
👋
or
Regarding the error, does the new password match your “password security policy” ?
🤞
Hello
I’ve already check this, i have found with this topic how i can modify the database to regain access, and i have update manually the timestamp of the expiration of the password.
For the password security policy it’s a generated password like the oldest.
I have the same problem. Where you able to solve this?
Hello Thomas,
i have updated the timestamp of the password un the database
Hi, we are able to reproduce the bug and have certainly found the root cause of this issue. We’ll start to develop a patch for this soon.
Hi,
To change the default password, connect to your server as root and run this command:
[root@centreon-central ~]# mariadb -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 14
Server version: 10.5.15-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> use centreon;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [centreon]> INSERT INTO contact_password (password, contact_id, creation_date) VALUES ('$2y$10$ubq1hJ9z3YPXBhejjae.Ie9u3AcMrwFNImPhOnnkLmEoNtwRGwNrC', 1, (SELECT UNIX_TIMESTAMP(NOW())));
Query OK, 1 row affected (0.002 sec)
Now you can connect to Centreon with the login/password: admin/centreon
Don't forget to change this password by editing your profile !
Any news on when this issue is resolved?
is this bugreport in a publicstate or in your internal github?
+2Hi,
To change the default password, connect to your server as root and run this command:
Nice, it worked like a charm!
I just can't believe the appliance comes with this issue, thank you very much for the code.
Don't forget to change this password by editing your profile !
Sorry, I don’t understand what you meant here. What profile?
Kind regards,
LM
+14+2
I guess you are right, thanks! :-)
+21
Nice, it worked like a charm!
I just can't believe the appliance comes with this issue, thank you very much for the code.
I'm not sure I understand.
Centreon install a default security policy. This one ask for 12 characters including lowercase uppercase number and special characters. So if you don’t change it, your new password must matchs this policy.
+6+21Hi
+6I understand but just indicate “your password don’t match the password policy” is enough.
Thank you.
+2I’m not able to change admin password from web panel as an error message tells me the password is not expired. Can’t force it?
Thx for your help.
+21HI
+2HI
Centreon 23.04.7
Hi
Guess what i managed to update password with:
SELECT contact_id, contact_name FROM centreon.contact;
USE centreon;
UPDATE contact_password SET password = md5('newone') WHERE contact_id = 1;
But i can’t get rid of the last critical error concerning centreon-engine
centreon-central service:
CRITICAL: Cannot connect: Access denied for user 'centreon-engine'@'localhost'
Unable to hide passwords in command (Reason: Configuration has changed)
Does it make sense?
Best Regards
Gilles
+2HI
NB: the service which is yelling is connection-time
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.