1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

turn on spam filter/anti virus for all accounts

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by perler2, Dec 22, 2010.

  1. perler2

    perler2 Basic Pleskian

    20
    90%
    Joined:
    Aug 14, 2009
    Messages:
    34
    Likes Received:
    0
    hi,

    after moving domains from another server with a different AV/Sapm filter system, all accounts have the stock spam filter and AV (Parallels Premium Antivirus) switched off.

    is there a way to turn these features on for all accounts on the server?

    PAT
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    You can write some script for mass mailboxes update with using /usr/local/psa/bin/mail utility. --help option for more details.
     
  3. perler2

    perler2 Basic Pleskian

    20
    90%
    Joined:
    Aug 14, 2009
    Messages:
    34
    Likes Received:
    0
    ok, thanks, but you don't have this internally done yet? this must have come up in the development process. could you check?

    regards,

    PAT
     
  4. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    You can also try to set 'spamfilter' and 'virusfilter' in 'mail' table of psa database for each mailbox and rebuild mailsettings with /usr/local/psa/admin/sbin/mchk --with-spam
     
  5. perler2

    perler2 Basic Pleskian

    20
    90%
    Joined:
    Aug 14, 2009
    Messages:
    34
    Likes Received:
    0
    oh, this is cool, thanks, that will work,

    PAT
     
  6. perler2

    perler2 Basic Pleskian

    20
    90%
    Joined:
    Aug 14, 2009
    Messages:
    34
    Likes Received:
    0
    ok, this works, at least in regard to spam filtering, only halfway. although i can switch on the spam filter by setting all accounts to "true" in the "psa/mail" table, column "spamfilter" and the the mail get's filtered by spamassassin, there is the problem, that the mails found are not marked, as there needs to be added a row for each mail account in the table "psa/spamfilter_preferences" like "move" ort "subject: SPAM".

    do you have an SQL query ready, which does this for all accounts?
     
  7. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Sorry, I do not understand. spamfilter_preferences table contains settings for spamfilters and why do you think that there is should be some records for _each_ mailbox?
     
  8. perler2

    perler2 Basic Pleskian

    20
    90%
    Joined:
    Aug 14, 2009
    Messages:
    34
    Likes Received:
    0
    have a look:

    this is th preferences panel of a user, where i turn on the spam filter by hand:

    http://screencast.com/t/TUSafO2Udfa

    the table spamfilter_preferences looks like this

    http://screencast.com/t/w8eeVCQfZ

    this is the panel of someone, where i set the spamfilter to "on" in the database and let run mcheck:

    http://screencast.com/t/0wpyZED6CBC

    as you can see, in the table above is no entry for preferences for this user, so it get's set to default, mark as spam, but don't change the subject.

    PAT
     
  9. perler2

    perler2 Basic Pleskian

    20
    90%
    Joined:
    Aug 14, 2009
    Messages:
    34
    Likes Received:
    0
    IgorG? any news?
     
Loading...