User Tools

Site Tools


how_to:remove_messages_from_the_outbound_queue

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
how_to:remove_messages_from_the_outbound_queue [2010/08/17 08:07] paulhow_to:remove_messages_from_the_outbound_queue [2014/01/03 09:05] – [Alternative method for version 5 or later] paul
Line 10: Line 10:
 Note that you cannot delete items from the VPOP3 OutQueue whilst VPOP3 is in the process of sending them, so you should stop VPOP3 from sending first. Note that you cannot delete items from the VPOP3 OutQueue whilst VPOP3 is in the process of sending them, so you should stop VPOP3 from sending first.
  
-=====Alternative method=====+=====Alternative method for version 4 or earlier=====
 If there are too many messages in the outqueue and you cannot delete them using the above method, you can delete //all the messages// them the 'backdoor way'. To do this, stop VPOP3, then delete all the Q*.DAT files in the VPOP3\Outqueue directory, then restart VPOP3. (Note that doing it this way, you can't be selective about which messages you delete). If there are too many messages in the outqueue and you cannot delete them using the above method, you can delete //all the messages// them the 'backdoor way'. To do this, stop VPOP3, then delete all the Q*.DAT files in the VPOP3\Outqueue directory, then restart VPOP3. (Note that doing it this way, you can't be selective about which messages you delete).
  
Line 16: Line 16:
  
 If the messages are in the outqueue due to a problem of some sort, it can be worth keeping some of the Q*.DAT files for diagnostic/forensic purposes. If the messages are in the outqueue due to a problem of some sort, it can be worth keeping some of the Q*.DAT files for diagnostic/forensic purposes.
 +
 +=====Alternative method for version 5 or later=====
 +If there are too many messages in the outqueue and you cannot delete them using the above method, you can delete messages by accessing the database directly.
 +
 +  -  Go to Settings -> Database -> Query
 +  - Choose 'Outqueue' from the 'Schema Name' box
 +
 +If you know the IP address of the original sender of the messages, type:
 +
 +  DELETE FROM outmessages WHERE senderip='<sender IP address>';
 +
 +and press **Do Query**
 +
 +If you know the authenticated sender of the messages, type:
 +
 +  DELETE FROM outmessages WHERE authsender='<sender user name>';
 +
 +and press **Do Query**
 +
 +Otherwise you will need to empty the outqueue totally, so type:
 +
 +  DELETE FROM outmessages;
 +
 +and press **Do Query**
 +
 +If you cannot start VPOP3, or get into the VPOP3 settings, then you can [[delete outqueue messages directly from the database]].
  
 {{tag>outqueue outbox sending delete remove}} {{tag>outqueue outbox sending delete remove}}
  
how_to/remove_messages_from_the_outbound_queue.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1