Support

Admin Tools for WordPress

#34281 – Clear Queued Up Admin Tools Email

Posted in ‘Akeeba Admin Tools for WordPress’
This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Wednesday, 30 December 2020 09:23 CST
3by400Inc

We resolved a cron issue on one of our sites and now thousands of previously queued emails from Admin Tools are being delivered in batches of 100. How can we clear the queue of these old emails?

 
Wednesday, 30 December 2020 09:31 CST
tampe125

Hello,

emails are stored inside the database. If you look at the table wp_admintools_storage, you will find that there are several entries that starts with mail_ .

Simply delete them and you will clear any queued email.



Davide Tampellini

Developer and Support Staff



Italian: native

English: good



Please keep in mind my timezone and cultural differences when reading my replies. Thank you!



Wednesday, 30 December 2020 09:37 CST
3by400Inc

Thanks for the quick reply. I checked the Admin Tools tables earlier and couldn't find any related data stored there. I'm attaching a screenshot of the only records in our wp_admintools_storage table.

Where's their next stop from there?

 
Wednesday, 30 December 2020 09:54 CST
tampe125

If there's nothing there, it means that all emails have been sent.



Davide Tampellini

Developer and Support Staff



Italian: native

English: good



Please keep in mind my timezone and cultural differences when reading my replies. Thank you!



Wednesday, 30 December 2020 09:57 CST
3by400Inc

Alrighty, Thank you.

 
Wednesday, 30 December 2020 10:02 CST
3by400Inc

Hmm, we're definitely still receiving old email from Admin Tools, though. We just received another 8 login failure notifications back to back and we have the throttle in the email template set to 5 in an hour. The storage table is still empty of email records.

 
Wednesday, 30 December 2020 10:05 CST
tampe125

Maybe the email provider is still processing them? Sadly there's nothing we can do: if they're not in the table it means that they're been already sent :/



Davide Tampellini

Developer and Support Staff



Italian: native

English: good



Please keep in mind my timezone and cultural differences when reading my replies. Thank you!



Wednesday, 30 December 2020 10:24 CST
3by400Inc

Something isn't adding up.

-- Admin Tools Storage table is empty

-- Still receiving Admin Tools notifications in larger batches that the email template throttle

-- I assume these are old queued up emails because we only have 15 new security exceptions in our log after I cleared the table yesterday and we've received about 7,000 of these emails since then.

-- I removed the email address from the WAF settings to disable security exception emails half an hour ago and that has affected the old email delivery, because we're still getting old failed logins and old admin directory hits notifications but no general security exception emails.

 
Wednesday, 30 December 2020 10:25 CST
tampe125

If you disable Admin Tools are you still getting email notifications?



Davide Tampellini

Developer and Support Staff



Italian: native

English: good



Please keep in mind my timezone and cultural differences when reading my replies. Thank you!



Wednesday, 30 December 2020 10:28 CST
3by400Inc

Is deactivating the plugin sufficient to test that?

 
Wednesday, 30 December 2020 10:34 CST
3by400Inc

I guess that was sufficient because I haven't received an email since I deactivated the plugin. Strange. Where in the world are these coming from because they're not stored anywhere I've found thus far ...

 
Wednesday, 30 December 2020 10:54 CST
tampe125

Most likely you are targeted by a bot, which spawns hundreds of threads and you get all the emails at once. So even if the IP is blocked you still get the emails.
Just to understand better, are you using Admin Tools in auto-prepend mode? (The Optimize WAF option). If not, emails are sent synchronously, so you won't see anything in the table.
Did you disable logging for some kind of security exceptions? In that case Admin Tools can't apply any kind of throttling since we read the log table.

I'd suggest you disable emails except for successfully logins and let Admin Tools handle the rest.



Davide Tampellini

Developer and Support Staff



Italian: native

English: good



Please keep in mind my timezone and cultural differences when reading my replies. Thank you!



Friday, 29 January 2021 20:17 CST
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.
This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.