Hi Rick, Slept over it and, well - seems obvious now :-) Thanks for the example file - this will help start my own whitelist.
By the way, the "CREATE TABLE" example which is commented in the patch didn't work for me - here's the right one: CREATE DATABASE relaydelay; grant select,insert,update,delete on relaydelay.* to milter@"localhost" identified by "milter"; Greets, Achim _______________________________ ::/:: bildundtonstudio.de ::/:: Achim Rosenhagen / Eberhard-Finckh-Str. 26 / 72829 Engstingen-Haid fon +49 (0) 7129 600 427 / mobil +49 (0) 175 1933253 http://www.bildundtonstudio.de -----Ursprüngliche Nachricht----- Von: Rick Macdougall [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 2. Februar 2006 01:23 An: toaster@shupp.org Betreff: Re: [toaster] Sign: Greylisting whitelist entries 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
