Apply new setting (Spamfilter) to many email mailboxes at once

Discussion in 'Installation/Configuration' started by cocovina, Jan 7, 2018.

  1. cocovina

    cocovina New Member

    I've created my own spam policy and I'd like to apply it to many email mailboxes.
    Is there any way how to do it?
    Thanks for hints.
     
  2. Taleman

    Taleman Active Member HowtoForge Supporter

    Choose that policy in spamfilter in those mailboxes.
    If Your question is how to set this for several mailboxes in one go, it can be done manipulating dbispconfig database and then in Panel do resync from Tools Tab.
     
  3. cocovina

    cocovina New Member

    Thank you for your reply.
    Yes, I would like to apply it for mailboxes in one. But I am not good in SQL. Also I can not find the right column in mail_user table.
     
  4. Taleman

    Taleman Active Member HowtoForge Supporter

    How many mailboxes are involved?
     
  5. cocovina

    cocovina New Member

    More than 100 (first phase). I would like test new spam politic on some domains and their mailboxes. Then would like to apply on many others.
    So, looking for general SQL query which I can edit and apply for different users/mailboxes.
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    You mean a spamfilter policy in ISPConfig mail module? These exist just in the database, so a resync is not necessary (that's a rare case where you don't need a resync, so in general, taleman was right with his recommendation to resync). The mailboxes where you want to apply the policy have already a different spamfilter policy set? Changing the policy with SQL is easy, but in case they have no policy set at all, then it's quite complicated as you would have to add a record for each mailbox.
     
  7. cocovina

    cocovina New Member

    Yes, spamfilter policy in mail module. After migration every malimoxes and domains has no spamfilter defined "- not enabled -". So I added new one with my own tresholds etc. and would like to apply it for few testing domains and mailboxes, then I planning to apply it for many others. I am trying to avoid clicking this one by one.
    EDIT: If I understood right... resync is need just for config with generating some config file. .vhosts .cg etc.
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    Correct.

    Ok, so you don't have a spamfilter set for these domains yet if I understand you correctly. In that case, you will have to add a record into spamfilter_user table for each user or domain where you want to activate it. I recommend enabling a spamfilter for a mailbox in ISPConfig, then take a look at the spamfilter_user table with phpmyadmin to see how the required record looks like. You will see there that the record contains the email address, a reference on the policy and a column that is used for sorting (mailbox filters have to take precedence over domain wide filters).
     
    cocovina likes this.
  9. cocovina

    cocovina New Member

    Thanks for info (mainly table name).
    An incredible overlook on my part ... of course, I did not find the right tablename, because I missed a list of tables PAGING in phpmyadmin. ups!
    I found out, that every migrated mailboxes has a spamfilter policy, but the ID did not exists. So I duplicated my policy with right ID and I see taht it is allocated to mailboxes now right. :)
    THX for hints.
     

Share This Page