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

@jippi
Hi again! So I got tired of dealing with these bot signups and attempted what you suggested. This is the output:
postgres=# ALTER TABLE public.user_invite_requests
ADD CONSTRAINT invite_block_spam_bot
CHECK (text NOT ILIKE 'Automated protocol deliverability probe');
ERROR: relation "public.user_invite_requests" does not exist

Any ideas?

@fname try to remove the public. part if the name - I use glitch fork so actually not sure if this table exists in vanilla mastodon

@jippi
I’m running Glitch also.