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/ | ||
+ | |||
+ | =====Columns===== | ||
+ | * msgid - this is a [[http:// | ||
+ | * 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/ | ||
+ | * 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) | ||
+ | |||