Re: SQL preferences: where does the _DOMAIN_ in the query come from

2020-02-20 Thread RW
On Wed, 19 Feb 2020 23:03:47 -0700 @lbutlr wrote: > On 18 Feb 2020, at 14:48, RW wrote: > > It seems perfectly clear to me, if read carefully. > > The definition is clear, but the original post specifically addressed > the lack of _DOMAIN_ being defined: It says that _DOMAIN_ comes from the

Re: SQL preferences: where does the _DOMAIN_ in the query come from

2020-02-19 Thread @lbutlr
On 18 Feb 2020, at 14:48, RW wrote: > It seems perfectly clear to me, if read carefully. The definition is clear, but the original post specifically addressed the lack of _DOMAIN_ being defined: On 18 Feb 2020, at 00:36, Guido Goluke, Majorlabel wrote: > In my setup, the domain variable is em

Re: SQL preferences: where does the _DOMAIN_ in the query come from

2020-02-18 Thread RW
On Tue, 18 Feb 2020 13:35:18 -0700 @lbutlr wrote: > On 18 Feb 2020, at 07:25, RW wrote: > > It's the first match on _DOMAIN_, it stands out as being a > > definition, and it says in simple unambiguous language where the > > value comes from. > > If the OP could look up the domain in the sql

Re: SQL preferences: where does the _DOMAIN_ in the query come from

2020-02-18 Thread Kris Deugau
Guido Goluke, Majorlabel wrote: I'm in the process of setting up my preferences through SQL. Now spamc is invoked through a Postfix milter, but that's besides the point, since whatever way spamc is called, it can only specify one -u param as the username. However, the WIKI and Docs version of t

Re: SQL preferences: where does the _DOMAIN_ in the query come from

2020-02-18 Thread @lbutlr
On 18 Feb 2020, at 07:25, RW wrote: > On Tue, 18 Feb 2020 06:54:22 -0700 @lbutlr wrote: > >> On 18 Feb 2020, at 05:30, RW wrote: >>> On Tue, 18 Feb 2020 08:36:11 +0100 Guido Goluke, Majorlabel wrote: I'm in the process of setting up my preferences through SQL. Now spamc is invoked th

Re: SQL preferences: where does the _DOMAIN_ in the query come from

2020-02-18 Thread RW
On Tue, 18 Feb 2020 06:54:22 -0700 @lbutlr wrote: > On 18 Feb 2020, at 05:30, RW wrote: > > On Tue, 18 Feb 2020 08:36:11 +0100 Guido Goluke, Majorlabel wrote: > >> I'm in the process of setting up my preferences through SQL. Now > >> spamc is invoked through a Postfix milter, but that's besides

Re: SQL preferences: where does the _DOMAIN_ in the query come from

2020-02-18 Thread @lbutlr
On 18 Feb 2020, at 05:30, RW wrote: > On Tue, 18 Feb 2020 08:36:11 +0100 Guido Goluke, Majorlabel wrote: >> I'm in the process of setting up my preferences through SQL. Now >> spamc is invoked through a Postfix milter, but that's besides the >> point, since whatever way spamc is called, it can onl

Re: SQL preferences: where does the _DOMAIN_ in the query come from

2020-02-18 Thread RW
On Tue, 18 Feb 2020 08:36:11 +0100 Guido Goluke, Majorlabel wrote: > I'm in the process of setting up my preferences through SQL. Now > spamc is invoked through a Postfix milter, but that's besides the > point, since whatever way spamc is called, it can only specify one -u > param as the username.

SQL preferences: where does the _DOMAIN_ in the query come from

2020-02-17 Thread Guido Goluke, Majorlabel
I'm in the process of setting up my preferences through SQL. Now spamc is invoked through a Postfix milter, but that's besides the point, since whatever way spamc is called, it can only specify one -u param as the username. However, the WIKI and Docs version of the proposed query use both a _US

SQL Preferences and file-based per-user bayes

2014-04-15 Thread Sean Kennedy
Is there any way to use both an SQL configuration for virtual user preferences, but at the same time use file-based bayes databases for virtual users? The spamd man page for the "-virtual-config-dir" option states: "Note that this requires that -x is used, and cannot be comb

Re: SQL preferences when invoked via perl

2014-02-20 Thread Kevin A. McGrail
On 2/20/2014 3:07 PM, Wade Rossmann wrote: I'm using SpamAssassin via MimeDefang and trying to load user preferences in from a mySQL database. I've tried adding the user_scores_sql_* config items in the config file, but these seem to be ignored by everything except spamd -q. I've more or less g

SQL preferences when invoked via perl

2014-02-20 Thread Wade Rossmann
I'm using SpamAssassin via MimeDefang and trying to load user preferences in from a mySQL database. I've tried adding the user_scores_sql_* config items in the config file, but these seem to be ignored by everything except spamd -q. I've more or less given up on making that work [but if someone

RE: SQL preferences - multiword preferences

2005-06-24 Thread Dallas L. Engelken
> > > Hi, I am using spamassassin and store the user preferences in > an SQL database. > That works for simple options, like required_hits, since this > has a key (required_hits) and a value (5.0 for example). > But how about preferences where the key is composed of > multiple parts, like rewr

SQL preferences - multiword preferences

2005-06-24 Thread Marco Herrn
Hi, I am using spamassassin and store the user preferences in an SQL database. That works for simple options, like required_hits, since this has a key (required_hits) and a value (5.0 for example). But how about preferences where the key is composed of multiple parts, like rewrite_header subject

sql preferences

2005-01-12 Thread Paul Houselander
Hi Im trying to use SQL user preferences and SQL awl. I want my users to be able to choose whether they use awl, so in my test setup have created a user and entered use_auto_whitelist 0 in the userprefs table. It seems to skip it, mentioning administrator setting, can you not set this on a per u