The Chill Pilgrim - 2013-12-28

Hi,

I've been running around with a few issues - so hopefully this will get people going
I'm still working on a few things and I've pretty much ignored the Postfix SQL configuration as I'm purely using this tool as a Quarantine tool (so pretty much only created the MySQL tables from http://postfix.wiki.xs4all.nl/index.php?title=Virtual_Users_and_Domains_with_Courier-IMAP_and_MySQL)

PHP5

PHP5 disables by default short_open_tag = Off
Change to: short_open_tag = On

Clamav

chmod +x clamwatch.pl

SQL Tweaks found thus far

Missing SQL Commands from install notes:

Starting with amavisd-new-2.7.0, three fields need to be added
to table msgrcpt and one to table msgs:

ALTER TABLE msgrcpt ADD rseqnum integer DEFAULT 0 NOT NULL;
ALTER TABLE msgrcpt ADD content char(1) DEFAULT ' ' NOT NULL;
ALTER TABLE msgrcpt ADD is_local char(1) DEFAULT ' ' NOT NULL;
ALTER TABLE msgs ADD originating char(1) DEFAULT ' ' NOT NULL;

Ref: http://www.ijs.si/software/amavisd/README.sql-mysql.txt

Quarantine Query: content AS quaratinefor needs to be changed to msgs.content AS quaratinefor

config/config.php
114c114
$quarantine_query = "SELECT DISTINCT quarantine.mail_id, secret_id, rs, bspam_level, (UNIX_TIMESTAMP(time_iso) + (3600 * $time_offset)) AS time_iso, SUBSTRING(sender.email,1,35) AS sender, SUBSTRING(recipient.email,1,28) AS recipient, size, content AS quaratinefor, SUBSTRING( subject, 1, 25) AS subject FROM quarantine LEFT JOIN msgrcpt ON msgrcpt.mail_id = quarantine.mail_id LEFT JOIN msgs ON msgs.mail_id = quarantine.mail_id LEFT JOIN maddr AS recipient ON msgrcpt.rid = recipient.id LEFT JOIN maddr AS sender ON msgs.sid = sender.id WHERE msgrcpt.rs != 'R' AND msgrcpt.rs != 'D'";

$quarantine_query = "SELECT DISTINCT quarantine.mail_id, secret_id, rs, bspam_level, (UNIX_TIMESTAMP(time_iso) + (3600 * $time_offset)) AS time_iso, SUBSTRING(sender.email,1,35) AS sender, SUBSTRING(recipient.email,1,28) AS recipient, size, msgs.content AS quaratinefor, SUBSTRING( subject, 1, 25) AS subject FROM quarantine LEFT JOIN msgrcpt ON msgrcpt.mail_id = quarantine.mail_id LEFT JOIN msgs ON msgs.mail_id = quarantine.mail_id LEFT JOIN maddr AS recipient ON msgrcpt.rid = recipient.id LEFT JOIN maddr AS sender ON msgs.sid = sender.id WHERE msgrcpt.rs != 'R' AND msgrcpt.rs != 'D'";