We did not expect so many people to sign up within the first few days so we instantly went over our email quota.
Is there a command we can use to resend all confirmation emails that are yet to be confirmed?
I wrote a custom script to do it.
It is pretty easy.
Query the database for emails with accounts with “NULL” activation.
Download that data into a text file and then feed each email into the Resend Confirmation Email page.
Can do 1 email per 2 seconds before it throttles you.
You are going to have to Google how to run SQL queries. It is not hard and is worth learning.
It is not about how many users you have but how many requests you can make before the web server throttles you. Looks like there is some built-in limits with Mastodon to prevent bots and spam hitting the instances hard.
You can run User.where(confirmed_at: nil).find_in_batches(&:resend_confirmation_instructions) in the rails console to resend confirmation instructions to all unconfirmed users.