Sorry to have been so late in responding to this... You are right in
that I've not touched this code in a couple years. I'm no longer with
the enterprise I wrote this for and have had little time to keep up with
all the changes to amavisnew. If I were going to revisit it I've
actually thought about revamping the whole thing to use ldap for storing
all the per-user settings for amavis but still keep the database for the
quarantine. I would also make it more of a standalone app that could
also be embedded into SQM as a plugin since there has been some call for
that. If a site is large enough they should already be using ldap to
store per user data and it just makes more sense to have it there rather
than play games with trying to keep the sqldb in sync with userinfo. I
still like using the db for the quarantine to make it easy to
search/sort and deal with clusters of webmail servers.
I've also had requests for it to manage per-user policyd settings... I'm
not so sure about that one.. but I can see how useful such a thing would
be. To have one place for someone to manage all their personal settings
for relay level antispam.
I only get an email about this plugin maybe once every 6-8 months so I
have no idea if it's actually still being used out there... or if there
would be any interest in the new design I have in mind. Anyone?
Alex Schuilenburg wrote:
> The amavisnewsql plugin appears to be a couple of years behind the
> current sql database format of amavisd-new. I am currently running
> amavisd-new 2.4.5.
> I have started integrating amavisnewsql to use the latest format of
> amavisd-new 2.4.5 which is quite a major overhaul since the database has
> changed and the utility scripts process_bsmtp and cleanquarantine can be
> abandoned. Has anyone else already done this?
> If not is anyone else interested in updating amavisnewsql?