Achim Rosenhagen wrote:
Hi list,
I want to add some whitelist entries to the greylisting-db, but i think it
doesn't really work at all.
In the patch-file there's an example of whitelisting:
insert into relaytofrom values (0,NULL,NULL,"somedomain.com","0000-00-00
00:00:00","9999-12-31
23:59:59",0,0,0,"MANUAL",NOW(),NOW());
Actually "somedomain.com" will be added to the field "rcptto", which should be
wrong I think.
I want to whitelist all emails that come from "somedomain.com" NOT to
"somedomain.com" (obviously since i do not host
somedomain.com).
So anyone who can tell me how to add for example a general whitelist entry für
aol.com?!
Hi,
Attached is a bunch of whitelist entries I use, to white list aol.com,
do a dig aol.com mx or dnsmx aol.com, then dig the hosts or dnsip the
hosts and add those IP's. (ie insert into relaytofrom values
(0,"66.35.250",NULL,NULL,"0000-00-00 00:00:00",
"9999-12-3123:59:59",0,0,0,"MANUAL",NOW(),NOW()); ) where you change the
65.35.250 to aol's mail servers.
Do not do a (0,NULL,NULL,"aol.com", etc type whitelisting as spammers
sending as [EMAIL PROTECTED] will get through.
Bill, maybe we want to start a whitelist patch for the greylisting patch ?
HTH,
Regards,
Rick
# Example wildcard whitelists for subnets
insert into relaytofrom values (0,"127.0.0.1" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
insert into relaytofrom values (0,"192.168" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
# Yahoo Groups
insert into relaytofrom values (0,"66.218.66" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
insert into relaytofrom values (0,"66.218.67" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
insert into relaytofrom values (0,"66.94.237" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
# Paypal
insert into relaytofrom values (0,"64.4.240.67" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
# Vonage
insert into relaytofrom values (0,"12.144.47" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
insert into relaytofrom values (0,"216.115.26" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
# Ebay
insert into relaytofrom values (0,"66.135.209" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
# Google
insert into relaytofrom values (0,"216.239.56" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
# local domain
insert into relaytofrom values (0,"207.88.74" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
# Axess
insert into relaytofrom values (0,"216.162.64" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
# Apache
insert into relaytofrom values (0,"209.237.227" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
# Security Focus
insert into relaytofrom values (0,"205.206.231" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
# Nomi Bank
insert into relaytofrom values (0,"216.229.176" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
# Inter7
insert into relaytofrom values (0,"209.218.8" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
insert into relaytofrom values (0,"68.78.194" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
# Binc
insert into relaytofrom values (0,"217.144.230" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
# Example wildcard whitelist entry for a recieved domain or subdomain
insert into relaytofrom values (0,NULL,NULL,"supertv55.com","0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
insert into relaytofrom values (0,NULL,NULL,"supertv55.tv","0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
insert into relaytofrom values (0,"69.9.171" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
insert into relaytofrom values (0,"216.12.208" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
insert into relaytofrom values (0,"69.9.164" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
insert into relaytofrom values (0,"209.123.232" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
insert into relaytofrom values (0,"130.118.46" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
insert into relaytofrom values (0,"216.254.136" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
insert into relaytofrom values (0,"198.165.201" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
insert into relaytofrom values (0,"68.179.25" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
insert into relaytofrom values (0,"207.170.253" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
insert into relaytofrom values (0,"66.35.250" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
insert into relaytofrom values (0,"81.23.230" ,NULL,NULL,"0000-00-00
00:00:00","9999-12-31 23:59:59",0,0,0,"MANUAL",NOW(),NOW());
