Failure to initialize the relational database

[nizarmah]

Description

The setup script throws an error indicating it failed to initialize the relational database

Reproduction steps

1. Clone repository

   git clone https://github.com/opcotech/elemo.git && cd elemo

2. Install developmental requirements

   brew install yq jq go openssl mkcert nss docker make nvm

3. Run setup script

   > ./scripts/setup.sh
   go: downloading github.com/josharian/intern v1.0.0
   {"level":"info","ts":1713465255.4771578,"logger":"root","caller":"cli/root.go:147","msg":"config file loaded","path":"/Users/elmo/Work/opcotech/elemo/configs/development/config.local.gen.yml"}
   {"level":"fatal","ts":1713465281.392203,"logger":"root","caller":"cli/auth_add_client.go:55","msg":"failed to initialize relational database","error":"failed to connect to `host=127.0.0.1 user=elemo database=`: dial error (timeout: dial tcp 127.0.0.1:5432: connect: operation timed out)","stacktrace":"github.com/opcotech/elemo/cmd/elemo/cli.init.func1\n\t/Users/elmo/Work/opcotech/elemo/cmd/elemo/cli/auth_add_client.go:55\ngithub.ghproxy.top/spf13/cobra.(*Command).execute\n\t/Users/elmo/go/pkg/mod/github.com/spf13/[email protected]/command.go:987\ngithub.ghproxy.top/spf13/cobra.(*Command).ExecuteC\n\t/Users/elmo/go/pkg/mod/github.com/spf13/[email protected]/command.go:1115\ngithub.ghproxy.top/spf13/cobra.(*Command).Execute\n\t/Users/elmo/go/pkg/mod/github.com/spf13/[email protected]/command.go:1039\ngithub.ghproxy.top/opcotech/elemo/cmd/elemo/cli.Execute\n\t/Users/elmo/Work/opcotech/elemo/cmd/elemo/cli/root.go:87\nmain.main\n\t/Users/elmo/Work/opcotech/elemo/cmd/elemo/main.go:18\nruntime.main\n\t/Users/elmo/go/pkg/mod/golang.org/[email protected]/src/runtime/proc.go:271"}
   exit status 1

Screenshots

No response

Logs

> ./scripts/setup.sh
certutil is /opt/homebrew/bin/certutil
docker is /usr/local/bin/docker
docker-compose is /usr/local/bin/docker-compose
go is /opt/homebrew/bin/go
jq is /opt/homebrew/bin/jq
mkcert is /opt/homebrew/bin/mkcert
openssl is /opt/homebrew/opt/openssl@3/bin/openssl
yq is /opt/homebrew/bin/yq
Created a new local CA 💥
Sudo password:
The local CA is now installed in the system trust store! ⚡️
The local CA is now installed in the Firefox trust store (requires browser restart)! 🦊


Created a new certificate valid for the following names 📜
 - "0.0.0.0"

The certificate is at "/Users/elmo/elemo/configs/development/cert.gen.pem" and the key at "/Users/elmo/elemo/configs/development/key.gen.pem" ✅

It will expire on 18 July 2026 🗓

The local CA is already installed in the system trust store! 👍
The local CA is already installed in the Firefox trust store! 👍


Created a new certificate valid for the following names 📜
 - "127.0.0.1"

The certificate is at "/Users/elmo/elemo/configs/development/cert.local.gen.pem" and the key at "/Users/elmo/elemo/configs/development/key.local.gen.pem" ✅

It will expire on 18 July 2026 🗓

