Page 1 of 1
Quarantine Reports
Posted: 31 Oct 2014 18:32
by Archer
Hello all, Newbie here.
I have read, searched, and etc. to find out about marking option to send daily Quarantine Reports as a default for all users. (Or at least all new users.)
Is there anyway to make this happen?
We are in the process of removing our old filer and moving to EFA. But our users are accustom to receiving daily emails. And they do not handle change well.
Re: Quarantine Reports
Posted: 01 Nov 2014 18:14
by shawniverson
How are you adding users to EFA?
Re: Quarantine Reports
Posted: 01 Nov 2014 18:40
by Archer
I have it bound to our AD servers, so if somme one logs in with ad creds it makes the account. I have thought about using the AD import tools to pull them all in at once. As of now I have not done either as I was trying to find this solution before making all accounts.
Re: Quarantine Reports
Posted: 02 Nov 2014 23:46
by shawniverson
Yeah, by default, the Send Daily Report is not checked for users.
Of course, you can go in and change the users, but if you have a lot of users, this is time consuming and very inefficient.
There's a few ways to accomplish this currently.
1) You can edit the /usr/local/bin/mailwatch/tools/Cron_jobs/quarantine_report.php as follows:
Original code
Code: Select all
$users_sql = "
SELECT
username,
quarantine_rcpt,
type
FROM
users
WHERE
quarantine_report=1
";
Edit as follows
Code: Select all
$users_sql = "
SELECT
username,
quarantine_rcpt,
type
FROM
users
";
This will ignore the flag in MailWatch and send a quarantine report for all users. Note that updates to mailwatch will likely overwrite this change, so it will need to be changed again after an update.
2) Another way is to mass update the users table
Look in /etc/EFA-Config for the MAILWATCHSQLPWD
Code: Select all
mysql -u mailwatch --password=<MAILWATCHSQLPWD> -e 'UPDATE users SET quarantine_report=1' mailscanner
3) You can also set the quarantine_report to default to 1 in the database
Code: Select all
mysql -u mailwatch --password=<MAILWATCHSQLPWD> -e 'ALTER TABLE users ALTER COLUMN quarantine_report SET DEFAULT 1' mailscanner
Re: Quarantine Reports
Posted: 03 Nov 2014 01:53
by Archer
Cool. I will put that into use in the AM.
Thanks!!!
Re: Quarantine Reports
Posted: 03 Nov 2014 12:55
by Archer
That was just too cool.....you just made my day!!!!
Re: Quarantine Reports
Posted: 17 May 2016 15:06
by james27_84
This was working great until the latest version of EFA. Now all non spam email is listed in the quarantine report with the reason listed as "UNKNOWN" but when I check the users mailbox they were delivered successfully. Is there a way to stop non-quarantined emails from appearing on the daily quarantine report?
Re: Quarantine Reports
Posted: 30 May 2016 12:40
by shawniverson
Yes, check out the new settings in /var/www/html/mailscanner/conf.php.
Re: Quarantine Reports
Posted: 06 Sep 2018 21:24
by james27_84
Hello All,
Just had to set up a new EFA appliance. Noticed that on the latest version these steps are no longer relevant. Can anyone tell me how to go about turning on quarantine reports for all users in the latest version.
Thanks!
Re: Quarantine Reports
Posted: 08 Sep 2018 19:25
by shawniverson
The sql method should still be valid.
Re: Quarantine Reports
Posted: 10 Sep 2018 21:29
by james27_84
Thanks shawniverson, you are correct. I tried it and tested today. Thank you for your help!