SQL IDO database error

I am having an issue with the “There is currently no icinga instance writing to the IDO. Make sure that a icinga instance is configured and able to write to the IDO” I have not found a single thing to resolve it. When I look at the icinga2 log, it shows that "critical/IdoMysqlConnection: Connection to database ‘icinga’ with user ‘icinga’ on ‘localhost:3306’ failed: “Access denied for user ‘icinga’@‘localhost’ (using password: YES)” However I am not using that username, I am using icinga2, also the same database name. I am really confused at this point. Any help would be greatly appreciated!

Hi,

pls check fowolling:

  • the credentials in /etc/icinga2/features-available/ido-mysql.conf
  • is the mysql feature enabled:
    icinga2 feature list
  • is the mysql daemon running

Thank you for responding so quickly Stevie! All the above items are correct. I am attaching screenshots for your viewing pleasure. icinga2 icinga2-1

You need to remove those two slashes as they comment out your settings.

Sheesh. I knew I was missing something. Thank you so much!! I will say this is probably the fastest I have ever seen an open source company answer. Thank you again. Everything worked.