[horde] Any Maia (SpamAss+Amavisd+) Users?

[Vadim Pushkin]

Thank you Barry,

I got the "report as spam/ham" working, that was easy.  What I am still not 
sure of is how to properly maintain the white and black lists within Horde.

Within Maia, my username is username at domain.net

In Horde, my username is just username.

I suppose I can just modify my account in Maia to be username vs. 
username at domain.net

But using what settings for the W/B and where do I place them?

Many thanks,

.vp

>From: Barry Flanagan <barryf-lists at flanagan.ie>

>Vadim Pushkin wrote:
> > hello Barry;
> >
> > Many thanks for your wonderful news and reply!
> >
> > May I ask if you could please provide the following?
> >
> > The entries withing the sam/config/backends.php for this to work
>
>Sure. Backends attached.
>
> >
> > For "Report as Spam", was this via IMP or SAM?
> >
>
>This is within IMP, in the configuration there is an option for an
>external command to report as spam/ham. In there I simply put
>"/usr/bin/sa-learn --spam -u amavis --no-sync" and "/usr/bin/sa-learn
>--ham -u amavis --no-sync" respectively.
>
> > Any other config mods within Horde that are necessary?
> >
>
>
>No. The only thing that I found was that if a user makes settings
>changes from within Horde but was not already registered as a Maia user,
>then things did not work because no Maia_user record existed for the user.
>
>The ideal thing to do here would be to make a specific Maia driver for
>Sam based on the current amavisd-new driver, which properly creates the
>Maia user if it does not exist.
>
>My work-around was to make sure that auto create users is turned ON in
>Maia - this creates a Maia user automatically when an email is received
>- and to sent a welcome email when users are created which triggers this.
>
>NOTE the Maia warnings about auto create user - your upstream MTA really
>must do user lookups and ONLY pass on to Maia emails for users that
>actually exist, otherwise you will end up with lots and lots of garbage
>users in the Maia db.
>
>Regards,
>
>-Barry Flanagan
>
>
> >
> > .vp
> >
> >> >> I've CC'ed one of the Maia Authors, Robert LeBlanc, who has 
>expressed
> >> >> interest in getting this working.  Aside from having to rewrite all 
>of
> >> >> his PHP to use the Horde Framework, is their any other way, like
> >> >> perhaps describing what is done in his sql tables and how Horde can 
>be
> >> >> configured to use the Maia DB?
> >>
> >> We have integrated Maia reasonably well with the Sam module.
> >>
> >> Maia database structure is very similar to amavisd-new which already
> >> exists in backends.php. I simply mapped to the appropriate fields and
> >> ensured that I have Maia set up to auto-create users and that the users
> >> are actually created in Maia before they use Sam (otherwise they do not
> >> get entered correctly in the database, as Sam knows nothing about the
> >> Maia specific tables/fields.
> >>
> >> This allows users to change their spam/virus settings etc. through Sam,
> >> as well as manage their white/black lists.
> >>
> >> For "Report as Spam" I simply installed local spamassasin configured to
> >> point to the Maia database, and use
> >>
> >> /usr/bin/sa-learn --spam -u amavis --no-sync
> >>
> >> in $conf['spam']['program']
> >>
> >> It would be great to integrate this further so that the quarantine 
>could
> >> be viewed directly within Sam. This should not be too difficult to do 
>by
> >> creating a very simply Maia template but I have not gotten around to
> >> that yet.
> >>
> >> Overall, Maia is great. We use it on a system with 30,000+ users.
> >>
> >> Oh, and of course Horde/IMP et al are also utterly fantastic ;-)
> >>
> >> Hope this helps.
> >>
> >>
> >> -Barry Flanagan