User Tools

Site Tools


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

Differences

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


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