So, SA3.0 now supports (somehow) sql users. This is nice. (in theory :).

I am using Courier and postfixadmin to manage SOME of the domains on my server, whilst the others are standard local/shell users.

It appears (<http://wiki.apache.org/spamassassin/UsingSQL> and man spamd) that the -q/-Q support in spamd requires that ALL usersprefs be in sql, is this correct? Would the database I use for the userprefs be a separate database from the Courier/postfixadmin or could I simply ad the userpref table to the existing postfix db?

I don't care so much about user prefs per se, but I would prefer per user bayes.

I really should just move ALL the users to courier/postfixadmin but my own accounts rely on procmail and I've not climbed that mountain successfully as yet.


sql/README says:
While scanning a message if spamd is unable to connect to the server
specified in user_scores_dsn or an error occurs when querying the SQL
server then spam checking will not be performed on that message.

Shouldn't it instead fallback to the user settings of the UID used for the SQL users (virtual or postfix or courier or whatever) rather than simply not processing?

--
There are 10 types of people in the world: Those who understand binary, and those who don't.


Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to