Page 1 of 1

No Quarantine Report since Update

Posted: 08 Sep 2016 06:32
by Hybrid1980
Hallo,
first a BIG THX for the Project :)

I have a little problem,
after the Update to 3.1.0.3 from 3.1.0.1 the Users donĀ“t become a Report
when i execute the /usr/local/bin/mailwatch/tools/Cron_jobs/quarantine_report.php

i become the error


Code: Select all

=== Generating report for XXXXX type=A
 ==== huflejt has empty e-mail recipient address, skipping...

 === Generating report for XXXXXxX@XXXX.XX type=U
 ==== Recipient e-mail address is XXXXXxX@XXXX.XX
 ==== Building list for XXXXXxX@XXXX.XX
<B>Error executing query: </B><BR><BR>1054: Unknown column 'isaspam' in 'where clause'<BR><BR><B>SQL:</B><BR><PRE>
SELECT DISTINCT
a.id AS id,
DATE_FORMAT(timestamp,'%d/%m/%y <br/>%H:%i:%s') AS datetime,
a.to_address AS to_address,
a.from_address AS from_address,
a.subject AS subject,
CASE
 WHEN a.virusinfected>0 THEN 'Virus'
 WHEN a.nameinfected>0 THEN 'Bad Content'
 WHEN a.otherinfected>0 THEN 'Infected'
 WHEN a.ishighspam>0 THEN 'Spam'
 WHEN a.issaspam>0 THEN 'Spam'
 WHEN a.isrblspam>0 THEN 'Spam'
 WHEN a.spamblacklisted>0 THEN 'Blacklisted'
 WHEN a.isspam THEN 'Spam'
 WHEN a.ismcp>0 THEN 'Policy'
 WHEN a.ishighmcp>0 THEN 'Policy'
 WHEN a.issamcp>0 THEN 'Policy'
 WHEN a.mcpblacklisted>0 THEN 'Policy'
 WHEN a.isspam>0 THEN 'Spam'
 ELSE 'UNKNOWN'
END AS reason
FROM
 maillog a
WHERE
 a.quarantined = 1
AND
 ((to_address='XXXXX@XXXXXXXX) OR (to_domain='XXXXX@XXXX.de'))
AND
 a.date >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)
    AND
    isspam>0
        AND
        (
        virusinfected>0
        OR
        nameinfected>0
        OR
        otherinfected>0
        OR
        ishighspam>0
        OR
        isaspam>0
        OR
        isrblspam>0
        OR
        spamblacklisted>0
        OR
        isspam>0
        OR
        ismcp>0
        OR
        ishighmcp>0
        OR
        issamcp>0
        OR
        ismcpblacklisted>0
        OR
        isspam>0
        )
ORDER BY a.date DESC, a.time DESC</PRE>[root@spam ~]#
Anyone a idea?

Sorry for my bad English :)


Big thanx
Daniel

Re: No Quarantine Report since Update

Posted: 09 Sep 2016 06:18
by Hybrid1980
Ok, i see the problem is already known, thanks

Greets from Germany
Daniel

Re: No Quarantine Report since Update

Posted: 10 Sep 2016 10:56
by ldecoker
Hello!

I got the same problem. Can you add the bug report link for this bug?

thx!

Re: No Quarantine Report since Update

Posted: 11 Sep 2016 12:20
by shawniverson

Re: No Quarantine Report since Update

Posted: 12 Sep 2016 05:38
by ldecoker
Thx. I updated it and it's working .. but for users for which the override email field is empty, I received the following message: "has empty e-mail recipient address, skipping..."

From my understanding, the override recipient field is optional and if empty, the username will be used, right?

Re: No Quarantine Report since Update

Posted: 15 Sep 2016 19:41
by SharazJek
im on 3.1.0.4, and same issue.

[root@dlp-upemx01 ~]# php /usr/local/bin/mailwatch/tools/Cron_jobs/quarantine_report.php

=== Generating report for jhorne@yay.org type=R
==== jhorne@yay.org has empty e-mail recipient address, skipping...

Re: No Quarantine Report since Update

Posted: 16 Sep 2016 18:10
by shawniverson
Interesting, I'm not seeing this. How is this user set up in MailWatch?

Re: No Quarantine Report since Update

Posted: 24 Sep 2016 00:47
by dbrunt
If the username is simply "user", you have to complete the overriding email field. If the username is user@somedomain.com then an overriding email address is not required unless the user type is Administrator or Domain Administrator, in which case you have to have an overriding email address despite what the GUI says.

See viewtopic.php?f=13&t=1873

I've not checked this in 3.0.1.5 yet but it was still an issue in 3.0.1.1.