turn on spam filter/anti virus for all accounts

[perler2]

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

 

[IgorG]

You can write some script for mass mailboxes update with using /usr/local/psa/bin/mail utility. --help option for more details.

 

[perler2]

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

 

[IgorG]

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

 

[perler2]

oh, this is cool, thanks, that will work,

PAT

 

[perler2]

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?

 

[IgorG]

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?

 

[perler2]

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

 

[perler2]

IgorG? any news?