The score thresholds and other settings you describe can be configured to use rulesets. This can be done in the overal Mailscanner configuration, you shouldn't be looking for it in the Spamassassin config.<br><br>Rulesets normally point to text files containing stuff like:<br>
<a href="mailto:mailscanner@joolee.nl" target="_blank">mailscanner@joolee.nl</a> NO<br><br>But they can be configured to use an SQL database since the last few versions. I don't have experience with it but you can find the doc here: <a href="http://mailscanner.info/MailScanner.conf.index.html#SQL%20Ruleset">http://mailscanner.info/MailScanner.conf.index.html#SQL%20Ruleset</a><br>
<br>If you need an example table layout (you can define your own queries so as long as the output is according to the documentation, the laout of the tables shouldn't matter), you can search the mail archive. A few weeks back, there was someone asking for it.<br>
<br><div class="gmail_quote">
On 8 May 2012 15:35, Manel Gimeno Zaragozá <span dir="ltr"><<a href="mailto:magiza83@hotmail.com" target="_blank">magiza83@hotmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div dir="ltr">
Hello,<br><br>I've looking for it in the documentation but I can not find the way to query mysql to get user preferences. I've try to use the same as SA to get global configuration a specific configuration by user but i does not seem to work<br>
<br>required_score 5.0<br>rewrite_header Subject [SPAM1]<br>report_safe 1<br>use_bayes 1<br>skip_rbl_checks 0<br>use_razor2 1<br>
use_pyzor 1<br>ok_locales es<br>bayes_auto_learn 1<br>bayes_auto_learn_threshold_nonspam 0.1<br>bayes_auto_learn_threshold_spam 5.0<br>user_scores_dsn DBI:mysql:spamassassin:localhost<br>
user_scores_sql_username spamassassin<br>user_scores_sql_password *****<br>bayes_store_module Mail::SpamAssassin::BayesStore::MySQL<br>bayes_sql_dsn DBI:mysql:spamassassin:localhost<br>
bayes_sql_username spamassassin<br>bayes_sql_password *****<br><br>Can you guide me to the documentation or point to get it?<div><br><br>Thanks & Regards.<br><br>Manel Gimeno Zaragoza<br>
<a href="mailto:magiza83@hotmail.com" target="_blank">magiza83@hotmail.com</a><br><br><br></div><div><div></div><hr>From: <a href="mailto:mailscanner@joolee.nl" target="_blank">mailscanner@joolee.nl</a><br>Date: Tue, 8 May 2012 13:55:25 +0200<br>
To: <a href="mailto:mailscanner@lists.mailscanner.info" target="_blank">mailscanner@lists.mailscanner.info</a><br>Subject: Re: Use Mailscanner + Spamassassin user_prefs MYSQL<div><div><br><br>Mailscanner doesn't use SpamAssassin as you've been using it. Because Mailscanner directly uses the SpamAssassin API, the built in user-settings from Spamassassin won't work.<br>
There should be a symlink to a Mailscanner configuration file in the Spamassassin directory which you can use for the global Spamassassin settings. The per-user settings should be configured in Mailscanners own configuration. You can define queries and database information there.<br>
<br><div>On 8 May 2012 13:39, Manel Gimeno Zaragozá <span dir="ltr"><<a href="mailto:magiza83@hotmail.com" target="_blank">magiza83@hotmail.com</a>></span> wrote:<br><blockquote style="border-left:1px #ccc solid;padding-left:1ex">
<div><div dir="ltr">
Hello,<br><br>I'm developing a mail server in Centos 6 + postfix and I had configured Spamassassin with user_prefs saved in MYSQL database. Now I've tried to include MailScanner, but I'm not able to configure the access to user_prefs in mysql. MailScanner is getting the configuration from Mailscanner.conf & spam.assassin.prefs.conf but not from <a href="http://local.cf" target="_blank">local.cf</a> (where I have the MYSQL connection information).<br>
<br>Is there any possibility to have MailScanner with MYSQL user_prefs from Spamassassin? Without MailScanner, Spamassassin is working perfectly and the user_prefs are correctly loaded and applied, but I would like to include Mailscanner to support Virus scan as well.<br>
<br>Thanks & Regards.<br><br>Manel Gimeno Zaragoza<br><a href="mailto:magiza83@hotmail.com" target="_blank">magiza83@hotmail.com</a><br> </div></div>
<br>--<br>
MailScanner mailing list<br>
<a href="mailto:mailscanner@lists.mailscanner.info" target="_blank">mailscanner@lists.mailscanner.info</a><br>
<a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" target="_blank">http://lists.mailscanner.info/mailman/listinfo/mailscanner</a><br>
<br>
Before posting, read <a href="http://wiki.mailscanner.info/posting" target="_blank">http://wiki.mailscanner.info/posting</a><br>
<br>
Support MailScanner development - buy the book off the website!<br>
<br></blockquote></div><br>
<br>--
MailScanner mailing list
<a href="mailto:mailscanner@lists.mailscanner.info" target="_blank">mailscanner@lists.mailscanner.info</a>
<a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" target="_blank">http://lists.mailscanner.info/mailman/listinfo/mailscanner</a>
Before posting, read <a href="http://wiki.mailscanner.info/posting" target="_blank">http://wiki.mailscanner.info/posting</a>
Support MailScanner development - buy the book off the website!</div></div></div> </div></div>
<br>--<br>
MailScanner mailing list<br>
<a href="mailto:mailscanner@lists.mailscanner.info" target="_blank">mailscanner@lists.mailscanner.info</a><br>
<a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" target="_blank">http://lists.mailscanner.info/mailman/listinfo/mailscanner</a><br>
<br>
Before posting, read <a href="http://wiki.mailscanner.info/posting" target="_blank">http://wiki.mailscanner.info/posting</a><br>
<br>
Support MailScanner development - buy the book off the website!<br>
<br></blockquote></div><br>