Stuck with SpamAssassin daily training doesn’t work in Plesk for Windows? We can help you.

At Bobcares, we offer solutions for every query, big and small, as a part of our Server Management Service.

Let’s take a look at how our Support Team help a customer  deal with this Plesk error.

How to resolve SpamAssassin daily training doesn’t work in Plesk for Windows?

Plesk for Windows supports Microsoft SQL and MySQL. The Plesk Platform includes extensions for Backup, DNS, Cloud, Security, and Server Tools.

SpamAssassin training procedure works using Bayes system, which has its own internal database.

The database is updated each time a message is marked as spam or moved into spam folder or back to Inbox folder.

Bayes database contains words and patterns from processed messages known as tokens, which Bayes uses to identify message or spam or non-spam (ham).

Typically, we can see following errors in %plesk_dir%\admin\logs\php_error.log file

PleskUtilException: "C:\Program Files (x86)\Plesk/admin/bin/spammng" -train-messages-ham "mailname=jdoe@example.com" "-filename=C:/Program Files (x86)/Plesk/PrivateTemp/sat10f1e19e.tmp" failed with message: Unable to train spamassasin: Learned tokens from 0 message(s) (1 message(s) examined)

ERROR: the Bayes learn function returned an error, please re-run with -D for more information at C:\Program Files (x86)\Plesk\Additional\SpamAssassin\bin\sa-learn line 509.

Windows Event Viewer might contain the following error message:

Access denied for user 'sa_bayes'@'localhost' (using password: YES).

Today, let us see the steps followed by our Support techs to resolve it.

1. Firstly, connect to the server via RDP.

2. Then, open %plesk_dir%\Additional\SpamAssassin\etc\mail\spamassassin\v321.pre file for editing.

3. Prepend every # character in bayes_sql_password with a backslash \

For example:

before

bayes_sql_password 622#b1#F-VyD

after

bayes_sql_password 622\#b1\#F-VyD

[Need a solution to another query? We are just a click away.]

Conclusion

Today, we saw steps followed by our Support Engineers to resolve SpamAssassin daily training issue in plesk.