Amavis & SA SQL conf

[Rob Sterenborg (lists)]

Sorry to ask again, but.. Is there no one who can tell me what is/might
be going on?


--
Rob


On 08/01/2012 04:42 PM, Rob Sterenborg (lists) wrote:
> 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..]
> 
>