<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><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?<br><br>Thanks & Regards.<br><br>Manel Gimeno Zaragoza<br>magiza83@hotmail.com<br><br><br><div><div id="SkyDrivePlaceholder"></div><hr id="stopSpelling">From: mailscanner@joolee.nl<br>Date: Tue, 8 May 2012 13:55:25 +0200<br>To: mailscanner@lists.mailscanner.info<br>Subject: Re: Use Mailscanner + Spamassassin user_prefs MYSQL<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 class="ecxgmail_quote">On 8 May 2012 13:39, Manel Gimeno Zaragozá <span dir="ltr"><<a href="mailto:magiza83@hotmail.com">magiza83@hotmail.com</a>></span> wrote:<br><blockquote class="ecxgmail_quote" 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">magiza83@hotmail.com</a><br> </div></div>
<br>--<br>
MailScanner mailing list<br>
<a href="mailto:mailscanner@lists.mailscanner.info">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
mailscanner@lists.mailscanner.info
http://lists.mailscanner.info/mailman/listinfo/mailscanner
Before posting, read http://wiki.mailscanner.info/posting
Support MailScanner development - buy the book off the website!</div> </div></body>
</html>