Amavis & SA SQL conf

[Rob Sterenborg (lists)]

Hello,

I'm using Amavisd-new 2.8.0 with SA 3.3.2 and Perl 5.10.1, and I'm
trying to get SQL config with both Amavisd-new and SA working.

- The Amavis SQL config works.
- When testing SA with 'su - <amavis_user> -c "spamassassin -p
<sql_prefs_file> ..."' the configuration is being read and used without
errors.
- When using SA with Amavisd-new it isn't.

Turning on debugging, I see the below in the log (sorry for wrapping; I
separated each line for readability). 
I can see that Amavis reads the correct cf file because the log shows
the same settings as are in the cf file, but for some reason it cannot
parse the lines.

Can someone please point me to what I'm missing here?


--
Thanks,
Rob

=================

Aug  1 15:14:30 {myhostname} /usr/local/amavisd-new/sbin/amavisd[23991]:
(23991-01) SA dbg: config: copying current conf to backup

Aug  1 15:14:30 {myhostname} /usr/local/amavisd-new/sbin/amavisd[23991]:
(23991-01) SA info: config: not parsing, administrator setting:
user_scores_dsn DBI:mysql:<db_name>:<db_host>:3306

Aug  1 15:14:30 {myhostname} /usr/local/amavisd-new/sbin/amavisd[23991]:
(23991-01) SA info: config: failed to parse line, skipping, in
"/etc/mail/spamassassin.d/{custom}.cf": user_scores_dsn
DBI:mysql:<db_name>:<db_host>:3306

Aug  1 15:14:30 {myhostname} /usr/local/amavisd-new/sbin/amavisd[23991]:
(23991-01) SA info: config: not parsing, administrator setting:
user_scores_sql_username <sql_username>

Aug  1 15:14:30 {myhostname} /usr/local/amavisd-new/sbin/amavisd[23991]:
(23991-01) SA info: config: failed to parse line, skipping, in
"/etc/mail/spamassassin.d/{custom}.cf": user_scores_sql_username
<sql_username>

Aug  1 15:14:30 {myhostname} /usr/local/amavisd-new/sbin/amavisd[23991]:
(23991-01) SA info: config: not parsing, administrator setting:
user_scores_sql_password <sql_password>

Aug  1 15:14:30 {myhostname} /usr/local/amavisd-new/sbin/amavisd[23991]:
(23991-01) SA info: config: failed to parse line, skipping, in
"/etc/mail/spamassassin.d/{custom}.cf": user_scores_sql_password
<sql_password>

Aug  1 15:14:30 {myhostname} /usr/local/amavisd-new/sbin/amavisd[23991]:
(23991-01) SA info: config: not parsing, administrator setting:
user_scores_sql_custom_query SELECT _preference,_value FROM
user_preferences WHERE _username=_USERNAME_ OR _username='$GLOBAL' OR
_username = CONCAT('%',_DOMAIN_) ORDER BY _username ASC

Aug  1 15:14:30 {myhostname} /usr/local/amavisd-new/sbin/amavisd[23991]:
(23991-01) SA info: config: failed to parse line, skipping, in
"/etc/mail/spamassassin.d/{custom}.cf": user_scores_sql_custom_query
SELECT _preference,_value FROM user_preferences WHERE
_username=_USERNAME_ OR _username='$GLOBAL' OR _username =
CONCAT('%',_DOMAIN_) ORDER BY _username ASC

[etc.. etc..]