Cheers! I'm hoping to self-host Piped but I'm using cloudflare tunnels / Zerotrust to configure my containers public access (awful ISP CGNAT means this is the best way for my usecase). I've followed the docs https://docs.piped.video/docs/self-hosting/#docker-compose-nginx-aio-script and have configured a public hostname pointing to the nginx container's port configured in the compose.yml file -- but while I can access the frontend the backend/proxy seem to not be able to connect. I found this github issue discussing it https://github.com/TeamPiped/Piped/issues/2600 but even if I add CNAME references manually (though they are now generally handled through Zerotrust) I can't seem to get things to work. The "Trending" page seems to be continually loading, and the logs for piped-backend show
org.postgresql.util.PSQLException: Connection to postgres:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:346)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:273)
at org.postgresql.Driver.makeConnection(Driver.java:446)
at org.postgresql.Driver.connect(Driver.java:298)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:683)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:230)
at me.kavin.piped.utils.LiquibaseHelper.init(LiquibaseHelper.java:32)
at me.kavin.piped.Main.main(Main.java:82)
Caused by: java.net.ConnectException: Connection refused
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:682)
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:592)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
at java.base/java.net.Socket.connect(Socket.java:757)
at org.postgresql.core.PGStream.createSocket(PGStream.java:243)
at org.postgresql.core.PGStream.<init>(PGStream.java:98)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:136)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262)
Has anyone had luck hosting Piped using cloudflare tunnels and can point me in the right direction?