[Dovecot] DSpam mysql-plugin (was DSpam plugin)

[Johannes Berg]

On Wed, 2006-09-20 at 15:40 -0400, Michael Blinn wrote:
> After wrestling with Johannes's original plugin, I had a go at the mysql 
> plugin that Tim wrote, as described here:
> http://members.plug.org.au/~linuxalien/dokuwiki/projects:dovecot-mysql-dspam-plugin
> 
> I kept getting "Error: imap dump-capability process killed with signal 
> 11" when attempting to start dovecot with this plugin. 

That's odd. Probably a programming error in the plugin?

> I traced the 
> error to line 656 of master-settings.c in the dovecot source, in the 
> 'get_imap_capability' function. In this function, it notes:
> "Reloading configuration. Don't try to execute the imap process again. 
> Too risky and the wait() call below will break it anyway. Just use the 
> previous capability list we already had generated."
> 
> I changed the source so that the function always ran
> "    set->imap_generated_capability =
>                         p_strdup(settings_pool, generated_capability);
>                 return TRUE;"
> 
> instead of going through the function where it had on the wait described 
> in the comments.

Hmm.

> Now, voila. Dovecot starts without complaint, the plugin works, the 
> delivery and moving of email works.

Remember that with the mysql based dspam plugin you need a cron job to
actually do the retraining, he's written that in PHP. And it looks like
he's using the 'uid in signature' setting.

johannes