User Tools

Site Tools


reference:logdb_messages

Differences

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

Link to this comparison view

reference:logdb_messages [2018/11/14 10:45] (current)
Line 1: Line 1:
 +======LogDB.Messages table======
 +The [[LogDB]].Messages table contains a record of all messages logged by VPOP3. A message is logged when a message is sent/​received/​etc.
 +
 +=====Columns=====
 +  * msgid -  this is a [[http://​www.postgresql.org/​docs/​9.0/​static/​datatype-numeric.html|bigint]] sequential value which identifies the message uniquely in the database
 +  * sessid - this is a bigint value linking this message to a [[logdb sessions|session]] (or 0 if it is not linked to a session)
 +  * subject - the subject of the message
 +  * fromaddr - the from address of the message
 +  * authsender - the authenticated sender (if any) of the message
 +  * size - the size of the message (in bytes)
 +  * datetime - this is the date/time when the message was processed (in UTC)
 +  * spam - boolean value indicating whether the message was marked as spam or not
 +  * triggeredrule - contains the name of a download/​SMTP rule which was triggered by this message (if any)
 +  * errorcode - this is text containing any error detail about the session (eg invalid password etc)
 +  * processtime - the time taken to process this message (in seconds)
 +
  
reference/logdb_messages.txt ยท Last modified: 2018/11/14 10:45 (external edit)