Acknowledgements and Comments

[itadmins]

This list obviously shows various engineers who have acknowledged various alarms. It used to list the most recent at the top. Whenever I open this list, it now only shows ack's from 2-1-2019 and older. I don't maybe I needed to sort by date or maybe something I'm doing wrong, but I just mass ack's a couple of alarms and I don't see mine in this list.

any idea what I'm doing wrong? The ack process itself is working, ie the unhandled number disappears. But I used to go back to this list to quickly check back on some things.

[ssax]

Please PM me a copy of your profile, you can download it from Admin > System Profile > Download Profile.

Additionally, let me know the name of the contact/user you were logged in with and testing against. Do you remember which hosts/services you ack'ed? Please include those as well if you remember.

Does it show for other users?

Additionally, please send the output of these commands (as root):
- NOTE: You may need to adjust the -h 127.0.0.1, the -uroot, and -pnagiosxi in the first command if your DB is offloaded to another server and/or you've changed the root mysql password

Code: Select all

echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table

Then run this command:

Code: Select all

grep mysql /usr/local/nagiosxi/html/config.inc.php | wc -l

If it outputs the number 2, run the command below as well and include the output, if it outputs anything other than 2 - don't run the command. (some XI systems use both mysql and postgresql if they were install prior to XI 5.0 and then upgraded from there).

Code: Select all

echo "SELECT relname as Table, pg_size_pretty(pg_total_relation_size(relid)) As Size, pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as ExternalSize FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;" | psql nagiosxi nagiosxi

Thank you