coffeeisnotlatte 1 year ago • 100%
I got march of shamed once because I genuinely forgot, it somehow shortcircuits my brain when I need to wait for approval, thinking I've already paid and walk out after waiting for the person to come tap some buttons :|
coffeeisnotlatte 1 year ago • 100%
That sounds like a particularly horrible idea, there's no way to know. I would take the risk on electronics, not something you actually put into your body.
coffeeisnotlatte 1 year ago • 100%
Not super easily. It can be done by querying the postgresql dabase, but there is no built-in method to do it using the browser interface at the moment. When anyone from any instance does report them, you will see the report.
Do you have an example of a query I could use? I'm a bit rusty with databases :) with an example I can get chatgpt to build me something better
coffeeisnotlatte 1 year ago • 100%
I see, occasionally I get reports from local users about something elsewhere from a 'foreign' user... which I can then delete. I assume that's not deleting from their server?
For example I get a report from a local user about a lemmy.ml user with a post in lemmy.world
coffeeisnotlatte 1 year ago • 100%
I don't unfortunately, I deliberately don't log that due to some of the sensitive stuff on my own instance (we're China based)
After the bot attacks I've cleaned up and implemented some additional measures thanks to some helpful users, but I'd also like to monitor the situation in case someone from my server decides to go on a spam rampage... Is there a way to: 1) Easily get a list of comments from all my users locally and across the 'verse? 2) If I purge/ban these users, is there a protocol for letting other Lemmy admins know? I assume I have no power to delete things from their instances (just my copy of their instance?)
coffeeisnotlatte 1 year ago • 100%
From ChatGPT and a huge thank you to @sunaurus@lemm.ee who reached out to us initially about the issue. Unfortunately the SQL he provided seemed a bit of a nuke so I modified it a bit using chatgpt and got the below which got us to 335 users. I will keep a close eye on the ones left
This got most of them (27k+)
SELECT lu.id, p.name, lu.email FROM local_user lu JOIN person p ON lu.person_id = p.id LEFT JOIN community_follower cf on p.id = cf.person_id LEFT JOIN comment c on p.id = c.creator_id LEFT JOIN post on p.id = post.creator_id WHERE cf.id is null AND c.id is null AND post.id is null AND lu.validator_time >= '2023-06-19' AND lu.email IS NOT NULL AND lu.email <> '' AND lu.email ~ '[0-9]{5,}' ORDER BY lu.id DESC;
This got 1000 or so left by lowering to 4 numbers after an email
DELETE FROM local_user WHERE id IN (SELECT lu.id FROM local_user lu JOIN person p ON lu.person_id = p.id LEFT JOIN community_follower cf on p.id = cf.person_id LEFT JOIN comment c on p.id = c.creator_id LEFT JOIN post on p.id = post.creator_id WHERE cf.id is null AND c.id is null AND post.id is null AND lu.validator_time >= '2023-06-19' AND lu.email IS NOT NULL AND lu.email <> '' AND lu.email ~ '[0-9]{4,}');
And this got 500 by looking for usernames with 2 digits after their username. If you're worried about hitting actual users here use the joins
SELECT p.name, lu.email FROM local_user lu JOIN person p ON lu.person_id = p.id WHERE lu.person_id >= 356 AND p.name ~ '\d';
coffeeisnotlatte 1 year ago • 100%
Yup I've got them, luckily 5 or more repeating numbers in their email pretty much identified 99% of them. Would you like me to send the CSV somewhere? 27k+ bots
coffeeisnotlatte 1 year ago • 100%
That's okay I found it, luckily there's a pattern here too... I dug up 27k with repeating numbers on emails which is a good start!
coffeeisnotlatte 1 year ago • 100%
Huh adminer would definitely be an easier way to do this, do you have the part of the docker-compose you used with the env vars etc?
coffeeisnotlatte 1 year ago • 100%
Yeah that's the issue I'm having, someone sent me a postgres command in DM earlier but it does seem to be a bit of a nuke/picking up ordinary users....
coffeeisnotlatte 1 year ago • 100%
Nevermind, I'm in with user 'lemmy' :) I will start cleaning this up now...
Trying to purge them and set up with Lemmy Ansible, I've disabled signups without admin approval for now. I see a postgres container and a password but I'm not very familiar with postgres, I tried psql but can't get access Edit: Also anyone who's de-federated with us, please reconsider. We're a small server with active admin and will get a handle on this, I promise! We had an easy process to sign up for a few days while I got my users over and forgot to turn it off Edit2: Looking much more healthy now, I will put the commands I've used in a comment below
coffeeisnotlatte 1 year ago • 100%
Yeah I started on a dinky little server and now it's massive.... mostly seems to be a memleak or something going on though that's causing OOM and a massive CPU spike. Anyone know anything? 4GB of RAM getting eaten for breakfast... just had to up it to 8
coffeeisnotlatte 1 year ago • 100%
Damn, I've got to look into that myself. Mine's currently on AWS and costing me a small fortune
coffeeisnotlatte 1 year ago • 100%
I just put my instance through cloudflare, it seems okay. I would guess cloudflare won't be that fussed considering it's federated/easily accessible from others.
On 0.17.4, has anyone else noticed this? The last few days the server chewed through 2GB of RAM... then yesterday it chewed through 4GB after an upgrade in about 2 days and now seems to be chewing through about 100MB/hour with no sign of stopping. I put in a bug report but thought I'd ask if anyone else is having the issue too: https://github.com/LemmyNet/lemmy/issues/3183
coffeeisnotlatte 1 year ago • 95%
You could, but the API for Reddit won't work in two weeks... and tbh I like the fact we're building something new here
coffeeisnotlatte 1 year ago • 100%
This server does work in China, however I would still advise a VPN for anyone coming here from within authoritarian regimes. I've taken precautions and mask IPs in the logs but still....
I'm not on either the instance reported from or the instance reported to, I have my own instance. Why am I getting these reports/would care about them?
coffeeisnotlatte 1 year ago • 100%
I would, but unfortunately r/jailbreak is closed where I got the instructions :(
coffeeisnotlatte 1 year ago • 100%
It's like everyone saw what Twitter did, and thought they could get away with doing the same
coffeeisnotlatte 1 year ago • 100%
I could live without youtube for sure, I have more of a Reddit problem than a YouTube problem... but it seems they fixed that for me.
coffeeisnotlatte 1 year ago • 100%
Mine is actually also a VPS, my electricity is too unstable to host at home :')
It's pretty light though, 2GB RAM and 2vCPUs and about 10GB of space. It shot up to 9.5GB over a few days as people added more communities, then slowed down a lot. We have ~60 users as of now
coffeeisnotlatte 1 year ago • 100%
Regular Apollo still works for now, I've got the modified version on a backup iPhone 8 so let's see if it still works there after the shutdown
coffeeisnotlatte 1 year ago • 100%
Well, they've said 100 requests per minute is under the free tier, since I'm the only user with my API key that should be within their limits.
coffeeisnotlatte 1 year ago • 100%
I managed to get Apollo working with my own API key using a tweak and Sideloadly (works on jailed phones too)
We'll see if that continues working after 30th, if not I think I'm pretty much done with Reddit
coffeeisnotlatte 1 year ago • 100%
My lemmy instance :)
I used to self-host email with email and postfix, but I gave up with the amount of spam coming my way and moved to Proton
coffeeisnotlatte 1 year ago • 100%
The government can be a lot more unstable as we saw in 2020, people left because the balance went way too far on the government being more of a pain in the arse. Will they do that again? Who knows...
coffeeisnotlatte 1 year ago • 100%
Which one gets in your way less, the government or the job?
coffeeisnotlatte 1 year ago • 100%
The URL is also encrypted on a https connection, they can only see you've connected to Reddit... not what you're actually browsing: https://blog.mozilla.org/en/privacy-security/https-protect/
HTTPS also prevents your internet service provider (ISP) from seeing what pages you visit beyond the top level of a website. That means they can see that you regularly visit https://www.reddit.com, for example, but they won’t see that you spend most of your time at https://www.reddit.com/r/CatGifs/.
coffeeisnotlatte 1 year ago • 100%
It had to go eventually, you can still see the instructions if you are using a desktop... the mobile site/apps unfortunately doesn't show them
coffeeisnotlatte 1 year ago • 100%
Manjaro
coffeeisnotlatte 1 year ago • 100%
Fair enough you have me beat :')
coffeeisnotlatte 1 year ago • 90%
latte.isnot.coffee is mine, I think it's the best end for your name you can hope for ;)
coffeeisnotlatte 1 year ago • 100%
Are you guys seeing the trainwreck in this AMA?
coffeeisnotlatte 1 year ago • 100%
iamthatis (Apollo) even said he could do it with a bit more time after the initial shock, some negotiation etc, he was willing to try if Reddit would throw him anything at all so it was possible. But Reddit instead shut down all communication then lied about what happened
coffeeisnotlatte 1 year ago • 100%
If you're old enough to get around those controls, you're old enough to view porn, frankly. It's like a rite of passage that I went through 15 years ago... the parental controls were also much worse then, so it's arguably more effective now.
coffeeisnotlatte 1 year ago • 100%
Was it lemmy.org.uk? Not sure what happened to that one, I was there too... spun my own up in the end
coffeeisnotlatte 1 year ago • 100%
You're not the first, you just don't get the full list of comments until you subscribe from your home instance... and I'm unsure if you get earlier comments than when you did that. It's a bit of a pain point
You don't need to just search, you need to have at least one member subscribed
coffeeisnotlatte 1 year ago • 100%
I like it a lot too, the fact that I can roam around servers from my home server is really cool
coffeeisnotlatte 1 year ago • 100%
Originally, it was just a Reddit alternative. It turned that way later when regular users went back to Reddit and the more extreme users stuck around voat
coffeeisnotlatte 1 year ago • 100%
/r/china is migrating over at least for a week, as long you're respectful anti-CCP is fine (same rules as the subreddit)
/c/china on latte.isnot.coffee, we could do with some seeding before we close the sub on Reddit.
coffeeisnotlatte 1 year ago • 100%
We are migrating as we speak onto my local instance, I suspect the larger ones may get overloaded on the 12th
This is a general discussion thread for any questions or topics that you feel don't deserve their own thread, or just for random thoughts and comments. The sidebar guidelines apply here too and these threads will be closely moderated, so please keep the discussions civil, and try to keep top-level comments China-related.
As you can see in the screenshot, most communities I put in yesterday (except this one) have zero comments. Any idea why that would be? If I go to the instance itself I see comments