Global spamassassin enabling

[NightStorm]

Serverwide spamassassin preferences are doing nothing... so I need to enable spamassassin on every mailbox on the server. All 500+ across 60+ domains.
Any easy way? I've already tried running "/usr/local/psa/admin/bin/mchk --with-spam" and it did not do anything.

 

[p.engels]

hello, i have the same problem: ~1100 domains and NO spamassassin is working.

can anybody please read this topic and give an answer?

 

[azur99]

Originally posted by sjuerges here

Go into the psa mysql database and try this:

UPDATE sa_conf SET flt_enabled="user"
WHERE flt_enabled="serv"

that oughta do it.

Seb

P.S: Dont forget to restart spamassassin afterwards *grins*

or omit the where-clause and add other settings like

UPDATE sa_conf SET flt_enabled="user", rw_subject_tag="****SPAM***", hits_required=5, spam_action="save"

to disable global sa-settings and set default spamassasin user-settings for all mailnames.
possible values are
for flt_enabled: "serv", "user" or "both"
for rw_subject_tag: string to rewrite subject
hits_required: integer value
for spam_action: "save" or "delete"

 

[NightStorm]

No, that will only work if the email address is in that table... which requires going through each and every account and enabling the spamassassin filter.
Currently that table is empty.

 

[azur99]

what if you try these statements to populate the table?

1: global settings

INSERT INTO `sa_conf` ( `mailname` , `flt_enabled` , `rw_subject_tag` , `hits_required` , `spam_action` )
VALUES ('', 'user', '*****SPAM*****', '7', 'save')

2: settings for mailboxes

INSERT INTO `sa_conf` (`mailname` , `flt_enabled` , `rw_subject_tag` , `hits_required` , `spam_action`)
SELECT CONCAT(t1.mail_name,'@',t2.name),'user', '*****SPAM*****', '5', 'save' FROM `mail` as t1 left join
`domains` as t2 on t2.id=t1.dom_id where t1.postbox='true'

i've tried the mysql syntax, but i'm not sure whether populating the table is enough to actually enable spamassin or if you have to use a cli-command to rewrite spamassasin config.

 

[NightStorm]

I actually gave up and dropped psa-spamassassin completely. It was nothing but problems, and after spending a week arguing with swsoft "support" and fighting with it and the server loads it was causing, I simply went with ART's package of spamassassin and qmail-scanner.
I'd rather send my money to ART anyway, and get a product that works without me having to manually hack my way into and around a sloppy database.
This is the last of my servers still using Plesk, and I don't see it's future being a long one. The cost for all the nonfunctional extras (like backup, and spamassassin, and antivirus), and being a beta teter for substandard products just doesn't appeal to me as exciting anymore. I'd rather go with a product that offers the same features all bundled in for a cheaper cost.