GreyListing

From Ezee.co.uk

[edit] GreyListing RPM

My QMail Greylisting RPM qmail-greylist-1.03-6.i386.rpm

[edit] GreyListing RPM NOTES

Please note this rpm will not work for you as it has hardwired IP's in it and has conflicts which I --force. It is just posted here for my convenience. I am working on a patch for the greylisting source to allow a configuration file but am having to re-learn 'C' to do it. to install

wget http://ezee.co.uk/rpms/qmail-greylist-1.03-6.i386.rpm
wget http://ezee.co.uk/rpms/openssl097a-0.9.7a-9.i386.rpm
rpm -Uvh openssl097a-0.9.7a-9.i386.rpm
rpm -Uvh qmail-greylist-1.03-6.i386.rpm --force
/etc/rc.d/init.d/qmail restart

Yes it is messy but it works for me installing over multiple servers.

Original Code taken from http://meshier.com/2006/09/18/adding-greylisting-support-to-qmail-on-plesk-8/ With patches to fix small problem.
Thanks Brent you have cut down my server loading and spam levels by a magnitude

[edit] White listing and blacklisting

Whitelist By IP

INSERT INTO relaytofrom (relay_ip, mail_from, rcpt_to, block_expires, record_expires, origin_type, create_time) VALUES (’147.202.34.223′, NULL, NULL, NOW(), ‘2099-12-31 23:59:59′, ‘MANUAL’, NOW())

Whitelist by Sender Address

INSERT INTO relaytofrom (relay_ip, mail_from, rcpt_to, block_expires, record_expires, origin_type, create_time) VALUES (NULL, ‘nikkidecrette@gmail.com’, NULL, NOW(), ‘2099-12-31 23:59:59′, ‘MANUAL’, NOW())

Whitelist by Recipient Address

INSERT INTO relaytofrom (relay_ip, mail_from, rcpt_to, block_expires, record_expires, origin_type, create_time) VALUES (NULL, NULL, ‘nikkidecrette@gmail.com’, NOW(), ‘2099-12-31 23:59:59′, ‘MANUAL’, NOW())

Blacklist by subnet

INSERT INTO relaytofrom (relay_ip, mail_from, rcpt_to, block_expires, record_expires, origin_type, create_time) VALUES (’147.202.34′, NULL, NULL, ‘2099-12-31 23:59:59′, ‘2099-12-31 23:59:59′, ‘MANUAL’, NOW())

Blacklist by Sender Domain

INSERT INTO relaytofrom (relay_ip, mail_from, rcpt_to, block_expires, record_expires, origin_type, create_time) VALUES (NULL, ’spammer.com’, NULL, ‘2099-12-31 23:59:59′, ‘2099-12-31 23:59:59′, ‘MANUAL’, NOW())

Blacklist by Recipient Address
Only use this one on accounts with catchalls where the client can't/won't remove the catchall but needs one recipient blocking.

INSERT INTO relaytofrom (relay_ip, mail_from, rcpt_to, block_expires, record_expires, origin_type, create_time) VALUES (NULL, NULL, 'recipient@domain.com, ‘2099-12-31 23:59:59′, ‘2099-12-31 23:59:59′, ‘MANUAL’, NOW())