|Main Archive Page > Month Archives > spamassassin-users archives|
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:
>>> 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
>> 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  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
>>> _USERNAME_ or _DOMAIN_.
>>> What is the problem and what i should do to fix is?
-- Best regards, Duane mailto:email@example.com