Private Networking | Railway | Page 1

warped bough Jul 20, 2023, 5:30 PM

#

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)

sonic masonBOT Jul 20, 2023, 5:30 PM

#

To help others find answers, you can mark your question as solved via Right click solution message -> Apps -> ✅ Mark Solution

dense folioBOT Jul 20, 2023, 5:30 PM

#

Project ID: 3c03fc13-00d0-40a1-a011-5a52903a095b

warped bough Jul 20, 2023, 5:30 PM

#

3c03fc13-00d0-40a1-a011-5a52903a095b

#

Apologies if this is confusing

cold merlin Jul 20, 2023, 5:31 PM

#

olive pendant Jul 20, 2023, 5:34 PM

#

yes internal domains need to be called with a port specified, they may have a pretty domain, but they are still internal after all

warped bough Jul 20, 2023, 6:14 PM

#

olive pendant yes internal domains need to be called with a port specified, they may have a pr...

would I have to put the protocol?

#

http/https ?

olive pendant Jul 20, 2023, 6:19 PM

#

for good measure why not, this is internal, and internally your app listens on http

warped bough Jul 20, 2023, 6:19 PM

#

alright

#

yeah because I put the port and its still complaining

olive pendant Jul 20, 2023, 6:20 PM

#

your service also needs to be listening on [::], since the private networking is ipv6 only

warped bough Jul 20, 2023, 6:22 PM

#

olive pendant your service also needs to be listening on [::], since the private networking is...

alright, thanks

warped bough Jul 20, 2023, 6:46 PM

#

@olive pendant 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

olive pendant Jul 20, 2023, 7:37 PM

#

what program are you using to add this column?

warped bough Jul 20, 2023, 8:52 PM

#

olive pendant what program are you using to add this column?

The normal Postgres data editor in railway

olive pendant Jul 20, 2023, 8:53 PM

#

please dont rely on that, use something like pgadmin

warped bough Jul 20, 2023, 8:53 PM

#

How would I use pgadmin with railway

olive pendant Jul 20, 2023, 8:54 PM

#

railway gives you a database, just connect to it with pgadmin

#Private Networking