Differences

This shows you the differences between two versions of the page.

--- reference:logdb_spamrules [2011/08/31 10:19] – created paul
+++ reference:logdb_spamrules [2018/11/14 10:45] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-======LogDB.Recipients table======
+======LogDB.SpamRules table======
-The [[LogDB]].Recipients table contains a record of the recipients for messages logged by VPOP3. A message may have one or more recipients
+The [[LogDB]].SpamRules table contains a record of the spamfilter rules which matched for messages logged by VPOP3. A message may have zero or more spamrules entries
 =====Columns=====
-  * rcptid -  this is a [[http://www.postgresql.org/docs/9.0/static/datatype-numeric.html|bigint]] sequential value which identifies the recipient uniquely in the database
+  * spamruleid -  this is a [[http://www.postgresql.org/docs/9.0/static/datatype-numeric.html|bigint]] sequential value which identifies the spam rule entry uniquely in the database
   * msgid - this is a bigint value linking this message to a [[logdb messages|message]]
-  * name - the recipient email address
+  * name - the spam rule name
-  * rcpttype - the type of recipient (see below)
+  * testpattern - the spam rule test pattern which matched (if any)
-  * result - text containing the result of this recipient (eg when sending the message)
+  * testmatch - the message content which matched the pattern (if any)
+  * score - the spam filter score assigned by the spam rule match
-Note that recipients are NOT 'normalised'. If you send two messages to the same recipient, there will be two entries in the 'recipients' table, not just one.
-====RcptType values====
-  * F = LAN forwarded (on incoming messages)
-  * I = invalid (on incoming messages)
-  * N = normal (on incoming messages)
-  * R = remote (on incoming messages)
-  * S = being sent (on outgoing messages)

PSCS Wiki

User Tools

Site Tools

Differences

Page Tools