These “Automated protocol deliverability probe” signup attempts can eat my whole ass.

#MastoAdmin #FediAdmin

@fname i made a trigger in the database refusing any username with the 2 char prefix they all share lol - been quiet since

@jippi
I’ve read about people doing this. I’m hesitant to start messing with my DB at the command-line level. 😬

@fname yeah I get that, I got tired of banning networks and other things to try and sniff them out, so the trigger was bullet proof way to fix it with no side effects

ALTER TABLE public.user_invite_requests
ADD CONSTRAINT invite_block_spam_bot
CHECK (text NOT ILIKE 'Automated protocol deliverability probe');

and super easy to drop again - it just refuses at the database level any signup reason with the exact text they use