http://bugzilla.spamassassin.org/show_bug.cgi?id=1908
------- Additional Comments From [EMAIL PROTECTED] 2004-03-03 11:48 ------- Subject: Re: ConfSourceSQL: Postgres @GLOBAL overrides user prefs [EMAIL PROTECTED] wrote: >http://bugzilla.spamassassin.org/show_bug.cgi?id=1908 > > > > > >------- Additional Comments From [EMAIL PROTECTED] 2004-03-03 10:20 ------- >Perhaps I am totally missing something here, but in my version of Postgres >(7.4.1) this doesn't appear to be a problem. The @GLOBAL is sorted before the >user prefs no matter the username. > >What version of Postgres are you running? Possibly it's not doing the order by >correctly? > >Here are my results from a simple query: >select username, preference, value from userpref where username = '[EMAIL >PROTECTED]' or >username = 'GLOBAL' or username = '@GLOBAL' order by username asc; > username | preference | value >-----------+----------------+----------- > @GLOBAL | whitelist_from | [EMAIL PROTECTED] > [EMAIL PROTECTED] | whitelist_from | fong >(2 rows) > > > > >------- You are receiving this mail because: ------- >You reported the bug, or are watching the reporter. > > My results: select username, preference, value from userpref where username = 'danh' or username = 'znuff' or username = 'GLOBAL' or username = '@GLOBAL' order by username asc Results in the following set: username | preference | value ----------+------------------+-------------------------------------------- danh | subject_tag | !!!SPAM!!! danh | rewrite_subject | 1 danh | whitelist_from | symantec.com danh | auto_learn | 1 danh | bayes_path | /home/danh/.spamassassin/bayes danh | whitelist_from | [EMAIL PROTECTED] danh | whitelist_from | [EMAIL PROTECTED] danh | whitelist_from | spamcop.net danh | report_safe | 1 danh | use_bayes | 1 @GLOBAL | skip_rbl_checks | 1 @GLOBAL | required_hits | 6.0 @GLOBAL | subject_tag | [Possible SPAM] @GLOBAL | rewrite_subject | 0 @GLOBAL | spam_level_stars | 1 @GLOBAL | use_terse_report | 1 @GLOBAL | auto_learn | 0 @GLOBAL | bayes_path | /etc/mail/spamassassin/.spamassassin/bayes @GLOBAL | use_bayes | 1 znuff | required_hits | 1.0 znuff | rewrite_subject | 1 znuff | report_header | 0 znuff | defang_mime | 0 Version: postmaster (PostgreSQL) 7.3.4 Anyone with a username before the G's will have their prefs overwritten by the global settings. For example, I have autolearn enabled, but the global settings will override my autolearn settings. Also my bayes path will be incorrect. My patch causes the global prefs to be set first, then forces the local prefs to override. The cost is an extra SQL lookup. Thanks for looking at it. Dan ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee.
