I took out the custom query, it's still choosing user 'nobody' when I
send an email to my address.
logmsg: connection from localhost.localdomain [127.0.0.1] at port 46482
debug: Conf::SQL: executing SQL: select preference, value from userpref
where u
sername = 'nobody' or username = '@GLOBAL' order by username asc
debug: retrieving prefs for nobody from SQL server
debug: user has changed
debug: bayes: 12772 tie-ing to DB file R/O /root/.spamassassin/bayes_toks
debug: bayes: 12772 tie-ing to DB file R/O /root/.spamassassin/bayes_seen
debug: bayes: found bayes db version 3
I'm not sure if I have a problem with the query (or how it needs to be
setup to work successfully for multiple users and domains) or if it's a
problem with exiscan not passing something.
thanks
On 10/9/2004, "Michael Parker" <[EMAIL PROTECTED]> wrote:
>> the example was:
>> user_scores_sql_custom_query SELECT preference, value FROM _TABLE_
>> WHERE username = _USERNAME_ OR username = '$GLOBAL' OR username =
>> CONCAT('%',_DOMAIN_) ORDER BY username ASC
>>
>> my usersnames are in [EMAIL PROTECTED] format. so in the database say I have
>>
>> [EMAIL PROTECTED] required_hits 4.0
>> [EMAIL PROTECTED] required_hits 4.6
>> [EMAIL PROTECTED] required_hits 7.0
>> [EMAIL PROTECTED] required_hits 5.0
>> and use @GLOBAL if the username isn't in the database.
>>
>> I'm not sure how I would need to set the custom query up for that.
>>
>
>>From what you've said, it doesn't sound like you need a custom query,
>remove that line from your config file.
>
>Probably the true cause of your problems is the fact that you either
>aren't sending the Username to spamd or you are sending the wrong
>username. I'm not familar with exiscan so can't really help there.
>
>Michael
>
