Then yes, as I said… no users on sopuli.xyz have subscribed to your community yet: [email protected] - 0 subscribers
Other replies here have provided more info :)
Then yes, as I said… no users on sopuli.xyz have subscribed to your community yet: [email protected] - 0 subscribers
Other replies here have provided more info :)
Content for communities you’ve created on your instance will only be visible on other instances if a user there has subscribed to the community.
Or do you mean yours posts to communities homed to other instances do not show up?
In the UI? Not that I know of. From the database… sure:
docker exec -it <instancename>_postgres_1 sh
psql -U lemmy -h 127.0.0.1 -p 5432 -d lemmy
SELECT * from local_user;
If your VPS is purely for Lemmy, I’d suggest blowing it away and using the ansible playbook referenced here. I found the current docker-compose does not function, there are broken references to external nginx configs.
Ok, figured it out myself. For anyone else that needs it…
Run a shell within the postgres docker container:
docker exec -it <sitename>_postgres_1 sh
Connect to the postgres service:
psql -U lemmy -h 127.0.0.1 -p 5432 -d lemmy
Connect to the lemmy database:
\c lemmy
Then the user table: \d local_user
Find the user ID of the account you want to manually toggle, probably #1:
SELECT * from local_user;
Then update the email_verified and _accepted_application flag on the first account:
UPDATE local_user SET email_verified = ‘t’, accepted_application = ‘t’ WHERE id = 1;
lemmy=# UPDATE local_user SET email_verified = ‘t’, accepted_application = ‘t’ WHERE id = 3; UPDATE 1 lemmy=# UPDATE local_user SET email_verified = ‘t’, email_verified= ‘t’ WHERE id = 3; UPDATE 1 lemmy=#
Thats what I figured… I just have no idea how to do it. Can you point me to any info on how to do that? :)
Thats a different issue to what I encountered. For me the nginx docker config had a reference to the host nginx config… I had no nginx installed so “docker-compose up” failed.