> heh, it all looks good to me. I think I'm just not quite sure what you're > up to (that, and understores in field names confuse me for some reason ;).
It's just an old habit. When I learned SQL I was taught (mostly from the big SQL books) and of course the little black book of normalization, _Handbook of Relational Database Design_ that table columns should try to be unique yet understandable. > well, by using this data to make spamassassin into a much more accurate > detector, you could start collecting data on the spammers who send out > those messages.. could generate blacklists/filters based on information > that they put into their spams (phone numbers, web pages, ip's, etc).. > Not to mention making it easier for those of us who bother reporting them > to isp's and (for WA residents) attorney generals. Hmm that is a good point. I think I will take a closer look at the headers to see which to parse up. Certainly From, but also maybe Subject and the IP information from the last Received header... That should be enough to start with and yet have a wide variety of data to choose from. Now I've got another table brewing, one with the msgid and the from, subject and last Received: header data. :-) ... maybe we should start whitelisting known good SMTP servers. <joke/> > it does. but md5 doesn't generate a unique id... there's no way that a You're of course 100% correct. :-) > yeah, it's not easy... another thing I've considered is (and I'm shamed > to admit that microsoft seems to have come up with the idea) to create > whitelists based on your addressbook's... so messages from people who Yes. I think that SA's auto-whitelist works similarly. Of course if you're running IMAP the converters aren't so important. :-) Regards, Andrew _______________________________________________________________ Hundreds of nodes, one monster rendering program. Now that’s a super model! Visit http://clustering.foundries.sf.net/ _______________________________________________ Spamassassin-talk mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
