Postal: Held messages

Created on 20 Jun 2017  路  32Comments  路  Source: postalhq/postal

I think there is no sense to held messages for one month, the world can end in one month.
Is there any way to auto clean held messages?

picture elfeffe

Most helpful comment

If you have a lot of held outgoing messages, you can use the console to put them all back into your message queue and have them resend.

postal console

Server['org-name/server-name'].message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { |m| m.add_to_message_queue(:manual => true) }
picture adamcooke on 6 Jul 2017
👍3

All 32 comments

This is more user preference than a wide logic.

Some would argue it is better to have the message sent than not at all. We have broadband customers who decide to host their own mail server and due to fault/outage/power/whatever, their service could be broken and a repair could take time - I know for them, they'd not want to lose email.

iammattmartin picture iammattmartin on 20 Jun 2017

I understand.
But at least any interface (or setting) to handle it will be great.
We can't delete held messages.

elfeffe picture elfeffe on 20 Jun 2017

Yes, the problem is that we have more than 500 held messages :)

elfeffe picture elfeffe on 22 Jun 2017

Issue I've about 100K emails stuck with status "held". So the main thing is how can I delete all emails or force all to deliver?

ravimantri picture ravimantri on 6 Jul 2017

If you have a lot of held outgoing messages, you can use the console to put them all back into your message queue and have them resend.

postal console

Server['org-name/server-name'].message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { |m| m.add_to_message_queue(:manual => true) }
adamcooke picture adamcooke on 6 Jul 2017
👍3

I've added two issues to assist with these issues. #257 and #256

adamcooke picture adamcooke on 6 Jul 2017
👍1

@catphish @adamcooke, It' very urgent! How can I delete the held list (100K) all at once?

Looking for your help. Thanks

ravimantri picture ravimantri on 13 Jul 2017

rb(main):001:0> Server['org-name/server-name'].message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { |m| m.add_to_message_queue(:manual => true) } NoMethodError: undefined method `message_db' for nil:NilClass from (irb):1 from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/console.rb:65:in `start' from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/console_helper.rb:9:in `start' from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/commands_tasks.rb:78:in `console' from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/commands_tasks.rb:49:in `run_command!' from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands.rb:18:in `<top (required)>' from bin/rails:4:in `require' from bin/rails:4:in `<main>' irb(main):002:0>
Getting this error what am I doing wrong?

vady112 picture vady112 on 19 Jul 2017

You've entered the server name and/or organization name incorrectly.

adamcooke picture adamcooke on 19 Jul 2017

Thank you for reply. From where will I get server name?

vady1 picture vady1 on 24 Jul 2017

Dear @adamcooke by running "Server['org-name/server-name'].message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { |m| m.add_to_message_queue(:manual => true) }". Ihad changed the Server Name.

I get "NoMethodError: undefined method `message_db' for nil:NilClass"

What to do? My all emails are stuck in held, nothing processing.

Thanks

ravimantri picture ravimantri on 27 Jul 2017

You've entered the server name and/or organization name incorrectly.

adamcooke picture adamcooke on 27 Jul 2017

Thanks for your prompt reply. I actually used:

Server['gupta-publications/smtp-1'].message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { |m| m.add_to_message_queue(:manual => true) }

ravimantri picture ravimantri on 27 Jul 2017

You can get the correct org & server names from the URL in the web interface. I'd suggest that gupta-publications/smtp-1 is wrong.

adamcooke picture adamcooke on 27 Jul 2017

This is the Postal Interface I access: https://postal.domain.com/org/gupta-publications/servers/smtp-1

What to do?

ravimantri picture ravimantri on 27 Jul 2017

You can try to get the server

server = Organization.find_by_permalink('org-name').servers.find_by_permalink('smtp-1')
server.message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { \|m\| m.add_to_message_queue(:manual => true) }
adamcooke picture adamcooke on 27 Jul 2017

irb(main):004:0> server = Organization.find_by_permalink('gupta-publications').servers.find_by_permalink('smtp-1')
=> #

