Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 21st May 2013, 10:02
electronico_nc electronico_nc is offline
Member
 
Join Date: Oct 2012
Posts: 30
Thanks: 7
Thanked 1 Time in 1 Post
Default 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

Last edited by electronico_nc; 21st May 2013 at 12:46. Reason: added OS & ISPConfig version
Reply With Quote
Sponsored Links
  #2  
Old 22nd May 2013, 12:35
monkfish monkfish is offline
HowtoForge Supporter
 
Join Date: Mar 2013
Posts: 106
Thanks: 9
Thanked 15 Times in 14 Posts
Default

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
Reply With Quote
The Following User Says Thank You to monkfish For This Useful Post:
electronico_nc (22nd May 2013)
  #3  
Old 22nd May 2013, 22:33
electronico_nc electronico_nc is offline
Member
 
Join Date: Oct 2012
Posts: 30
Thanks: 7
Thanked 1 Time in 1 Post
Default

Thanks for your input !
SQL is OK.
Nicolas
Reply With Quote
The Following User Says Thank You to electronico_nc For This Useful Post:
monkfish (22nd May 2013)
  #4  
Old 22nd May 2013, 23:14
monkfish monkfish is offline
HowtoForge Supporter
 
Join Date: Mar 2013
Posts: 106
Thanks: 9
Thanked 15 Times in 14 Posts
Default

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.
Reply With Quote
  #5  
Old 23rd May 2013, 06:39
electronico_nc electronico_nc is offline
Member
 
Join Date: Oct 2012
Posts: 30
Thanks: 7
Thanked 1 Time in 1 Post
 
Default

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)
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Spamfilter Policy for Reseller ferryvdijk Installation/Configuration 2 27th August 2014 21:33
Spamfilter policy - forward blocked emails ppoetsma Installation/Configuration 2 9th August 2010 15:37
Spamfilter policy - question about spam actions prisfeo Installation/Configuration 4 2nd February 2010 16:17
Cannot change spamfilter marciliomcm Installation/Configuration 1 12th May 2009 19:46
Upgrade from 2.2.0 to 2.2.1 successful but SSL and IMAP stopped working teleriddler Installation/Configuration 8 29th April 2006 14:25


All times are GMT +2. The time now is 04:21.


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