Home

DirectAdmin # How to enable spamassassin

user warning: Unknown column 'u.signature_format' in 'field list' query: SELECT c.cid as cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, c.homepage, u.uid, u.name AS registered_name, u.signature, u.signature_format, u.picture, u.data, c.thread, c.status FROM comments c INNER JOIN users u ON c.uid = u.uid WHERE c.nid = 12 AND c.status = 0 ORDER BY c.thread DESC LIMIT 0, 30 in /home/cmsdd/domains/cmsdd.com/public_html/modules/comment/comment.module on line 992.
Sat, 04/05/2008 - 18:35 — WaterMan

#cd /usr/local/directadmin/scripts
#./spam.sh

run
#/usr/bin/spamd -d -c -m 5

edit /etc/exim.conf
old config
--------------------------------------------------------------------------------------
# Spam Assassin
#spamcheck_director:
# driver = accept
# condition = "${if and { \
# {!def:h_X-Spam-Flag:} \
# {!eq {$received_protocol}{spam-scanned}} \
# {!eq {$received_protocol}{local}} \
# {exists{/home/${lookup{$domain}lsearch{/etc/virtual/domainowners}{$value}}/.spamassassin/user_prefs}} \
# {<{$message_size}{100k}} \
# } {1}{0}}"
# retry_use_local_part
# transport = spamcheck
# no_verify
---------------------------------------------------------------------------------------

edit to
---------------------------------------------------------------------------------------
# Spam Assassin
spamcheck_director:
driver = accept
condition = "${if and { \
{!def:h_X-Spam-Flag:} \
{!eq {$received_protocol}{spam-scanned}} \
{!eq {$received_protocol}{local}} \
{exists{/home/${lookup{$domain}lsearch{/etc/virtual/domainowners}{$value}}/.spamassassin/user_prefs}} \
{<{$message_size}{100k}} \
} {1}{0}}"
retry_use_local_part
transport = spamcheck
no_verify
---------------------------------------------------------------------------------------
Ctrl + x
press y
enter

restart service
#service exim restart

Refer Link : http://www.thaihosttalk.com/th1/index.php?topic=5761.0