irb(main):005:0> server.message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { \|m\| m.add_to_message_queue(:manual => true) }
SyntaxError: (irb):5: syntax error, unexpected $undefined
...:scope => 'outgoing'}).each { \|m\| m.add_to_message_queue(:...
... ^
from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/console.rb:65:in start' from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/console_helper.rb:9:instart'
from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/commands_tasks.rb:78:in console' from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/commands_tasks.rb:49:inrun_command!'
from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands.rb:18:in <top (required)>' from bin/rails:4:inrequire'
from bin/rails:4:in `

'

ravimantri picture ravimantri on 27 Jul 2017

@adamcooke, anymore suggestions? Thanks

ravimantri picture ravimantri on 27 Jul 2017

It worked for me, thanks!

chocochrispi picture chocochrispi on 10 Oct 2017

Any option to delete the held queue by console? I see here only options to re-add them to the queue.

Thanks!

influenist picture influenist on 19 Jan 2018

Doesn't work for me neither.!

NoMethodError: undefined method `servers' for nil:NilClass
        from (irb):1
        from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/console.rb:65:in `start'
        from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/console_helper.rb:9:in `start'
        from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/commands_tasks.rb:78:in `console'
        from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/commands_tasks.rb:49:in `run_command!'
        from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands.rb:18:in `<top (required)>'
        from bin/rails:4:in `require'
        from bin/rails:4:in `<main>'

No matter what I try!

PureMSP picture PureMSP on 28 Mar 2018

You're getting the organization name wrong if you're getting that error.

adamcooke picture adamcooke on 28 Mar 2018

what if I want to cancel them all @adamcooke ? can you post the query for that too?

hadifarnoud picture hadifarnoud on 20 Jun 2018

Can we do the same for Hard Failed and bounced emails?
Got a few thousand that hard failed as our IP got blocked for a few days.

Humblr picture Humblr on 16 Dec 2018

@adamcooke can you shed some light on how to delete the held messages using the console please? Thanks!

njolin picture njolin on 16 Apr 2019

If you have a lot of held outgoing messages, you can use the console to put them all back into your message queue and have them resend.

postal console

Server['org-name/server-name'].message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { |m| m.add_to_message_queue(:manual => true) }

Hello @adamcooke
please how do i get message_db ?

lovelyns picture lovelyns on 22 May 2019

If you have a lot of held outgoing messages, you can use the console to put them all back into your message queue and have them resend.

postal console

Server['org-name/server-name'].message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { |m| m.add_to_message_queue(:manual => true) }

Hello @adamcooke
please how do i get message_db ?

I am getting the below error @adamcooke please help
NoMethodError: undefined method `message_db' for nil:NilClass

lovelyns picture lovelyns on 22 May 2019

This is answered above

You've entered the server name and/or organization name incorrectly.

willpower232 picture willpower232 on 22 May 2019

Thanks @willpower232

Am I still on track?

I got the below result;

=> #
irb(main):002:0> server.message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { \|m\| m.add_to_message_queue(:manual => true) }

lovelyns picture lovelyns on 22 May 2019

It worked for me, thanks!

Hi @chocochrispi
Could you please guide me on how you were able to get this done if my org name is matter and my server name is mail-server-10 ?

lovelyns picture lovelyns on 23 May 2019

It worked for me, thanks!

Hi @chocochrispi
Could you please guide me on how you were able to get this done if my org name is matter and my server name is mail-server-10 ?

server = Organization.find_by_permalink('matter').servers.find_by_permalink('mail-server-10')
server.message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { |m| m.add_to_message_queue(:manual => true) }

chocochrispi picture chocochrispi on 23 May 2019
👍1

It worked for me, thanks!

Hi @chocochrispi
Could you please guide me on how you were able to get this done if my org name is matter and my server name is mail-server-10 ?

server = Organization.find_by_permalink('matter').servers.find_by_permalink('mail-server-10')
server.message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { |m| m.add_to_message_queue(:manual => true) }

Thanks a million @chocochrispi it works

lovelyns picture lovelyns on 23 May 2019
Was this page helpful?
0 / 5 - 0 ratings

Related issues

broskees picture broskees  路  4Comments
destroyer998 picture destroyer998  路  5Comments
ajsb85 picture ajsb85  路  4Comments
stayallive picture stayallive  路  5Comments
harshweo picture harshweo  路  6Comments