Page 1 of 1
False Email Alerts
Posted: Thu Dec 30, 2021 1:00 pm
by lanxessinfy
Hello,
we are getting lot of false email alerts though hosts and services running fine. In email alert, From address is not our actual address.
please look into the below SS of false email alert :
MicrosoftTeams-image (1).png
in the above email alert, from address having our nagios server name also after "@" but that is not actual our email From address.
Could you please provide me the root cause for this false alert?
Thanks in advance!
Re: False Email Alerts
Posted: Mon Jan 03, 2022 12:49 pm
by ssax
Please PM me a copy of your
profile.zip, you can download it from Admin > System Profile by clicking the Download Profile button.
Additionally, 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
Re: False Email Alerts
Posted: Tue Jan 04, 2022 8:47 am
by lanxessinfy
Hello ssax,
Thanks for the response.
I have sent system profile privately to you. please look into it.
Below file has output of first command.
FirstCommandOutput.txt
The second command is showing: bash: psql: command not found
Thanks!
Re: False Email Alerts
Posted: Tue Jan 04, 2022 5:19 pm
by ssax
You can try running this to see if it fixes the issue:
Code: Select all
echo "truncate table xi_events; truncate table xi_meta; truncate table xi_eventqueue;" | mysql -uroot -pnagiosxi nagiosxi
For the From address showing wrong, please see the PM message I've sent.