Mailing-List: contact users-help@spamassassin.apache.org; run by ezmlm
Precedence: bulk
Received-SPF: pass (nike.apache.org: local policy)
Message-ID: <e5046d5c4b591c6eede31b09fb815ce1.squirrel@192.168.0.5>
In-Reply-To: <1332003676.20110713030712@duanemail.org>
References: <61ef93750db684b6ad96b71bdf048477.squirrel@192.168.0.5>
    <1332003676.20110713030712@duanemail.org>
Date: Wed, 13 Jul 2011 11:14:53 +0300
Subject: Re: problem with spamassassin and sql
From: "Kristian Kirilov" <d3v1ous@d3v1ous.info>
To: "Duane Hill" <duane@duanemail.org>
Cc: users@spamassassin.apache.org
Reply-To: d3v1ous@d3v1ous.info
User-Agent: SquirrelMail/1.4.20
MIME-Version: 1.0
Content-Type: text/plain;charset=UTF-8
Content-Transfer-Encoding: 8bit
Importance: Normal

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:duane@duanemail.org
>
>