Lemmy

11947 readers

93 users here now

Everything about Lemmy; bugs, gripes, praises, and advocacy.

For discussion about the lemmy.ml instance, go to [email protected].

founded 4 years ago

MODERATORS

[email protected]

As a community owner/mod, how do I approve a follow from a Mastodon user? (imgur.com)

submitted 1 year ago by [email protected] to c/[email protected]

8 comments fedilink hide all child comments

I created a community here, and then tried to follow it from my Mastodon account. On Mastodon it says the follow request is pending approval. But I don't see any way to approve it from here on lemmy.ml. Any suggestions?

you are viewing a single comment's thread
view the rest of the comments

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

Also, as a mod, how can I see who are the subscribers to the community?

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

You can query your DB with something like:

$ docker exec -it lemmystudio_postgres_1 bash
# psql -U lemmy lemmy
lemmy=# SELECT person.actor_id, community.actor_id
FROM community_follower
JOIN person ON person_id = person.id
JOIN community ON community_id = community.id
ORDER BY person.actor_id;

This gives you the users and communities they're subscribed to.

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

Thanks, but I'm just a user here on lemmy.ml, so I don't have access to that. If it's not exposed in the UI at all I'll open an issue over in GitHub.

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

Ah, I see! I thought you were an admin with access to the DB, sorry!

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

No worries, it was still a useful answer as an instance admin might find the post.

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

I found this post, and it was useful.