Sql error when searhing by domain suffix on main page

krobertson71 · Post by **krobertson71** » Fri Jan 09, 2015 3:34 pm

Weird issues.

I tried to search for all hosts that end with dhe.duke.edu and got the error below:

Selection_083.png

If I search another domain it returns a result just fine:

Selection_084.png

I'm at a loss.

Post by **tgriep** » Fri Jan 09, 2015 4:05 pm

What version of NagiosXI are you running?

krobertson71 · Post by **krobertson71** » Fri Jan 09, 2015 4:14 pm

Sorry, latest and greatest. 2014r2.3

Post by **tgriep** » Fri Jan 09, 2015 4:23 pm

You could have a corrupt SQL database table, let's run a repair on the databases.
From a command prompt on the NagiosXI server, run this

/usr/local/nagiosxi/scripts/repair_databases.sh

Nagios Support Forum