User Tools

Site Tools


reference:list_failed_message_send_summary

This is an old revision of the document!


Database query to list failed message sends

This will list failed outgoing messages from the last 3 days (with the default VPOP3 settings)

At a command prompt in the VPOP3 directory run

psql

(The password is 'vpop3pass')

Then, type

select created,returnpath,subject,username || '@' || domain as recipient, latesterror 
from outqueue.outrecipients inner join outqueue.outmessages using(msgid) where
failedtime is not null order by created desc;

N.B. VPOP3 does not need to be stopped while you do this

reference/list_failed_message_send_summary.1467804504.txt.gz · Last modified: 2018/11/14 10:44 (external edit)