tugg

joined 1 year ago
 

I'm not sure if it is because of an influx of users, but small instance has stopped receiving posts/comments from any subscribed community on lemmy.ml. Lemmy.world shows up fine as does beehaw.org and others, just not lemmy.ml. I'm not defederated as far as I can tell. Anybody else having this issue?

 

Can somebody let me know how I would remove an account from the posgreSQL database?

I can see the tables, but don't know where the accounts are held or the sql statement to delete them.

Thank you.

[โ€“] tugg@lemmyverse.org 23 points 1 year ago* (last edited 1 year ago) (3 children)

I dont have much to add other than I am an experienced admin and was dismayed at how vulnerable Lemmy is. Having an option to have open registrations with no checks is not great. No serious platform would allow that.

I dont know of a bulletproof way to weed put the bad actors, but a voting system that Lemmy can leverage, with a minimum reputation in order to stay federated might work. This would require some changes that I'm not sure the devs can or would make. Without any protection in place, people will get frustrated and abandon Lemmy. I would.

 

I have the application process enabled for people to join my instance, and I've gotten about 20 bots trying to join today when I had nobody trying to join for 5 days. I can tell because they are generic messages and I put a question in asking what 2+3 is and none of them have answered it at all, they just have a generic message.

Be careful out there, for all you small instance admins.

[โ€“] tugg@lemmyverse.org 21 points 1 year ago (3 children)

I belive > 50% are bot accounts, maybe more.

2
submitted 1 year ago* (last edited 1 year ago) by tugg@lemmyverse.org to c/lemmy@lemmy.ml
 

Does anybody know of a good place to upload short video clips like people do with v.redd.it?