1 (edited by bmackay 2014-07-03 10:48:14)

Topic: Popular Sites To Whitelist From Greylisting

Here is a quick way to whitelist common email sources that really shouldn't be greylisted:   Google, Outlook.com, Twitter, Facebook.   Add any additional IP blocks that you might need such as Mailchimp, ZenDesk, etc... by editing the SQL file before importing.   After that it's much easier to make minor edits as the Cluebringer web interface UX is horrendous for adding a lot of entries.

Take the following SQL code, save it as greylist-whitelist.sql  and import into your cluebringer database.

mysql -p cluebringer <greylist-whitelist.sql

Contents of greylist-whitelist.sql

INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:216.239.32.0/19','GOOGLE',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:64.233.160.0/19','GOOGLE',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:66.249.80.0/20','GOOGLE',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:72.14.192.0/18','GOOGLE',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:209.85.128.0/17','GOOGLE',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:66.102.0.0/20','GOOGLE',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:74.125.0.0/16','GOOGLE',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:64.18.0.0/20','GOOGLE',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:207.126.144.0/20','GOOGLE',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:173.194.0.0/16','GOOGLE',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:65.54.190.0/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:65.54.190.64/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:65.54.190.128/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:65.54.190.192/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:65.55.116.0/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:65.55.111.64/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:65.55.116.64/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:65.55.111.128/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:65.55.34.0/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:65.55.34.64/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:65.55.34.128/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:65.55.34.192/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:65.55.90.0/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:65.55.90.64/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:65.55.90.128/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:65.55.90.192/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:65.54.51.64/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:65.54.61.64/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:207.46.66.0/28','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:157.55.0.192/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:157.55.1.128/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:157.55.2.0/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:157.55.2.64/26','MICROSOFT',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:69.63.179.25','FACEBOOK',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:69.63.178.128/25','FACEBOOK',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:69.63.184.0/25','FACEBOOK',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:66.220.144.128/25','FACEBOOK',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:66.220.155.0/24','FACEBOOK',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:69.171.232.128/25','FACEBOOK',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:66.220.157.0/25','FACEBOOK',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:69.171.244.0/24','FACEBOOK',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:199.16.156.0/22','TWITTER',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:199.59.148.0/22','TWITTER',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:8.25.194.26/31','TWITTER',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:204.92.114.203','TWITTER',0);
INSERT INTO greylisting_whitelist (Source,Comment,Disabled) VALUES ('SenderIP:204.92.114.204/31','TWITTER',0);

2

Re: Popular Sites To Whitelist From Greylisting

Thanks for your sharing. Maybe it's a good idea to add them during iRedMail installation.