On Thursday 26 July 2007 20:15:00 LedHed wrote:
> Marcin M. Jessa wrote:
> > Hi guys.
> >
> > What arguments are accepted by the dspam_preferences SQL table?
> > I tried to set the spamSubject option for a user but I still got the
> > standard spam tag set in dspam.conf:
> >
> > mysql> insert into dspam_preferences values("134","spamSubject","SPAM");
> > Query OK, 1 row affected (0.01 sec)
> >
> > mysql> select * from dspam_preferences;
> > +-----+-------------+-------+
> >
> > | uid | preference | value |
> >
> > +-----+-------------+-------+
> >
> > | 134 | spamSubject | SPAM |
> >
> > +-----+-------------+-------+
> >
> > The same thing worked with dspam_admin just fine:
> > dspam_admin add preference [EMAIL PROTECTED] spamSubject SPAM
> >
> > I couldn't find any docs about this table. Would dspam.conf override
> > what's in the SQL?
> >
> >
> > Marcin.
>
> The preferences set in MySQL should take precedence over settings in the
> dspam.conf.
>
> What you have should work, but you will also need a few other
> preferences set for that user/uid (Assuming they haven't already been set).
>
>
> Most importantly:
>
> "spamAction"
> +-----+-------------+-------+
>
> | uid | preference | value |
>
> +-----+-------------+-------+
>
> | 134 | spamAction | tag |
>
> +-----+-------------+-------+
>
> and
>
> "optIn"
> +-----+-------------+-------+
>
> | uid | preference | value |
>
> +-----+-------------+-------+
>
> | 134 | optIn | on |
>
> +-----+-------------+-------+
>
>
> -Jeff Harris
That didn't work either.
mysql> select * from dspam_preferences;
+-----+-------------+-------+
| uid | preference | value |
+-----+-------------+-------+
| 134 | spamSubject | SPAM |
| 134 | spamAction | tag |
| 134 | optIn | on |
+-----+-------------+-------+
Emails get tagged as ***SPAM*** which is what is defined in dspam.conf
Marcin.
