User Tools

Site Tools


reference:list_messages_in_lan_forwrding_queue_waiting_to_go_to_a_specific_server

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)