what's the point of all these random accounts creation? seems like a automated process. would it be to upload illegal stuff?
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 ?
My modlog got spammed today by some script banning a lot of people for spam automatically. It's getting wild. This was inevitable with the growth of Lemmy as a platform though.
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..
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.
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