> -----Original Message----- > From: spamassassinuser19 [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 19, 2006 08:14 > To: users@spamassassin.apache.org > Subject: RE: SA 3.1.1 and sql user prefs > > > Thank you for the link to the article.It was very helpful. I > think i understand what is going on. It is only putting > username in the database without the [EMAIL PROTECTED] I am > using squirellmail saspam plugin to let users adjust their > own settings. They just login with username into squirellmail > and not the @domain. Is there anyway to get spamassassin sql > to just look for the username? > > Thanks again for your assistance!!!
if squirell is storing just the user name, then you will want to use __MAILBOX__ instead of __USERNAME__ in the sql_custom_query WHERE username = __MAILBOX__ or you could do WHERE username = __MAILBOX__ or username = __USERNAME__ just to be allow for both. d