I’ve set registration to Require application again, don’t like this bots creating accounts.

Also I’m running into email limitations. Using the Sendgrid Free plan of 100 emails per day, but if a couple of member have email notification on, I’m reaching that 100 very quickly. How do others handle the high email traffic ?

You are viewing a single thread.
View all comments View context
3 points

Mine too I see now. You can only ban a user when they have posted something right ? There is no list for admins of all users registered ? Maybe I’ll do it direct in the database…

permalink
report
parent
reply

Just did that for my instance. Luckily it’s fairly easy. Since there were no human registrations after those bots I just looked up the lowest bot id in the local_user table which was 9 and then used delete from person where id in (select person_id from local_user where id >= 9);. Thanks to the references and triggers on the table, the rest of the database was also cleaned up by that, including the local_user table.

permalink
report
parent
reply
1 point

For me it were the last 30 or something entries in local_user. They all didn’t have email_verified. I access the db through Postico. Also removed all other older accounts that didn’t verify their email address

permalink
report
parent
reply

Lemmy Support

!lemmy_support@lemmy.ml

Create post

Support / questions about Lemmy.

Matrix Space: #lemmy-space

Community stats

  • 219

    Monthly active users

  • 1.2K

    Posts

  • 5.7K

    Comments

Community moderators