coffeeisnotlatte

joined 1 year ago
MODERATOR OF
[–] [email protected] 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 :|

[–] [email protected] 1 points 1 year ago (1 children)

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.

[–] [email protected] 2 points 1 year ago

You can leave that blank if you're filling in a text post

[–] [email protected] 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

[–] [email protected] 3 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

[–] [email protected] 2 points 1 year ago

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?)
[–] [email protected] 2 points 1 year ago (2 children)

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

[–] [email protected] 4 points 1 year ago (1 children)

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!

[–] [email protected] 2 points 1 year ago (3 children)

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?

[–] [email protected] 3 points 1 year ago (5 children)

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....

[–] [email protected] 3 points 1 year ago

Nevermind, I'm in with user 'lemmy' :) I will start cleaning this up now...

22
submitted 1 year ago* (last edited 1 year ago) by [email protected] to c/[email protected]
 

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

[–] [email protected] 2 points 1 year ago

About 80 total, but I'd say only a handful are active every day

15
We seem to be memleaking (latte.isnot.coffee)
submitted 1 year ago* (last edited 1 year ago) by [email protected] to c/[email protected]
 

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

 

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?

 

Not at the side like on Reddit

3
Cat (latte.isnot.coffee)
 
 

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.

7
Welcome to Lemmy (latte.isnot.coffee)
submitted 1 year ago* (last edited 1 year ago) by [email protected] to c/[email protected]
 

This is Lemmy, on this server (latte.isnot.coffee) we have /c/china and /c/chinavisa and any other communities you want to make which are local to this server and can be interacted with in the same way as Reddit, that's sort of cool but the magic happens elsewhere.

When you signed up for this server, you got [email protected], you can use this to go to different communities on different lemmy servers as a sort of guest and post there too! So you can post anywhere!

How to find other places? I'm going to call them "foreign" for the sake of simplicity - first you can go to Communities -> All (or click here) which will show you the ones the users here locally have subscribed to, and which server they're on (you'll see a lot of lemmy.ml) - if you click that you can go over there and make a post. Think of it as flying to another country

But not all communities are in that list, if no-one here has gone there yet you won't see it.

Do note that you may get 'lost' if you click an offsite link over there, and end up on a different Lemmy server (thus logged out) - you can simply type latte.isnot.coffee again in your URL bar and you'll be right back at home :)

To add an existing 'foreign' community elsewhere to this server, you simply need to search for it from the Communities -> All page. To search you want to use [email protected] (for example to find /c/gaming you'd use [email protected])

You only need to add it once, then everyone on latte.isnot.coffee can see it on the All page. You will need to subscribe to the 'foreign' community to start bringing comments through. Once that's done, you can interact it like you would local communities

Notes: Sometimes it says "No Results" after searching, don't worry about that. You'll simply need to go back to the Communities -> All page and it will be there!

Notes2: You cannot log into your account here from other Lemmy servers, but you can post from here to other lemmy servers. Just make sure your URL is always latte.isnot.coffee

As an example, a post I made to Lemmy Support on lemmy.ml (a foreign server): https://latte.isnot.coffee/post/291

Notes3: You can browse "foreign" communities here: https://browse.feddit.de/ to see what's out there, then...

To join you simply need the community name (let's take asklemmy as an example) and the server. In this case it would be [email protected] to type into the search bar on Communities -> All on latte.isnot.coffee

As the server grows, you may find your favourite communities already in Communities -> All so don't need to worry about searching/subscribing to it.

Notes4: It's not very good at refreshing for new content, you may have to hit F5

 

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

view more: next ›