PSCS Wiki

User Tools

Site Tools

Trace: • How to start VPOP3 • Timeout problems downloading/uploading messages with attachments • POP3 Mail Collection • Incoming SMTP Feed • How to automatically forward spam to the PSCS spamtrap • Transmission Receipt Message • User Routing Script • VPOP3.GetMessageLines • SMTP Reputation Stats • Using VPOP3 Spam Filtering with LAN Forwarding
how_to:delete_outqueue_messages_directly_from_the_database

Differences

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

Link to this comparison view

Next revision		Previous revision
Next revisionBoth sides next revision
how_to:delete_outqueue_messages_directly_from_the_database [2014/01/03 09:23] – created paulhow_to:delete_outqueue_messages_directly_from_the_database [2014/01/03 09:31] – [To delete the messages] paul
Line 21: Line 21:
 The three most common causes of unwanted messages in the OutQueue are: The three most common causes of unwanted messages in the OutQueue are:
  
-  - open relay - you can tell this because the 'senderip' is an external IP address, and the 'authsender' is blank +  * open relay - you can tell this because the 'senderip' is an external IP address, and the 'authsender' is blank 
-  - 'hacked' account - you can tell this because the 'senderip' is an external IP address, and the 'authsender' is not blank - in this case someone has found or guessed the 'authsender's password +  * 'hacked' account - you can tell this because the 'senderip' is an external IP address, and the 'authsender' is not blank - in this case someone has found or guessed the 'authsender's password 
-  - virus/spambot on local PC - you can tell this because the 'senderip' is an internal IP address - check the computer with that IP address+  * virus/spambot on local PC - you can tell this because the 'senderip' is an internal IP address - check the computer with that IP address
  
 ====To delete the messages==== ====To delete the messages====
Line 38: Line 38:
 etc. etc.
  
-After deleting the messages, you may want to shrink the disk file, otherwise there will be a lot of wasted disk space. To do this, at the psql prompt, do:+After deleting the messages, you may want to shrink the disk file, otherwise there may be a lot of wasted disk space if you have deleted an extremely large number of messages. To do this, at the psql prompt, do:
  
 ''CLUSTER VERBOSE outqueue.outmessages;\\ ''CLUSTER VERBOSE outqueue.outmessages;\\
 CLUSTER VERBOSE outqueue.outrecipients;'' CLUSTER VERBOSE outqueue.outrecipients;''
  
how_to/delete_outqueue_messages_directly_from_the_database.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki