Database connections errors in centstorage.log

[Noosymer]

Hello,

I recently installed Centreon and it works except the graphs.

I followed some instructions to fix it and I found these errors in: /usr/local/centreon/log/centstorage.log

17/3/2010 17:39:20 - Error when connecting to database : Access denied for user 'centreon'@'localhost' (using password: YES)
17/3/2010 17:39:20 - Error when connecting to database : Access denied for user 'centreon'@'localhost' (using password: YES)
Can't call method "prepare" on an undefined value at /usr/local/centreon/lib/verifyHostServiceIdName.pm line 62.
17/3/2010 17:39:22 - Error when connecting to database : Access denied for user 'centreon'@'localhost' (using password: YES)

Could you help me fix that issue?

Thanks.

[NutZ]

First: check in /etc/centreon/conf.pm the name of your centstorage database user ($mysql_database_ods value).

Then check that user's privileges in MySQL for your centstorage database. He should have full privileges (including "grant").

[Noosymer]

First: check in /etc/centreon/conf.pm the name of your centstorage database user ($mysql_database_ods value).

My database user is centreon

Then check that user's privileges in MySQL for your centstorage database. He should have full privileges (including "grant").

here is the result:
+-----------------------------------------------------------------------------------------------------------------+
| Grants for centreon@localhost |
+-----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'centreon'@'localhost' IDENTIFIED BY PASSWORD 'XXXXXXXXXXXXXXXXXXXX' |
| GRANT ALL PRIVILEGES ON `centreon`.* TO 'centreon'@'localhost' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `centstorage`.* TO 'centreon'@'localhost' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `centstatus`.* TO 'centreon'@'localhost' WITH GRANT OPTION |
+-----------------------------------------------------------------------------------------------------------------+

Thanks

[Noosymer]

Ok, it seems to be my database password that cause the issue.

I have a "@" in my password and apparently it doesn't like this character so I am trying to find how to change my database password...

[Noosymer]

I changed my password in mysql but now I have an error once logged in to Centreon on some pages (not all):

Connection failed, please contact your administrator.

I have changed the password also in some config files but apparently not all...

If someone knows in which config files do I need to replicate the modifications, that would be very helpful.

Thanks,

[Noosymer]

No one?

Please.

[tosage]

hy,

Have you modify the /etc/centreon/contreon.conf.php too ?

[Noosymer]

Hi,

Yes, I have modified this one.

I have modified these config files:

• /etc/centreon/conf.pm
• /etc/centreon/centreon.conf.php
• /usr/local/nagios/etc/ndo2db.cfg

[AkHeNaToN]

For this file : /usr/local/nagios/etc/ndo2db.cfg please use Centreon (menu "Configuration -> Centreon -> ndo2db.cfg" sheet "Database").

[Noosymer]

That fixed it!

Thank you so much, it works now!