• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

Resolved Spam Score Update of all subscriptions

Heppi75

Basic Pleskian
Hi,

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

Thank you.
 
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
 
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?
 
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
 
Back
Top