Create spamassassin rule sql
#CREATE SPAMASSASSIN RULE SQL UPDATE#
Update your Amavis configuration /etc/amavis/conf.d/50_user = ( ) # none, same, or separate database Nota Bene : while executing DROP TABLE users, don't be silly, and do not remove mysql users database. # mysql -u amavis_storage -p amavis_storage Load the initial schema from Amavis docs (usually located in /usr/share/doc/amavisd-new/ ).ĭelete unnecessary tables, as we will be using this database only for mail storage and not for lookups : Mysql> GRANT ALL PRIVILEGES ON amavis_storage.* TO FLUSH PRIVILEGES
![create spamassassin rule sql create spamassassin rule sql](https://manula.r.sizr.io/large/user/1483/img/query.jpg)
The ISPConfig policies can be changed in tab Email => Spamfilter => Policy in ISPConfig panel. It means that whatever you would set as $sa_spam_subject_tag, $sa_tag_level_deflt, $sa_tag2_level_deflt, $sa_kill_level_deflt, $sa_dsn_cutoff_level, it will be overridden by per-user policies. ' ORDER BY spamfilter_wblist.priority DESC' ' WHERE (spamfilter_wblist.rid=?) AND (spamfilter_wblist.email IN (%k))'. $sql_select_white_black_list = 'SELECT wb FROM spamfilter_wblist'. ' WHERE spamfilter_users.email IN (%k) ORDER BY spamfilter_users.priority DESC'
![create spamassassin rule sql create spamassassin rule sql](https://i.stack.imgur.com/g43A6.png)
' FROM spamfilter_users LEFT JOIN spamfilter_policy ON spamfilter_users.policy_id=spamfilter_policy.id'. The configuration file for Amavis, written by ISPConfig contains = In a default ISPConfig installation per-user ISPConfig policies are loaded. Off-subject generic explanations 2.1 Amavis and ISPConfig policies ISPConfig policies, Tag-Levels Jump to Installation if you know what you are doing. Optional : a working mail server with PHP (for Mailzu).A working SQL (PostgreSQL, MySQL.) database.A working Postfix+Amavis stack with ISPConfig.