[Bug 225248] New: Problem in SpamAssassin
https://bugzilla.novell.com/show_bug.cgi?id=225248 Summary: Problem in SpamAssassin Product: SUSE Linux 10.1 Version: Final Platform: i586 OS/Version: SuSE Linux 10.1 Status: NEW Severity: Major Priority: P5 - None Component: Security AssignedTo: security-team@suse.de ReportedBy: charles@integrasul.inf.br QAContact: qa@suse.de The spamassassin have got problem, spamassassin configuration for use postgresql do execution select in table userpref with username up fxxxxx the result wrong. Exemple: Select * from userpref where username='charles' or username='@GLOBAL' order by username asc; 24 charles blacklist_to *@zzz.com 45 @GLOBAL blacklist_to *@xxx.com this is wrong. Select * from userpref where username='marcus' or username='@GLOBAL' order by username asc; 45 @GLOBAL blacklist_to *@xxx.com 32 marcus blacklist_to *@eee.com this is correct. If select with username hxxx or ixxx or other the result ok. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug, or are watching someone who is.
https://bugzilla.novell.com/show_bug.cgi?id=225248 lnussel@novell.com changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|security-team@suse.de |varkoly@novell.com ------- Comment #1 from lnussel@novell.com 2006-12-01 06:06 MST ------- It's all Greek to me. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug, or are watching someone who is.
https://bugzilla.novell.com/show_bug.cgi?id=225248 varkoly@novell.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED ------- Comment #2 from varkoly@novell.com 2006-12-08 05:37 MST ------- 1. Postfix sorts the names withouth '@' and case in sensitiv. I think we can not change it. 2. The name '@GLOBAL' is not good for this reason. 0GLOBAL may be better 3. The name '@GLOBAL' is not used consequently: In SQLBasedAddrList.pm only GLOBAL will be used. I'll ask the developer of spamassassin what to do. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug, or are watching someone who is.
https://bugzilla.novell.com/show_bug.cgi?id=225248 varkoly@novell.com changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|Major |Normal -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug, or are watching someone who is.
https://bugzilla.novell.com/show_bug.cgi?id=225248 ------- Comment #3 from varkoly@novell.com 2006-12-22 02:27 MST ------- I mean postgres not postfix :-) -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug, or are watching someone who is.
https://bugzilla.novell.com/show_bug.cgi?id=225248 ------- Comment #4 from charles@integrasul.inf.br 2006-12-22 05:58 MST ------- for resolver it: Alter the archive: /usr/lib/perl5/vendor_perl/5.8.7/Mail/SpamAssassin/Conf/SQL.pm lines 142 to 144 $sql = "select $f_preference, $f_value from $f_table where ". "$f_username = ".$dbh->quote($username). " or $f_username = '\@GLOBAL' order by $f_username asc"; alter for: $sql = "select $f_preference, $f_value, ascii(username) as user_asci from $f_table where ". "$f_username = ".$dbh->quote($username). " or $f_username = '\@GLOBAL' order by user_asci asc"; -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug, or are watching someone who is.
https://bugzilla.novell.com/show_bug.cgi?id=225248 varkoly@novell.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution| |WORKSFORME ------- Comment #5 from varkoly@novell.com 2007-01-18 15:47 MST ------- Thank you, I'll fix it for stable. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug, or are watching someone who is.
https://bugzilla.novell.com/show_bug.cgi?id=225248 varkoly@novell.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED Resolution| |FIXED ------- Comment #9 from varkoly@novell.com 2007-02-23 02:27 MST ------- Fixed in stable -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug, or are watching someone who is.
participants (1)
-
bugzilla_noreply@novell.com