After a couple years on Fedora I decided to do one more Distro hop- to one I have little experience with, openSUSE.
But it seems the everything from the installer, philosophy, package manager, configs, and general way of working is just very different than every Distro I've tried before (Debian/*Buntu, Fedora, Arch, Gentoo)
Like what's up with YaST? It's like a system-wide settings/configs program plus a package manager front end unique to openSUSE?
And to update grub it seems the best command is "update-bootloader" - for example. This isn't standard on anything else afaik. Is there anywhere other than practice I can learn all of these quirks?
Thought I'd advertise this at least one more time with a new wave of users. Having a commmunity for truckers is sorely needed!
Well I never had spam issues, until 0.18 forced captchas to be disabled. Thankfully the bots just seem to be signing up, not doing much yet. Using fake emails that never get verified.
So I threw together a little script. Just put this in a sh file, and create a cron job or systemd service to run it every 15 minutes or so. Use your favorite text edit tool to replace "thelemmyclub" with your instance name, or whatever you have your docker containers named. (Check `docker ps`). You'll also have to be able to run docker without sudo, so add your user to the docker group or put the cron job on root (if you do that make sure only root can access the file, for security)
Also if you set up manually without docker, well I'm sure you have the skills to adapt these commands appropriately.
First though run:
`docker exec -it thelemmyclub_postgres_1 psql -U lemmy -h 127.0.0.1 -p 5432 -d lemmy -c "select * from local_user where id in (select local_user_id from email_verification where published < (NOW() - INTERVAL '60 minute'));"`
This will list all users who haven't completed email verification, except those that are under an hour old. If you think these are all abandoned accounts and bots, carry on. It's always best to check before doing things to live databases...
Edit: thanks to input from [@email@example.com](https://centennialstate.social/u/freeskier)
The sh file you need:
docker exec -it thelemmyclub_postgres_1 psql -U lemmy -h 127.0.0.1 -p 5432 -d lemmy -c "DELETE FROM person WHERE local = 'true' AND id IN (SELECT person_id FROM local_user WHERE id IN (SELECT local_user_id FROM email_verification WHERE published < (NOW() - INTERVAL '60 minute')));"
This will delete all users over an hour old who haven't completed email verification. (Only applies to accounts made after you enabled email verification, so older accounts are safe)
Hope this helps!
Hello fellow steering wheel holders! Join us over at:
If the above link doesn't work, just search one of these in your instance's search bar:
Then, search again.
Join us at:
If you're on a larger instance, if you could search one of the above it would help a lot!
Very very good. Crust came out too tough but almost certainly my fault.