[SAtalk] Save user rules in mysql?

2003-12-01 Thread Patrick T. Tsang
Hello, Spamc can read user preference from mysql. This is working fine. However, how can I store the user filtering rules / setting on mysql and let spamc to read it? I have tried insert some rules into mysql but failed. Any one can help? Patrick Tsang

[SAtalk] spamc (+mysql) user setting looking at local.cf !!

2003-12-01 Thread Patrick T. Tsang
Hello, sorry to say that this is not the first post of mine to show a bug in spamc with mysql support. Spamc with mysql support have to duplicate the same set of filtering rules/setting on .cf file from mysql before getting the user-based rules works. I have to conditionally restart spamassassinc

Re: [SAtalk] mysql spamc ignores the email in mailling list

2003-11-27 Thread Patrick T. Tsang
t;Rob Hutton" <[EMAIL PROTECTED]> To: "Ryan Moore" <[EMAIL PROTECTED]>; "Patrick T. Tsang" <[EMAIL PROTECTED]>; "spamassassin-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, November 25, 2003 11:40 PM Subject: RE: [SAtalk] mysql spamc ignores the em

Re: [SAtalk] mysql user rules (no local.cf definition)

2003-11-26 Thread Patrick T. Tsang
Message - From: "Adam Denenberg" <[EMAIL PROTECTED]> To: "Patrick T. Tsang" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, November 27, 2003 12:27 PM Subject: Re: [SAtalk] mysql user rules (no local.cf definition) > Yes i have "allow_us

[SAtalk] Drop spam into a cyrus mailbox?

2003-11-26 Thread Patrick T. Tsang
Hello, I would like to know if anyone have the experience to integrate Spamassassin with Cyrus-imapd. I want a spam mail can be dropped into a user's mailbox. It seems that only procmal with some peal script which handle cyrus-imapd can do this. Anyone has the suggestions? Best Regards Patrick T

Re: [SAtalk] mysql user rules (no local.cf definition)

2003-11-26 Thread Patrick T. Tsang
ginal Message - From: "Adam Denenberg" <[EMAIL PROTECTED]> To: "Patrick T. Tsang" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, November 27, 2003 12:27 PM Subject: Re: [SAtalk] mysql user rules (no local.cf definition) > Yes i have &q

Re: [SAtalk] mysql user rules (no local.cf definition)

2003-11-26 Thread Patrick T. Tsang
Dear Adam, I am using Webuserprefs such that each user will use his/her rules but it cannot support Header and Body test. so I am very interested in your works. 1. How can I include the user-defined Header test in Mysql? 2. What about Body test? In the Mysql db schema, I can't see any enough f

[SAtalk] Postfix & Spamassassin - problem in mailling list?

2003-11-20 Thread Patrick T. Tsang
- Original Message - From: "Patrick T. Tsang" <[EMAIL PROTECTED]> To: "Jason McCormick" <[EMAIL PROTECTED]> Sent: Thursday, November 20, 2003 6:47 PM Subject: Re: Postfix & Spamassassin - problem in mailling list? > Dear Jason, > > Thanks f

[SAtalk] mysql spamc ignores the email in mailling list

2003-11-20 Thread Patrick T. Tsang
- Original Message - From: "Patrick T. Tsang" <[EMAIL PROTECTED]> To: "Matt Kettler" <[EMAIL PROTECTED]> Sent: Thursday, November 20, 2003 6:57 PM Subject: Re: [SAtalk] mysql spamc ignores the email in mailling list > At 06:09 PM 11/19/03 +0800, Pat

[SAtalk] mysql spamc ignores the email in mailling list

2003-11-20 Thread Patrick T. Tsang
Dear Ryan, Thanks for your help. Do u have any worked examples? Patrick - Original Message - From: "Ryan Moore" <[EMAIL PROTECTED]> To: "Patrick T. Tsang" <[EMAIL PROTECTED]>; "spamassassin-Talk" <[EMAIL PROTECTED]> Sent: Thursday

[SAtalk] mysql spamc ignores the email in mailling list

2003-11-19 Thread Patrick T. Tsang
Hello, I am trying to put all user-defined rules in Mysql. It is working fine until I find a problem. >From the maillog, I have checked that spamd has successfully filtered the mail at first. However, spamd only check email using the last email address found in the mailling list and check against

[SAtalk] spamc only handle ONE smtp session?

2003-11-17 Thread Patrick T. Tsang
Hello, I am trying to integrate the cyrus-imapd virtual user and their own user-defined filter. spamc can now specify the rule by a specified user with "-u" ie. spamc -u [EMAIL PROTECTED] eg. /etc/postfix/master.cf spamc -f -u $(recipient} -e ... The spamd is started with -x -q option to connecti

[SAtalk] spamc only handle ONE smtp session?

2003-11-17 Thread Patrick T. Tsang
Hello, I am trying to integrate the cyrus-imapd virtual user and their own user-defined filter. spamc can now specify the rule by a specified user with "-u" ie. spamc -u [EMAIL PROTECTED] eg. /etc/postfix/master.cf spamc -f -u $(recipient} -e ... The spamd is started with -x -q option to