User Tools

Site Tools


reference:find_message

Differences

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

Link to this comparison view

reference:find_message [2018/11/14 10:45] (current)
Line 1: Line 1:
 +======Find a message======
  
 +If you know the subject of a message, you can search the entire message store for messages with this subject.
 +
 +Go to Settings → Database → Query
 +
 +Alternatively,​ at a command prompt in the VPOP3 directory run
 +
 +  psql
 +(The password is '​vpop3pass'​)
 +
 +Then, type
 +
 +<​code>​
 +SELECT messagetime,​ internaltime,​ subject, fromaddr, fromname, tolist, attachments,​ spam, size, username, folder FROM allmessages INNER JOIN foldermessages fm USING (msgid) INNER JOIN folders f ON f.folderid=fm.folderid INNER JOIN users.users ON userid=usernumber WHERE subject ilike '​%<​subject to search for>​%';​
 +</​code>​
 +
 +Replace <subject to search for> with the text to search for in the subject. Note that this only works if the message subject was in ASCII. If it contains non-ASCII characters or is encoded using BASE64 or Quoted-Printable encoding, then it may not find those messages.
 +
 +N.B. VPOP3 does not need to be stopped while you do this
reference/find_message.txt · Last modified: 2018/11/14 10:45 (external edit)