After days of debugging, I have discovered that some rows of mysql data can
be the cause of my not autowhitelisting.

What i have discovered for sure is that ASSP, do query 3 times the redlist
table, like this:
select pvalue,pfrozen from redlist where pkey='em...@example.tld'
select pvalue,pfrozen from redlist where pkey='*'
select pvalue,pfrozen from redlist where pkey=''

I have found an empty entry in my redlist table, now deleted, so probably
this is the cause.
I have also found a lot of email addresses with "strange" characters, most
of them starting with the hash "#", or with the underscore "_". Also deleted
all of them. Moreover deleted thousand of email addresses whose domain part
was already into the noprocessingdomains.txt file.

Only at this point I have restarted ASSP, so I have a good reason to think
that my problem is related to mysql, but I'm not entirely sure of what
exactly was the cause.

Now I'm looking at my log, and can see some lines saying "auto whitelist
addition: " again.
Wow!

Luigi



--
View this message in context: 
http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/Outbound-mail-dont-auto-whitelisting-anymore-tp38156p38170.html
Sent from the assp-user mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works. 
Faster operations. Version large binaries.  Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
_______________________________________________
Assp-user mailing list
Assp-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-user

Reply via email to