How long does it take for a generated public domain to work?
I'm trying to connect to a postgresql link but it keeps timing out, and the web shows a 404.
Created it about an hour ago.
37 Replies
Project ID:
N/AI'm not sure what postgres has to do with generating a domain? perhaps you are misunderstanding something, could you provide more context?
psql -h postgres-production-c626.up.railway.app -p 8080 -U railway -d railway
psql: error: connection to server at "postgres-production-c626.up.railway.app" (35.213.158.48), port 8080 failed: Operation timed out
Is the server running on that host and accepting TCP/IP connections?
you need to use a TCP proxy for databases
Before I look how to do that, I'm trying to reset my umami password and they're saying I have to do it in the DB. Is there a quicker way? Tried the CLI tools, but that's not going to plan either lol (% railway connect
Select service Postgrespsql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: role "railway" does not exist)
they are correct, you would need to access the database to do that, and to access the database you need to use the tcp proxy
adding a TCP proxy is covered in the template overview
Ok, will have a look there. Thanks 🙂
Hmm, not sure why this isn't working still. I added the 5432 TCP proxy, redeployed with new settings. psql -h roundhouse.proxy.rlwy.net -p 35459 -U railway -d railway
psql: error: connection to server at "roundhouse.proxy.rlwy.net" (35.213.135.65), port 35459 failed: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
show me a screenshot of your public networking please
and 5432 is set as a variable
what is the start command in use?
/bin/sh -c "unset PGPORT; docker-entrypoint.sh postgres --port=5432"
That's just the template default I think
yep that's correct, that's what I've set it to, just needed to make sure it wasn't removed or modified
please send the deployment logs for postgres - https://bookmarklets.up.railway.app/log-downloader/
are you perhaps behind a firewall of some kind? hotel, work, school, etc
no, using my phone's hotspot
ISP firewall?
With the CLI tools, using railway connect should work regardless right?
No firewall afaik
No, the cli simply calls out to psql with pre defined flags
don;t have any issues connecting to anything
most things don't run on port 35459
nmap -p 35459 roundhouse.proxy.rlwy.net
Starting Nmap 7.95 ( https://nmap.org ) at 2024-07-25 13:14 AWST
Nmap scan report for roundhouse.proxy.rlwy.net (35.213.135.65)
Host is up (0.29s latency).
rDNS record for 35.213.135.65: 65.135.213.35.bc.googleusercontent.com
PORT STATE SERVICE
35459/tcp open unknown
Nmap done: 1 IP address (1 host up) scanned in 0.71 seconds
Nmap: the Network Mapper - Free Security Scanner
Nmap Free Security Scanner, Port Scanner, & Network Exploration Tool. Download open source software for Linux, Windows, UNIX, FreeBSD, etc.
can you re-deploy (not restart) the database?
ok
hmm, seems something is working
we like when things work!
Ok, I might have to update psql from 14 to 15 too.
I have too many templates to remember, what version of Postgres is in use for umami?
15 alpine
but also, you can deploy dbgate into the project and use that to manage your database, I've used dbgate to reset a password on umami before with great success
Right, now me and chatgpt are going to figure this one out https://github.com/umami-software/umami/discussions/2483 :poggers:
GitHub
changed my password but lost it. How to get it back · umami-softwar...
I previously deployed Umami version 1.39.5 with MySQL as the database. Now, due to server migration, I need to redeploy Umami and MySQL. I plan to import the existing MySQL data to the new MySQL se...
with dbgate you can just go in and update that value and done
where do I set that up? Variables?
Or just deploy that on the same instance?
you simply deploy the dbgate template
yeah, playing with it now
fkn hell, remind me not to lose my umami password again lol
time to start using a password manager
but hey, as long as you've done it once the second time will be easy
I do, it just didn't save for some reason haha Yeah, best way to learn
sweet, that worked!
Thanks for the help
Should I delete the logs etc from here? Looks like it's not provate
it's not private, but nothing sensitive was shared