False Email Alerts

[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!

[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

[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!

[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.