http://bugzilla.spamassassin.org/show_bug.cgi?id=3415
Summary: BayesStoreSQL quoting issues with PostgreSQL
Product: Spamassassin
Version: SVN Trunk (Latest Devel Version)
Platform: Other
OS/Version: other
Status: NEW
Severity: major
Priority: P5
Component: Learner
AssignedTo: [EMAIL PROTECTED]
ReportedBy: [EMAIL PROTECTED]
using the fixed SQL-schema from bug #3414, SQL-bayes is now partly working here,
but there seems to be still some major problems with Inputquoting/Inputescaping.
this is a (shortend) example of a sa-learn debug-run:
debug: Learning Spam
debug: received-header: parsed as [ ip=128.138.207.242
rdns=openbsd.cs.colorado.edu helo=openbsd.cs.colorado.edu by=cronos.madness.at
ident= envfrom= intl=0 id=1Aqqgg-000GHx-3H ]
debug: received-header: parsed as [ ip=127.0.0.1 rdns=localhost.cs.colorado.edu
helo=openbsd.org by=openbsd.cs.colorado.edu ident= envfrom= intl=0
id=i1B9S029002943 ]
debug: received-header: parsed as [ ip=220.81.241.132 rdns=tech helo=tech
by=openbsd.cs.colorado.edu ident= envfrom= intl=0 id=i1B9Phtf025285 ]
debug: is DNS available? 0
debug: received-header: cannot use DNS, do not trust any hosts from here on
debug: received-header: relay 128.138.207.242 trusted? no internal? no
debug: received-header: relay 127.0.0.1 trusted? no internal? no
debug: received-header: relay 220.81.241.132 trusted? no internal? no
debug: metadata: X-Spam-Relays-Trusted:
debug: metadata: X-Spam-Relays-Untrusted: [ ip=128.138.207.242
rdns=openbsd.cs.colorado.edu helo=openbsd.cs.colorado.edu by=cronos.madness.at
ident= envfrom= intl=0 id=1Aqqgg-000GHx-3H ] [ ip=127.0.0.1
rdns=localhost.cs.colorado.edu helo=openbsd.org by=openbsd.cs.colorado.edu
ident= envfrom= intl=0 id=i1B9S029002943 ] [ ip=220.81.241.132 rdns=tech
helo=tech by=openbsd.cs.colorado.edu ident= envfrom= intl=0 id=i1B9Phtf025285 ]
debug: ---- MIME PARSER START ----
debug: main message type: text/plain
debug: parsing normal part
debug: added part, type: text/plain
debug: ---- MIME PARSER END ----
debug: decoding: other encoding type (8bit), ignoring
debug: tokenize: header tokens for *rp = "U*owner-tech+M5649 D*openbsd.org
D*org"
debug: tokenize: header tokens for Envelope-to = "[EMAIL PROTECTED]"
debug: tokenize: header tokens for Delivery-date = "Wed, 11 Feb 2004 10:29:53
+0100"
debug: tokenize: header tokens for *M = " zgklkqlusm 5575222ddsbxu Toddaejxmqzg
"
debug: tokenize: header tokens for *F = "U*bobbysmartness D*asiamail.com D*com"
debug: tokenize: header tokens for To = "U*tech D*openbsd.org D*org"
debug: tokenize: header tokens for MIME-Version = ""
debug: tokenize: header tokens for Content-Transfer-Encoding = "8bit"
debug: tokenize: header tokens for *c = "/plain; charset="us-ascii""
debug: tokenize: header tokens for Precedence = "list"
debug: tokenize: header tokens for *RT = ""
debug: tokenize: header tokens for *RU = "[ ip=128.138.207.242
rdns=openbsd.cs.colorado.edu helo=openbsd.cs.colorado.edu by=cronos.madness.at
ident= envfrom= intl=0 id=1Aqqgg-000GHx-3H ] [ ip=127.0.0.1
rdns=localhost.cs.colorado.edu helo=openbsd.org by=openbsd.cs.colorado.edu
ident= envfrom= intl=0 id=i1B9S029002943 ] [ ip=220.81.241.132 rdns=tech
helo=tech by=openbsd.cs.colorado.edu ident= envfrom= intl=0 id=i1B9Phtf025285 ]"
debug: tokenize: header tokens for *r = " tech ([220.81.241 ip*220.81.241.132
]) by openbsd.cs.colorado.edu (8.12.10/8.12.10) <[EMAIL PROTECTED]>; "
debug: tokenize: header tokens for *r = " tech ([220.81.241 ip*220.81.241.132
]) by openbsd.cs.colorado.edu (8.12.10/8.12.10) <[EMAIL PROTECTED]>;
openbsd.org (localhost.cs.colorado.edu [127.0.0 ip*127.0.0.1 ]) by
openbsd.cs.colorado.edu (8.12.10/8.12.10) ; "
debug: bayes: tok_get: SQL Error: ERROR: unterminated quoted string at or near
"'�1�" at character 126
debug: bayes: _put_token: SQL Error: ERROR: unterminated quoted string at or
near "'�1�" at character 109
debug: bayes: tok_get: SQL Error: ERROR: unterminated quoted string at or near
"'�b" at character 126
debug: bayes: _put_token: SQL Error: ERROR: unterminated quoted string at or
near "'�b" at character 109
debug: bayes: seen ([EMAIL PROTECTED]) put
debug: bayes: Learned '[EMAIL PROTECTED]',
atime: 1076491782
Learned from 1 message(s) (1 message(s) examined).
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
