---------- Original Message ---------------------------------- From: Gary Smith <gary.sm...@holdstead.com> Date: Wed, 26 Aug 2009 12:29:24 -0700
>I've been finding a lot of singletons in the AWL db for domains that are all >spam. Is there a way put an entire domain into AWL or set it up to give an >average score for that domain? > >Obviously I can put this directly into the config file but I'm looking for a >less intrusive way to do this. What might be useful is an awl_domain table >that it manages the average for the domain/ip as well as just the single email. > >Anyway, is there a way to do this currently? > >Example of the database (I think I have like 500 for these guys now from this >week). > >+----------+----------------------------------------+-------+-------+----------+ >| username | email | ip | count | totscore >| >+----------+----------------------------------------+-------+-------+----------+ >| filter | ajdiohxo...@weekendhotdeals.info | 76.73 | 1 | 6.519 >| >| filter | ajuxorpc...@weekendhotdeals.info | 76.73 | 1 | 6.519 >| >| filter | aqxkopmj...@weekendhotdeals.info | 76.73 | 2 | 10.872 >| >| filter | atjwoxps...@weekendhotdeals.info | 76.73 | 1 | 11.918 >| >| filter | bckxiypg...@weekendhotdeals.info | 76.73 | 1 | 6.519 >| >| filter | beqrikuo...@weekendhotdeals.info | 76.73 | 2 | 10.872 >| >| filter | bkqrasni...@weekendhotdeals.info | 76.73 | 2 | 13.038 >| >| filter | blyhovks...@weekendhotdeals.info | 76.73 | 1 | 6.519 >| >| filter | bsfmogqa...@weekendhotdeals.info | 76.73 | 2 | 10.872 >| >| filter | bsgjuulc...@weekendhotdeals.info | 76.73 | 2 | 10.872 >| >+----------+----------------------------------------+-------+-------+----------+ I don't let that junk get past envelope stage: postmap -q "weekendhotdeals.info" mysql:/usr/local/etc/postfix/mysql-from_senders_rhsbl.cf 554 RHSBL_DOMAIN Len