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 :|
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.
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
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
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
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....
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
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.
Hey :) I don't think we can drill down into communities yet, the search page is a bit haphazard unfortunately but I think 18.0 is supposed to bring a whole host of new features so I'm just waiting for that for now - deselecting NSFW in your profile does indeed work and stop them showing in results though.
And no problem! We're a small server but I enjoy hosting it :D
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 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 :|
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.
You can leave that blank if you're filling in a text post
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
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
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)
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
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!
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?
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....
Nevermind, I'm in with user 'lemmy' :) I will start cleaning this up now...
About 80 total, but I'd say only a handful are active every day
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
Damn, I've got to look into that myself. Mine's currently on AWS and costing me a small fortune
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.
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
Hey :) I don't think we can drill down into communities yet, the search page is a bit haphazard unfortunately but I think 18.0 is supposed to bring a whole host of new features so I'm just waiting for that for now - deselecting NSFW in your profile does indeed work and stop them showing in results though.
And no problem! We're a small server but I enjoy hosting it :D
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 would, but unfortunately r/jailbreak is closed where I got the instructions :(
It's like everyone saw what Twitter did, and thought they could get away with doing the same