coffeeisnotlatte

joined 1 year ago
[–] coffeeisnotlatte@latte.isnot.coffee 9 points 1 year ago* (last edited 1 year ago)

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@latte.isnot.coffee 2 points 1 year ago (1 children)

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@latte.isnot.coffee 2 points 1 year ago* (last edited 1 year ago)

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

 

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?)
1
submitted 1 year ago* (last edited 1 year ago) by coffeeisnotlatte@latte.isnot.coffee to c/lemmy@lemmy.ml
 

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@latte.isnot.coffee 1 points 1 year ago (1 children)

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

[–] coffeeisnotlatte@latte.isnot.coffee 1 points 1 year ago* (last edited 1 year ago)

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.

1
We seem to be memleaking (latte.isnot.coffee)
submitted 1 year ago* (last edited 1 year ago) by coffeeisnotlatte@latte.isnot.coffee to c/lemmy_support@lemmy.ml
 

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

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

I would, but unfortunately r/jailbreak is closed where I got the instructions :(

[–] coffeeisnotlatte@latte.isnot.coffee 4 points 1 year ago (1 children)

It's like everyone saw what Twitter did, and thought they could get away with doing the same

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

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

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.

 

Testing 123

view more: next ›