There is currently no icinga instance writing to the IDO

I have a setup with 1 icinga master + 1 seperate icingaweb instance.

My Database and IDO feature are only running on the Master.

I want to make the connection from the websetup to my master and have remote access to my database.

But when i connect to it, i get the message: There is currently no icinga instance writing to the IDO

output of icinga2 object list -t IdoMysqlConnection:

Object ‘ido-mysql’ of type ‘IdoMysqlConnection’:
% declared in ‘/etc/icinga2/features-enabled/ido-mysql.conf’, lines 3:1-3:37

  • __name = “ido-mysql”
  • categories = [ “DbCatConfig”, “DbCatState”, “DbCatAcknowledgement”, “DbCatComment”, “DbCatDowntime”, “DbCatEventHandler”, “DbCatFlapping”, “DbCatNotification”, “DbCatProgramStatus”, “DbCatRetention”, “DbCatStateHistory” ]
  • cleanup
  • database = “ido_user”
    % = modified in ‘/etc/icinga2/features-enabled/ido-mysql.conf’, lines 8:3-8:24
  • enable_ha = true
  • enable_ssl = false
  • failover_timeout = 30
  • host = “192.150.1.1”
    % = modified in ‘/etc/icinga2/features-enabled/ido-mysql.conf’, lines 6:3-6:22
  • instance_description = “”
  • instance_name = “default”
  • name = “ido-mysql”
  • package = “_etc”
  • password = “fsdafgsadfdsf”
    % = modified in ‘/etc/icinga2/features-enabled/ido-mysql.conf’, lines 5:3-5:31
  • port = 3306
    % = modified in ‘/etc/icinga2/features-enabled/ido-mysql.conf’, lines 7:3-7:13
  • socket_path = “”
  • source_location
    • first_column = 1
    • first_line = 3
    • last_column = 37
    • last_line = 3
    • path = “/etc/icinga2/features-enabled/ido-mysql.conf”
  • ssl_ca = “”
  • ssl_capath = “”
  • ssl_cert = “”
  • ssl_cipher = “”
  • ssl_key = “”
  • table_prefix = “icinga_”
  • templates = [ “ido-mysql” ]
    % = modified in ‘/etc/icinga2/features-enabled/ido-mysql.conf’, lines 3:1-3:37
  • type = “IdoMysqlConnection”
  • user = “ido_user”
    % = modified in ‘/etc/icinga2/features-enabled/ido-mysql.conf’, lines 4:3-4:20
  • zone = “”

So i really stuck here. I have an IDO running on my master, and icingaweb can read from it, but it tells me that no ido is writing?

library “db_ido_mysql”

object IdoMysqlConnection “ido-mysql” {
user = “ido_user”,
password = “afsdajfasjdfasdä”
host = “192.150.1.1” //this is my master
port = 3306
database = “ido_user”
}

It seems that icingaweb just isnt aware of the ido, even if it can connect to the IDO database. Some help on this would be really nice.

Best Regards

ghost

Hello @ghost!

Do the Icinga 2 logs say that Icinga 2 is actually writing to the IDO?

Best,
A/K

Hi @Al2Klimov

I got it working, it was missing permission on the host.
Im still Stuck here, because i cant achieve my setup.

Every of my database Users and ido are running in my master but my seperate webserver always takes the webserver as deployment endpoint, so i dont see them in the Web ui.