P
Postizβ€’2mo ago
Support

Ticket: Port 3000 Initialization Failure in Database Setup

@zapoqx Just created a ticket
Question: Something is wrong with initializing Port 3000 into the database.
Attempted: I intiailly tried using my synology nas to make the containers. I learned I couldn't use port 5432 so I tried switching that port and I changed the volumes. Everything seems to work, but on check, much like the post found here: https://discord.com/channels/1243410146097500202/1297914286001361008 I would get a 502 error on making the login. After messing with several settings and trying a few things, I couldn't get a solution going so I decided to try seeing if it was possible to go more default to the docker compose installation by setting up on a blank raspberry pi 5 with just portainer and watchtower. Took longer than the synology drive, but it was up, though the exact same error still comes up and port 3000 fails to initialize so its making me think its not just about a specific platform as something is causing port 3000 to fail to initialize. Perhaps the Caddy built-in may not be working right or the prisma isn't wanting to connect. Attached displays the error that comes up, but note that the port has been tested inside the container to see if it can be pinged which it can, so something is preventing the connection.
Working On: Depends on whether we are talking on the Raspberry Pi 5 or a Synology Nas.
Take it from here @Postiz
261 Replies
zapoqx
zapoqxβ€’2mo ago
Attached is the error that is shown where it cannot connect to the database.
Nevo David
Nevo Davidβ€’2mo ago
Do you use the normal docker? it's actually try to proxy everything to port 5000
zapoqx
zapoqxβ€’2mo ago
As I said, I did it as per initial guide of docker compose, but through portainer. The Synology method literally cannot do 5432 for whatever reason and that was the only reason I changed as similar to the other post. But to also not work for the same reason based more on the original code with a Raspberry Pi is what got me questioning. or did you mean did I try switching to docker standalone? besides, if I did docker standalone, looking at the information, the issue would be the same thing, is it not? Standalone contains Caddy still. saw there was an update, did a quick check, same error still at exact same spot.
xcons
xconsβ€’2mo ago
Heya Yeah, synology usese port 5432 already for the database Do you need you change the Postgres post in your configuration So, instead of;
DATABASE_URL: "postgresql://postiz-user:postiz-password@postiz-postgres:5432/postiz-db-local"
DATABASE_URL: "postgresql://postiz-user:postiz-password@postiz-postgres:5432/postiz-db-local"
Do this;
DATABASE_URL: "postgresql://postiz-user:postiz-password@postiz-postgres:54321/postiz-db-local"
DATABASE_URL: "postgresql://postiz-user:postiz-password@postiz-postgres:54321/postiz-db-local"
zapoqx
zapoqxβ€’2mo ago
I did already. it is still focused on the port 3000 issue with the error. the overall is it doesn't matter what is done on ports for the postgresql database, the port 3000 that is set by caddy will refuse to connect to the database and it doesn't matter even how direct I guess. I left it to "postiz-postgres" and I changed it to "localhost" and even went with the local network that came up (i.e. if network was set to 172.16.1.4, then I set it as such for that database), it just gives the error as from the attached log (replacing "localhost:5432" with whatever combination that it was pointed to).
xcons
xconsβ€’2mo ago
So, it's not picking up the changed DATABASE_URL then? Are you using Docker Compose? If so, did you do docker compose down and up again?
zapoqx
zapoqxβ€’2mo ago
Continuing on from other thread:
I'm confused, why is the internal Caddy an issue? Let's go back to basics, can you explain your setup?
zapoqx
zapoqxβ€’2mo ago
Here is the base problem... by documentation going by this: https://docs.postiz.com/installation/docker-compose the Postiz Container has an internal Proxy by Caddy. From following along with the launch of the logs, the container does its thing to start to get everything ready. Prisma is used for the Database which I understand. So before anything happens, the database all launch and Caddy has to make and connect the services. Thus from the attached message, what I'm saying is during the creation time, it successfully makes Frontend Service a connected source. However, the Docker-compose.yml example that is provided shows nothing about port 4200, not that it is required to be opened for the docker's sake or anything like that. If I wasn't looking at the document, I would have no idea that there is a port 4200 even called. So moving past that, 4200 is successful and creates the front end that any setup that has a domain name with HTTPS 443 setup to go to the reverse proxy of the http at port 5000 (or theoretically any port that you create at that time for the docker that you can configure) HAS to go through a secondary internal reverse proxy with Caddy that as the coder has zero control over. So we can acknowledge from that point on the Frontend, it creates and is successfully connected. Then Prisma has to use Caddy to make a connection to the backend. Before it can even try to creat the connection, it errors talking about you may have to run $[qe("prisma generate")] for your changes to take effect. Due to that error, it seems it will always fail to try to connect to any postgres port, which in turn will make Caddy fail to connect to port 3000. My idea is, much like 5432 being consumed by Synology, what if the error is more about the port itself being consumed still by something else. Hence why I tried to use a Raspberry Pi with nothing but Portainer setup to do a docker compose. Portainer has one port used and nothing more. 5432 default will work on the Pi cause that pi literally has nothing (though it takes forever to compose). However, it too will have the exact same error when trying to launch Prisma with Caddy. So unless there is a lock on a port somewhere OR there is an extra dependency that for whatever reason isn't being generated on 2 different hardware (1 being Synology but with x86 architecture, 1 with ARM), then its not going to matter what is being used unless I attempt something like the document that mentions a VM Ubuntu setup which seems a bit absurd. So I wanted to try to have Caddy separated out or something to where I can manually check if its a port issue or if its Prisma itself and what in Prisma is causing the error to generate? As long as Prisma errors AFTER the successful creation of port 4200 with connection to front end but before it can even try to connect to the database, it will fail. Also, I realized in there that even if you changed the port of the internal URL according to the end of the log, that code of BACKEND_INTERNAL_URL: "http://localhost:3000" is pointless to mess with because from my assumption, internal caddy is hardcoded to port 3000.
Postiz Documentation
Docker Compose – Postiz Docs
Postiz - Open source social media scheduling tool
zapoqx
zapoqxβ€’2mo ago
as an aside, I also checked the Docker (standalone) version, and it at least does have port configuration which I assume is just exposing port 4200 and port 3000 in the docker itself for the connection, though it seems like more of a "what purpose" if Docker Compose does not have that configuration. So hoping that there would be some kind of different error, I tried exposing those ports manually in Docker Compose and still the exact same error comes up. So Prisma is failing somehow, but I cannot figure out how or why its failing before that connection is made, yet it seems to be successful with the frontend port without issue. and since its not easy to get the logs I want to post... here it is from start of postiz container:
zapoqx
zapoqxβ€’2mo ago
No description
zapoqx
zapoqxβ€’2mo ago
No description
No description
zapoqx
zapoqxβ€’2mo ago
No description
No description
No description
No description
No description
No description
No description
zapoqx
zapoqxβ€’2mo ago
No description
No description
zapoqx
zapoqxβ€’2mo ago
and no, 2 of the images is not posted twice, it errors twice in the log. oh and just as a Double checking element, I can go into the postiz container itself and do a ping check on the created network for the database to ensure it can be reached from Postiz' container. So it can't be a connection error in which it cannot connect to.
Mirza
Mirzaβ€’2mo ago
My question is Prisma’s connection is needed before Caddy is fully initialized?
zapoqx
zapoqxβ€’2mo ago
I did see something about postgres could need a timeout delay to connect and while I tried to see if I could change that in the URL, it didn't seem to matter. So would that be more of a hardcode in the container itself?
Mirza
Mirzaβ€’2mo ago
You tried connect_timeout=x
zapoqx
zapoqxβ€’2mo ago
yep
Mirza
Mirzaβ€’2mo ago
Same error?
zapoqx
zapoqxβ€’2mo ago
yep increased it questioning if it was by ms count, tried to put in a value that should be 1 minute, but the error still comes up and there didn't seem to be a delay of any sort.
xcons
xconsβ€’2mo ago
So, no, Caddy is just handling incomming traffic Prisma is the bit that connects to the Postgres database (connects out from Postiz to Postgres) So, your postgres is probably not running on localhost right, if you're running docker compose "localhost" in the container means "local to the container" Your DATABASE_URL should probably have "postiz-postgres" as the server name
zapoqx
zapoqxβ€’2mo ago
as opposed to... network localhost done that did it original changed it to localhost thinking to go with network localhost still same error
xcons
xconsβ€’2mo ago
Did you do "docker compose down" after changing the values in your docker-compose.yml?
zapoqx
zapoqxβ€’2mo ago
portainer does it automatically when updating the value to save it that is
xcons
xconsβ€’2mo ago
ah okay dokey I've not used portainer yet, but does it have the ability to get a terminal inside the container easily?
zapoqx
zapoqxβ€’2mo ago
portainer has a knack of giving errors at the right time to know if there is an issue with the code itself. yep
xcons
xconsβ€’2mo ago
Okay, go do that, let's do some debugging Can you run the command env | grep -i DATABASE for me inside the container, and show me the screenshot of the output?
zapoqx
zapoqxβ€’2mo ago
give me a sec.
xcons
xconsβ€’2mo ago
No worries
zapoqx
zapoqxβ€’2mo ago
so you want it in the postiz container or the postgres portion of the container?
xcons
xconsβ€’2mo ago
Inside the Postiz container please πŸ™‚
zapoqx
zapoqxβ€’2mo ago
No description
zapoqx
zapoqxβ€’2mo ago
realized I put in a different user name and password just to see if it needed to be done so censored that.
xcons
xconsβ€’2mo ago
hmm, that's interesting, so it certainly looks like that is correct for the hostname Now can you run nc -vz postiz-postgres:5439 for me?
zapoqx
zapoqxβ€’2mo ago
k. nothing returned... guess I'll check the logs? nothing changed in logs either
xcons
xconsβ€’2mo ago
hmm, that means it cannot connect to that server on that port - nc is "net cat" Did you deliberately start the Postgres container on a different port? The default is 5432
zapoqx
zapoqxβ€’2mo ago
I do see them in their own network container under currently 172.22.0.X on synology yes
xcons
xconsβ€’2mo ago
Ah right, as something on Synology uses that port already?
zapoqx
zapoqxβ€’2mo ago
I believe its own app has something on that port which is why it fails
xcons
xconsβ€’2mo ago
Sure, sure. Let's try redis;
zapoqx
zapoqxβ€’2mo ago
on raspberry pi, I can confirm default port does not error on creation of the container, but still has same error which was why I was questioning something
xcons
xconsβ€’2mo ago
nc -vz postiz-redis 6379
zapoqx
zapoqxβ€’2mo ago
ok postiz-redis:6379 (172.22.0.3:6379) open
xcons
xconsβ€’2mo ago
Okay dokey, that's good! So let's go look at your postgres container, I assume Portainer says that is running all OK?
zapoqx
zapoqxβ€’2mo ago
everything is healthy
xcons
xconsβ€’2mo ago
Can you get a shell on that container as well?
zapoqx
zapoqxβ€’2mo ago
yep currently in
xcons
xconsβ€’2mo ago
apt-get update && apt-get install iproute2 and then;
ss -ntaupe | grep -i LISTEN
ss -ntaupe | grep -i LISTEN
zapoqx
zapoqxβ€’2mo ago
huh... I was already questioning if I could do that but got my answer in typing. but maybe that command might still work ok I was hopeful
xcons
xconsβ€’2mo ago
Yeah, I want to see is Postgres is listening on the right port properly. We want to see a line like;
tcp LISTEN 0 244 0.0.0.0:5432
tcp LISTEN 0 244 0.0.0.0:5432
zapoqx
zapoqxβ€’2mo ago
apt-get isn't found in the postgres container kinda makes sense
xcons
xconsβ€’2mo ago
oh, it is there in the postgres container we recommend What image is that container using?
zapoqx
zapoqxβ€’2mo ago
image: postgres:17-alpine
xcons
xconsβ€’2mo ago
ook someone changed that lol
Mirza
Mirzaβ€’2mo ago
Bro did you allow "trust" in pg_hba.conf
xcons
xconsβ€’2mo ago
Okay, no problem apk add iproute2 should work I'm assuming the alpine image does that by default but I'll check that, at the moment we've got no network connection to postgres, so we'll troubleshoot that later if it's an issue
zapoqx
zapoqxβ€’2mo ago
ok, yep, that did it...
tcp LISTEN 0 128 0.0.0.0:5432 0.0.0.0:* uid:70 ino:115404023 sk:1 <->
tcp LISTEN 0 128 127.0.0.11:43513 0.0.0.0:* ino:115402351 sk:2 <->
tcp LISTEN 0 128 [::]:5432 [::]:* uid:70 ino:115404024 sk:3 v6only:1 <->
tcp LISTEN 0 128 0.0.0.0:5432 0.0.0.0:* uid:70 ino:115404023 sk:1 <->
tcp LISTEN 0 128 127.0.0.11:43513 0.0.0.0:* ino:115402351 sk:2 <->
tcp LISTEN 0 128 [::]:5432 [::]:* uid:70 ino:115404024 sk:3 v6only:1 <->
xcons
xconsβ€’2mo ago
Okay dokey, your postgres is listening on the default port inside the container, all good So now, let's take a look at the "ports" definition of the container in Portainer It should be 5439:5432 hopefully
zapoqx
zapoqxβ€’2mo ago
erm
xcons
xconsβ€’2mo ago
I don't have a portainer installation to check, so maybe a screenshot of that or whatever?
zapoqx
zapoqxβ€’2mo ago
no? I did same to same
xcons
xconsβ€’2mo ago
Ah, theres your problem then πŸ™‚
zapoqx
zapoqxβ€’2mo ago
hrm...
xcons
xconsβ€’2mo ago
Inside the container, it's running port 5432, that's fine, as it's not listening publicly on your synology However you want to access it on a different external port (5439), so you change that in the port mapping So, in Portainer, change the port assignment to "5439:5432", and restart the Postgres container.
zapoqx
zapoqxβ€’2mo ago
ok, but then in theory, should it have worked out the gate then on the raspberry pi when the port wasn't changed and it was 1:1 on the port (5432:5432) k, making the change.
xcons
xconsβ€’2mo ago
Sure - you're talking about two different servers here right, the synology and a rpi?
zapoqx
zapoqxβ€’2mo ago
yea I mean hey, I gotta try all avenues before reporting my problems
xcons
xconsβ€’2mo ago
Okay, well we could possibly fix that rpi later, but let's just keep to one server for now otherwise things will get confusing πŸ™‚ Did you manage to change the port assignment and restart the postiz-postres container now?
zapoqx
zapoqxβ€’2mo ago
also tends to take 2.5 minutes on a pi to get any updates done. Anyways... its up... looking at logs no error still there
xcons
xconsβ€’2mo ago
Okay, don't worry about the logs right now, we'll need to restart Postiz in a minute anyway Get a terminal back on the Postiz container and run nc -vz postiz-postgres:5439 for me Hopefully we'll see a "open" message.
zapoqx
zapoqxβ€’2mo ago
negative
xcons
xconsβ€’2mo ago
insert sad music Okay, what do you see instead?
zapoqx
zapoqxβ€’2mo ago
its a simple return?
xcons
xconsβ€’2mo ago
Like, no output?
zapoqx
zapoqxβ€’2mo ago
f91cb146ddac:/app# nc -vz postiz-postgres:5439
f91cb146ddac:/app#
f91cb146ddac:/app# nc -vz postiz-postgres:5439
f91cb146ddac:/app#
like I'd appreciate something even if there is no value to return but it looks more like a script execution at that point no verbose anyways, enough of my rambling.
xcons
xconsβ€’2mo ago
hmm, so that's very odd, here's what you should see
be1c6a06d550:/app# nc -vz postiz-postgres 5432
postiz-postgres (172.18.0.2:5432) open
be1c6a06d550:/app# nc -vz postiz-postgres 5432
postiz-postgres (172.18.0.2:5432) open
zapoqx
zapoqxβ€’2mo ago
right and it would make sense
xcons
xconsβ€’2mo ago
Just incase, try a space between the host and port, incase it doesn't like the :
zapoqx
zapoqxβ€’2mo ago
still no
xcons
xconsβ€’2mo ago
Okay, let's check something that obviously should work; nc -vz google.com 80 and also; ping postiz-postgres
zapoqx
zapoqxβ€’2mo ago
f91cb146ddac:/app# nc -vz postiz-postgres 5439
f91cb146ddac:/app# nc -vz google.com 80
google.com (142.250.68.238:80) open
f91cb146ddac:/app#
f91cb146ddac:/app# nc -vz postiz-postgres 5439
f91cb146ddac:/app# nc -vz google.com 80
google.com (142.250.68.238:80) open
f91cb146ddac:/app#
xcons
xconsβ€’2mo ago
Okay, and the ping?
zapoqx
zapoqxβ€’2mo ago
f91cb146ddac:/app# ping postiz-postgres
PING postiz-postgres (172.22.0.2): 56 data bytes
64 bytes from 172.22.0.2: seq=0 ttl=64 time=0.075 ms
64 bytes from 172.22.0.2: seq=1 ttl=64 time=0.089 ms
64 bytes from 172.22.0.2: seq=2 ttl=64 time=0.082 ms
64 bytes from 172.22.0.2: seq=3 ttl=64 time=0.089 ms
64 bytes from 172.22.0.2: seq=4 ttl=64 time=0.083 ms
64 bytes from 172.22.0.2: seq=5 ttl=64 time=0.082 ms
64 bytes from 172.22.0.2: seq=6 ttl=64 time=0.088 ms
64 bytes from 172.22.0.2: seq=7 ttl=64 time=0.102 ms
64 bytes from 172.22.0.2: seq=8 ttl=64 time=0.079 ms
^X64 bytes from 172.22.0.2: seq=9 ttl=64 time=0.081 ms
^Z
[1]+ Stopped ping postiz-postgres
f91cb146ddac:/app#
f91cb146ddac:/app# ping postiz-postgres
PING postiz-postgres (172.22.0.2): 56 data bytes
64 bytes from 172.22.0.2: seq=0 ttl=64 time=0.075 ms
64 bytes from 172.22.0.2: seq=1 ttl=64 time=0.089 ms
64 bytes from 172.22.0.2: seq=2 ttl=64 time=0.082 ms
64 bytes from 172.22.0.2: seq=3 ttl=64 time=0.089 ms
64 bytes from 172.22.0.2: seq=4 ttl=64 time=0.083 ms
64 bytes from 172.22.0.2: seq=5 ttl=64 time=0.082 ms
64 bytes from 172.22.0.2: seq=6 ttl=64 time=0.088 ms
64 bytes from 172.22.0.2: seq=7 ttl=64 time=0.102 ms
64 bytes from 172.22.0.2: seq=8 ttl=64 time=0.079 ms
^X64 bytes from 172.22.0.2: seq=9 ttl=64 time=0.081 ms
^Z
[1]+ Stopped ping postiz-postgres
f91cb146ddac:/app#
xcons
xconsβ€’2mo ago
huh. confused face
zapoqx
zapoqxβ€’2mo ago
I do agree though that if this is solved, then in theory it should resolve on any other platform using portainer
xcons
xconsβ€’2mo ago
Okay, so here's where we are, postiz cannot apply the database migrations because it cannot talk to the database. We thought it was a closed port / wrong port, and found it was, and we changed it. You can ping from the app to teh database, but it's still unable to talk to the database on that port.
zapoqx
zapoqxβ€’2mo ago
correct
xcons
xconsβ€’2mo ago
Okay, can you ssh do the server running Portainer for me now, and run docker inspect postiz-postgres | grep -i port -B 5
zapoqx
zapoqxβ€’2mo ago
well I gotta open the SSH port for that first.
xcons
xconsβ€’2mo ago
^^ I was just stating where we'd got to, just making sure you knew where we were. Ah sorry :-(, is that OK to do?
zapoqx
zapoqxβ€’2mo ago
prefer not to for too long but yes.
xcons
xconsβ€’2mo ago
Thanks, I need to validate that the Postgres container really is running on the right port.
zapoqx
zapoqxβ€’2mo ago
but that is my internal security side of me screaming.
xcons
xconsβ€’2mo ago
SSH itself is very secure πŸ™‚
zapoqx
zapoqxβ€’2mo ago
oh yea, but its the possibility of it being seen is why it screams anyways interesting
Mirza
Mirzaβ€’2mo ago
?
xcons
xconsβ€’2mo ago
I have a guess that Portainer is cheating you πŸ˜›
zapoqx
zapoqxβ€’2mo ago
Got permission denied while trying to connect to the Docker daemon socket at unix:///var/run/docker.sock: Get "http://%2Fvar%2Frun%2Fdocker.sock/v1.24/containers/postiz-postgres/json": dial unix /var/run/docker.sock: connect: permission denied
Got permission denied while trying to connect to the Docker daemon socket at unix:///var/run/docker.sock: Get "http://%2Fvar%2Frun%2Fdocker.sock/v1.24/containers/postiz-postgres/json": dial unix /var/run/docker.sock: connect: permission denied
xcons
xconsβ€’2mo ago
Ah, I assume you're not root - sudo su?
Mirza
Mirzaβ€’2mo ago
Bro when did you last restart your Synology?
zapoqx
zapoqxβ€’2mo ago
unless I need to sudo.
xcons
xconsβ€’2mo ago
Yeah, docker requires root.
zapoqx
zapoqxβ€’2mo ago
actually 3 days ago πŸ™‚ ok, let me try that again.
docker inspect postiz-postgres | grep -i port -B 5
"LogConfig": {
"Type": "db",
"Config": {}
},
"NetworkMode": "postiz_postiz-network",
"PortBindings": {
"5432/tcp": [
{
"HostIp": "",
"HostPort": "5439"
--
"Cgroup": "",
"Links": null,
"OomScoreAdj": 0,
"PidMode": "",
"Privileged": false,
"PublishAllPorts": false,
--
"Domainname": "",
"User": "",
"AttachStdin": false,
"AttachStdout": true,
"AttachStderr": true,
"ExposedPorts": {
--
"Bridge": "",
"SandboxID": "0d3fd756e5db58a4a0b1555f3e2def9d6c312a59e3f545421aa8aaf33a7e3c17",
"HairpinMode": false,
"LinkLocalIPv6Address": "",
"LinkLocalIPv6PrefixLen": 0,
"Ports": {
"5432/tcp": [
{
"HostIp": "0.0.0.0",
"HostPort": "5439"
},
{
"HostIp": "::",
"HostPort": "5439"
docker inspect postiz-postgres | grep -i port -B 5
"LogConfig": {
"Type": "db",
"Config": {}
},
"NetworkMode": "postiz_postiz-network",
"PortBindings": {
"5432/tcp": [
{
"HostIp": "",
"HostPort": "5439"
--
"Cgroup": "",
"Links": null,
"OomScoreAdj": 0,
"PidMode": "",
"Privileged": false,
"PublishAllPorts": false,
--
"Domainname": "",
"User": "",
"AttachStdin": false,
"AttachStdout": true,
"AttachStderr": true,
"ExposedPorts": {
--
"Bridge": "",
"SandboxID": "0d3fd756e5db58a4a0b1555f3e2def9d6c312a59e3f545421aa8aaf33a7e3c17",
"HairpinMode": false,
"LinkLocalIPv6Address": "",
"LinkLocalIPv6PrefixLen": 0,
"Ports": {
"5432/tcp": [
{
"HostIp": "0.0.0.0",
"HostPort": "5439"
},
{
"HostIp": "::",
"HostPort": "5439"
xcons
xconsβ€’2mo ago
Okay, damn, that looks like the right port. I'm confused why nc is not giving you any output though.
zapoqx
zapoqxβ€’2mo ago
i'd love to at least have some kind of verbose log to why but...
xcons
xconsβ€’2mo ago
Okay, well that is a bit of a mystery, but at least the container appears to be running on the right port.
zapoqx
zapoqxβ€’2mo ago
correct
xcons
xconsβ€’2mo ago
Just while you're there, docker inspect postiz-app | grep -i networkmode
Mirza
Mirzaβ€’2mo ago
Yeah no blame to candy
zapoqx
zapoqxβ€’2mo ago
er, should it be postiz?
xcons
xconsβ€’2mo ago
Sorry, yep
zapoqx
zapoqxβ€’2mo ago
"NetworkMode": "postiz_postiz-network",
"NetworkMode": "postiz_postiz-network",
xcons
xconsβ€’2mo ago
Okay, all good there. I don't think there's anything else we need to test from here, you can close that SSH session and block SSH again if you like. Let's try a full restart of Postiz, and have a full read of it's startup logs. I need you to do effectively a docker compose down postiz and docker compose up postiz if you can do the same as that from the Portainer web interface, and then see the logs from the startup Importantly I want you to recreate that Postiz container (which compose down / compose up will do)
zapoqx
zapoqxβ€’2mo ago
hmmm so I have it as a Stack in portainer so effectively doing manually would make them their own containers rather than grouped.
xcons
xconsβ€’2mo ago
Okay, basically we want to make sure the Postiz container is deleted and created again new. Do you have to stop the whole stack and then restart the whole stack again?
Mirza
Mirzaβ€’2mo ago
I'm excited to see culprit
xcons
xconsβ€’2mo ago
Or, stop, delete, start? I'm gonna brb 10 mins
zapoqx
zapoqxβ€’2mo ago
well yes, I do, but when you mentioned just the container, I went to the container itself to see if I can simply recreate it while being part of the stack. Never tried it that way, but seeing welp...
zapoqx
zapoqxβ€’2mo ago
Mirza
Mirzaβ€’2mo ago
Again
xcons
xconsβ€’2mo ago
Okay, so at least it's definately trying to get to the right address. Let's see if Portainer is doing something funny with networking, can you get a shell on the postiz-postgres container please? Then run apk add nc && nc -vz postiz 5000
zapoqx
zapoqxβ€’2mo ago
postiz (172.22.0.4:5000) open
xcons
xconsβ€’2mo ago
Okay, phew So the DB can talk to the app (specifically, caddy) But the app can't talk to the DB
zapoqx
zapoqxβ€’2mo ago
correct
xcons
xconsβ€’2mo ago
Let's sanity check again, let's get a terminal back on the postiz container nc -vz postiz-postgres 5432 (should not work) and nc -vz postiz-postgres 5439 (should work, but didn't before)
zapoqx
zapoqxβ€’2mo ago
f91cb146ddac:/app# nc -vz postiz-postgres 5432
postiz-postgres (172.22.0.2:5432) open
f91cb146ddac:/app# nc -vz postiz-postgres 5439
f91cb146ddac:/app#
f91cb146ddac:/app# nc -vz postiz-postgres 5432
postiz-postgres (172.22.0.2:5432) open
f91cb146ddac:/app# nc -vz postiz-postgres 5439
f91cb146ddac:/app#
xcons
xconsβ€’2mo ago
wait what
zapoqx
zapoqxβ€’2mo ago
I know your confusion
Mirza
Mirzaβ€’2mo ago
Yes 5432
xcons
xconsβ€’2mo ago
err confused face what lol
Mirza
Mirzaβ€’2mo ago
Bro you need a quick reboot i think What's your OS
xcons
xconsβ€’2mo ago
No no, don't reboot
zapoqx
zapoqxβ€’2mo ago
I can, but I don't think its gonna change anything.
xcons
xconsβ€’2mo ago
Nah, I don't think so either. Also, in the off chance that it does, we don't want to reset the state of everyting *everything
Mirza
Mirzaβ€’2mo ago
Did you check you might be running some other containers in background
xcons
xconsβ€’2mo ago
So, I'm confused, we checked that postiz-postgres container definition, we saw it was running in port 5439, however nc is saying that it's not, and it's running in port 5432 - the default I wondered if it's actually getting to the postgres on your synology, but it's not, because 172.22.0.2 is deffo a container IP
Mirza
Mirzaβ€’2mo ago
.3 is your pi ?
xcons
xconsβ€’2mo ago
Actually, can you check the IP address of the postiz-postgres container? Validate that it really is 172.22.0.2?
zapoqx
zapoqxβ€’2mo ago
I'd also like to point out that error, while currently on Synology (7.2.1), and earlier, I mentioned I did the same setup but more default on a Raspberry Pi 5, both were restarted at the same time, but the exact error that comes up is the only common point.
xcons
xconsβ€’2mo ago
Yeah, you real error is this;
Prisma schema loaded from schema.prisma
Datasource "db": PostgreSQL database "wdblocal", schema "public" at "postiz-postgres:5439"
Error: P1001: Can't reach database server at `postiz-postgres:5439`
Prisma schema loaded from schema.prisma
Datasource "db": PostgreSQL database "wdblocal", schema "public" at "postiz-postgres:5439"
Error: P1001: Can't reach database server at `postiz-postgres:5439`
It goes on to try and start Postiz later, but that won't work because of the previous error.
zapoqx
zapoqxβ€’2mo ago
exactly so something is specific to this container itself (imo) but trust me, as also done QA work before and annoyed devs to no end, I'm honestly enjoying this trying to figure out the why me approach here.
xcons
xconsβ€’2mo ago
Again just to checkpoint where we are, I don't see anything like a Postiz or Postgres bug or anything here, we're just dealing with a basic network problem, where the app isn't connecting to the database - because weirdly the DB looks like it's running on the wrong port.
zapoqx
zapoqxβ€’2mo ago
ports:
- 5439:5432
ports:
- 5439:5432
Correctly set
xcons
xconsβ€’2mo ago
^^ No problem, I'm a dev and I've done a lot of sysadmin, just as long as we follow one thing at a time and keep communicating I'll help you all night πŸ˜„ But I am properly confused as to why the container is on the "wrong" port.
Mirza
Mirzaβ€’2mo ago
That's why I asked
xcons
xconsβ€’2mo ago
Okay, let's see, can you get the current IP address of the postiz-postgres container? Let's validate that really is 172.22.0.2
zapoqx
zapoqxβ€’2mo ago
well lets just make it easy with this:
No description
zapoqx
zapoqxβ€’2mo ago
(I added 4200 and 3000 to postiz just as an experiment)
xcons
xconsβ€’2mo ago
Sure, port 5000 is what we really want, not 4200 or 3000, but they're not causing problems Everything there looks sane to me But this does not look sane, I am very confused.
Mirza
Mirzaβ€’2mo ago
😢
zapoqx
zapoqxβ€’2mo ago
I get what you're asking, but I don't know what you're talking about there as trusting a file from where to what? if you're asking from the folder for the container, I didn't set any specific things yet as I didn't see anything specific that required any specialty permissions
Mirza
Mirzaβ€’2mo ago
It's just a config file of postgresql to allow network
zapoqx
zapoqxβ€’2mo ago
hm
xcons
xconsβ€’2mo ago
I don't think that's the problem here, if that was not setup correctly we'd probably get a connection denied when connecting to postgres, not connection unreachable. However, I'm currently not quite sure what to try. Let's get a shell on the postiz-postgres container, and run; tail -n 15 /var/lib/postgresql/data/pg_hba.conf
Mirza
Mirzaβ€’2mo ago
Yes you are right boss
zapoqx
zapoqxβ€’2mo ago
No description
zapoqx
zapoqxβ€’2mo ago
normally I would find something in a docker-capable app if it needs special permissions so this is default on its own
Mirza
Mirzaβ€’2mo ago
That's good But still we have some network issue here lol
xcons
xconsβ€’2mo ago
brb few mins
zapoqx
zapoqxβ€’2mo ago
fe5558d990c0:/# tail -n 15 /var/lib/postgresql/data/pg_hba.conf
# TYPE DATABASE USER ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
local replication all trust
host replication all 127.0.0.1/32 trust
host replication all ::1/128 trust

host all all all scram-sha-256
fe5558d990c0:/# tail -n 15 /var/lib/postgresql/data/pg_hba.conf
# TYPE DATABASE USER ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
local replication all trust
host replication all 127.0.0.1/32 trust
host replication all ::1/128 trust

host all all all scram-sha-256
With that, I need a few min break myself. 10 min
xcons
xconsβ€’2mo ago
Yeah, that all looks normal. Sure, speak in 10.
Mirza
Mirzaβ€’2mo ago
Update
zapoqx
zapoqxβ€’2mo ago
back ready whenever you are
xcons
xconsβ€’2mo ago
Sorry, didn't see that you came back πŸ™‚
zapoqx
zapoqxβ€’2mo ago
no worries
xcons
xconsβ€’2mo ago
So, the postiz-postgres container is still not accessible on the expected port 5439, but is on 5432.
zapoqx
zapoqxβ€’2mo ago
yep
xcons
xconsβ€’2mo ago
My instinct is that the container port mapping isn't working, but we checked that on the running container with the docker inspect, and it showed a host port of 5439. Like all these things, I bet it's something very simple actually. It's a typo that we're not seeing, or similar. Can you dump me your current running docker-compose again please? Let me check that, top to bottom.
zapoqx
zapoqxβ€’2mo ago
let me sanitize it slightly
xcons
xconsβ€’2mo ago
Sure thing, most important really is the social media API keys - don't post them obviously.
zapoqx
zapoqxβ€’2mo ago
oh I didn't get there yet to know fully about that when I couldn't make an account which is where we all started XD
services:
postiz:
image: ghcr.io/gitroomhq/postiz-app:latest
container_name: postiz
restart: always
environment:
TZ: America/Phoenix
PUID: 1026
PGID: 100
# You must change these. Replace `postiz.your-server.com` with your DNS name - what your web browser sees.
MAIN_URL: "https://postiz.domain.com"
FRONTEND_URL: "https://postiz.domain.com"
NEXT_PUBLIC_BACKEND_URL: "https://postiz.domain.com/api"
JWT_SECRET: "longsecretcodeishere"

# These defaults are probably fine, but if you change your user/password, update it in the
# postiz-postgres or postiz-redis services below.
DATABASE_URL: "postgresql://pguser:pgpass@postiz-postgres:5439/wdblocal"
REDIS_URL: "redis://postiz-redis:6379"
BACKEND_INTERNAL_URL: "http://localhost:3000"
IS_GENERAL: "true" # Required for self-hosting.
# The container images are pre-configured to use /uploads for file storage.
# You probably should not change this unless you have a really good reason!
STORAGE_PROVIDER: "local"
UPLOAD_DIRECTORY: "/uploads"
NEXT_PUBLIC_UPLOAD_DIRECTORY: "/uploads"

# Mail
EMAIL_PROVIDER: "nodemailer"
EMAIL_HOST: "mail.domain.com" # smtp host if you choose nodemailer
EMAIL_PORT: "465" # smtp port if you choose nodemailer
EMAIL_SECURE: "true" # smtp secure if you choose nodemailer
EMAIL_USER: "muser" # smtp user if you choose nodemailer
EMAIL_PASS: "mpassword" # smtp pass if you choose nodemailer
volumes:
- /volume2/docker/postiz/config:/config:rw
- /volume2/docker/postiz/uploads:/uploads:rw
ports:
- 5000:5000
- 4200:4200
- 3000:3000
networks:
- postiz-network
depends_on:
postiz-postgres:
condition: service_healthy
postiz-redis:
condition: service_healthy

postiz-postgres:
image: postgres:17-alpine
container_name: postiz-postgres
restart: always
environment:
POSTGRES_PASSWORD: pgpass
POSTGRES_USER: pguser
POSTGRES_DB: wdblocal
volumes:
- /volume2/docker/postiz/postgresql/data:/var/lib/postgresql/data:rw
ports:
- 5439:5432
networks:
- postiz-network
healthcheck:
test: pg_isready -U pguser -d wdblocal
interval: 10s
timeout: 3s
retries: 3

postiz-redis:
image: redis:7.2
container_name: postiz-redis
restart: always
ports:
- 6379:6379
healthcheck:
test: redis-cli ping
interval: 10s
timeout: 3s
retries: 3
volumes:
- /volume2/docker/postiz/data:/data:rw
networks:
- postiz-network


#volumes:
# postgres-volume:
# external: false

# postiz-redis-data:
# external: false

# postiz-config:
# external: false

# postiz-uploads:
# external: false

networks:
postiz-network:
external: false
services:
postiz:
image: ghcr.io/gitroomhq/postiz-app:latest
container_name: postiz
restart: always
environment:
TZ: America/Phoenix
PUID: 1026
PGID: 100
# You must change these. Replace `postiz.your-server.com` with your DNS name - what your web browser sees.
MAIN_URL: "https://postiz.domain.com"
FRONTEND_URL: "https://postiz.domain.com"
NEXT_PUBLIC_BACKEND_URL: "https://postiz.domain.com/api"
JWT_SECRET: "longsecretcodeishere"

# These defaults are probably fine, but if you change your user/password, update it in the
# postiz-postgres or postiz-redis services below.
DATABASE_URL: "postgresql://pguser:pgpass@postiz-postgres:5439/wdblocal"
REDIS_URL: "redis://postiz-redis:6379"
BACKEND_INTERNAL_URL: "http://localhost:3000"
IS_GENERAL: "true" # Required for self-hosting.
# The container images are pre-configured to use /uploads for file storage.
# You probably should not change this unless you have a really good reason!
STORAGE_PROVIDER: "local"
UPLOAD_DIRECTORY: "/uploads"
NEXT_PUBLIC_UPLOAD_DIRECTORY: "/uploads"

# Mail
EMAIL_PROVIDER: "nodemailer"
EMAIL_HOST: "mail.domain.com" # smtp host if you choose nodemailer
EMAIL_PORT: "465" # smtp port if you choose nodemailer
EMAIL_SECURE: "true" # smtp secure if you choose nodemailer
EMAIL_USER: "muser" # smtp user if you choose nodemailer
EMAIL_PASS: "mpassword" # smtp pass if you choose nodemailer
volumes:
- /volume2/docker/postiz/config:/config:rw
- /volume2/docker/postiz/uploads:/uploads:rw
ports:
- 5000:5000
- 4200:4200
- 3000:3000
networks:
- postiz-network
depends_on:
postiz-postgres:
condition: service_healthy
postiz-redis:
condition: service_healthy

postiz-postgres:
image: postgres:17-alpine
container_name: postiz-postgres
restart: always
environment:
POSTGRES_PASSWORD: pgpass
POSTGRES_USER: pguser
POSTGRES_DB: wdblocal
volumes:
- /volume2/docker/postiz/postgresql/data:/var/lib/postgresql/data:rw
ports:
- 5439:5432
networks:
- postiz-network
healthcheck:
test: pg_isready -U pguser -d wdblocal
interval: 10s
timeout: 3s
retries: 3

postiz-redis:
image: redis:7.2
container_name: postiz-redis
restart: always
ports:
- 6379:6379
healthcheck:
test: redis-cli ping
interval: 10s
timeout: 3s
retries: 3
volumes:
- /volume2/docker/postiz/data:/data:rw
networks:
- postiz-network


#volumes:
# postgres-volume:
# external: false

# postiz-redis-data:
# external: false

# postiz-config:
# external: false

# postiz-uploads:
# external: false

networks:
postiz-network:
external: false
xcons
xconsβ€’2mo ago
Okay let's have a read It's not related here, but note that PUID and PGID won't work in the postiz image. Those are LSIO (linuxserver.io) conventions.
zapoqx
zapoqxβ€’2mo ago
Got used to it was all
xcons
xconsβ€’2mo ago
No worries. You also don't need;
- 4200:4200
- 3000:3000
- 4200:4200
- 3000:3000
zapoqx
zapoqxβ€’2mo ago
ya had that added in just in case if it made a difference before today but removed
xcons
xconsβ€’2mo ago
hmm, it all looks fine though Okay, I'm going to try and run this on a clean VM myself
zapoqx
zapoqxβ€’2mo ago
k
xcons
xconsβ€’2mo ago
OK! I have the same error with your docker compose
zapoqx
zapoqxβ€’2mo ago
on one hand... excellent
xcons
xconsβ€’2mo ago
That's very good, I can debug much easier this way It's okay, I didn't want to sleep tonight πŸ˜›
zapoqx
zapoqxβ€’2mo ago
Hah who knows, I may not sleep much myself.
xcons
xconsβ€’2mo ago
Same behavior;
555b3697f38f:/app# nc -vz postiz-postgres 5432
postiz-postgres (172.18.0.2:5432) open
555b3697f38f:/app# nc -vz postiz-postgres 5439
555b3697f38f:/app# nc -vz postiz-postgres 5432
postiz-postgres (172.18.0.2:5432) open
555b3697f38f:/app# nc -vz postiz-postgres 5439
zapoqx
zapoqxβ€’2mo ago
been cleaning up to put a new monitor in.
xcons
xconsβ€’2mo ago
It's going to be a typo somewhere I'm betting
zapoqx
zapoqxβ€’2mo ago
hmmm k so at least you can replicate it
xcons
xconsβ€’2mo ago
ohhh I wonderrrrrrrr
zapoqx
zapoqxβ€’2mo ago
???
xcons
xconsβ€’2mo ago
Yeah I think I've got it, just fixing something with my https setup to check I can create a user
zapoqx
zapoqxβ€’2mo ago
k
xcons
xconsβ€’2mo ago
Okay, so, I learned something about docker compose this evening. The problem is that "ports" is ignored in this context
zapoqx
zapoqxβ€’2mo ago
I... wat
xcons
xconsβ€’2mo ago
Because they're all on the same network - the "ports" part is for connecting ports on the host to the container
Mirza
Mirzaβ€’2mo ago
Hey bro try test: ["CMD", "pg_isready", "-U", "pguser", "-d", "wdblocal"] Instead test: pg_isready -U pguser -d wdblocal
xcons
xconsβ€’2mo ago
However, for container to container networking, it's ignored
Mirza
Mirzaβ€’2mo ago
Ooooh
xcons
xconsβ€’2mo ago
On a technical level, containers in docker compose is the same newwork share the same "network" namespace, but not the same "uts" namespace Meaning they each have their own localhost, and hostnames
zapoqx
zapoqxβ€’2mo ago
O_O
xcons
xconsβ€’2mo ago
And they'd each have their own IP address as well (that happens anyway)
Mirza
Mirzaβ€’2mo ago
🫠
xcons
xconsβ€’2mo ago
But they're all sharing the same ports
zapoqx
zapoqxβ€’2mo ago
so localhost in one container in this context is not the same as localhost in another container
xcons
xconsβ€’2mo ago
Or on a technical level, the same "port namespace" Yeah, because they have separate "uts" namespaces
Mirza
Mirzaβ€’2mo ago
Docker thing
zapoqx
zapoqxβ€’2mo ago
I was looking for a localhost within the network, but really was looking within this defined space >_>
xcons
xconsβ€’2mo ago
So, the solution to your problem is actually ridicuslously simple, and I should update the docker compose examples
Mirza
Mirzaβ€’2mo ago
Now I can sleep in peace πŸ•ŠοΈβœŒοΈ
xcons
xconsβ€’2mo ago
Simply use port "5432" in DATABASE_URL and remove "ports" for the postgres container and redis container - they're not actually being used at all Infact, it's actually a security issue, because it's exposing them on the "external" network when they don't need to be
zapoqx
zapoqxβ€’2mo ago
ok
xcons
xconsβ€’2mo ago
uggh Thanks for your patience this evening/this afternoon
Mirza
Mirzaβ€’2mo ago
GN
xcons
xconsβ€’2mo ago
Let me know of course if that works - but just on the postiz container;
ports:
- 5000:5000
ports:
- 5000:5000
and set "5432" in DATABASE_URL and stop/recreate/start everything
zapoqx
zapoqxβ€’2mo ago
understood should I still add the code change: test: ["CMD", "pg_isready", "-U", "pguser", "-d", "wdblocal"]
Mirza
Mirzaβ€’2mo ago
Try if you don't get it run But I think it will perfectly run
xcons
xconsβ€’2mo ago
There's a healthcheck: defined on the postiz-postgres container anyway
zapoqx
zapoqxβ€’2mo ago
woah guess its time to test if I can actually make an account then
Mirza
Mirzaβ€’2mo ago
It worked bro πŸ˜…
zapoqx
zapoqxβ€’2mo ago
lol it went through cleanly in the logs yes, only having this pop up:
[Nest] 183 - 11/02/2024, 6:00:38 PM WARN [Configuration issue] CLOUDFLARE_ACCOUNT_ID not set. Needed to setup providers.

[Nest] 183 - 11/02/2024, 6:00:38 PM WARN [Configuration issue] CLOUDFLARE_ACCESS_KEY not set. Needed to setup providers.

[Nest] 183 - 11/02/2024, 6:00:38 PM WARN [Configuration issue] CLOUDFLARE_SECRET_ACCESS_KEY not set. Needed to setup providers.

[Nest] 183 - 11/02/2024, 6:00:38 PM WARN [Configuration issue] CLOUDFLARE_BUCKETNAME not set. Needed to setup providers.

[Nest] 183 - 11/02/2024, 6:00:38 PM WARN [Configuration issue] CLOUDFLARE_BUCKET_URL not set. Needed to setup providers.

[Nest] 183 - 11/02/2024, 6:00:38 PM WARN [Configuration issue] CLOUDFLARE_REGION not set. Needed to setup providers.

[Nest] 183 - 11/02/2024, 6:00:38 PM WARN Configuration issues found: 6

[Nest] 183 - 11/02/2024, 6:00:38 PM LOG :rocket: Backend is running on: http://localhost:3000

2024-11-03 01:00:41,375 INFO success: backend entered RUNNING state, process has stayed up for > than 10 seconds (startsecs)
[Nest] 183 - 11/02/2024, 6:00:38 PM WARN [Configuration issue] CLOUDFLARE_ACCOUNT_ID not set. Needed to setup providers.

[Nest] 183 - 11/02/2024, 6:00:38 PM WARN [Configuration issue] CLOUDFLARE_ACCESS_KEY not set. Needed to setup providers.

[Nest] 183 - 11/02/2024, 6:00:38 PM WARN [Configuration issue] CLOUDFLARE_SECRET_ACCESS_KEY not set. Needed to setup providers.

[Nest] 183 - 11/02/2024, 6:00:38 PM WARN [Configuration issue] CLOUDFLARE_BUCKETNAME not set. Needed to setup providers.

[Nest] 183 - 11/02/2024, 6:00:38 PM WARN [Configuration issue] CLOUDFLARE_BUCKET_URL not set. Needed to setup providers.

[Nest] 183 - 11/02/2024, 6:00:38 PM WARN [Configuration issue] CLOUDFLARE_REGION not set. Needed to setup providers.

[Nest] 183 - 11/02/2024, 6:00:38 PM WARN Configuration issues found: 6

[Nest] 183 - 11/02/2024, 6:00:38 PM LOG :rocket: Backend is running on: http://localhost:3000

2024-11-03 01:00:41,375 INFO success: backend entered RUNNING state, process has stayed up for > than 10 seconds (startsecs)
xcons
xconsβ€’2mo ago
wooop Yeah I need to fix that, it can safely be ignored
Mirza
Mirzaβ€’2mo ago
I think for now you can ignore that warning ⚠️
xcons
xconsβ€’2mo ago
Yeah I added it in months ago when we were depending on CloudFlare
Mirza
Mirzaβ€’2mo ago
Nice I learned something new today Docker Sucks πŸ˜‚
xcons
xconsβ€’2mo ago
Wellllll, I've been using Docker since 2015 when it was basically pre 1.0, and I never knew this worked like it did πŸ˜„ However I don't use docker-compose much. and technically I don't use Docker much, I use podman/cri-o
zapoqx
zapoqxβ€’2mo ago
hah so solved one problem, into another but I mean we're passed this point at least
Mirza
Mirzaβ€’2mo ago
And I have been using it since 2023 This is the things we learn while solving bugs πŸ›
zapoqx
zapoqxβ€’2mo ago
Email sender information not found in environment variables
Email sender information not found in environment variables
Unless you'd like to, I'd like to update the otehr ticket so that Klaus fellow can actually have progress on his end too.
xcons
xconsβ€’2mo ago
Ah, set EMAIL_FROM_ADDRES and EMAIL_FROM_NAME, that's why you're getting that error message
zapoqx
zapoqxβ€’2mo ago
he probably didn't set a nodemailer (I was just trying that in the documentation when I found out about it)
xcons
xconsβ€’2mo ago
I'll add that to the docker compose docs too, now I'm editing them nah, it's specificlaly those 2 variables - here's the code;
25 if (!process.env.EMAIL_FROM_ADDRESS || !process.env.EMAIL_FROM_NAME) {
26 console.log(
27 'Email sender information not found in environment variables'
25 if (!process.env.EMAIL_FROM_ADDRESS || !process.env.EMAIL_FROM_NAME) {
26 console.log(
27 'Email sender information not found in environment variables'
Mirza
Mirzaβ€’2mo ago
Look into .env now
xcons
xconsβ€’2mo ago
ah, EMAIL_FROM_NAME and EMAIL_FROM_ADDRESS are in the email docs already
zapoqx
zapoqxβ€’2mo ago
yea that was probably my mistake.
xcons
xconsβ€’2mo ago
I'll just change it to "must be set"
zapoqx
zapoqxβ€’2mo ago
only so much to try when you have nothing to work with XD
xcons
xconsβ€’2mo ago
hah, yes of course πŸ™‚ I assume you're all logged in now?
zapoqx
zapoqxβ€’2mo ago
not yet gotta redo db cause of trapped e-mail to activate
xcons
xconsβ€’2mo ago
ah, and note that because you have email set, yeah, you'll have to do user activation We can hack the DB if it's a pain
zapoqx
zapoqxβ€’2mo ago
nah I'd rather just get it at least clean to start
xcons
xconsβ€’2mo ago
Nice πŸ™‚
zapoqx
zapoqxβ€’2mo ago
ah it did send good
xcons
xconsβ€’2mo ago
Right, it's 1:15am here, I've just pushed doc changes for docker-compose and the emails, to hopefully prevent this happening to other people again (port 5432 will no longer be needed on the host, reducing chances of a conflict).
zapoqx
zapoqxβ€’2mo ago
I guess once I get in, I'll start to learn the rest and adding APIs as wanted through the docs uh one last thing I know it said in the docs to use Option A, B, or C for the Docker Compose can you mix?
xcons
xconsβ€’2mo ago
If you can register without an error message, it shows that the database connection and backend service are working at least πŸ™‚
zapoqx
zapoqxβ€’2mo ago
like if we're talking about adding APIs like I saw in the ENV example
xcons
xconsβ€’2mo ago
Yes, you can mix, that's fine, but I'd strongly recommend just keeping everything in the docker-compose.
zapoqx
zapoqxβ€’2mo ago
makes sense I back it up anyways so just define them as is
xcons
xconsβ€’2mo ago
Otherwise you start asking "hmm, where was that environment varable set, which one has precedence" ,etc
zapoqx
zapoqxβ€’2mo ago
hah yea I can see myself doing that too
xcons
xconsβ€’2mo ago
We're moving away from environment variables for all the configuration as well Apart from DATABASE_URL
zapoqx
zapoqxβ€’2mo ago
ah good
xcons
xconsβ€’2mo ago
I'm building a settings editor, etc, so make stuff like email configuration and provider configuration all pointy and clicky, copy and paste into text boxes.
zapoqx
zapoqxβ€’2mo ago
er whoops looks like I wasn't out of the woods yet and may be my fault with my mailfilter
xcons
xconsβ€’2mo ago
hmm? No activation email?
zapoqx
zapoqxβ€’2mo ago
I think my mailfilter activated before I did but now the page just keeps refreshing back to login so can't get in
zapoqx
zapoqxβ€’2mo ago
zapoqx
zapoqxβ€’2mo ago
my mailfilter has a nasty habit of pre-checking links to make sure there is nothing malicious when its a first e-mail from anything even if the domain itself is "trusted"
xcons
xconsβ€’2mo ago
Okay, I'm not sure what that is, and I haven't actually gone through the user activation flow via email before (Nevo wrote that) - I can read through the code tomorrow, but for now I need to go to bed! I'd recommend disabling email for now just to get things working maybe?
zapoqx
zapoqxβ€’2mo ago
sounds good have a good night! Not sure if a new ticket should be made, but yea, I tested sending an e-mail by registering another account on another e-mail and it oddly goes to the signup page. If I click the link again, it says I already activated the account. If I try to login... the page looks like it refreshes, but nothing happens. I checked the logs and nothing new came up. Just to make sure logs was clean, I restarted it and tried logging in again and it just refreshes. To be sure it was working, I tried putting in an account name that shouldn't exist which it does end up erroring that there isn't an account, so using the credentials made from either account, nothing happens other than a refresh of the page. Just wanted to check if you had some time to check today?
xcons
xconsβ€’2mo ago
@zapoqx , sorry, I didn't - I spent most of the evening coding Postiz instead
xcons
xconsβ€’2mo ago
GitHub
feature: Responsive launches UI by jamesread Β· Pull Request #416 Β· ...
TODO: Writing description - come back in a few mins This PR introduces a functional responsive UI for at least the &quot;launches&quot; part of the web interface, which is obviously the mos...
xcons
xconsβ€’2mo ago
I'm in UK timezone, I know you're Pheonix Timezone, we can speak tomorrow maybe - I'm just heading to bed, it's 2am for me!
zapoqx
zapoqxβ€’2mo ago
Ok. Understood! been busy most of the day @xcons so apologies for not reaching out. @xcons still not quite in after updating to the newest version. Signin just refreshes. and also, this one is the one that relates: https://discord.com/channels/1243410146097500202/1303035017446031492/1303488927574917191
Want results from more Discord servers?
Add your server