How to use @sa_userconf_maps for white-/blacklisting in Amavis 2.7.0

[SB]

Hi,

I'd like to use the new sa_userconf_maps feature in Amavis 2.7.0 (Ubuntu
x64), but unfortunately I'm not able to figure out the correct
configuration from what I can find online.

My setting is as follows:

I have a MYSQL database called 'spamassassin_db' on my server with a
single table 'userpref' in it, containing white- and blacklist entries.
These are filled by some other application, so I don't want to change
anything here (e.g., to amavis SQL rules which seem to be even less well
documented) if possible.

I have configured the SQL database in my /etc/spamassassin/local.cf as
follows:

user_scores_dsn                 DBI:mysql:spamassassin_db:localhost
user_scores_sql_username        (...)
user_scores_sql_password        (...)
user_scores_sql_custom_query    SELECT preference, value FROM userpref
WHERE username = _USERNAME_ OR username = '$GLOBAL' OR username =
CONCAT('%',_DOMAIN_) ORDER BY username ASC



What I would like amavisd to do is to have spamassassin respect the
whitelist_auth/blacklist_from rules in this database table globally,
i.e. regardless of the recipient's email address.
However, I don't seem to know the appropriate commands, and where to put
them.

If I just put

@sa_userconf_maps = (
       {
          '.*' => 'sql:',
       }
     );

...how does amavis know which SQL database is referred to? Or that it
should use "local.cf"? I have also tried something like

@sa_userconf_maps = (
"/etc/spamassassin/local.cf"
     );

without success.

It's not surprising to me that I haven't got it to work so far, given
that I simply can't find any clear instructions anywhere on the Web.


Any help would be very much appreciated! :)

Thanks,
S.