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