ipfw tables
${fwcmd} add 2 deny all from “table(1)” to any in recv ${if_z}
grep -ve “^#” /usr/home/case/bans.txt| while read IP
do
${fwcmd} table 1 add $IP 1
done
${fwcmd} add 2 deny all from “table(1)” to any in recv ${if_z}
grep -ve “^#” /usr/home/case/bans.txt| while read IP
do
${fwcmd} table 1 add $IP 1
done
postfix (smtpd) + dovecot (imapd) + roundcube webmail (web interface for imapd) + spamassassin
dovecot.conf (только изменения)
protocols = imap
listen = 127.0.0.1
disable_plaintext_auth = no
ssl_disable = yes
mail_location = maildir:/usr/home/vmail/%u
auth default {
mechanisms = plain
passdb sql {
args = /usr/local/etc/dovecot-sql.conf
}
userdb static {
args = uid=2011 gid=2011 home=/usr/home/vmail/%u
}
user = vmail
}
spamassassin: /usr/local/etc/mail/spamassassin/local.cf
rewrite_header Subject *****SPAM*****
report_safe 0
required_score 10.0
use_bayes 1
bayes_auto_learn 1
Анализ таблицы, подбираем необходимым минимум типа данных для столбца.
http://dev.mysql.com/doc/refman/5.0/en/procedure-analyse.html