<html><body bgcolor="#FFFFFF"><div><span class="Apple-style-span" style="-webkit-tap-highlight-color: rgba(26, 26, 26, 0.296875); -webkit-composition-fill-color: rgba(175, 192, 227, 0.230469); -webkit-composition-frame-color: rgba(77, 128, 180, 0.230469); font-size: medium; "><span>*bump*</span></span><span class="Apple-style-span" style="-webkit-tap-highlight-color: rgba(26, 26, 26, 0.296875); -webkit-composition-fill-color: rgba(175, 192, 227, 0.230469); -webkit-composition-frame-color: rgba(77, 128, 180, 0.230469); font-size: medium; "><br></span><span class="Apple-style-span" style="-webkit-tap-highlight-color: rgba(26, 26, 26, 0.296875); -webkit-composition-fill-color: rgba(175, 192, 227, 0.230469); -webkit-composition-frame-color: rgba(77, 128, 180, 0.230469); font-size: medium; "><span>Does no one know an answer? This shouldn't be too a hard for someone who has it up and running. I just can't see the error.</span></span><span class="Apple-style-span" style="-webkit-tap-highlight-color: rgba(26, 26, 26, 0.296875); -webkit-composition-fill-color: rgba(175, 192, 227, 0.230469); -webkit-composition-frame-color: rgba(77, 128, 180, 0.230469); font-size: medium; "><br></span><span class="Apple-style-span" style="-webkit-tap-highlight-color: rgba(26, 26, 26, 0.296875); -webkit-composition-fill-color: rgba(175, 192, 227, 0.230469); -webkit-composition-frame-color: rgba(77, 128, 180, 0.230469); font-size: medium; "><span></span></span><span class="Apple-style-span" style="-webkit-tap-highlight-color: rgba(26, 26, 26, 0.296875); -webkit-composition-fill-color: rgba(175, 192, 227, 0.230469); -webkit-composition-frame-color: rgba(77, 128, 180, 0.230469); font-size: medium; "><br></span><span class="Apple-style-span" style="-webkit-tap-highlight-color: rgba(26, 26, 26, 0.296875); -webkit-composition-fill-color: rgba(175, 192, 227, 0.230469); -webkit-composition-frame-color: rgba(77, 128, 180, 0.230469); font-size: medium; "><span>Thanks,</span></span></div><div><span class="Apple-style-span" style="-webkit-tap-highlight-color: rgba(26, 26, 26, 0.296875); -webkit-composition-fill-color: rgba(175, 192, 227, 0.230469); -webkit-composition-frame-color: rgba(77, 128, 180, 0.230469); font-size: medium; "><span></span></span><span class="Apple-style-span" style="-webkit-tap-highlight-color: rgba(26, 26, 26, 0.292969); -webkit-composition-fill-color: rgba(175, 192, 227, 0.230469); -webkit-composition-frame-color: rgba(77, 128, 180, 0.230469); font-size: medium;">S.</span></div><div><span class="Apple-style-span" style="-webkit-tap-highlight-color: rgba(26, 26, 26, 0.292969); -webkit-composition-fill-color: rgba(175, 192, 227, 0.230469); -webkit-composition-frame-color: rgba(77, 128, 180, 0.230469); font-size: medium;"><br></span><br></div><div></div><blockquote type="cite"><div><span>Hi,</span><br><span></span><br><span>I'd like to use the new sa_userconf_maps feature in Amavis 2.7.0 (Ubuntu</span><br><span>x64), but unfortunately I'm not able to figure out the correct</span><br><span>configuration from what I can find online.</span><br><span></span><br><span>My setting is as follows:</span><br><span></span><br><span>I have a MYSQL database called 'spamassassin_db' on my server with a</span><br><span>single table 'userpref' in it, containing white- and blacklist entries.</span><br><span>These are filled by some other application, so I don't want to change</span><br><span>anything here (e.g., to amavis SQL rules which seem to be even less well</span><br><span>documented) if possible.</span><br><span></span><br><span>I have configured the SQL database in my /etc/spamassassin/local.cf as</span><br><span>follows:</span><br><span></span><br><span>user_scores_dsn DBI:mysql:spamassassin_db:localhost</span><br><span>user_scores_sql_username (...)</span><br><span>user_scores_sql_password (...)</span><br><span>user_scores_sql_custom_query SELECT preference, value FROM userpref</span><br><span>WHERE username = _USERNAME_ OR username = '$GLOBAL' OR username =</span><br><span>CONCAT('%',_DOMAIN_) ORDER BY username ASC</span><br><span></span><br><span></span><br><span></span><br><span>What I would like amavisd to do is to have spamassassin respect the</span><br><span>whitelist_auth/blacklist_from rules in this database table globally,</span><br><span>i.e. regardless of the recipient's email address.</span><br><span>However, I don't seem to know the appropriate commands, and where to put</span><br><span>them.</span><br><span></span><br><span>If I just put</span><br><span></span><br><span>@sa_userconf_maps = (</span><br><span> {</span><br><span> '.*' => 'sql:',</span><br><span> }</span><br><span> );</span><br><span></span><br><span>...how does amavis know which SQL database is referred to? Or that it</span><br><span>should use "local.cf"? I have also tried something like</span><br><span></span><br><span>@sa_userconf_maps = (</span><br><span>"/etc/spamassassin/local.cf"</span><br><span> );</span><br><span></span><br><span>without success.</span><br><span></span><br><span>It's not surprising to me that I haven't got it to work so far, given</span><br><span>that I simply can't find any clear instructions anywhere on the Web.</span><br><span></span><br><span></span><br><span>Any help would be very much appreciated! :)</span><br><span></span><br><span>Thanks,</span><br><span>S.</span><br></div></blockquote></body></html>