Private Networking

I'm trying to deploy Plausible Analytics via a Docker image, and have both that and Postgres installed in an environment. I tried to deploy a Clickhouse DB via Docker Image, but to no avail. I did find this template, https://railway.app/template/clickhouse, but I can't figure out how to get the URL from that and reference it in an ENV in the Plausible service. Would this have something to do with private networking? I've tried opening PN on the Clickhouse DB and referencing it (clickhouse.railway.internal) as CLICKHOUSE_DATABASE_URL in Plausible, but its saying that it's an invalid URL. Do I have to put a port or protocol in front of it? (CH is running on port 8123)
15 Replies
Percy
Percy17mo ago
Project ID: 3c03fc13-00d0-40a1-a011-5a52903a095b
proudparrot2
proudparrot2OP17mo ago
3c03fc13-00d0-40a1-a011-5a52903a095b Apologies if this is confusing
Fragly
Fragly17mo ago
Brody
Brody17mo ago
yes internal domains need to be called with a port specified, they may have a pretty domain, but they are still internal after all
proudparrot2
proudparrot2OP17mo ago
would I have to put the protocol? http/https ?
Brody
Brody17mo ago
for good measure why not, this is internal, and internally your app listens on http
proudparrot2
proudparrot2OP17mo ago
alright yeah because I put the port and its still complaining
Brody
Brody17mo ago
your service also needs to be listening on [::], since the private networking is ipv6 only
proudparrot2
proudparrot2OP17mo ago
alright, thanks @Brody I'm being told to add a column to my Postgres with a TIMESTAMP datatype, but the only one I see is Data, and it rejects that How can I do this, or is it not possible? "Postgrex expected %Date{}, got ~U[2023-07-20 18:45:24.308146Z]. Please make sure the value you are passing matches the definition in your table or in your query or convert the value accordingly." when I put it as date
Brody
Brody17mo ago
what program are you using to add this column?
proudparrot2
proudparrot2OP17mo ago
The normal Postgres data editor in railway
Brody
Brody17mo ago
please dont rely on that, use something like pgadmin
proudparrot2
proudparrot2OP17mo ago
How would I use pgadmin with railway
Brody
Brody17mo ago
railway gives you a database, just connect to it with pgadmin
proudparrot2
proudparrot2OP17mo ago
Ah okay
Want results from more Discord servers?
Add your server