28 Replies
<#1248903970362101791>
Category
Help needed
Product
Coder OSS (v2)
Platform
Linux
Logs
Please post any relevant logs/error messages.
changed the config, didnt work
Try quoting the variable values. Specifically the postgrss URL
like?
this one?
Like
CODER_PG_CONNECTION_URL="Some value"
For all valuesoh sir
ok
Your errors message says that's .env file is not valid so quoting could help fix it.
Also look for any mistyped characters
also have ^@
a lot
yeah
it works
i copied my env file to new vm
idk why it occurs that
the systemctl sucks for a while
@Atif
Please check your .env file for any typos
already checked
see the logs
that no db named coder
Copy and paste your .env file
No screenshots
so i have to
sudo -u postgres psql
Jun 09 10:26:52 ubuntu coder[75383]: Started HTTP listener at http://0.0.0.0:3000
Jun 09 10:26:52 ubuntu coder[75383]: View the Web UI: https://workspace.trung.is-a.dev
Jun 09 10:26:52 ubuntu coder[75383]: 2024-06-09 10:26:52.732 [warn] ping postgres: retrying error="pq: database \"coder\" does not exist" try=1
Jun 09 10:26:54 ubuntu coder[75383]: 2024-06-09 10:26:54.355 [warn] ping postgres: retrying error="pq: database \"coder\" does not exist" try=2
Jun 09 10:26:56 ubuntu coder[75383]: 2024-06-09 10:26:56.978 [warn] ping postgres: retrying error="pq: database \"coder\" does not exist" try=3
Jun 09 10:26:59 ubuntu coder[75383]: 2024-06-09 10:26:59.983 [warn] ping postgres: retrying error="pq: database \"coder\" does not exist" try=4
Jun 09 10:27:02 ubuntu coder[75383]: 2024-06-09 10:27:02.987 [warn] ping postgres: retrying error="pq: database \"coder\" does not exist" try=5
Jun 09 10:27:05 ubuntu coder[75383]: 2024-06-09 10:27:05.992 [warn] ping postgres: retrying error="pq: database \"coder\" does not exist" try=6
Jun 09 10:27:08 ubuntu coder[75383]: 2024-06-09 10:27:08.996 [warn] ping postgres: retrying error="pq: database \"coder\" does not exist" try=7
Follow this instructions here
https://coder.com/docs/install/database
@Atif root@ubuntu:/etc/coder.d# psql
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "root" does not exist
was like this
This isn't a Coder issue. You should probably look for help on how to set up a postgrss database
Maybe someone else can help better here. Good luck
BROOOOOOOOOOOOOOOOO
💀
i am dying
fixed it
@Trung™ closed the thread.