We are running our Databases in a clustered setup with a VIP.
Unfortunately when we try to specify the clusterable hostname for the ndoutils database Nagios does not come back up properly. However long we wait we have the 3 green & 3 blue information buttons whilst it tries to start up.
Our config snippet;
Code: Select all
"ndoutils" => array(
"dbtype" => 'mysql',
"dbserver" => 'DB-VIP',
"user" => 'nagios_ndo2db',
"pwd" => '*****',
"db" => 'nagiosxi',
"dbmaint" => array( // variables affecting maintenance of ndoutils db
"max_externalcommands_age" => 7, // max time (in DAYS) to keep external commands
"max_logentries_age" => 90, // max time (in DAYS) to keep log entries
"max_statehistory_age" => 730, // max time (in DAYS) to keep state history information
"max_notifications_age" => 90, // max time (in DAYS) to keep notifications
"max_timedevents_age" => 5, // max time (minutes) to keep timed events
"max_systemcommands_age" => 5, // max time (minutes) to keep system commands
"max_servicechecks_age" => 5, // max time (minutes) to keep service checks
"max_hostchecks_age" => 5, // max time (minutes) to keep host checks
"max_eventhandlers_age" => 5, // max time (minutes) to keep event handlers
"optimize_interval" => 60, // time (in minutes) between db optimization runs
"repair_interval" => 0, // time (in minutes) between db repair runs
),
),
"nagiosql" => array(
"dbtype" => 'mysql',
"dbserver" => 'DB-VIP',
"user" => 'nagios_user',
"pwd" => '****',
"db" => 'nagiosql',
"dbmaint" => array( // variables affecting maintenance of db
"max_logbook_age" => 480, // max time (minutes) to keep log book records
"optimize_interval" => 60, // time (in minutes) between db optimization runs
"repair_interval" => 0, // time (in minutes) between db repair runs
),
),
);
Code: Select all
[ "ndoutils" => array(
"dbtype" => 'mysql',
"dbserver" => 'STATIC HOSTNAME OF DB NODE',
"user" => 'nagios_ndo2db',
"pwd" => '*****',
"db" => 'nagiosxi',
"dbmaint" => array( // variables affecting maintenance of ndoutils db
"max_externalcommands_age" => 7, // max time (in DAYS) to keep external commands
"max_logentries_age" => 90, // max time (in DAYS) to keep log entries
"max_statehistory_age" => 730, // max time (in DAYS) to keep state history information
"max_notifications_age" => 90, // max time (in DAYS) to keep notifications
"max_timedevents_age" => 5, // max time (minutes) to keep timed events
"max_systemcommands_age" => 5, // max time (minutes) to keep system commands
"max_servicechecks_age" => 5, // max time (minutes) to keep service checks
"max_hostchecks_age" => 5, // max time (minutes) to keep host checks
"max_eventhandlers_age" => 5, // max time (minutes) to keep event handlers
"optimize_interval" => 60, // time (in minutes) between db optimization runs
"repair_interval" => 0, // time (in minutes) between db repair runs
),
),
"nagiosql" => array(
"dbtype" => 'mysql',
"dbserver" => 'DBVIP',
"user" => 'nagios_user',
"pwd" => '*****',
"db" => 'nagiosql',
"dbmaint" => array( // variables affecting maintenance of db
"max_logbook_age" => 480, // max time (minutes) to keep log book records
"optimize_interval" => 60, // time (in minutes) between db optimization runs
"repair_interval" => 0, // time (in minutes) between db repair runs
),
),
);
The above configuration works just fine. Any ideas or suggestions would be much appreciated.
Kind Regards
Hani