Skip to main content
Solved

mariadb, access denied for user centreon@localhost

  • October 20, 2023
  • 8 replies
  • 2364 views

ensenada
Forum|alt.badge.img+7

Hello,

Im following the migration guide:

https://docs.centreon.com/docs/migrate/migrate-from-el-to-debian/#prerequisites

After done the steps 4 adn 5 from Step 2 : Synchronize the data, i cant log in the web interface.

 

in SYSLOG i have this errors:

I have try to grant permision to mysql database

 

But still is not working. Any idea?

Thanks,

Best answer by lpinsivy

Password must be in plain text in both files.

8 replies

ensenada
Forum|alt.badge.img+7
  • Author
  • Steward ***
  • 36 replies
  • October 23, 2023

Wow, many thanks.

 

I have contracted centreon support and they don't help me with these migration problems,

I ask in the forum and they don't help me either.

 

Great forum and great company.

 

 


fgbetokpanou
Centreonian
Forum|alt.badge.img+11
  • Centreonian
  • 189 replies
  • October 23, 2023

Hi @ensenada,

I'm sorry to see this issue you're facing. However, I can also see that you posted your question on the forum last Friday, and with the weekend in between, it might not have been easy to find someone online to provide you with potential solutions. It's a new week, and I'm confident that a watcher will respond to you shortly. Let's remain optimistic!
 

On my end, I will escalate the issue to our support team so that they can reach out to you as soon as possible.


In any case, your problem will be resolved; I'm absolutely certain of that!


lpinsivy
Centreonian
Forum|alt.badge.img+21
  • Centreonian
  • 1120 replies
  • October 23, 2023

Hi @ensenada do you use MariaDB or MySQL?

 


ensenada
Forum|alt.badge.img+7
  • Author
  • Steward ***
  • 36 replies
  • October 23, 2023

Hi @ensenada do you use MariaDB or MySQL?

 

Hi, i use mariadb as the guide says

Thanks for the answer


lpinsivy
Centreonian
Forum|alt.badge.img+21
  • Centreonian
  • 1120 replies
  • October 23, 2023

Can you check the password of ‘centreon user in’:

  • /etc/centreon/centreon.conf.php
  • /etc/centreon/conf.pm

In “Configuration > Pollers > Broker configuration”, edit “central-broker-master” configuration and in output tab, check password, save and generate/export configuration.


ensenada
Forum|alt.badge.img+7
  • Author
  • Steward ***
  • 36 replies
  • October 23, 2023

I have “centreon” as password in both files. Have i set database password in plane text in this files ?

I cant access to web interface because this other problem:

 

 


lpinsivy
Centreonian
Forum|alt.badge.img+21
  • Centreonian
  • 1120 replies
  • Answer
  • October 24, 2023

Password must be in plain text in both files.


ensenada
Forum|alt.badge.img+7
  • Author
  • Steward ***
  • 36 replies
  • October 24, 2023

Setting password in this files:

/etc/centreon/centreon.conf.php

/etc/centreon/conf.pm

Solve the problem.

When the migration is finished, I will change the password to a more complex one.

Thanks.