Coldfusion 9, How do you Empty an "Undelivered Mail Queue"

Question

I have roughly 9,000 undelivered messages in my mail spool in Coldfusion 9. As far as I can tell the only way to manage these messages is to manipulate them 10 at a time through the CF Admin GUI.

I'm looking for a way to expedite this process. I'd like to just clear the queue, or batch send them all.

Does anyone know how to do this?

Thank you,

-Dave

score 12 · Answer 1 · answered Jul 22 '11 at 16:09

12

Go into the filesystem and move the files from cfusion/mail/undelivr to cfusion/mail/spool. Simple!

answered Jul 22 '11 at 16:09

scrittler

1,121
6
8

I routinely use this method but I always first look to see how old some of the emails are. If I have some that I decide are just too old to get re-spooled then I simply delete those and the rest I move to the spool. I simply sort the directory off the file dates to determine the age. – Snipe656 Mar 25 '13 at 15:05

score 3 · Answer 2 · answered Jul 23 '11 at 04:19

3

Take a look at Ray Camden's SpoolMail (http://spoolmail.riaforge.org/). This is a very handy plug-in that you can add to all your servers and at bulk move your emails to spool and resend them.

answered Jul 23 '11 at 04:19

Andreas Schuldhaus

2,618
2
19
22

score 0 · Answer 3 · answered Mar 24 '13 at 13:41

If you moved your mail server and the spool doesn't seem to ever empty out, you need to open up each .cfmail file and change the IP number. I moved my mail server as well, and when I brought it back up I had forgotten to change the IP setting for mail in CF Admin, and wound up with 21,000 emails in my spool by the next day. Ugh. I could have run a cf script on it to open up each one, change the IP number, and then move the file into the spool dir, but opted instead of downloading a free search and replace utility from download dot com. Worked like a charm. It took about twenty minutes to do the full s&r and then a few seconds to move them all over.

score 0 · Answer 4 · answered Nov 02 '18 at 14:36

The file system is the simplest way.

To attempt to resend the emails, move the files in ~\ColdFusion2016\cfusion\Mail\Undelivr to ~\ColdFusion2016\cfusion\Mail\Spool.

If you just don't care about those email files then simply delete them.

I point my development mail server to point to nowhere (smtp.gmail.com.dontSend) so no mail goes out and they all just stack up in undelivered. That way the rest of my development team does not get all the errors I generate and catch through email. More importantly, no test emails accidentally go out to real accounts.

I go into the CF-Administrator to look at and manage my undelivered mail when testing but if/when it gets huge I just delete them from the file system.

score 0 · Answer 5 · answered Jul 22 '11 at 16:24

Someone sent me a snippet at some point that would try to reprocess the queue periodically at some point, but for the life of me, I can;t find it or see it on google. - sorry.

HOWEVER: the undeliverable queue is just a bunch of files, you can write yourself a little application that will try to reprocess the queue periodically and prune out the ones that have been in the undeliverable too long.

I am pretty sure that the spool only tries to deliver mail once
just move the files back into the spool directory to have the spooler "retry"
you would have to keep a file or DB to track what has been tried & how many times.
I would also send a notification on what has been deleted - or at least log it.

-sean

PS> 9000? what is your traffic like? I would suspect there is a problem if you have that many undeliverables....

I have a ton of traffic. Several thousand messages a day. We just moved the mail server though, and the inter server routing had some issues and backed us up. — Dave Ostrander, Jul 28 '11 at 17:48

score 0 · Answer 6 · answered Jul 25 '11 at 01:53

0

You should write simple CF program for tracking and deleting for undelivered mails.

Use cfdirectory tag.

answered Jul 25 '11 at 01:53

PPShein

13,309
42
142
227

Coldfusion 9, How do you Empty an "Undelivered Mail Queue"

6 Answers6