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
That was just too cool.....you just made my day!!!!