I'm currently using SA 2.55 with qmail-1.03+vpopmail+qmail-scanner.  I don't
have a problem with SA running per se.  I'm using mySQL to store my
preferences, using HORDE's SAM module to modify it.

Here's my actual problem: users can't seem to override the @GLOBAL defaults set
in the table.

Here are my GLOBAL defaults set into my table:

mysql> select * from userpref where horde_id='@GLOBAL';
+--------+----------+----------+------------------+--------+
| prefid | horde_id | username | preference       | value  |
+--------+----------+----------+------------------+--------+
|    119 | @GLOBAL  | @GLOBAL  | skip_rbl_checks  | 1      |
|    118 | @GLOBAL  | @GLOBAL  | defang_mime      | 0      |
|    117 | @GLOBAL  | @GLOBAL  | use_terse_report | 0      |
|    116 | @GLOBAL  | @GLOBAL  | report_header    | 0      |
|    115 | @GLOBAL  | @GLOBAL  | spam_level_stars | 1      |
|    114 | @GLOBAL  | @GLOBAL  | rewrite_subject  | 1      |
|    113 | @GLOBAL  | @GLOBAL  | subject_tag      | [SPAM] |
|    112 | @GLOBAL  | @GLOBAL  | required_hits    | 20.0   |
+--------+----------+----------+------------------+--------+

Now, if I view my specific preferences for the account [EMAIL PROTECTED] (virtual
account hosted on the same computer), this is what is saved in the table:

mysql> select * from userpref where horde_id='[EMAIL PROTECTED]';
+--------+-----------------+-----------------+------------------+--------+
| prefid | horde_id        | username        | preference       | value  |
+--------+-----------------+-----------------+------------------+--------+
|    111 | [EMAIL PROTECTED] | [EMAIL PROTECTED] | skip_rbl_checks  | 1      |
|    110 | [EMAIL PROTECTED] | [EMAIL PROTECTED] | defang_mime      | 0      |
|    109 | [EMAIL PROTECTED] | [EMAIL PROTECTED] | subject_tag      |        |
|    108 | [EMAIL PROTECTED] | [EMAIL PROTECTED] | use_terse_report | 0      |
|    107 | [EMAIL PROTECTED] | [EMAIL PROTECTED] | report_header    | 0      |
|    106 | [EMAIL PROTECTED] | [EMAIL PROTECTED] | spam_level_stars | 0      |
|    104 | [EMAIL PROTECTED] | [EMAIL PROTECTED] | required_hits    | 1000.0 |
|    105 | [EMAIL PROTECTED] | [EMAIL PROTECTED] | rewrite_subject  | 0      |
+--------+-----------------+-----------------+------------------+--------+

Regardless of what a user sets (not just this particular user, but everyone I've
tested), the default always overrides it.  I've even tried removing the @GLOBAL
entires, but then the required_hits defaults back to 5.0.  I know it is reading
from the table properly because the required_hits value found in the headers
changes as I change the @GLOBAL required_hits value.

Is this a problem on my end or a problem with mysql implementation with SA 2.55?

Any suggestions on how to resolve this would be appreciated.

Thank you for your time.

-Patrick Lahni
 [EMAIL PROTECTED]

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/


-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
Spamassassin-talk mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/spamassassin-talk

Reply via email to