1

I wan't get icinga2 notification history from db. like timestamp1 object1 state->DOWN, call notifycommand1 send to user1.

main table icinga_notifications is ok. but nothing in icinga_contactnotificationmethods and icinga_contact_notificationcommands.

Also, no data in icinga_logentries.

Do I make any mistake in config or what config can make this occur?

icinga2 version: r2.8.4

My ido_mysql config:

library "db_ido_mysql"

object IdoMysqlConnection "ido-mysql" {
  host = "xxx"
  port = xxx
  user = "xxx"
  password = "xxx"
  database = "xxx"
  table_prefix = "icinga_"
  instance_name = "default"
  enable_ha = true
  cleanup = {
    acknowledgements_age = 1209600
    commenthistory_age = 1209600
    contactnotificationmethods_age = 1209600
    contactnotifications_age = 1209600
    downtimehistory_age = 1209600
    eventhandlers_age = 1209600
    externalcommands_age = 1209600
    flappinghistory_age = 1209600
    hostchecks_age = 1209600
    logentries_age = 1209600
    notifications_age = 1209600
    processevents_age = 1209600
    servicechecks_age = 1209600
    statehistory_age = 1209600
    systemcommands_age = 1209600
  }

}

https://icinga.com/docs/icinga1/latest/en/db_model.html

Document db model can't match mine.

Thomas
  • 41
  • 3

0 Answers0