go: downloading go1.22.2 (darwin/arm64)
go: downloading github.com/hyperboloide/lk v0.0.0-20230325114855-ce3fecd34798
go: downloading github.com/goccy/go-json v0.10.2
go: downloading github.com/rs/xid v1.5.0
2024/04/18 22:33:02 License generated: /Users/elmo/elemo/configs/development/license.gen.key
[+] Running 14/14
 ✔ postgres 13 layers [⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿]      0B/0B      Pulled                                                                           30.1s 
   ✔ b5d25b35c1db Pull complete                                                                                                         8.3s 
   ✔ 49cf892a3d6e Pull complete                                                                                                         1.0s 
   ✔ 2a0b6c31bad8 Pull complete                                                                                                         2.9s 
   ✔ 30c88dd7faee Pull complete                                                                                                         5.9s 
   ✔ 8ed188c9a01e Pull complete                                                                                                         6.8s 
   ✔ 5ef46eb6901b Pull complete                                                                                                         7.9s 
   ✔ 691a93171f6d Pull complete                                                                                                         7.8s 
   ✔ f492dbf99c64 Pull complete                                                                                                         8.7s 
   ✔ 30f9a70969b5 Pull complete                                                                                                        22.6s 
   ✔ c20fc1dde117 Pull complete                                                                                                         9.2s 
   ✔ 9930c16ee27c Pull complete                                                                                                        10.3s 
   ✔ 149a29989f91 Pull complete                                                                                                        11.2s 
   ✔ 9282b944f2c9 Pull complete                                                                                                        11.9s 
[+] Running 4/4
 ✔ Network elemo-network       Created                                                                                                  0.0s 
 ✔ Volume "docker_pg_data"     Created                                                                                                  0.0s 
 ✔ Volume "docker_neo4j_data"  Created                                                                                                  0.0s 
 ✔ Container elemo-postgres    Started                                                                                                  1.5s 
