Hi! My forum has a lot of imported users that have a specific email domain that doesn’t work anymore. A few thousand users have such an email address. It was not an issue until now, but I increased suppress digest email after days value, and my forum sent a lot of digest emails, including to a lof of users having non-working email domains. It led to too many bounces and mailgun disabled my domain. What should I do with these accounts to prevent this and fix my issue? A lot of these accounts belong to legit users that didn’t come back to the forum yet. There are not necessarily abandoned accounts. Because of this issue, users can’t register to the forum until it is fixed.

I think I might UserEmail.where("email like '%@brokendomain.com'").each do |e| e.update(email: SecureRandom.hex + "@email.invalid) end Yours could work too, but Im’ not sure if the User model got updated to be able to do a u.email.include? after they moved emails to another model/table.

Check out Handling bouncing e-mails

For some reason I didn’t find this topic using the search… I guess I panicked! :sweat_smile: Thanks you very much for your fast answer!

But if there are a zillion email addresses like bademail.domain, maybe what you want to do is something like rake posts:remap['bademail.domain', 'no-email.invalid'] as described in Replace a string in all posts. That will make all of those email addresses such that Discourse won’t send to them. Another good solution would be something like bad=User.find_by_email bad.update_all(active: false) and deactivate all of the users with the known bogus email addresses. Not quite sure how to do the first bit off the top of my head, but it should be easy enough to figure out.

Yeah, I thought about doing this to get rid of these email domains. I notice that a Discourse method creates @no-email.invalid emails: app/services/user_merger.rb main Invite .with_deleted .where(invited_by_id: @source_user.id) .update_all(invited_by_id: @target_user.id) Invite .with_deleted .where(deleted_by_id: @source_user.id) .update_all(deleted_by_id: @target_user.id) update_user_id(:muted_users, conditions: "x.muted_user_id = y.muted_user_id") update_user_id( :muted_users, user_id_column_name: "muted_user_id", conditions: "x.user_id = y.user_id", ) update_user_id(:ignored_users, conditions: "x.ignored_user_id = y.ignored_user_id") update_user_id( :ignored_users, user_id_column_name: "ignored_user_id", conditions: "x.user_id = y.user_id", And in the importer base, it uses @email.invalid which is slightly different: script/import_scripts/base.rb main end def update_category_featured_topics puts "", "Updating featured topics in categories" count = 0 total = Category.count Category.find_each do |category| CategoryFeaturedTopic.feature_topics_for(category) print_status(count += 1, total, get_start_time("category_featured_topics")) end end def update_tl0 puts "", "Setting users with no posts to trust level 0" count = 0 total = User.count User Are these two different “dummy domains” both ignored when Discourse must send emails? Should I replace my non-working domain with @no-email.invalid or @email.invalid, or it doesn’t matter? @pfaffman, I’m not sure to understand why I should remap in posts instead of changing the user emails… :thinking: These email addresses aren’t in posts, unless I’m missing something. If it is a recommended way, I’d just like to replace my @brokendomains.com addresses in each profile by @no-email.invalid or @email.invalid. I can figure out how to do this, I just wonder which “fake” domain to use.

[图片] Canapin: I’m not sure to understand why I should remap in posts I’m fairly certain that posts:remap remaps that domain across all tables, but they had to put it in some class. You could also just write your own replacement in the UserEmails table (or whatever it’s called). I’m fairly certain that whatever.invalid will tell The World that it’s an invalid address and it won’t try to send it.

Neat. So I guess this would do the trick? User.find_each do |u| if u.email.include? "@brokendomain.com" u.update(email: SecureRandom.hex + "@email.invalid") end end

I tried my script just to see if it was returning the target email addresses and it works. Your script should be faster than mine since you use a query to select specific email domains instead of looping through all the users. Thank you very much for your help :+1:

Ooops. Here’s the remap I meant. It’s just discourse remap old new See Change the domain name or rename your Discourse. I think that the above would work, but the UserEmails solution is probably a tiny bit better.

[图片] pfaffman: I think that the above would work, but the UserEmails solution is probably a tiny bit better. Thank you. This is the one I used. More than 5000 users of a total of 17000 users had such email domains. No wonder the number of bounces when I increased suppress digest email after days…

[图片] pfaffman: I’m fairly certain that whatever.invalid will tell The World that it’s an invalid address and it won’t try to send it. This is special handling by Discourse for anything ending in .invalid, which is a reserved TLD.

过多的用户电子邮件域名无法正常工作导致 Mailgun 域名被禁用：该怎么办？

产品支持

pfaffman (Jay Pfaffman) 2020 年10 月 20 日 19:51 2

查看处理退信

话题		回复	浏览量
Migrated forum with many invalid (bouncing) emails Product Support	1	1015	2019 年7 月 23 日
How can I bulk remap/update user email addresses? Product Support	13	3194	2017 年1 月 29 日
Mailgun "temporarily disabled due to high bounce rate" Product Support	9	4281	2018 年6 月 1 日
Discourse user email rejected by recipients what is the best practice for this user Product Support	6	846	2021 年8 月 12 日
Migrating users with invalid emails Product Support	3	1015	2017 年4 月 20 日

过多的用户电子邮件域名无法正常工作导致 Mailgun 域名被禁用：该怎么办？

相关话题