User Tools

Site Tools


reference:list_all_messages_in_lan_forwrding_queue

Differences

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

Link to this comparison view

reference:list_all_messages_in_lan_forwrding_queue [2018/11/14 10:45] (current)
Line 1: Line 1:
 +======Database query to list ALL messages in the LAN forwarding queue======
  
 +The VPOP3 settings show the first 100 messages in the LAN forwarding queue. Usually this is sufficient as the LAN forwarding queue is usually nearly empty, but in case of a problem it may be much bigger. The database queries below may help in that situation.
 +
 +At a command prompt in the VPOP3 directory run
 +
 +  psql
 +  ​
 +(The password is '​vpop3pass'​)
 +
 +Then, type
 +
 +  SELECT sender,​target,​subject,​r.username || '​@'​ || r.domain as recipient FROM messages.outgoing INNER JOIN messages.outgoingrecipients r USING(msgid) INNER JOIN messages.outgoingtargets USING(msgid) ORDER BY msgid;
 +  ​
 +to list all the messages in the LAN forwarding queue
 +
 +or use
 +
 +  SELECT count(*) FROM messages.outgoing;​
 +  ​
 +to simply get a count of the number of messages in the queue
 +
 +
 +N.B. VPOP3 does not need to be stopped while you do this
reference/list_all_messages_in_lan_forwrding_queue.txt ยท Last modified: 2018/11/14 10:45 (external edit)