Wednesday, July 13, 2011, 3:14:53 AM, Kristian wrote:
> Is it nessacary needed? When i start spamd in debug mode saw the
> /usr/share/spamassassin/10_default_prefs.cf is proceeded.
You shouldn't make any changes in the /usr/share/spamassassin
directory as they could be overwritten when you upgrade SpamAssassin.
I believe by default, the user_scores_* settings are commented out.
The default SpamAssassin stores userprefs in individual user
directories within the file system. Any changes to the config should
be done within the local.cf config file.
>> Wednesday, July 13, 2011, 1:23:51 AM, Kristian wrote:
>>
>>> Hello im using spamassassin and user prefs in mysql database, i have
>>> successfully setting up mysql table and all about correct work of
>>> squirelmail plugin and from client site everything is ok. The problem is
>>> spamassassin can't handle username & domain variables..
>>
>>> I mean this:
>>
>>> /usr/share/spamassassin/10_default_prefs.cf
>>
>>> user_scores_dsn DBI:mysql:spamassassin:localhost:3306
>>> user_scores_sql_password spamassassin
>>> user_scores_sql_username spamassassin
>>
>> Do you have anything defined in your local.cf file? This is what I
>> have:
>>
>> user_scores_dsn DBI:mysql:spamass:127.0.0.1:3306
>> user_scores_sql_username spamass
>> user_scores_sql_password password
>> user_scores_sql_custom_query SELECT preference, value FROM _TABLE_
>> WHERE username = _USERNAME_ OR username = '@GLOBAL' OR username =
>> concat('@', _DOMAIN_) ORDER BY username ASC
>>
>>
>>> but when i started spamassassin with debug in the logs i watching this:
>>
>>> Tue Jul 12 18:54:12 2011 [10110] dbg: config: Conf::SQL: executing SQL:
>>> select preference, value from userpref where username = 'spamd' or
>>> username = '@GLOBAL' order by username asc
>>
>>> which is incorrect rule, because i need to replace username with virtual
>>> user and domain. The problem is spamassassin not recognize variables
>>> like
>>> _USERNAME_ or _DOMAIN_.
>>
>>> What is the problem and what i should do to fix is?
>>> Thanks.
--
Best regards,
Duane mailto:du...@duanemail.org
