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: > >> /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 > >