Use Mailscanner + Spamassassin user_prefs MYSQL

[Joolee]

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.

Rulesets normally point to text files containing stuff like:
mailscanner at joolee.nl NO

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:
http://mailscanner.info/MailScanner.conf.index.html#SQL%20Ruleset

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.

On 8 May 2012 15:35, Manel Gimeno Zaragozá <magiza83 at hotmail.com> wrote:

>  Hello,
>
> 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
>
> required_score                  5.0
> rewrite_header Subject          [SPAM1]
> report_safe                     1
> use_bayes                       1
> skip_rbl_checks                 0
> use_razor2                      1
> use_pyzor                       1
> ok_locales                      es
> bayes_auto_learn                1
> bayes_auto_learn_threshold_nonspam    0.1
> bayes_auto_learn_threshold_spam       5.0
> user_scores_dsn                 DBI:mysql:spamassassin:localhost
> user_scores_sql_username        spamassassin
> user_scores_sql_password        *****
> bayes_store_module              Mail::SpamAssassin::BayesStore::MySQL
> bayes_sql_dsn                   DBI:mysql:spamassassin:localhost
> bayes_sql_username              spamassassin
> bayes_sql_password              *****
>
> Can you guide me to the documentation or point to get it?
>
>
> Thanks & Regards.
>
> Manel Gimeno Zaragoza
> magiza83 at hotmail.com
>
>
> ------------------------------
> From: mailscanner at joolee.nl
> Date: Tue, 8 May 2012 13:55:25 +0200
> To: mailscanner at lists.mailscanner.info
> Subject: Re: Use Mailscanner + Spamassassin user_prefs MYSQL
>
>
> 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.
> 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.
>
> On 8 May 2012 13:39, Manel Gimeno Zaragozá <magiza83 at hotmail.com> wrote:
>
>  Hello,
>
> 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 local.cf (where I have the MYSQL
> connection information).
>
> 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.
>
> Thanks & Regards.
>
> Manel Gimeno Zaragoza
> magiza83 at hotmail.com
>
> --
> MailScanner mailing list
> mailscanner at 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!
>
>
>
> -- MailScanner mailing list mailscanner at 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!
>
> --
> MailScanner mailing list
> mailscanner at 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!
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.mailscanner.info/pipermail/mailscanner/attachments/20120508/149dc8e9/attachment.html