Hi Im trying to use SQL user preferences and SQL awl.
I want my users to be able to choose whether they use awl, so in my test setup have created a user and entered use_auto_whitelist 0 in the userprefs table. It seems to skip it, mentioning administrator setting, can you not set this on a per user basis? Out put from spamd below. Thanks Paul debug: Conf::SQL: executing SQL: select preference, value from userpref where username = 'test' or username = '@GLOBAL' order by username asc debug: retrieving prefs for test from SQL server debug: config: not parsing, administrator setting: use_auto_whitelist 0 debug: config: SpamAssassin failed to parse line, skipping: use_auto_whitelist 0 debug: SQL Based AWL: Connected to DBI:mysql:sqltest:localhost debug: auto-whitelist (sql-based) get_addr_entry: Found existing entry for [EMAIL PROTECTED]|ip=x.x debug: auto-whitelist (sql-based): [EMAIL PROTECTED]|ip=x.x scores 2/5.877 debug: AWL active, pre-score: 1.376, autolearn score: 1.376, mean: 2.9385, IP: x.x.x.x debug: auto-whitelist (sql-based) add_score: New count: 3, new totscore: 7.253 for [EMAIL PROTECTED]|ip=x.x debug: auto-whitelist (sql-based) finish: Disconnected from DBI:mysql:sqltest:localhost debug: Post AWL score: 2.15725 This message has been scanned for unacceptable content by 'VITANIUM' the industry leading email virus and content management service from Vitanium Systems. Contact details are available at www.vitanium.com.
