HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (
-   General (
-   -   Spamfilter policy : change all to another one (

electronico_nc 21st May 2013 11:02

Spamfilter policy : change all to another one
Ubuntu 12.04.2 LTS server

Hi all,

While manually creating emails (domains, users) I had everything setup (both domain and user email acounts) to Spamfilter 'Normal' permission.
After setting 'Quarantine' emails accounts, it turns out that every email user ( around 100 users ), need to be set to 'Permissive' Spamfilter policy (allow BAD HEADER).
I just would like to know if there is one 'magic SQL' that would allow me to do this, as I don't have time (right now) to study the ISPConfig3 code.

(looking at the ispconfig MySQL tables hasn't been enough)

Thanks in advance for your time and comprehension.


monkfish 22nd May 2013 13:35


Looking at the spamfilter_users policy_id settings in the sql tables, it appears to me that "Normal" is a setting of 5 and "Permissive" is a setting of 7.

I reckon you could try a SQL statement like:


UPDATE `dbispconfig`.`spamfilter_users` SET `policy_id` = '7' WHERE `spamfilter_users`.`policy_id` = 5;
Then try a mailbox resync from ispconfig interface.

Would like to know myself from a developer if the above is feasible!

electronico_nc 22nd May 2013 23:33

Thanks for your input !
SQL is OK.

monkfish 23rd May 2013 00:14

Thanks for the update - has it actually applied the spam rules by doing a mailbox resync?

That was the part I was unsure of - by manually editing the SQL tables we need some way of applying the settings made with that bulk update.

electronico_nc 23rd May 2013 07:39

All email accounts ( that were previousely at 'Normal' ) are showing 'Permissive' permissions in ISPConfig after running the SQL Command and the resync of :
- mailbox
- clientdb config
from ispconfig interface.
(sorry I checked these 2 ones while resync, so I can't tell about mailbox resync only)

All times are GMT +2. The time now is 09:02.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.