User Tools

Site Tools


reference:list_failed_message_send_summary
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_failed_message_send_summary [2018/11/14 10:45] (current) – external edit 127.0.0.1
Line 1: Line 1:
 +======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.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1