bdonvr

But seriously I'm running WefWef on my instance... (app.thelemmy.club) and it seems like I have to git pull and build it twice a day!

I might automate it, as long as there's no conflicts with my minor changes. Lmao

Great work!

I don't know if you've heard of the EXCELLENT web app for lemmy over at https://WefWef.app

Not that I don't trust WefWef or their team! But now users of thelemmy.club can use WefWef knowing their credentials and data never leave their own instance. Check it out at https://app.thelemmy.club

https://app.thelemmy.club

I've heard multiple people express distrust at giving a third party website their login credentials. I trust the WefWef team, but their concern is understandable. So I decided to host it myself!

Made a few minor changes to the code to lock it down to only login to my instance.

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 protected]

The sh file you need:

#! /bin/bash
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!

Tom Grossi stopped at Pappasito's Cantina on Tuesday along his trip to visit 30 stadiums in 30 days to raise money for St. Jude's.

We counted about 35-40 people at the start, but there may have been more that filed in later.

He said he was actually able to get a tour of NRG, which is nice because not every team has let him inside. His full video on it should be coming out in the next day or two.