This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
how_to:remove_messages_from_the_outbound_queue [2010/08/17 08:07] – paul | how_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 |
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 ' | 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 ' | ||
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/ | 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/ | ||
+ | |||
+ | =====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 ' | ||
+ | |||
+ | If you know the IP address of the original sender of the messages, type: | ||
+ | |||
+ | DELETE FROM outmessages WHERE senderip='< | ||
+ | |||
+ | and press **Do Query** | ||
+ | |||
+ | If you know the authenticated sender of the messages, type: | ||
+ | |||
+ | DELETE FROM outmessages WHERE authsender='< | ||
+ | |||
+ | 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> | {{tag> | ||