Connect to your database and execute this sql:
UPDATE local_site SET private_instance = false
Then restart docker container
this post was submitted on 27 Jun 2023
4 points (100.0% liked)
No Stupid Questions
35772 readers
1181 users here now
No such thing. Ask away!
!nostupidquestions is a community dedicated to being helpful and answering each others' questions on various topics.
The rules for posting and commenting, besides the rules defined here for lemmy.world, are as follows:
Rules (interactive)
Rule 1- All posts must be legitimate questions. All post titles must include a question.
All posts must be legitimate questions, and all post titles must include a question. Questions that are joke or trolling questions, memes, song lyrics as title, etc. are not allowed here. See Rule 6 for all exceptions.
Rule 2- Your question subject cannot be illegal or NSFW material.
Your question subject cannot be illegal or NSFW material. You will be warned first, banned second.
Rule 3- Do not seek mental, medical and professional help here.
Do not seek mental, medical and professional help here. Breaking this rule will not get you or your post removed, but it will put you at risk, and possibly in danger.
Rule 4- No self promotion or upvote-farming of any kind.
That's it.
Rule 5- No baiting or sealioning or promoting an agenda.
Questions which, instead of being of an innocuous nature, are specifically intended (based on reports and in the opinion of our crack moderation team) to bait users into ideological wars on charged political topics will be removed and the authors warned - or banned - depending on severity.
Rule 6- Regarding META posts and joke questions.
Provided it is about the community itself, you may post non-question posts using the [META] tag on your post title.
On fridays, you are allowed to post meme and troll questions, on the condition that it's in text format only, and conforms with our other rules. These posts MUST include the [NSQ Friday] tag in their title.
If you post a serious question on friday and are looking only for legitimate answers, then please include the [Serious] tag on your post. Irrelevant replies will then be removed by moderators.
Rule 7- You can't intentionally annoy, mock, or harass other members.
If you intentionally annoy, mock, harass, or discriminate against any individual member, you will be removed.
Likewise, if you are a member, sympathiser or a resemblant of a movement that is known to largely hate, mock, discriminate against, and/or want to take lives of a group of people, and you were provably vocal about your hate, then you will be banned on sight.
Rule 8- All comments should try to stay relevant to their parent content.
Rule 9- Reposts from other platforms are not allowed.
Let everyone have their own content.
Rule 10- Majority of bots aren't allowed to participate here.
Credits
Our breathtaking icon was bestowed upon us by @Cevilia!
The greatest banner of all time: by @TheOneWithTheHair!
founded 1 year ago
MODERATORS
Thank you for your response, but can you explain like I'm five? Lol
I don't know what you mean by connect to my database, I'm really new to this stuff, this is all really above my head.
In your case you can try this:
$ docker exec -ti lemmy_postgresql_1 bash
or put here your container name instead "lemmy_postgresql_1", look inside docker ps output
$ su postgres
$ psql -d lemmy
$ UPDATE local_site SET private_instance = false;
Then restart docker container with
docker restart lemmy_lemmy_1 # or your container name instead "lemmy_lemmy_1", look inside docker ps output
i'm so sorry but i still don't understand...
root@laptop:/home/rain# docker exec -ti lemmy_postgresql_1 bash
Error response from daemon: No such container: lemmy_postgresql_1
here is the guide i followed that got me to this point... and then i checked that box with out understanding what i was doing...
Replace lemmy_postgresql_1 with whatever the name of your database container is. If you don't know the name, I guess you should be able to figure it out by reading config.env?
i don't see the database mentioned in that file
The hostname for your instance
Do NOT put http:// or https://
ONLY put your domain here. Subdomains are ok.
LEMMY_HOSTNAME="atosoul.zapto.org"
If you use Cloudflare, your Cloudflare API token. Otherwise leave blank.
If present, the DNS-01 challenge will be used to obtain valid HTTPS certificates
--> If you use the Cloudflare Proxy, DO NOT FORGET to enable Cloudflare's Full (Strict) SSL mode! <--
This token must have access to edit the Zone where $LEMMY_HOSTNAME is
Using this option will increase build time, as the DNS plugin needs to be compiled. Subsequent deploys will be faster.
CF_API_TOKEN=""
Whether or not to build Lemmy from source rather than use the Docker Hub images
This will significantly increase deploy time!
BUILD_FROM_SOURCE="false"
The name of your Lemmy instance, will be displayed on the site header (only used during first-time setup)
If you use special characters, please backslash-escape them.
SETUP_SITE_NAME="AtoSoul"
###############################################################
SETTINGS FOR ADVANCED USERS ONLY
I CANNOT HELP YOU WITH ISSUES RELATED TO THESE SETTINGS
###############################################################
The external port to use for Caddy's port 80
CADDY_HTTP_PORT=80
The external port to use for Caddy's port 443
CADDY_HTTPS_PORT=443
If true/1, also deploy the postfix server and configure Lemmy to send emails
NOTE: Port 25 is USUALLY disabled on most server providers. For this reason, the email service is not well tested
Feedback on the email service is appreciated!
USE_EMAIL="false"
If true/1, prefix the Caddy host block with http:// to disable TLS entirely
CADDY_DISABLE_TLS="false"
The options below will be passed directly to lemmy.hjson
See that file for how they will be used
Remember to backslash escape any special characters!
POSTGRES_POOL_SIZE="5" TLS_ENABLED="true" SETUP_ADMIN_USER="lemmy" LEMMY_NOREPLY_DISPLAY="Lemmy NoReply" LEMMY_NOREPLY_FROM="noreply"
Hmm... well, it must be somewhere (I don't know much about docker). Maybe run some Docker command to list the containers, then supply the appropriate one to the grandparent commenter's docker exec... command.
I'm sorry, that went over my head... i'm as new at this as you can be...
The name you are looking for should be listed in this output:
docker ps -a
You need to run it is root or as
sudo docker ps -a
To connect to your database: psql -h localhost -U PG_USER
Replace PG_USER with the username in your docker-compose file (under the entry for postgresql). It'll ask you for a password which will be right next to your pg user in docker compose or lemmy.hjson
If you get an error about psql not being a valid command then you probably need to install the postgresql client tools. Depending on OS that varies, usually sudo apt install postgresql or sudo dnf install postgresql will do it.
If you get an error about being unable to connect, you also will need to expose access to your database from docker. For that modify your docker compose file, look for something like "externalproxy" in the network section to know the name of the network you need to add to the postgresql container. You'll see an example of it under nginx container. Put a copy of that in the postgresql docker section. You'll also need to add port mapping 5432:5432 to PG container - again see other container entries in there for an example of the port declaration looks like. After that do docker compose up -d to reload it and you should be able to connect with psql.
Once you get in with psql, enter that query and hit enter. It should output UPDATE 1 if it worked and then you can do \q to exit.
view more: next ›