Turn on Spamassassin for all domains and users

[Stuff That Spins]

Is it possible to turn Spamassassin on for all domains and users? I had to reinstall Spamassasin and now all email accounts are turned off.

Thanks!

 

[IgorG]

# /usr/local/psa/admin/sbin/spammng stop

 

[Stuff That Spins]

thanks igor. i mean spamassassin is running. i want to switch spam protection on for every email account and every domain at once.

 

[Stuff That Spins]

went into plesk MySQL "psa" table and changed the value for "spamfilter" to "true"

UPDATE `psa`.`mail` set spamfilter = "true"

i'll see if this works

 

[IgorG]

You can use following script:

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 -status true; done