!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:
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.
Our breathtaking icon was bestowed upon us by @Cevilia!
The greatest banner of all time: by @TheOneWithTheHair!
Connect to your database and execute this sql:
UPDATE local_site SET private_instance = false
Then restart docker container
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
LEMMY_HOSTNAME="atosoul.zapto.org"
CF_API_TOKEN=""
BUILD_FROM_SOURCE="false"
SETUP_SITE_NAME="AtoSoul"
###############################################################
###############################################################
CADDY_HTTP_PORT=80
CADDY_HTTPS_PORT=443
USE_EMAIL="false"
CADDY_DISABLE_TLS="false"
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
==== Docker Information ====
Detected runtime: docker (Docker version 24.0.2, build cb74dfc)
Detected compose: docker compose (Docker Compose version v2.18.1)
Runtime state: ERROR
==== System Information ====
MEMORY: total used free shared buff/cache available
Mem: 5.6Gi 1.7Gi 1.1Gi 325Mi 2.8Gi 3.3Gi
Swap: 2.0Gi 0B 2.0Gi
KERNEL: 5.19.0-45-generic (x86_64)
SHELL: /bin/bash
PRETTY_NAME="Ubuntu 22.04.2 LTS"
NAME="Ubuntu"
VERSION_ID="22.04"
VERSION="22.04.2 LTS (Jammy Jellyfish)"
VERSION_CODENAME=jammy
ID=ubuntu
ID_LIKE=debian
HOME_URL="https://www.ubuntu.com/"
SUPPORT_URL="https://help.ubuntu.com/"
BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/"
PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy"
UBUNTU_CODENAME=jammy
==== Lemmy Easy Deploy Information ====
Version: 1.1.4
Integrity:
a84c0dfab3cab81bca79e53784501fecd202324d9c476438e760097d9e77b60c ./deploy.sh
1e9b0c0988998dcc33cb0fbfdb0e1679229424e724f898b797380adc7d102446 ./templates/Caddy-Dockerfile.template
c1202e70662dd2228da36a35a0f38ec8fc81bec8964d7315d02e8671a58dd7d7 ./templates/Caddyfile.template
7754ef7e8aa7e925becfcbbda0f873387533397a0756405741f4f4b9eb7f7253 ./templates/cloudflare.snip
1df196524e8d55a4be93b5bf401669d61b372c4f6f7670da83ab1947631fd0ed ./templates/compose-email.snip
839ce56196227e2bac2291ee045ef95bc6af9c9706396352f39cb0812754c5c1 ./templates/compose-email-volumes.snip
06cfd023e5c61bd4cbda9809ba35e4e99eaf090e3d674612bc3c04fe58eee397 ./templates/docker-compose.yml.template
308b8a122ee03cb9f5279fc2ad79663b0bffb2ed2a4042b96f678715cc997914 ./templates/lemmy-email.snip
8f25408461972b9b66ee3c4d3f6430e2e1eaa950394d2d8b7e3d1287fe0d8f07 ./templates/lemmy.hjson.template
==== Settings ====
BUILD_FROM_SOURCE=false
CADDY_HTTP_PORT=80
CADDY_HTTPS_PORT=443
USE_EMAIL=false
CADDY_DISABLE_TLS=false
POSTGRES_POOL_SIZE=5
TLS_ENABLED=true
==== Generated Files ====
total 36K
drwxr-xr-x 2 0 0 4.0K Jun 26 09:53 caddy
-rw-r--r-- 1 0 0 33 Jun 27 05:29 caddy.env
-rw-r--r-- 1 0 0 2.0K Jun 27 05:29 docker-compose.yml
-rw-r--r-- 1 0 0 50 Jun 26 09:53 lemmy.env
-rw-r--r-- 1 0 0 469 Jun 27 05:29 lemmy.hjson
-rw-r--r-- 1 0 0 49 Jun 26 09:53 pictrs.env
-rw-r--r-- 1 0 0 37 Jun 27 05:29 postfix.env
-rw-r--r-- 1 0 0 51 Jun 26 09:53 postgres.env
-rw-r--r-- 1 0 0 7 Jun 27 05:30 version