HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   General (http://www.howtoforge.com/forums/forumdisplay.php?f=25)
-   -   Spamfilter policy : change all to another one (http://www.howtoforge.com/forums/showthread.php?t=61913)

electronico_nc 21st May 2013 10:02

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

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.

Nicolas

monkfish 22nd May 2013 12:35

Hello,

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:

Code:

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!
M

electronico_nc 22nd May 2013 22:33

Thanks for your input !
SQL is OK.
Nicolas

monkfish 22nd May 2013 23: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 06: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 08:43.

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