spamassassin-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Duane Hill <du...@duanemail.org>
Subject Re: problem with spamassassin and sql
Date Wed, 13 Jul 2011 08:42:22 GMT
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:duane@duanemail.org


Mime
View raw message