On Mon, 19 Nov 2007 14:47:37 -0700, Bob Beck wrote: > RW <[EMAIL PROTECTED]> [2007-11-11 22:39]: > >> It seems that the migrated database works but new entries go on the end >> - no SORT of order, and SPAMTRAP entries (that I entered using a >> script) ended up showing in two bunches in the midst of other unordered >> entries. >> >> My question is: Is this normal with spamd a la 4.2 or is it because I >> migrated a database? > > This is normal in 4.2 - the change happened post 4.0 when >spamdb stopped using DB_BTREE
Thanks Bob. I'm already using a script to sort the list to emulate the previous behaviour but at least I know I'll have to keep a copy for any future wipe and re-install upgrade. Looking at today's output showed me another puzzle which you will probably shoot down, but here goes. Here is one line fro spamdb: GREY|69.28.223.134|mta5br.cmpgnr.com|<gotb1103621_1102728_683443_1138134 [EMAIL PROTECTED] >|<[EMAIL PROTECTED]>|1195673789|1195675648|1195688189|2|0 but here is a line from my spamlog: Nov 22 07:08:14 mail spamd[28826]: whitelisting 69.28.223.134 in /var/db/spamd Why does the spamdb output show GREY instead of WHITE three hours later? It does show the 2 knocks which date -r will show were more than a half hour apart and so the whitelisting should have happened. Colour me puzzled. BTW the envelope recipient address shown is a spamtrap and is my only edit of the output. Thanks again for spamd. I absolutely love it. I have never known of it causing loss of genuine mail and also grepping the mail log daily for "reject" has only shown two emails in the last six months being blocked by zen.spamhaus having passed spamd. Both were really spammers anyway so apmd has an extremely good batting average. Two domains hosted on that box and zero customer complaints = mail admin happiness. In the beginning was The Word and The Word was Content-type: text/plain The Word of Rod.