waiting 5 seconds to let the services boot
go: downloading github.com/go-oauth2/oauth2/v4 v4.5.2
go: downloading github.com/gabor-boros/go-oauth2-pg v0.0.0-20230608073400-a93883d73d34
go: downloading github.com/spf13/cobra v1.8.0
go: downloading github.com/spf13/viper v1.18.2
go: downloading go.opentelemetry.io/otel/trace v1.25.0
go: downloading go.uber.org/zap v1.27.0
go: downloading go.opentelemetry.io/otel v1.25.0
go: downloading github.com/Shopify/gomail v0.0.0-20220729171026-0784ece65e69
go: downloading go.opentelemetry.io/otel/exporters/otlp/otlptrace/otlptracehttp v1.25.0
go: downloading go.opentelemetry.io/otel/sdk v1.25.0
go: downloading go.opentelemetry.io/otel/exporters/otlp/otlptrace v1.25.0
go: downloading github.com/hibiken/asynq v0.24.1
go: downloading github.com/neo4j/neo4j-go-driver/v5 v5.19.0
go: downloading github.com/go-redis/cache/v9 v9.0.0
go: downloading github.com/go-chi/chi/v5 v5.0.12
go: downloading github.com/go-chi/cors v1.2.1
go: downloading github.com/prometheus/client_golang v1.19.0
go: downloading golang.org/x/time v0.5.0
go: downloading github.com/getkin/kin-openapi v0.124.0
go: downloading github.com/go-session/session v3.1.2+incompatible
go: downloading github.com/oapi-codegen/nethttp-middleware v1.0.1
go: downloading github.com/oapi-codegen/runtime v1.1.1
go: downloading github.com/slok/go-http-metrics v0.11.0
go: downloading go.opentelemetry.io/contrib/instrumentation/net/http/otelhttp v0.50.0
go: downloading go.uber.org/multierr v1.11.0
go: downloading github.com/fsnotify/fsnotify v1.7.0
go: downloading github.com/mitchellh/mapstructure v1.5.0
go: downloading github.com/sagikazarmark/slog-shim v0.1.0
go: downloading github.com/spf13/afero v1.11.0
go: downloading github.com/spf13/cast v1.6.0
go: downloading github.com/go-playground/validator/v10 v10.19.0
go: downloading github.com/go-logr/logr v1.4.1
go: downloading go.opentelemetry.io/otel/metric v1.25.0
go: downloading golang.org/x/crypto v0.22.0
go: downloading golang.org/x/sys v0.19.0
go: downloading github.com/cespare/xxhash/v2 v2.3.0
go: downloading go.opentelemetry.io/proto/otlp v1.2.0
go: downloading google.golang.org/protobuf v1.33.0
go: downloading github.com/klauspost/compress v1.17.8
go: downloading github.com/vmihailenco/go-tinylfu v0.2.2
go: downloading github.com/vmihailenco/msgpack/v5 v5.4.1
go: downloading golang.org/x/sync v0.7.0
go: downloading github.com/robfig/cron/v3 v3.0.1
go: downloading github.com/beorn7/perks v1.0.1
go: downloading github.com/prometheus/client_model v0.6.1
go: downloading github.com/prometheus/common v0.52.3
go: downloading github.com/prometheus/procfs v0.13.0
go: downloading github.com/go-openapi/jsonpointer v0.21.0
go: downloading github.com/invopop/yaml v0.3.1
go: downloading github.com/mohae/deepcopy v0.0.0-20170929034955-c48cc78d4826
go: downloading github.com/perimeterx/marshmallow v1.1.5
go: downloading github.com/golang-jwt/jwt v3.2.2+incompatible
go: downloading github.com/felixge/httpsnoop v1.0.4
go: downloading github.com/subosito/gotenv v1.6.0
go: downloading gopkg.in/ini.v1 v1.67.0
go: downloading github.com/magiconair/properties v1.8.7
go: downloading github.com/pelletier/go-toml/v2 v2.2.1
go: downloading github.com/go-logr/stdr v1.2.2
go: downloading google.golang.org/grpc v1.63.2
go: downloading github.com/gabriel-vasile/mimetype v1.4.3
go: downloading github.com/cenkalti/backoff/v4 v4.3.0
go: downloading github.com/go-playground/universal-translator v0.18.1
go: downloading github.com/leodido/go-urn v1.4.0
go: downloading github.com/grpc-ecosystem/grpc-gateway/v2 v2.19.1
go: downloading github.com/golang/protobuf v1.5.4
go: downloading github.com/vmihailenco/tagparser/v2 v2.0.0
go: downloading github.com/apapsch/go-jsonmerge/v2 v2.0.0
go: downloading github.com/go-openapi/swag v0.23.0
go: downloading github.com/gorilla/mux v1.8.1
go: downloading github.com/mailru/easyjson v0.7.7
go: downloading golang.org/x/net v0.24.0
go: downloading google.golang.org/genproto/googleapis/rpc v0.0.0-20240415151819-79826c84ba32
go: downloading github.com/go-playground/locales v0.14.1
go: downloading google.golang.org/genproto/googleapis/api v0.0.0-20240415151819-79826c84ba32
go: downloading github.com/josharian/intern v1.0.0
{"level":"info","ts":1713465255.4771578,"logger":"root","caller":"cli/root.go:147","msg":"config file loaded","path":"/Users/elmo/elemo/configs/development/config.local.gen.yml"}
{"level":"fatal","ts":1713465281.392203,"logger":"root","caller":"cli/auth_add_client.go:55","msg":"failed to initialize relational database","error":"failed to connect to `host=127.0.0.1 user=elemo database=`: dial error (timeout: dial tcp 127.0.0.1:5432: connect: operation timed out)","stacktrace":"github.com/opcotech/elemo/cmd/elemo/cli.init.func1\n\t/Users/elmo/elemo/cmd/elemo/cli/auth_add_client.go:55\ngithub.ghproxy.top/spf13/cobra.(*Command).execute\n\t/Users/elmo/go/pkg/mod/github.com/spf13/[email protected]/command.go:987\ngithub.ghproxy.top/spf13/cobra.(*Command).ExecuteC\n\t/Users/elmo/go/pkg/mod/github.com/spf13/[email protected]/command.go:1115\ngithub.ghproxy.top/spf13/cobra.(*Command).Execute\n\t/Users/elmo/go/pkg/mod/github.com/spf13/[email protected]/command.go:1039\ngithub.ghproxy.top/opcotech/elemo/cmd/elemo/cli.Execute\n\t/Users/elmo/elemo/cmd/elemo/cli/root.go:87\nmain.main\n\t/Users/elmo/elemo/cmd/elemo/main.go:18\nruntime.main\n\t/Users/elmo/go/pkg/mod/golang.org/[email protected]/src/runtime/proc.go:271"}
exit status 1

Browsers

No response

Version

{ "Commit": "9a3b5f0", "GoVersion": "go1.22.1 darwin/arm64" }

[nizarmah]

Small note, it would be nice to have a script to extract the version easily.