User Tools

Site Tools


reference:logdb_spamrules

Differences

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

Link to this comparison view

Next revision
Previous revision
reference:logdb_spamrules [2011/08/31 09:19]
paul created
reference:logdb_spamrules [2018/11/14 10:45] (current)
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===== =====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]]   * 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)+
  
reference/logdb_spamrules.txt · Last modified: 2018/11/14 10:45 (external edit)