Page 1 of 1
Event Log not showing anything
Posted: Thu Jun 24, 2021 11:10 am
by acentek
Hi, I have two problems. I see nothing when I look at Monitoring Process > Event Log (on the Home page).
Also, the "oec.service" will not enable on the server. So when the server reboots the service doesn't start and that's bad.
Thanks
Re: Event Log not showing anything
Posted: Thu Jun 24, 2021 5:36 pm
by ssax
Please PM me a copy of your profile, you can download it from Admin > System Profile by clicking the Download Profile button.
You may have crashed DB tables, please send the output of these commands:
- 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
This next command may fail, that's okay, not all systems run postgresql, send the output anyways:
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
If the first command above shows NULL for any of the sizes (specifically for the event log it would be nagios_logentries), repair the databases:
https://assets.nagios.com/downloads/nag ... tabase.pdf
Re: Event Log not showing anything
Posted: Fri Jun 25, 2021 12:48 pm
by acentek
Thanks! PM sent with profile and the output from both commands you requested.
Re: Event Log not showing anything
Posted: Fri Jun 25, 2021 3:01 pm
by ssax
Tables look good.
I'm seeing a lot of these:
Code: Select all
(70007)The timeout specified has expired: [client 192.168.18.109:52289] AH01075: Error dispatching request to : (polling)
Please run this command and send me the resulting
/tmp/SUPPORTFILES.zip file:
Code: Select all
zip -r /tmp/SUPPORTFILES.zip /etc/httpd/conf.d/php.conf /etc/php-fpm.d/www.conf /etc/php.ini /etc/my*