Resolved Spam Score Update of all subscriptions

[Heppi75]

Hi,

is it possible to update the spam score points of all subscriptions to a new value at once?

Thank you.

 

[IgorG]

Do you mean server-wide value? In this case, for example, to set the minimum score for marking email messages as spam for the Plesk server to 5:

# plesk bin spamassassin --update-server -hits 5

 

[Heppi75]

Does this also update the score from existing accounts or only if I create a new one this value is used? What I want is that all all existing accounts would get a new score. Maybe this can be done directly in the database? Is the score stored in the database - if yes, which table?

 

[IgorG]

My command above is server-wide setting, which applies for the whole server will all existing mailboxes and for new created.
If you want to update a special score (3) only for all existing mailboxes, you can try to use the following command:


for i in `mysql -uadmin -p\`cat /etc/psa/.psa.shadow\` psa -Ns -e "select concat(mail.mail_name,\"@\",domains.name) as address from mail,domains,accounts where mail.dom_id=domains.id and mail.account_id=accounts.id order by address"`; do /usr/local/psa/bin/spamassassin -u $i -hits 3 -reject-spam true; done

 

[Heppi75]

Igor thank you very much, exactly what I was looking for ...