Also Michael - how would one write a custom rule in the database? For example, if I have this in a .cf file:
header MY_STOCK Subject =~ /[sS]t[0]ck/i score MY_STOCK 5.0 In which I create a new rule called MY_STOCK, how would I put that into the userpref table? Username of @GLOBAL, preference of header MY_STOCK and value of Subject =~ /[sS]t[0]ck/i doesn't seem to work. -- Matthew Yette Senior Engineer - NOC/Operations MA Polce Consulting, Inc. [EMAIL PROTECTED] 315-838-1644 (w) 315-356-0597 (f) AIM/Yahoo: MAPolceNOC MSN: [EMAIL PROTECTED] -----Original Message----- From: Michael Parker [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 12:28 PM To: Matthew Yette Cc: users@spamassassin.apache.org Subject: Re: shared SQL DB Matthew Yette wrote: >Hey Michael - > >In the presentation you provided, I have a question re: the AWL and the >lastupdate table column. First off - it won't allow me to create the >column w/o a default value (since it's not null). All 0's are fine - >but when I tested it, each row inserted had that default value in it, >instead of the true timestamp. Is there something I have to modify to >get it to insert/update the current time into that row? > > > You used the timestamp column type? You shouldn't need a default value with the timestamp type. What version of MySQL? What does your create table statement look like? Michael