ICINGADB Service - Error 1045: Access denied for user 'icingadb'@'localhost'

Icinga DB
1

I have just updated OS from Ubuntu 18.04 LTS to 20.04 LTS
After that I have installed the icingadb as per:
https://icinga.com/docs/icinga-2/latest/doc/02-installation/02-Ubuntu/#set-up-icinga-db
After the installation, the command
systemctl status icingadb
return me this:

image
image1098×309 22.6 KB

I have verified the settings into the file
/etc/icingadb/config.yml
And seems that are ok.
Ihave also noticed from PhpMyAdmin that the user icingadb do not have the “GRANT” on icingadb Database. And Even if I try to assign the GRANT - this do not work.

image
image883×530 26.9 KB

image
image504×715 25.1 KB

2

I have the same error.
systemctl status icingadb

icinga
icinga1345×1010 32 KB

3

image
image1506×931 33.7 KB

4

Hello,

did you both adjust the password in /etc/icingadb/config.yml ?
There you need to change the password aswell.

5

Ye, the connection parameter are ok into the file:
/etc/icingadb/config.yml

But Do I need to modify also the file:
/etc/icinga2/features-available/icingadb.conf
??
because here I hece the rows commented:
image
Do I need to UNCOMMENT HERE ?
THX

6

Hello,

Which version of icingadb and icingadb-redis is installed ?
Because icingadb is not enabled yet i seen on the “About” screen.
Is this version 1.0.2 ?

7

Hello,

localhost:0 ? > is this not localhost:xxx (the port of the database mysql/postgres)

8

I think there is a difference between icingadb@localhost and icingadb@127.0.0.1.
Try adding grants for the one the daemon is complaining about.