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 ?

  • RGB@lemmyfi.com
    link
    fedilink
    English
    arrow-up
    1
    ·
    1 year ago

    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.

    • majorswitcher@lemmyfly.orgOP
      link
      fedilink
      English
      arrow-up
      2
      ·
      1 year ago

      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…

      • thatcasualgamingguy@lemmy.nerdcore.social
        link
        fedilink
        English
        arrow-up
        2
        ·
        1 year ago

        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.

        • majorswitcher@lemmyfly.orgOP
          link
          fedilink
          English
          arrow-up
          1
          ·
          1 year ago

          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