Hello all,

I'm using amavisd-new and like to add spam features to Squirrelmail.

Well, indeed, I have added this with the amavisnewsql plugin for
Squirrelmail years ago. Unfortunally the amavisnewsql plugin is not
developed anymore, causes tons of warnings and errors with PHP 5.3 (the
user frontend does not work anymore) and also relies on a very old Amavis
mysql table schema. I use bsmtp method for storing spam and virus mails and
a php script of amavisnewsql puts these mails into the database. Amavis
looks up user settings in this database (lookup_sql) and users can setup
their settings in Squirrelmail. I use a second database for amavis itself
for some storage features (but not for storing spam etc to database).

So what I like to accomplish is at least the same features as I had, but
with newer and working programs. Features are:

- Users can setup their settings in Squirrelmail (spam policy, b/w list...)
- Users can see their spam quarantine in Squirrelmail and work on it
  (delete, release...)
- Amavis is using these personal settings and is saving spam etc mails
  directly to the database.

I think the third point is a 3 minute thing. Just adjust Amavis to use a
database with a current schema for lookup and storage.

The first two points are a lot more difficult. It seems that most people
use(d) amavisnewsql plugin for Squirrelmail, at least if I do some research
with Google.

Paul Lesniewski of the Squirrelmail team recommended the server_settings
plugin, which has "all the functionality". To be honest, with a 60+ KB
config file it has a lot more to offer than amavisnewsql. The problem is,
that the example config is for use with Spamassassin and it seems that
nobody tried to use it with Amavis yet.

That's the reason why I write to the list. I'm not that expert with MySQL
Queries so I'm stuck here.

Does somebody already use Server Settings and can help me out with a
working setup?

Here's the link to the plugin:
http://www.squirrelmail.org/plugin_view.php?id=274

Kindest regards,
Martin


------------------------------------------------------------------------------
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net 
https://lists.sourceforge.net/lists/listinfo/amavis-user 
 AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 
 AMaViS-HowTos:http://www.amavis.org/howto/ 

Reply via email to