|Main Archive Page > Month Archives > spamassassin-users archives|
Is it nessacary needed? When i start spamd in debug mode saw the
/usr/share/spamassassin/10_default_prefs.cf is proceeded.
> 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