User Tools

Site Tools


reference:list_messages_in_lan_forwrding_queue_waiting_to_go_to_a_specific_server

Differences

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

Link to this comparison view

reference:list_messages_in_lan_forwrding_queue_waiting_to_go_to_a_specific_server [2018/11/14 10:45] (current)
Line 1: Line 1:
 +======Database query to list messages in the LAN forwarding queue waiting to go to a specific server======
  
 +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 let you list just messages going to a specific server.
 +
 +At a command prompt in the VPOP3 directory run
 +
 +  psql
 +  ​
 +(The password is '​vpop3pass'​)
 +
 +Then, type
 +
 +  SELECT sender,​subject,​r.username || '​@'​ || r.domain as recipient FROM messages.outgoing INNER JOIN messages.outgoingrecipients r USING(msgid) INNER JOIN messages.outgoingtargets USING(msgid) WHERE target='<​server>'​ ORDER BY msgid;
 +  ​
 +to list all the messages in the LAN forwarding queue going to the server "<​server>"​. <​server>​ should be the server name as specified in the LAN forwarding rules, including the target port number if applicable. Do not include the <>
 +
 +or use
 +
 +  SELECT count(*) FROM messages.outgoingtargets WHERE target='<​server>';​
 +  ​
 +to simply get a count of the number of messages in the queue for that server.
 +
 +
 +N.B. VPOP3 does not need to be stopped while you do this
reference/list_messages_in_lan_forwrding_queue_waiting_to_go_to_a_specific_server.txt ยท Last modified: 2018/11/14 10:45 (external edit)