> >
All,
Appologies for top-posting, but it seems best to start off with a summary:
I have the same need as Shaun, which is to keep user prefs in a database,
where they are easily accessed by other tools, however, I have no need (nor
desire) to migrate our Bayes and AWL databases into SQL.
That point has been glossed over by responders on this thread, but as far as
I can tell (and I've looked around a lot), it's an either-or kind of thing.
It would be possible if I had a site-wide Bayes system, but I do not.
Until now, this has worked wonderfully for us:
spamd -d --max-children=20 -H /etc/razor -u spamd -x \
--virtual-config-dir=/var/spool/spamassassin/%d/%l
Ideally, I'd simply like to add the -q option to spamd (and have spamd know
that everything besides user prefs is still in the location listed by the
virtual-config-dir parameter), but that's just not how it works ATM. Or 2nd
best would be to have some setting in the user prefs that points to a HOME
directory... bayes_path *might* work (haven't tried because there's no awl_path
anyway), but I digress.
I think we'll just have to bite the bullet and push everything into SQL if we
want to use the -q option, but it's a little frustrating that SQL-based user
prefs and file-based per-user Bayes/AWL can't be mixed/matched.
If I missed something and this is in fact not impossible, I'd appreciate
feedback.
Many thanks for a wonderful product,
Paul
> > That's the way it is.
> >
> > From the man page:
> > -x, --nouser-config Disable user config files
>
> Hmmm. Later in that same manpage, is this:
>
> -x, --nouser-config, --user-config
> Turn off(on) per-user config files. All users will just get the
> default configuration. The default behaviour is for per-user con-
> figuration to be off.
>
> I take that to mean that -x is a toggle, and if the default is for
> per-user configs to be off, then I believed my use of -x is actually
> toggling per-user configs *on*, yes?
>
> > The mysql userprefs setup is a tradeoff. Where is spamd supposed to
> > learn of the virtual user's home directory?
>
> I mentioned this in an earlier email: my database has fields for the
> username, their uid, their gid, their homedir, and their maildir. All
> the information is there, if spamd would only use it. Courier-imap uses
> it to find my mailbox, courier-maildrop uses it to find my mailbox and
> filter file, postfix uses it ...everything uses it - except spamassassin.
>
> > If you pull the -x and you
> > have your system setup to be able to find the virual user's information
> > you can have per user bayes. But if spamd was complaining about running
> > as root, I don't think your setup matches those requirements.
>
> So, are you saying I can drop -x, and use --virtual-config-dir, that
> spamd will create the bayes database in each user's home dir?
>
> > Have you read README.spamd?
>
> Yes, several times, and if I fully understood it, I probably wouldn't be
> asking so many questions. My apologies, and my thanks for holding my hand.
