this post was submitted on 27 Jun 2023
4 points (100.0% liked)

No Stupid Questions

35791 readers
1121 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
ja2@lemmy.world
_MoveSwiftly@lemmy.world
Rooki@lemmy.world
Thekingoflorda@lemmy.world
automodbeta@lemmy.world
L3s@lemmy.world
4
I erroneously set my personal lemmy instance to private! how do i access it now?! (lemmy.world)
submitted 1 year ago* (last edited 1 year ago) by Soullioness@lemmy.world to c/nostupidquestions@lemmy.world
12 comments fedilink hide all child comments
 

now i get this error when i attempt to access it. anyone know how to set it back?

404: FetchError: request to http://lemmy:8536/api/v3/site

and the command docker compose -p lemmy-easy-deploy logs -f yeilds a bunch of nonsense but this line stood out...

Error: LemmyError { message: Some("Cannot have both private instance and federation enabled."), inner: Cannot have both private instance and federation enabled., context: "SpanTrace" }

you are viewing a single comment's thread
view the rest of the comments
[–] Soullioness@lemmy.world -1 points 1 year ago* (last edited 1 year ago) (2 children)

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.

[–] kerrigan@l.jugregator.org 1 points 1 year ago (1 children)

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

[–] Soullioness@lemmy.world -1 points 1 year ago* (last edited 1 year ago) (1 children)

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...

[–] grue@lemmy.world 0 points 1 year ago (1 children)

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?

[–] Soullioness@lemmy.world 1 points 1 year ago* (last edited 1 year ago) (1 children)

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"

[–] grue@lemmy.world 1 points 1 year ago (1 children)

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.

[–] Soullioness@lemmy.world 0 points 1 year ago (1 children)

I'm sorry, that went over my head... i'm as new at this as you can be...

[–] twack@lemmy.world 1 points 1 year ago* (last edited 1 year ago)

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

[–] key@lemmy.keychat.org 1 points 1 year ago

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.