Question

Error access-denied

  • 14 August 2023
  • 14 replies
  • 1674 views

Badge +1

Dear

I did a fresh VMware 23.04 installation. I have 3 problems with this installation.
Error message :

  • Connection-Time : CRITICAL: Cannot connect: Access denied for user 'centreon-engine'@'localhost'
  • proc-rsyslogd : Number of current processes running: 0
  • proc-postfix : Number of current processes running: 0

     

Also, during server reboot, wait 30 minutes before data refresh. I think about first error message

 

Centreon also does not want to change the administrator password 

Thanks to help me


J'ai fait une nouvelle installation VMware 23.04. J'ai 2 porblèmes avec cette installation.
Message d'erreur 

  • Connection-Time : CRITICAL: Cannot connect: Access denied for user 'centreon-engine'@'localhost'
  • proc-rsyslogd : Number of current processes running: 0
  • proc-postfix : Number of current processes running: 0

Egalement, lors du redémarrage serveur, il faut attendre 30 minutes avant l'actualisation des données

Centreon ne veut pas non plus changer le mot de passe administrateur 

Merci de votre aide


14 replies

Badge +1

Dear

I did a fresh VMware 23.04 installation. I have 3 problems with this installation.
Error message :

  • Connection-Time : CRITICAL: Cannot connect: Access denied for user 'centreon-engine'@'localhost'
  • proc-rsyslogd : Number of current processes running: 0
  • proc-postfix : Number of current processes running: 0

     

Also, during server reboot, wait 30 minutes before data refresh. I think about first error message

 

Centreon also does not want to change the administrator password 

Thanks to help me

 

Hello,

I have exactly the same problem.

Please can someone help us with these issues?


Thank you!

Badge +1

Hello,

Nobody can help us with this issue?

Thanks,

Badge +1

Impossible to change the password...

Badge +1

Centreon also does not want to change the administrator password 

Thanks to help me

Hello @Cyrille , just solved it this by doing this:

  1. connect to mysql running “mariadb”
  2. SELECT contact_id, contact_name FROM centreon.contact; (to get the ID of the contact you want to reset the password)
  3. UPDATE contact_password SET password = md5('XXX') WHERE contact_id = XX;
  4. Voilà 😀
Badge

Hi,

Not solved for this service...

Connection-Time:
Status information

CRITICAL: Cannot connect: Access denied for user 'centreon-engine'@'localhost'

 

I’m running a virtualbox ova instance in Centreon 23.04.723 Alma Linux 8.

 

What i’ve done wrong?

 

Accounts seems ok know…

 

Best regards,

 

Gilles

 

Badge +2

Hello,

Did you solve the problem for centreon-engine access denied?

I followed the doc to secure my install and I get the same messages.

No user called centreono-engine in MariaDB.

Thank you


Bonjour,

Avez-vous résolu le souci “access denied” pour l’utilisateur centreon-engine?

J’ai le même message après avoir suivi la doc pour sécuriser l’installation, et je n’ai pas d’utilisateur centreon-engine dans MariaDB.

Cela ressemble a un problème strictement système de Linux, mais je n’ai pas trouvé où modifier ça dans l’interface Web de centreon.

Merci

Hi,

I have the same problem : UNKNOWN: Cannot connect: Access denied for user 'centreon-engine'@'localhost'

The database’s user is centreon and not centreon-engine, where can we change this information ?

I’ve tried to add macros in the centreon host configuration MYSQLUSERNAME and MYSQLPASSWORD  but he keep centreon-engine @ localhost.

 

Thank’s for your help.

 

Badge +1
Good morning,
I’ve the same problem with version 23.04 for services:.
  • Open-Files
  • Mysiam-Keycache
  • Database-Size
  • Conneections-Number
  • Partitioning
  • Slowqueries
  • Queries
  • Connection-Time

Cannot connect: Access denied for user ‘centreon-engine’@’localhost’

Has anyone managed to resolve the connection problem?
Badge +4

Now, im going to help in the forum.

I had the same problem, when you copy the configuration files, you overwrite the file that contain the password:

https://thewatch.centreon.com/platform-7/mariadb-access-denied-for-user-centreonatlocalhost-2439

Badge +1
the passwords are correctly entered in plain text in both files but it still does not work
Badge +1

please have you a solution ?

Badge

a solution ?

Badge
to get around the problem:

CREATE USER 'centreon-engine'@'localhost' IDENTIFIED BY 'centreon';

GRANT ALL PRIVILEGES ON *.* TO 'centreon-engine'@'localhost' WITH GRANT OPTION;

 

Badge +1

@Cyrille 

bonjour Cyrille, peux tu lister les users que tu as actuellement au niveau de ta base de données ?

 

par exemple : select user, host from mysql.user where host <> 'localhost';

essaie aussi : select user, host from mysql.user where host <> 'adress-ip';

 

Kay

Reply