User Tools

Site Tools


reference:logdb_messages
no way to compare when less than two revisions

Differences

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


Previous revision
reference:logdb_messages [2018/11/14 10:45] (current) – external edit 127.0.0.1
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 by 127.0.0.1