私有化部署后不能注册用户进行登录，提示网络错误

Description
window11下面部署后能打开网页，但不能注册用户，输入邮箱点击获取验证码后，提示网络错误
ILLA Builder Version
最新版本
Browser
No response
Operating System

[ ] macOS
[X] Windows
[ ] Linux

Additional Information
查看docker里面日志，提示error连接数据库失败：
2022-11-24 06:13:11 2022-11-23 22:13:11.434 UTC [85] FATAL:  password authentication failed for user "postgres"
2022-11-24 06:13:11 2022-11-23 22:13:11.434 UTC [85] DETAIL:  Connection matched pg_hba.conf line 100: "host all all all scram-sha-256"
2022-11-24 06:13:11 2022-11-23 22:13:11.463 UTC [86] FATAL:  password authentication failed for user "postgres"
2022-11-24 06:13:11 2022-11-23 22:13:11.463 UTC [86] DETAIL:  Connection matched pg_hba.conf line 100: "host all all all scram-sha-256"
2022-11-24 06:13:20 2022-11-23 22:13:20.984 UTC [98] FATAL:  role "illa" does not exist
2022-11-24 06:13:41
2022-11-24 06:13:41 2022/11/23 22:13:41 /opt/illailder-backend/pkg/connection.go:61
2022-11-24 06:13:41 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-11-24 06:13:51
2022-11-24 06:13:51 2022/11/23 22:13:51 /opt/illailder-backend/pkg/connection.go:61
2022-11-24 06:13:51 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-11-24 06:13:51
2022-11-24 06:13:51 2022/11/23 22:13:51 /opt/illailder-backend/pkg/connection.go:61
2022-11-24 06:13:51 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-11-24 06:13:11 2022-11-23 22:13:11.434 UTC [85] FATAL:  password authentication failed for user "postgres"
2022-11-24 06:13:11 2022-11-23 22:13:11.434 UTC [85] DETAIL:  Connection matched pg_hba.conf line 100: "host all all all scram-sha-256"
2022-11-24 06:13:11 2022-11-23 22:13:11.463 UTC [86] FATAL:  password authentication failed for user "postgres"
2022-11-24 06:13:11 2022-11-23 22:13:11.463 UTC [86] DETAIL:  Connection matched pg_hba.conf line 100: "host all all all scram-sha-256"
2022-11-24 06:13:20 2022-11-23 22:13:20.984 UTC [98] FATAL:  role "illa" does not exist
2022-11-24 06:13:41
2022-11-24 06:13:41 2022/11/23 22:13:41 /opt/illailder-backend/pkg/connection.go:61
2022-11-24 06:13:41 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))

@fengdu126
你好, 看上去像数据库没有初始化成功, 能麻烦把所有 docker 日志粘上来吗? 尤其是Postgres 初始化这部分（位于日志最前面）。

@fengdu126
你好, 看上去像数据库没有初始化成功, 能麻烦把所有 docker 日志粘上来吗? 尤其是Postgres 初始化这部分（位于日志最前面）。

2022-11-25 08:48:18
2022-11-25 08:48:18 config init.
2022-11-25 08:48:18
2022-11-25 08:48:18 API_SERVER_PORT not defined, skip.
2022-11-25 08:48:18
2022-11-25 08:48:18 config init done.
2022-11-25 08:48:18
2022-11-25 08:48:18 Running postgres-entrypoint.sh
2022-11-25 08:48:18 now user is: 0
2022-11-25 08:48:18
2022-11-25 08:48:18 illa database already exists; Skipping initialization
2022-11-25 08:48:18
2022-11-25 08:48:18 total 36K
2022-11-25 08:48:18 drwxr-xr-x 1 root     root     4.0K Oct  5 09:05 .
2022-11-25 08:48:18 drwxr-xr-x 1 root     root     4.0K Oct  4 00:00 ..
2022-11-25 08:48:18 drwxr-xr-x 1 root     root     4.0K Nov 21 12:05 apt
2022-11-25 08:48:18 drwxr-xr-x 1 root     root     4.0K Nov 21 12:05 dpkg
2022-11-25 08:48:18 drwxr-xr-x 2 root     root     4.0K Sep  3 12:10 misc
2022-11-25 08:48:18 drwxr-xr-x 2 root     root     4.0K Oct  4 00:00 pam
2022-11-25 08:48:18 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 postgresql
2022-11-25 08:48:18 drwxr-xr-x 1 root     root     4.0K Oct  5 09:04 systemd
2022-11-25 08:48:18 drwxr-xr-x 3 root     root     4.0K Oct  5 09:05 ucf
2022-11-25 08:48:18 total 8.0K
2022-11-25 08:48:18 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 .
2022-11-25 08:48:18 drwxr-xr-x 1 root     root     4.0K Oct  5 09:05 ..
2022-11-25 08:48:18 drwx------ 1 postgres root      512 Nov 25 00:46 data
2022-11-25 08:48:18 total 48K
2022-11-25 08:48:18 drwx------ 1 postgres root      512 Nov 25 00:46 .
2022-11-25 08:48:18 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 ..
2022-11-25 08:48:18 drwx------ 1 postgres postgres  512 Nov 23 21:36 base
2022-11-25 08:48:18 drwx------ 1 postgres postgres  512 Nov 23 21:42 global
2022-11-25 08:48:18 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_commit_ts
2022-11-25 08:48:18 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_dynshmem
2022-11-25 08:48:18 -rw------- 1 postgres postgres 4.8K Nov 23 21:36 pg_hba.conf
2022-11-25 08:48:18 -rw------- 1 postgres postgres 1.6K Nov 23 21:36 pg_ident.conf
2022-11-25 08:48:18 drwx------ 1 postgres postgres  512 Nov 25 00:46 pg_logical
2022-11-25 08:48:18 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_multixact
2022-11-25 08:48:18 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_notify
2022-11-25 08:48:18 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_replslot
2022-11-25 08:48:18 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_serial
2022-11-25 08:48:18 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_snapshots
2022-11-25 08:48:18 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_stat
2022-11-25 08:48:18 drwx------ 1 postgres postgres  512 Nov 25 00:47 pg_stat_tmp
2022-11-25 08:48:18 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_subtrans
2022-11-25 08:48:18 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_tblspc
2022-11-25 08:48:20 {"level":"error","ts":1669337300.1495886,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":6,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:48:20 {"level":"error","ts":1669337300.1495445,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:48:20 {"level":"error","ts":1669337300.153881,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":6,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:48:20 {"level":"error","ts":1669337300.1537616,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:48:20 2022-11-25 00:48:20.238 UTC [41] LOG:  starting PostgreSQL 14.5 (Debian 14.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
2022-11-25 08:48:20 2022-11-25 00:48:20.238 UTC [41] LOG:  listening on IPv4 address "<IP_ADDRESS>", port 5432
2022-11-25 08:48:20 2022-11-25 00:48:20.238 UTC [41] LOG:  listening on IPv6 address "::", port 5432
2022-11-25 08:48:20 2022-11-25 00:48:20.250 UTC [41] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-11-25 08:48:20 2022-11-25 00:48:20.314 UTC [65] LOG:  database system was interrupted; last known up at 2022-11-25 00:46:34 UTC
2022-11-25 08:48:18 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_twophase
2022-11-25 08:48:18 -rw------- 1 postgres postgres    3 Nov 23 21:36 PG_VERSION
2022-11-25 08:48:18 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_wal
2022-11-25 08:48:18 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_xact
2022-11-25 08:48:18 -rw------- 1 postgres postgres   88 Nov 23 21:36 postgresql.auto.conf
2022-11-25 08:48:18 -rw------- 1 postgres postgres  29K Nov 23 21:36 postgresql.conf
2022-11-25 08:48:18 -rw------- 1 postgres postgres   36 Nov 25 00:46 postmaster.opts
2022-11-25 08:48:18 -rw------- 1 postgres postgres   95 Nov 25 00:46 postmaster.pid
2022-11-25 08:48:20 Running postgres-entrypoint.sh
2022-11-25 08:48:20 now user is: 999
2022-11-25 08:48:20 total 36K
2022-11-25 08:48:20 drwxr-xr-x 1 root     root     4.0K Oct  5 09:05 .
2022-11-25 08:48:20 drwxr-xr-x 1 root     root     4.0K Oct  4 00:00 ..
2022-11-25 08:48:20 drwxr-xr-x 1 root     root     4.0K Nov 21 12:05 apt
2022-11-25 08:48:20 drwxr-xr-x 1 root     root     4.0K Nov 21 12:05 dpkg
2022-11-25 08:48:20 drwxr-xr-x 2 root     root     4.0K Sep  3 12:10 misc
2022-11-25 08:48:20 drwxr-xr-x 2 root     root     4.0K Oct  4 00:00 pam
2022-11-25 08:48:20 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 postgresql
2022-11-25 08:48:20 drwxr-xr-x 1 root     root     4.0K Oct  5 09:04 systemd
2022-11-25 08:48:20 drwxr-xr-x 3 root     root     4.0K Oct  5 09:05 ucf
2022-11-25 08:48:20 total 8.0K
2022-11-25 08:48:20 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 .
2022-11-25 08:48:20 drwxr-xr-x 1 root     root     4.0K Oct  5 09:05 ..
2022-11-25 08:48:20 drwx------ 1 postgres root      512 Nov 25 00:46 data
2022-11-25 08:48:20 total 48K
2022-11-25 08:48:20 drwx------ 1 postgres root      512 Nov 25 00:46 .
2022-11-25 08:48:20 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 ..
2022-11-25 08:48:20 drwx------ 1 postgres postgres  512 Nov 23 21:36 base
2022-11-25 08:48:20 drwx------ 1 postgres postgres  512 Nov 23 21:42 global
2022-11-25 08:48:20 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_commit_ts
2022-11-25 08:48:20 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_dynshmem
2022-11-25 08:48:20 -rw------- 1 postgres postgres 4.8K Nov 23 21:36 pg_hba.conf
2022-11-25 08:48:20 -rw------- 1 postgres postgres 1.6K Nov 23 21:36 pg_ident.conf
2022-11-25 08:48:20 drwx------ 1 postgres postgres  512 Nov 25 00:46 pg_logical
2022-11-25 08:48:20 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_multixact
2022-11-25 08:48:20 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_notify
2022-11-25 08:48:20 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_replslot
2022-11-25 08:48:20 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_serial
2022-11-25 08:48:20 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_snapshots
2022-11-25 08:48:20 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_stat
2022-11-25 08:48:20 drwx------ 1 postgres postgres  512 Nov 25 00:47 pg_stat_tmp
2022-11-25 08:48:20 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_subtrans
2022-11-25 08:48:20 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_tblspc
2022-11-25 08:48:20 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_twophase
2022-11-25 08:48:20 -rw------- 1 postgres postgres    3 Nov 23 21:36 PG_VERSION
2022-11-25 08:48:20 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_wal
2022-11-25 08:48:20 drwx------ 1 postgres postgres  512 Nov 23 21:36 pg_xact
2022-11-25 08:48:20 -rw------- 1 postgres postgres   88 Nov 23 21:36 postgresql.auto.conf
2022-11-25 08:48:20 -rw------- 1 postgres postgres  29K Nov 23 21:36 postgresql.conf
2022-11-25 08:48:20 -rw------- 1 postgres postgres   36 Nov 25 00:46 postmaster.opts
2022-11-25 08:48:20 -rw------- 1 postgres postgres   95 Nov 25 00:46 postmaster.pid
2022-11-25 08:48:20
2022-11-25 08:48:20 PostgreSQL Database directory appears to contain a database; Skipping initialization
2022-11-25 08:48:20
2022-11-25 08:48:20
2022-11-25 08:48:20 2022/11/25 00:48:20 /opt/illa/builder-backend/pkg/db/connection.go:48
2022-11-25 08:48:20 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: dial error (dial tcp [::1]:5432: connect: cannot assign requested address)
2022-11-25 08:48:20
2022-11-25 08:48:20 2022/11/25 00:48:20 /opt/illa/builder-backend/pkg/db/connection.go:48
2022-11-25 08:48:20 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: dial error (dial tcp [::1]:5432: connect: cannot assign requested address)
2022-11-25 08:48:28 2022-11-25 00:48:28.786 UTC [65] LOG:  database system was not properly shut down; automatic recovery in progress
2022-11-25 08:48:28 2022-11-25 00:48:28.836 UTC [65] LOG:  redo starts at 0/16FB410
2022-11-25 08:48:28 2022-11-25 00:48:28.838 UTC [65] LOG:  invalid record length at 0/16FB448: wanted 24, got 0
2022-11-25 08:48:28 2022-11-25 00:48:28.838 UTC [65] LOG:  redo done at 0/16FB410 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2022-11-25 08:48:28 2022-11-25 00:48:28.958 UTC [41] LOG:  database system is ready to accept connections
2022-11-25 08:48:30 2022-11-25 00:48:30.168 UTC [83] FATAL:  role "illa" does not exist
2022-11-25 08:48:30 {"level":"error","ts":1669337310.1687324,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":5,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:48:30 {"level":"error","ts":1669337310.1687078,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:48:30
2022-11-25 08:48:30 2022/11/25 00:48:30 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-11-25 08:48:30 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-11-25 08:48:30 2022-11-25 00:48:30.172 UTC [85] FATAL:  role "illa" does not exist
2022-11-25 08:48:30 {"level":"error","ts":1669337310.1731477,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":5,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:48:30 {"level":"error","ts":1669337310.1731188,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:48:30
2022-11-25 08:48:30 2022/11/25 00:48:30 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-11-25 08:48:30 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-11-25 08:48:40
2022-11-25 08:48:40 2022/11/25 00:48:40 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-11-25 08:48:40 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-11-25 08:48:40
2022-11-25 08:48:40 2022/11/25 00:48:40 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-11-25 08:48:40 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-11-25 08:48:40 2022-11-25 00:48:40.195 UTC [99] FATAL:  role "illa" does not exist
2022-11-25 08:48:40 2022-11-25 00:48:40.195 UTC [98] FATAL:  role "illa" does not exist
2022-11-25 08:48:40 {"level":"error","ts":1669337320.1956758,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":4,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:48:40 {"level":"error","ts":1669337320.1956265,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:48:40 {"level":"error","ts":1669337320.196666,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":4,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:48:40 {"level":"error","ts":1669337320.1956778,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:48:50 2022-11-25 00:48:50.207 UTC [111] FATAL:  role "illa" does not exist
2022-11-25 08:48:50 {"level":"error","ts":1669337330.2075405,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":3,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:48:50 {"level":"error","ts":1669337330.2075145,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:48:50
2022-11-25 08:48:50 2022/11/25 00:48:50 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-11-25 08:48:50 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-11-25 08:48:50 2022-11-25 00:48:50.210 UTC [113] FATAL:  role "illa" does not exist
2022-11-25 08:48:50 {"level":"error","ts":1669337330.2111301,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":3,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:48:50 {"level":"error","ts":1669337330.2111025,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:48:50
2022-11-25 08:48:50 2022/11/25 00:48:50 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-11-25 08:48:50 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-11-25 08:49:00 2022-11-25 00:49:00.219 UTC [126] FATAL:  role "illa" does not exist
2022-11-25 08:49:00 2022-11-25 00:49:00.219 UTC [125] FATAL:  role "illa" does not exist
2022-11-25 08:49:00 {"level":"error","ts":1669337340.219372,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":2,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:49:00 {"level":"error","ts":1669337340.219347,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:49:00 {"level":"error","ts":1669337340.2194014,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":2,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:49:00 {"level":"error","ts":1669337340.2193775,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:49:00
2022-11-25 08:49:00 2022/11/25 00:49:00 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-11-25 08:49:00 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-11-25 08:49:00
2022-11-25 08:49:00 2022/11/25 00:49:00 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-11-25 08:49:00 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-11-25 08:49:10 2022-11-25 00:49:10.509 UTC [139] FATAL:  role "illa" does not exist
2022-11-25 08:49:10 {"level":"error","ts":1669337350.5101638,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":1,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:49:10 {"level":"error","ts":1669337350.5099618,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:49:10 panic: failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-11-25 08:49:10
2022-11-25 08:49:10 goroutine 1 [running]:
2022-11-25 08:49:10 github.com/illa-family/builder-backend/pkg/db.NewDbConnection(0xc00061be00, 0xc000124598)
2022-11-25 08:49:10 /opt/illa/builder-backend/pkg/db/connection.go:68 +0x925
2022-11-25 08:49:10 main.Initialize()
2022-11-25 08:49:10 /opt/illa/builder-backend/cmd/http-server/wire_gen.go:38 +0xa5
2022-11-25 08:49:10 main.main()
2022-11-25 08:49:10 /opt/illa/builder-backend/cmd/http-server/main.go:20 +0x19
2022-11-25 08:49:10 2022-11-25 00:49:10.523 UTC [140] FATAL:  role "illa" does not exist
2022-11-25 08:49:10 {"level":"error","ts":1669337350.5241964,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":1,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:49:10 {"level":"error","ts":1669337350.5241725,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-25 08:49:10
2022-11-25 08:49:10 2022/11/25 00:49:10 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-11-25 08:49:10 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-11-25 08:49:10
2022-11-25 08:49:10 2022/11/25 00:49:10 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-11-25 08:49:10 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-11-25 08:49:10 panic: failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-11-25 08:49:10
2022-11-25 08:49:10 goroutine 1 [running]:
2022-11-25 08:49:10 github.com/illa-family/builder-backend/pkg/db.NewDbConnection(0xc00022e320, 0xc000126b48)
2022-11-25 08:49:10 /opt/illa/builder-backend/pkg/db/connection.go:68 +0x925
2022-11-25 08:49:10 main.initEnv()
2022-11-25 08:49:10 /opt/illa/builder-backend/cmd/websocket-server/main.go:54 +0x5d
2022-11-25 08:49:10 main.main()
2022-11-25 08:49:10 /opt/illa/builder-backend/cmd/websocket-server/main.go:127 +0x9c

@fengdu126 分享一下我遇到的问题与解决方法。

遇到相同的db role的问题，原因是我的本地已经有postgresql在运行，且占用了5432端口

解决方法如下：

修改本地的postgresql端口为5433, 具体方法是修改postgresql.conf中的port参数并重启PG（可使用pg_ctl restart来重启）
docker ps 获取到illa container的id, 然后docker stop container_id
清理illa postgresql 容器的数据目录, 可以通过docker inspect -f '{{ .Mounts }}' container_id container_id是通过上面步骤2获取到的。
illa deploy 重新部署即可成功。

希望对你有帮助。

遇到同样的问题， 操作感受不好， 建议“建议移除docker版的，验证码模块” ，或在新版本中解决这个问题，可以平滑本地部署

@fengdu126 分享一下我遇到的问题与解决方法。

遇到相同的db role的问题，原因是我的本地已经有postgresql在运行，且占用了5432端口

解决方法如下：

修改本地的postgresql端口为5433, 具体方法是修改postgresql.conf中的port参数并重启PG（可使用pg_ctl restart来重启）
docker ps 获取到illa container的id, 然后docker stop container_id
清理illa postgresql 容器的数据目录, 可以通过docker inspect -f '{{ .Mounts }}' container_id container_id是通过上面步骤2获取到的。
illa deploy 重新部署即可成功。

希望对你有帮助。

纯净的docker环境也会报这个错误，似乎是初始pgsql带脏数据，第3步具体怎么清理？全部删除吗？

是的，直接删除掉 mount 的文件夹即可。注意如果有数据记得备份。

请提供下日志？如果数据库冲突问题过多我们考虑将默认port修改一下。关于注册策略我们已经反馈到负责的同事，有修改我们会第一时间通知大家。

遇到同样的问题， 操作感受不好， 建议“建议移除docker版的，验证码模块” ，或在新版本中解决这个问题，可以平滑本地部署

请提供下日志？如果数据库冲突问题过多我们考虑将默认port修改一下。关于注册策略我们已经反馈到负责的同事，有修改我们会第一时间通知大家。

@fengdu126
你好, 看上去像数据库没有初始化成功, 能麻烦把所有 docker 日志粘上来吗? 尤其是Postgres 初始化这部分（位于日志最前面）。

2022-11-25 08:48:18 2022-11-25 08:48:18 config init. 2022-11-25 08:48:18 2022-11-25 08:48:18 API_SERVER_PORT not defined, skip. 2022-11-25 08:48:18 2022-11-25 08:48:18 config init done. 2022-11-25 08:48:18 2022-11-25 08:48:18 Running postgres-entrypoint.sh 2022-11-25 08:48:18 now user is: 0 2022-11-25 08:48:18 2022-11-25 08:48:18 illa database already exists; Skipping initialization 2022-11-25 08:48:18 2022-11-25 08:48:18 total 36K 2022-11-25 08:48:18 drwxr-xr-x 1 root root 4.0K Oct 5 09:05 . 2022-11-25 08:48:18 drwxr-xr-x 1 root root 4.0K Oct 4 00:00 .. 2022-11-25 08:48:18 drwxr-xr-x 1 root root 4.0K Nov 21 12:05 apt 2022-11-25 08:48:18 drwxr-xr-x 1 root root 4.0K Nov 21 12:05 dpkg 2022-11-25 08:48:18 drwxr-xr-x 2 root root 4.0K Sep 3 12:10 misc 2022-11-25 08:48:18 drwxr-xr-x 2 root root 4.0K Oct 4 00:00 pam 2022-11-25 08:48:18 drwxr-xr-x 1 postgres postgres 4.0K Oct 5 09:06 postgresql 2022-11-25 08:48:18 drwxr-xr-x 1 root root 4.0K Oct 5 09:04 systemd 2022-11-25 08:48:18 drwxr-xr-x 3 root root 4.0K Oct 5 09:05 ucf 2022-11-25 08:48:18 total 8.0K 2022-11-25 08:48:18 drwxr-xr-x 1 postgres postgres 4.0K Oct 5 09:06 . 2022-11-25 08:48:18 drwxr-xr-x 1 root root 4.0K Oct 5 09:05 .. 2022-11-25 08:48:18 drwx------ 1 postgres root 512 Nov 25 00:46 data 2022-11-25 08:48:18 total 48K 2022-11-25 08:48:18 drwx------ 1 postgres root 512 Nov 25 00:46 . 2022-11-25 08:48:18 drwxr-xr-x 1 postgres postgres 4.0K Oct 5 09:06 .. 2022-11-25 08:48:18 drwx------ 1 postgres postgres 512 Nov 23 21:36 base 2022-11-25 08:48:18 drwx------ 1 postgres postgres 512 Nov 23 21:42 global 2022-11-25 08:48:18 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_commit_ts 2022-11-25 08:48:18 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_dynshmem 2022-11-25 08:48:18 -rw------- 1 postgres postgres 4.8K Nov 23 21:36 pg_hba.conf 2022-11-25 08:48:18 -rw------- 1 postgres postgres 1.6K Nov 23 21:36 pg_ident.conf 2022-11-25 08:48:18 drwx------ 1 postgres postgres 512 Nov 25 00:46 pg_logical 2022-11-25 08:48:18 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_multixact 2022-11-25 08:48:18 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_notify 2022-11-25 08:48:18 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_replslot 2022-11-25 08:48:18 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_serial 2022-11-25 08:48:18 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_snapshots 2022-11-25 08:48:18 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_stat 2022-11-25 08:48:18 drwx------ 1 postgres postgres 512 Nov 25 00:47 pg_stat_tmp 2022-11-25 08:48:18 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_subtrans 2022-11-25 08:48:18 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_tblspc 2022-11-25 08:48:20 {"level":"error","ts":1669337300.1495886,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":6,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:48:20 {"level":"error","ts":1669337300.1495445,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:48:20 {"level":"error","ts":1669337300.153881,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":6,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:48:20 {"level":"error","ts":1669337300.1537616,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:48:20 2022-11-25 00:48:20.238 UTC [41] LOG: starting PostgreSQL 14.5 (Debian 14.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit 2022-11-25 08:48:20 2022-11-25 00:48:20.238 UTC [41] LOG: listening on IPv4 address "<IP_ADDRESS>", port 5432 2022-11-25 08:48:20 2022-11-25 00:48:20.238 UTC [41] LOG: listening on IPv6 address "::", port 5432 2022-11-25 08:48:20 2022-11-25 00:48:20.250 UTC [41] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2022-11-25 08:48:20 2022-11-25 00:48:20.314 UTC [65] LOG: database system was interrupted; last known up at 2022-11-25 00:46:34 UTC 2022-11-25 08:48:18 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_twophase 2022-11-25 08:48:18 -rw------- 1 postgres postgres 3 Nov 23 21:36 PG_VERSION 2022-11-25 08:48:18 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_wal 2022-11-25 08:48:18 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_xact 2022-11-25 08:48:18 -rw------- 1 postgres postgres 88 Nov 23 21:36 postgresql.auto.conf 2022-11-25 08:48:18 -rw------- 1 postgres postgres 29K Nov 23 21:36 postgresql.conf 2022-11-25 08:48:18 -rw------- 1 postgres postgres 36 Nov 25 00:46 postmaster.opts 2022-11-25 08:48:18 -rw------- 1 postgres postgres 95 Nov 25 00:46 postmaster.pid 2022-11-25 08:48:20 Running postgres-entrypoint.sh 2022-11-25 08:48:20 now user is: 999 2022-11-25 08:48:20 total 36K 2022-11-25 08:48:20 drwxr-xr-x 1 root root 4.0K Oct 5 09:05 . 2022-11-25 08:48:20 drwxr-xr-x 1 root root 4.0K Oct 4 00:00 .. 2022-11-25 08:48:20 drwxr-xr-x 1 root root 4.0K Nov 21 12:05 apt 2022-11-25 08:48:20 drwxr-xr-x 1 root root 4.0K Nov 21 12:05 dpkg 2022-11-25 08:48:20 drwxr-xr-x 2 root root 4.0K Sep 3 12:10 misc 2022-11-25 08:48:20 drwxr-xr-x 2 root root 4.0K Oct 4 00:00 pam 2022-11-25 08:48:20 drwxr-xr-x 1 postgres postgres 4.0K Oct 5 09:06 postgresql 2022-11-25 08:48:20 drwxr-xr-x 1 root root 4.0K Oct 5 09:04 systemd 2022-11-25 08:48:20 drwxr-xr-x 3 root root 4.0K Oct 5 09:05 ucf 2022-11-25 08:48:20 total 8.0K 2022-11-25 08:48:20 drwxr-xr-x 1 postgres postgres 4.0K Oct 5 09:06 . 2022-11-25 08:48:20 drwxr-xr-x 1 root root 4.0K Oct 5 09:05 .. 2022-11-25 08:48:20 drwx------ 1 postgres root 512 Nov 25 00:46 data 2022-11-25 08:48:20 total 48K 2022-11-25 08:48:20 drwx------ 1 postgres root 512 Nov 25 00:46 . 2022-11-25 08:48:20 drwxr-xr-x 1 postgres postgres 4.0K Oct 5 09:06 .. 2022-11-25 08:48:20 drwx------ 1 postgres postgres 512 Nov 23 21:36 base 2022-11-25 08:48:20 drwx------ 1 postgres postgres 512 Nov 23 21:42 global 2022-11-25 08:48:20 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_commit_ts 2022-11-25 08:48:20 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_dynshmem 2022-11-25 08:48:20 -rw------- 1 postgres postgres 4.8K Nov 23 21:36 pg_hba.conf 2022-11-25 08:48:20 -rw------- 1 postgres postgres 1.6K Nov 23 21:36 pg_ident.conf 2022-11-25 08:48:20 drwx------ 1 postgres postgres 512 Nov 25 00:46 pg_logical 2022-11-25 08:48:20 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_multixact 2022-11-25 08:48:20 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_notify 2022-11-25 08:48:20 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_replslot 2022-11-25 08:48:20 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_serial 2022-11-25 08:48:20 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_snapshots 2022-11-25 08:48:20 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_stat 2022-11-25 08:48:20 drwx------ 1 postgres postgres 512 Nov 25 00:47 pg_stat_tmp 2022-11-25 08:48:20 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_subtrans 2022-11-25 08:48:20 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_tblspc 2022-11-25 08:48:20 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_twophase 2022-11-25 08:48:20 -rw------- 1 postgres postgres 3 Nov 23 21:36 PG_VERSION 2022-11-25 08:48:20 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_wal 2022-11-25 08:48:20 drwx------ 1 postgres postgres 512 Nov 23 21:36 pg_xact 2022-11-25 08:48:20 -rw------- 1 postgres postgres 88 Nov 23 21:36 postgresql.auto.conf 2022-11-25 08:48:20 -rw------- 1 postgres postgres 29K Nov 23 21:36 postgresql.conf 2022-11-25 08:48:20 -rw------- 1 postgres postgres 36 Nov 25 00:46 postmaster.opts 2022-11-25 08:48:20 -rw------- 1 postgres postgres 95 Nov 25 00:46 postmaster.pid 2022-11-25 08:48:20 2022-11-25 08:48:20 PostgreSQL Database directory appears to contain a database; Skipping initialization 2022-11-25 08:48:20 2022-11-25 08:48:20 2022-11-25 08:48:20 2022/11/25 00:48:20 /opt/illa/builder-backend/pkg/db/connection.go:48 2022-11-25 08:48:20 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: dial error (dial tcp [::1]:5432: connect: cannot assign requested address) 2022-11-25 08:48:20 2022-11-25 08:48:20 2022/11/25 00:48:20 /opt/illa/builder-backend/pkg/db/connection.go:48 2022-11-25 08:48:20 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: dial error (dial tcp [::1]:5432: connect: cannot assign requested address) 2022-11-25 08:48:28 2022-11-25 00:48:28.786 UTC [65] LOG: database system was not properly shut down; automatic recovery in progress 2022-11-25 08:48:28 2022-11-25 00:48:28.836 UTC [65] LOG: redo starts at 0/16FB410 2022-11-25 08:48:28 2022-11-25 00:48:28.838 UTC [65] LOG: invalid record length at 0/16FB448: wanted 24, got 0 2022-11-25 08:48:28 2022-11-25 00:48:28.838 UTC [65] LOG: redo done at 0/16FB410 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2022-11-25 08:48:28 2022-11-25 00:48:28.958 UTC [41] LOG: database system is ready to accept connections 2022-11-25 08:48:30 2022-11-25 00:48:30.168 UTC [83] FATAL: role "illa" does not exist 2022-11-25 08:48:30 {"level":"error","ts":1669337310.1687324,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":5,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:48:30 {"level":"error","ts":1669337310.1687078,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:48:30 2022-11-25 08:48:30 2022/11/25 00:48:30 /opt/illa/builder-backend/pkg/db/connection.go:61 2022-11-25 08:48:30 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000)) 2022-11-25 08:48:30 2022-11-25 00:48:30.172 UTC [85] FATAL: role "illa" does not exist 2022-11-25 08:48:30 {"level":"error","ts":1669337310.1731477,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":5,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:48:30 {"level":"error","ts":1669337310.1731188,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:48:30 2022-11-25 08:48:30 2022/11/25 00:48:30 /opt/illa/builder-backend/pkg/db/connection.go:61 2022-11-25 08:48:30 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000)) 2022-11-25 08:48:40 2022-11-25 08:48:40 2022/11/25 00:48:40 /opt/illa/builder-backend/pkg/db/connection.go:61 2022-11-25 08:48:40 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000)) 2022-11-25 08:48:40 2022-11-25 08:48:40 2022/11/25 00:48:40 /opt/illa/builder-backend/pkg/db/connection.go:61 2022-11-25 08:48:40 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000)) 2022-11-25 08:48:40 2022-11-25 00:48:40.195 UTC [99] FATAL: role "illa" does not exist 2022-11-25 08:48:40 2022-11-25 00:48:40.195 UTC [98] FATAL: role "illa" does not exist 2022-11-25 08:48:40 {"level":"error","ts":1669337320.1956758,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":4,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:48:40 {"level":"error","ts":1669337320.1956265,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:48:40 {"level":"error","ts":1669337320.196666,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":4,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:48:40 {"level":"error","ts":1669337320.1956778,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:48:50 2022-11-25 00:48:50.207 UTC [111] FATAL: role "illa" does not exist 2022-11-25 08:48:50 {"level":"error","ts":1669337330.2075405,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":3,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:48:50 {"level":"error","ts":1669337330.2075145,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:48:50 2022-11-25 08:48:50 2022/11/25 00:48:50 /opt/illa/builder-backend/pkg/db/connection.go:61 2022-11-25 08:48:50 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000)) 2022-11-25 08:48:50 2022-11-25 00:48:50.210 UTC [113] FATAL: role "illa" does not exist 2022-11-25 08:48:50 {"level":"error","ts":1669337330.2111301,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":3,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:48:50 {"level":"error","ts":1669337330.2111025,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:48:50 2022-11-25 08:48:50 2022/11/25 00:48:50 /opt/illa/builder-backend/pkg/db/connection.go:61 2022-11-25 08:48:50 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000)) 2022-11-25 08:49:00 2022-11-25 00:49:00.219 UTC [126] FATAL: role "illa" does not exist 2022-11-25 08:49:00 2022-11-25 00:49:00.219 UTC [125] FATAL: role "illa" does not exist 2022-11-25 08:49:00 {"level":"error","ts":1669337340.219372,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":2,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:49:00 {"level":"error","ts":1669337340.219347,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:49:00 {"level":"error","ts":1669337340.2194014,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":2,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:49:00 {"level":"error","ts":1669337340.2193775,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:49:00 2022-11-25 08:49:00 2022/11/25 00:49:00 /opt/illa/builder-backend/pkg/db/connection.go:61 2022-11-25 08:49:00 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000)) 2022-11-25 08:49:00 2022-11-25 08:49:00 2022/11/25 00:49:00 /opt/illa/builder-backend/pkg/db/connection.go:61 2022-11-25 08:49:00 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000)) 2022-11-25 08:49:10 2022-11-25 00:49:10.509 UTC [139] FATAL: role "illa" does not exist 2022-11-25 08:49:10 {"level":"error","ts":1669337350.5101638,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":1,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:49:10 {"level":"error","ts":1669337350.5099618,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:49:10 panic: failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000)) 2022-11-25 08:49:10 2022-11-25 08:49:10 goroutine 1 [running]: 2022-11-25 08:49:10 github.com/illa-family/builder-backend/pkg/db.NewDbConnection(0xc00061be00, 0xc000124598) 2022-11-25 08:49:10 /opt/illa/builder-backend/pkg/db/connection.go:68 +0x925 2022-11-25 08:49:10 main.Initialize() 2022-11-25 08:49:10 /opt/illa/builder-backend/cmd/http-server/wire_gen.go:38 +0xa5 2022-11-25 08:49:10 main.main() 2022-11-25 08:49:10 /opt/illa/builder-backend/cmd/http-server/main.go:20 +0x19 2022-11-25 08:49:10 2022-11-25 00:49:10.523 UTC [140] FATAL: role "illa" does not exist 2022-11-25 08:49:10 {"level":"error","ts":1669337350.5241964,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":1,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:49:10 {"level":"error","ts":1669337350.5241725,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} 2022-11-25 08:49:10 2022-11-25 08:49:10 2022/11/25 00:49:10 /opt/illa/builder-backend/pkg/db/connection.go:61 2022-11-25 08:49:10 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000)) 2022-11-25 08:49:10 2022-11-25 08:49:10 2022/11/25 00:49:10 /opt/illa/builder-backend/pkg/db/connection.go:61 2022-11-25 08:49:10 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000)) 2022-11-25 08:49:10 panic: failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000)) 2022-11-25 08:49:10 2022-11-25 08:49:10 goroutine 1 [running]: 2022-11-25 08:49:10 github.com/illa-family/builder-backend/pkg/db.NewDbConnection(0xc00022e320, 0xc000126b48) 2022-11-25 08:49:10 /opt/illa/builder-backend/pkg/db/connection.go:68 +0x925 2022-11-25 08:49:10 main.initEnv() 2022-11-25 08:49:10 /opt/illa/builder-backend/cmd/websocket-server/main.go:54 +0x5d 2022-11-25 08:49:10 main.main() 2022-11-25 08:49:10 /opt/illa/builder-backend/cmd/websocket-server/main.go:127 +0x9c

看上去像本地已经有数据库文件了，但是数据库没有正确启动。解决方案如下：

尝试清理本地数据库文件（记得备份）然后重新部署
docker ps 看下是否有本地的Postgres数据库占用了5432端口？如果占用了可以考虑修改下或者暂停下。
另外这个日志看上去像v1.3.x版本的，我们昨天新发布了1.4.x版本，包含了一些bugfix。可以考虑试试新版本，看看会不会解决问题。

我确实是安装了本地的pg，但是先停掉了再启动docker的，也会有影响吗，我试试最新版本的看下

数据库已经初始化成功了，前端报错
{"errorCode":400,"errorMessage":"parse request body error: Key: 'SignUpRequest.VerificationToken' Error:Field validation for 'VerificationToken' failed on the 'required' tag"}导致无法注册

root@VM-0-7-ubuntu:/home/mark/illa-x86_64-linux# docker logs -f -t --tail 100 fd64c7725f9f
2022-11-26T14:51:11.276878651Z 2022-11-26 14:51:11.276 UTC [69] LOG:  listening on IPv4 address "<IP_ADDRESS>", port 5432
2022-11-26T14:51:11.277003136Z 2022-11-26 14:51:11.276 UTC [69] LOG:  listening on IPv6 address "::", port 5432
2022-11-26T14:51:11.284036901Z 2022-11-26 14:51:11.283 UTC [69] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-11-26T14:51:11.293351940Z 2022-11-26 14:51:11.293 UTC [84] LOG:  database system was shut down at 2022-11-26 14:51:11 UTC
2022-11-26T14:51:11.301763113Z 2022-11-26 14:51:11.301 UTC [69] LOG:  database system is ready to accept connections
2022-11-26T14:51:21.270774975Z 2022-11-26 14:51:21.270 UTC [103] FATAL:  role "illa" does not exist
2022-11-26T14:51:21.271447785Z
2022-11-26T14:51:21.271459183Z 2022/11/26 14:51:21 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-11-26T14:51:21.271464155Z [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-11-26T14:51:21.271612481Z {"level":"error","ts":1669474281.2715302,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":5,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-26T14:51:21.271685184Z {"level":"error","ts":1669474281.271508,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-26T14:51:21.273585937Z 2022-11-26 14:51:21.273 UTC [104] FATAL:  role "illa" does not exist
2022-11-26T14:51:21.273822293Z
2022-11-26T14:51:21.273834927Z 2022/11/26 14:51:21 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-11-26T14:51:21.273848502Z [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-11-26T14:51:21.274024867Z {"level":"error","ts":1669474281.2739244,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":5,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-26T14:51:21.274143038Z {"level":"error","ts":1669474281.273898,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-11-26T14:51:29.970592442Z CREATE DATABASE
2022-11-26T14:51:29.977544815Z You are now connected to database "illa" as user "postgres".
这是什么错误呢？

数据库已经初始化成功了，前端报错 {"errorCode":400,"errorMessage":"parse request body error: Key: 'SignUpRequest.VerificationToken' Error:Field validation for 'VerificationToken' failed on the 'required' tag"}导致无法注册

您好，请问您点击获取验证码之后有正常收到邮件吗？看起来像是获取验证码时失败了

安装过程写的不细致，容易产生各种问题。
一开始的数据库端口的问题其实是安装开发工具时选择过多时造成的本地数据库端口占用。
但后续依然无法注册
| |
何威
|
|
@.***
|
---- 回复的原邮件 ----
| 发件人 | @.> |
| 发送日期 | 2022年11月28日 18:36 |
| 收件人 | @.> |
| 抄送人 | @.> ,
@.> |
| 主题 | Re: [illacloud/illa-builder] 私有化部署后不能注册用户进行登录，提示网络错误 (Issue #543) |
数据库已经初始化成功了，前端报错 {"errorCode":400,"errorMessage":"parse request body error: Key: 'SignUpRequest.VerificationToken' Error:Field validation for 'VerificationToken' failed on the 'required' tag"}导致无法注册
您好，请问您点击获取验证码之后有正常收到邮件吗？看起来像是获取验证码时失败了
—
Reply to this email directly, view it on GitHub, or unsubscribe.
You are receiving this because you commented.Message ID: @.***>

前端 网络异常

initdb: error: directory "/var/lib/postgresql/data" exists but is not empty If you want to create a new database system, either remove or empty the directory "/var/lib/postgresql/data" or run initdb with an argument other than "/var/lib/postgresql/data". postgres: could not access the server configuration file "/var/lib/postgresql/data/postgresql.conf": No such file or directory {"level":"error","ts":1669700219.1179018,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":6,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} {"level":"error","ts":1669700219.1174076,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}

@

前端 网络异常

请尝试用root用户部署？这个问题看上去是数据库无法访问本地存储上的数据库文件造成的。
如果没有特殊的定制化需求请使用自动化程度更高的 illa-cli 部署

看上去像数据库初始化失败了，请提供您的部署方式，操作系统和部署环境？

now user is: 999
2022-12-01 00:56:51 Error: Database is uninitialized and superuser password is not specified.
2022-12-01 00:56:51        You must specify POSTGRES_PASSWORD to a non-empty value for the
2022-12-01 00:56:51        superuser. For example, "-e POSTGRES_PASSWORD=password" on "docker run".
2022-12-01 00:56:51
2022-12-01 00:56:51        You may also use "POSTGRES_HOST_AUTH_METHOD=trust" to allow all
2022-12-01 00:56:51        connections without a password. This is not recommended.
2022-12-01 00:56:51
2022-12-01 00:56:51        See PostgreSQL documentation about "trust":
2022-12-01 00:56:51        https://www.postgresql.org/docs/current/auth-trust.html

now user is: 999 2022-12-01 00:56:51 Error: Database is uninitialized and superuser password is not specified. 2022-12-01 00:56:51 You must specify POSTGRES_PASSWORD to a non-empty value for the 2022-12-01 00:56:51 superuser. For example, "-e POSTGRES_PASSWORD=password" on "docker run". 2022-12-01 00:56:51 2022-12-01 00:56:51 You may also use "POSTGRES_HOST_AUTH_METHOD=trust" to allow all 2022-12-01 00:56:51 connections without a password. This is not recommended. 2022-12-01 00:56:51 2022-12-01 00:56:51 See PostgreSQL documentation about "trust": 2022-12-01 00:56:51 https://www.postgresql.org/docs/current/auth-trust.html

我也遇到了部署好之后出现网络错误提示。使用docker desktop 拉取镜像，然后使用illa.exe 执行安装部署。windows11 系统，系统内没有安装过数据库和WEB软件。

同样的问题，好不容易部署成功，卡在登陆页面了

initdb: error: directory "/var/lib/postgresql/data" exists but is not empty If you want to create a new database system, either remove or empty the directory "/var/lib/postgresql/data" or run initdb with an argument other than "/var/lib/postgresql/data". postgres: could not access the server configuration file "/var/lib/postgresql/data/postgresql.conf": No such file or directory {"level":"error","ts":1669700219.1179018,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":6,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} {"level":"error","ts":1669700219.1174076,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}

请提供更多的部署细节？比如操作系统，部署方式等。

docker desktop 拉取镜像，然后使用illa.exe 执行安装部署。
部署时有正确配置服务器地址环境变量吗？
请提供更详细的浏览器控制台network信息？
部署时有正确配置服务器地址环境变量吗？
请提供更详细的浏览器控制台network信息？实在是太小了看不清楚
感谢反馈

windows10和centos7都试过，都失败了，通过ILLA CLI下载链接安装，使用illa deploy --self --port=10000启动
都是网络无法连接
2022-12-06 21:38:12
2022-12-06 21:38:12 config init.
2022-12-06 21:38:12
2022-12-06 21:38:12 API_SERVER_PORT not defined, skip.
2022-12-06 21:38:12
2022-12-06 21:38:12 config init done.
2022-12-06 21:38:12
2022-12-06 21:38:12 Running postgres-entrypoint.sh
2022-12-06 21:38:12 now user is: 0
2022-12-06 21:38:12
2022-12-06 21:38:12 illa database already exists; Skipping initialization
2022-12-06 21:38:12
2022-12-06 21:38:12 total 36K
2022-12-06 21:38:12 drwxr-xr-x 1 root     root     4.0K Oct  5 09:05 .
2022-12-06 21:38:12 drwxr-xr-x 1 root     root     4.0K Oct  4 00:00 ..
2022-12-06 21:38:12 drwxr-xr-x 1 root     root     4.0K Dec  2 10:41 apt
2022-12-06 21:38:12 drwxr-xr-x 1 root     root     4.0K Dec  2 10:41 dpkg
2022-12-06 21:38:12 drwxr-xr-x 2 root     root     4.0K Sep  3 12:10 misc
2022-12-06 21:38:12 drwxr-xr-x 2 root     root     4.0K Oct  4 00:00 pam
2022-12-06 21:38:12 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 postgresql
2022-12-06 21:38:12 drwxr-xr-x 1 root     root     4.0K Oct  5 09:04 systemd
2022-12-06 21:38:12 drwxr-xr-x 3 root     root     4.0K Oct  5 09:05 ucf
2022-12-06 21:38:12 total 8.0K
2022-12-06 21:38:12 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 .
2022-12-06 21:38:12 drwxr-xr-x 1 root     root     4.0K Oct  5 09:05 ..
2022-12-06 21:38:12 drwx------ 1 postgres root     4.0K Dec  6 13:36 data
2022-12-06 21:38:12 total 48K
2022-12-06 21:38:12 drwx------ 1 postgres root     4.0K Dec  6 13:36 .
2022-12-06 21:38:12 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 ..
2022-12-06 21:38:12 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 base
2022-12-06 21:38:12 drwx------ 1 postgres postgres 4.0K Dec  6 13:37 global
2022-12-06 21:38:12 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_commit_ts
2022-12-06 21:38:12 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_dynshmem
2022-12-06 21:38:12 -rw------- 1 postgres postgres 4.8K Dec  6 13:36 pg_hba.conf
2022-12-06 21:38:12 -rw------- 1 postgres postgres 1.6K Dec  6 13:36 pg_ident.conf
2022-12-06 21:38:12 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_logical
2022-12-06 21:38:12 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_multixact
2022-12-06 21:38:14 {"level":"error","ts":1670333894.062811,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":6,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:38:14 {"level":"error","ts":1670333894.0627024,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:38:14 {"level":"error","ts":1670333894.0637176,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":6,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:38:14 {"level":"error","ts":1670333894.0635848,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:38:14 2022-12-06 13:38:14.131 UTC [40] LOG:  starting PostgreSQL 14.5 (Debian 14.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
2022-12-06 21:38:14 2022-12-06 13:38:14.132 UTC [40] LOG:  listening on IPv4 address "<IP_ADDRESS>", port 5432
2022-12-06 21:38:14 2022-12-06 13:38:14.132 UTC [40] LOG:  listening on IPv6 address "::", port 5432
2022-12-06 21:38:14 2022-12-06 13:38:14.144 UTC [40] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-12-06 21:38:14 2022-12-06 13:38:14.192 UTC [66] LOG:  database system was interrupted; last known up at 2022-12-06 13:36:40 UTC
2022-12-06 21:38:12 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_notify
2022-12-06 21:38:12 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_replslot
2022-12-06 21:38:12 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_serial
2022-12-06 21:38:12 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_snapshots
2022-12-06 21:38:12 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_stat
2022-12-06 21:38:12 drwx------ 1 postgres postgres 4.0K Dec  6 13:37 pg_stat_tmp
2022-12-06 21:38:12 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_subtrans
2022-12-06 21:38:12 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_tblspc
2022-12-06 21:38:12 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_twophase
2022-12-06 21:38:12 -rw------- 1 postgres postgres    3 Dec  6 13:36 PG_VERSION
2022-12-06 21:38:12 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_wal
2022-12-06 21:38:12 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_xact
2022-12-06 21:38:12 -rw------- 1 postgres postgres   88 Dec  6 13:36 postgresql.auto.conf
2022-12-06 21:38:12 -rw------- 1 postgres postgres  29K Dec  6 13:36 postgresql.conf
2022-12-06 21:38:12 -rw------- 1 postgres postgres   36 Dec  6 13:36 postmaster.opts
2022-12-06 21:38:12 -rw------- 1 postgres postgres   95 Dec  6 13:36 postmaster.pid
2022-12-06 21:38:13 Running postgres-entrypoint.sh
2022-12-06 21:38:13 now user is: 999
2022-12-06 21:38:13 total 36K
2022-12-06 21:38:13 drwxr-xr-x 1 root     root     4.0K Oct  5 09:05 .
2022-12-06 21:38:13 drwxr-xr-x 1 root     root     4.0K Oct  4 00:00 ..
2022-12-06 21:38:13 drwxr-xr-x 1 root     root     4.0K Dec  2 10:41 apt
2022-12-06 21:38:13 drwxr-xr-x 1 root     root     4.0K Dec  2 10:41 dpkg
2022-12-06 21:38:13 drwxr-xr-x 2 root     root     4.0K Sep  3 12:10 misc
2022-12-06 21:38:13 drwxr-xr-x 2 root     root     4.0K Oct  4 00:00 pam
2022-12-06 21:38:13 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 postgresql
2022-12-06 21:38:13 drwxr-xr-x 1 root     root     4.0K Oct  5 09:04 systemd
2022-12-06 21:38:13 drwxr-xr-x 3 root     root     4.0K Oct  5 09:05 ucf
2022-12-06 21:38:13 total 8.0K
2022-12-06 21:38:13 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 .
2022-12-06 21:38:13 drwxr-xr-x 1 root     root     4.0K Oct  5 09:05 ..
2022-12-06 21:38:13 drwx------ 1 postgres root     4.0K Dec  6 13:36 data
2022-12-06 21:38:14 total 48K
2022-12-06 21:38:14 drwx------ 1 postgres root     4.0K Dec  6 13:36 .
2022-12-06 21:38:14 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 ..
2022-12-06 21:38:14 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 base
2022-12-06 21:38:14 drwx------ 1 postgres postgres 4.0K Dec  6 13:37 global
2022-12-06 21:38:14 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_commit_ts
2022-12-06 21:38:14 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_dynshmem
2022-12-06 21:38:14 -rw------- 1 postgres postgres 4.8K Dec  6 13:36 pg_hba.conf
2022-12-06 21:38:14 -rw------- 1 postgres postgres 1.6K Dec  6 13:36 pg_ident.conf
2022-12-06 21:38:14 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_logical
2022-12-06 21:38:14 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_multixact
2022-12-06 21:38:14 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_notify
2022-12-06 21:38:14 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_replslot
2022-12-06 21:38:14 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_serial
2022-12-06 21:38:14 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_snapshots
2022-12-06 21:38:14 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_stat
2022-12-06 21:38:14 drwx------ 1 postgres postgres 4.0K Dec  6 13:37 pg_stat_tmp
2022-12-06 21:38:14 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_subtrans
2022-12-06 21:38:14 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_tblspc
2022-12-06 21:38:14 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_twophase
2022-12-06 21:38:14 -rw------- 1 postgres postgres    3 Dec  6 13:36 PG_VERSION
2022-12-06 21:38:14 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_wal
2022-12-06 21:38:14 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_xact
2022-12-06 21:38:14 -rw------- 1 postgres postgres   88 Dec  6 13:36 postgresql.auto.conf
2022-12-06 21:38:14 -rw------- 1 postgres postgres  29K Dec  6 13:36 postgresql.conf
2022-12-06 21:38:14 -rw------- 1 postgres postgres   36 Dec  6 13:36 postmaster.opts
2022-12-06 21:38:14 -rw------- 1 postgres postgres   95 Dec  6 13:36 postmaster.pid
2022-12-06 21:38:14
2022-12-06 21:38:14 PostgreSQL Database directory appears to contain a database; Skipping initialization
2022-12-06 21:38:14
2022-12-06 21:38:14 [GIN-debug] [WARNING] Running in "debug" mode. Switch to "release" mode in production.
2022-12-06 21:38:14  - using env:       export GIN_MODE=release
2022-12-06 21:38:14  - using code:      gin.SetMode(gin.ReleaseMode)
2022-12-06 21:38:14
2022-12-06 21:38:14
2022-12-06 21:38:14 2022/12/06 13:38:14 /opt/illa/builder-backend/pkg/db/connection.go:48
2022-12-06 21:38:14 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: dial error (dial tcp [::1]:5432: connect: cannot assign requested address)
2022-12-06 21:38:14
2022-12-06 21:38:14 2022/12/06 13:38:14 /opt/illa/builder-backend/pkg/db/connection.go:48
2022-12-06 21:38:14 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: dial error (dial tcp [::1]:5432: connect: cannot assign requested address)
2022-12-06 21:38:17 "06/Dec/2022:13:38:17 +0000" client=<IP_ADDRESS> method=GET request="GET /user/register HTTP/1.1" request_length=771 status=200 bytes_sent=1421 body_bytes_sent=1107 referer=http://localhost:10000/dashboard http_x_forwarded_for=- user_agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36" upstream_addr=- upstream_status=- request_time=0.000 upstream_response_time=- upstream_connect_time=- upstream_header_time=-
2022-12-06 21:38:24
2022-12-06 21:38:24 2022/12/06 13:38:24 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:38:24 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:38:24
2022-12-06 21:38:24 2022/12/06 13:38:24 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:38:24 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:38:34
2022-12-06 21:38:34 2022/12/06 13:38:34 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:38:34 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:38:34
2022-12-06 21:38:34 2022/12/06 13:38:34 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:38:34 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:38:44
2022-12-06 21:38:44 2022/12/06 13:38:44 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:38:44 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:38:19 2022-12-06 13:38:19.956 UTC [66] LOG:  database system was not properly shut down; automatic recovery in progress
2022-12-06 21:38:20 2022-12-06 13:38:20.005 UTC [66] LOG:  redo starts at 0/16FAF08
2022-12-06 21:38:20 2022-12-06 13:38:20.006 UTC [66] LOG:  invalid record length at 0/16FAF40: wanted 24, got 0
2022-12-06 21:38:20 2022-12-06 13:38:20.006 UTC [66] LOG:  redo done at 0/16FAF08 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2022-12-06 21:38:20 2022-12-06 13:38:20.152 UTC [40] LOG:  database system is ready to accept connections
2022-12-06 21:38:24 2022-12-06 13:38:24.078 UTC [84] FATAL:  role "illa" does not exist
2022-12-06 21:38:24 {"level":"error","ts":1670333904.0787444,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":5,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:38:24 {"level":"error","ts":1670333904.078698,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:38:24 2022-12-06 13:38:24.088 UTC [86] FATAL:  role "illa" does not exist
2022-12-06 21:38:24 {"level":"error","ts":1670333904.0890584,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":5,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:38:24 {"level":"error","ts":1670333904.0890155,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:38:34 2022-12-06 13:38:34.102 UTC [98] FATAL:  role "illa" does not exist
2022-12-06 21:38:34 {"level":"error","ts":1670333914.1031623,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":4,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:38:34 {"level":"error","ts":1670333914.103101,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:38:34 2022-12-06 13:38:34.105 UTC [101] FATAL:  role "illa" does not exist
2022-12-06 21:38:34 {"level":"error","ts":1670333914.1058104,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":4,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:38:34 {"level":"error","ts":1670333914.1057532,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:38:44 2022-12-06 13:38:44.125 UTC [114] FATAL:  role "illa" does not exist
2022-12-06 21:38:44 2022-12-06 13:38:44.126 UTC [115] FATAL:  role "illa" does not exist
2022-12-06 21:38:44 {"level":"error","ts":1670333924.126472,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":3,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:38:44 {"level":"error","ts":1670333924.1264226,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:38:44 {"level":"error","ts":1670333924.1268346,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":3,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:38:44 {"level":"error","ts":1670333924.126805,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:38:54 2022-12-06 13:38:54.147 UTC [128] FATAL:  role "illa" does not exist
2022-12-06 21:38:54 2022-12-06 13:38:54.147 UTC [129] FATAL:  role "illa" does not exist
2022-12-06 21:38:54 {"level":"error","ts":1670333934.147969,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":2,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:38:54 {"level":"error","ts":1670333934.1479304,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:38:54 {"level":"error","ts":1670333934.148096,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":2,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:38:54 {"level":"error","ts":1670333934.148023,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:39:04 2022-12-06 13:39:04.169 UTC [143] FATAL:  role "illa" does not exist
2022-12-06 21:39:04 2022-12-06 13:39:04.169 UTC [142] FATAL:  role "illa" does not exist
2022-12-06 21:39:04 {"level":"error","ts":1670333944.1696181,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":1,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:39:04 {"level":"error","ts":1670333944.1695764,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:39:04 {"level":"error","ts":1670333944.1696432,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":1,"stacktrace":"go.uber.org/zap.(SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:39:04 {"level":"error","ts":1670333944.1695964,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:39:04 panic: panic: failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:39:04
2022-12-06 21:39:04 goroutine 1 [running]:
2022-12-06 21:39:04 github.com/illa-family/builder-backend/pkg/db.NewDbConnection(0xc00007e410, 0xc00000eb58)
2022-12-06 21:39:04     /opt/illa/builder-backend/pkg/db/connection.go:68failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000)) +
2022-12-06 21:39:04 0x925
2022-12-06 21:39:04
2022-12-06 21:39:04 goroutine 1 [runningmain.initEnv]:
2022-12-06 21:39:04 ()
2022-12-06 21:39:04     /opt/illa/builder-backend/cmd/websocket-server/main.go:54 +0x5d
2022-12-06 21:39:04 main.main()
2022-12-06 21:39:04 github.com/illa-family/builder-backend/pkg/db.NewDbConnection       (/opt/illa/builder-backend/cmd/websocket-server/main.go0xc0000c2c80:, 0xc0000bcbf0127)
2022-12-06 21:39:04  +  /opt/illa/builder-backend/pkg/db/connection.go0x9c
2022-12-06 21:39:04 :68 +0x925
2022-12-06 21:39:04 main.Initialize()
2022-12-06 21:39:04     /opt/illa/builder-backend/cmd/http-server/wire_gen.go:38 +0xa5
2022-12-06 21:39:04 main.main()
2022-12-06 21:39:04     /opt/illa/builder-backend/cmd/http-server/main.go:20 +0x19
2022-12-06 21:40:06 2022-12-06 13:40:06.246 UTC [40] LOG:  received fast shutdown request
2022-12-06 21:38:44
2022-12-06 21:38:44 2022/12/06 13:38:44 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:38:44 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:38:54
2022-12-06 21:38:54 2022/12/06 13:38:54 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:38:54 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:38:54
2022-12-06 21:38:54 2022/12/06 13:38:54 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:38:54 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:39:04
2022-12-06 21:39:04 2022/12/06 13:39:04 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:39:04 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:39:04
2022-12-06 21:39:04 2022/12/06 13:39:04 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:39:04 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:40:15
2022-12-06 21:40:15 config init.
2022-12-06 21:40:15
2022-12-06 21:40:15 API_SERVER_PORT not defined, skip.
2022-12-06 21:40:15
2022-12-06 21:40:15 config init done.
2022-12-06 21:40:15
2022-12-06 21:40:15 Running postgres-entrypoint.sh
2022-12-06 21:40:15
2022-12-06 21:40:15 illa database already exists; Skipping initialization
2022-12-06 21:40:15
2022-12-06 21:40:15 now user is: 0
2022-12-06 21:40:15 total 36K
2022-12-06 21:40:15 drwxr-xr-x 1 root     root     4.0K Oct  5 09:05 .
2022-12-06 21:40:15 drwxr-xr-x 1 root     root     4.0K Oct  4 00:00 ..
2022-12-06 21:40:15 drwxr-xr-x 1 root     root     4.0K Dec  2 10:41 apt
2022-12-06 21:40:15 drwxr-xr-x 1 root     root     4.0K Dec  2 10:41 dpkg
2022-12-06 21:40:15 drwxr-xr-x 2 root     root     4.0K Sep  3 12:10 misc
2022-12-06 21:40:15 drwxr-xr-x 2 root     root     4.0K Oct  4 00:00 pam
2022-12-06 21:40:15 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 postgresql
2022-12-06 21:40:15 drwxr-xr-x 1 root     root     4.0K Oct  5 09:04 systemd
2022-12-06 21:40:15 drwxr-xr-x 3 root     root     4.0K Oct  5 09:05 ucf
2022-12-06 21:40:15 total 8.0K
2022-12-06 21:40:15 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 .
2022-12-06 21:40:15 drwxr-xr-x 1 root     root     4.0K Oct  5 09:05 ..
2022-12-06 21:40:15 drwx------ 1 postgres root     4.0K Dec  6 13:38 data
2022-12-06 21:40:15 total 48K
2022-12-06 21:40:15 drwx------ 1 postgres root     4.0K Dec  6 13:38 .
2022-12-06 21:40:15 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 ..
2022-12-06 21:40:15 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 base
2022-12-06 21:40:15 drwx------ 1 postgres postgres 4.0K Dec  6 13:38 global
2022-12-06 21:40:15 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_commit_ts
2022-12-06 21:40:15 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_dynshmem
2022-12-06 21:40:15 -rw------- 1 postgres postgres 4.8K Dec  6 13:36 pg_hba.conf
2022-12-06 21:40:15 -rw------- 1 postgres postgres 1.6K Dec  6 13:36 pg_ident.conf
2022-12-06 21:40:15 drwx------ 1 postgres postgres 4.0K Dec  6 13:38 pg_logical
2022-12-06 21:40:15 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_multixact
2022-12-06 21:40:15 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_notify
2022-12-06 21:40:15 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_replslot
2022-12-06 21:40:15 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_serial
2022-12-06 21:40:15 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_snapshots
2022-12-06 21:40:15 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_stat
2022-12-06 21:40:15 drwx------ 1 postgres postgres 4.0K Dec  6 13:39 pg_stat_tmp
2022-12-06 21:40:15 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_subtrans
2022-12-06 21:40:15 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_tblspc
2022-12-06 21:40:15 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_twophase
2022-12-06 21:40:15 -rw------- 1 postgres postgres    3 Dec  6 13:36 PG_VERSION
2022-12-06 21:40:15 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_wal
2022-12-06 21:40:15 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_xact
2022-12-06 21:40:15 -rw------- 1 postgres postgres   88 Dec  6 13:36 postgresql.auto.conf
2022-12-06 21:40:15 -rw------- 1 postgres postgres  29K Dec  6 13:36 postgresql.conf
2022-12-06 21:40:15 -rw------- 1 postgres postgres   36 Dec  6 13:38 postmaster.opts
2022-12-06 21:40:15 -rw------- 1 postgres postgres   95 Dec  6 13:38 postmaster.pid
2022-12-06 21:40:17 Running postgres-entrypoint.sh
2022-12-06 21:40:17 now user is: 999
2022-12-06 21:40:17 total 36K
2022-12-06 21:40:17 drwxr-xr-x 1 root     root     4.0K Oct  5 09:05 .
2022-12-06 21:40:17 drwxr-xr-x 1 root     root     4.0K Oct  4 00:00 ..
2022-12-06 21:40:17 drwxr-xr-x 1 root     root     4.0K Dec  2 10:41 apt
2022-12-06 21:40:17 drwxr-xr-x 1 root     root     4.0K Dec  2 10:41 dpkg
2022-12-06 21:40:17 drwxr-xr-x 2 root     root     4.0K Sep  3 12:10 misc
2022-12-06 21:40:17 drwxr-xr-x 2 root     root     4.0K Oct  4 00:00 pam
2022-12-06 21:40:17 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 postgresql
2022-12-06 21:40:17 drwxr-xr-x 1 root     root     4.0K Oct  5 09:04 systemd
2022-12-06 21:40:17 drwxr-xr-x 3 root     root     4.0K Oct  5 09:05 ucf
2022-12-06 21:40:17 total 8.0K
2022-12-06 21:40:17 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 .
2022-12-06 21:40:17 drwxr-xr-x 1 root     root     4.0K Oct  5 09:05 ..
2022-12-06 21:40:17 drwx------ 1 postgres root     4.0K Dec  6 13:38 data
2022-12-06 21:40:17 total 48K
2022-12-06 21:40:17 drwx------ 1 postgres root     4.0K Dec  6 13:38 .
2022-12-06 21:40:17 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 ..
2022-12-06 21:40:17 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 base
2022-12-06 21:40:17 drwx------ 1 postgres postgres 4.0K Dec  6 13:38 global
2022-12-06 21:40:17 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_commit_ts
2022-12-06 21:40:17 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_dynshmem
2022-12-06 21:40:17 -rw------- 1 postgres postgres 4.8K Dec  6 13:36 pg_hba.conf
2022-12-06 21:40:17 -rw------- 1 postgres postgres 1.6K Dec  6 13:36 pg_ident.conf
2022-12-06 21:40:17 drwx------ 1 postgres postgres 4.0K Dec  6 13:38 pg_logical
2022-12-06 21:40:17 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_multixact
2022-12-06 21:40:17 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_notify
2022-12-06 21:40:17 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_replslot
2022-12-06 21:40:17 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_serial
2022-12-06 21:40:17 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_snapshots
2022-12-06 21:40:17 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_stat
2022-12-06 21:40:17 drwx------ 1 postgres postgres 4.0K Dec  6 13:39 pg_stat_tmp
2022-12-06 21:40:17 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_subtrans
2022-12-06 21:40:17 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_tblspc
2022-12-06 21:40:17 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_twophase
2022-12-06 21:40:17 -rw------- 1 postgres postgres    3 Dec  6 13:36 PG_VERSION
2022-12-06 21:40:17 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_wal
2022-12-06 21:40:17 drwx------ 1 postgres postgres 4.0K Dec  6 13:36 pg_xact
2022-12-06 21:40:17 -rw------- 1 postgres postgres   88 Dec  6 13:36 postgresql.auto.conf
2022-12-06 21:40:17 -rw------- 1 postgres postgres  29K Dec  6 13:36 postgresql.conf
2022-12-06 21:40:17 -rw------- 1 postgres postgres   36 Dec  6 13:38 postmaster.opts
2022-12-06 21:40:17 -rw------- 1 postgres postgres   95 Dec  6 13:38 postmaster.pid
2022-12-06 21:40:17
2022-12-06 21:40:17 PostgreSQL Database directory appears to contain a database; Skipping initialization
2022-12-06 21:40:17
2022-12-06 21:40:17 [GIN-debug] [WARNING] Running in "debug" mode. Switch to "release" mode in production.
2022-12-06 21:40:17  - using env:       export GIN_MODE=release
2022-12-06 21:40:17  - using code:      gin.SetMode(gin.ReleaseMode)
2022-12-06 21:40:17
2022-12-06 21:40:17
2022-12-06 21:40:17 2022/12/06 13:40:17 /opt/illa/builder-backend/pkg/db/connection.go:48
2022-12-06 21:40:17 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: dial error (dial tcp [::1]:5432: connect: cannot assign requested address)
2022-12-06 21:40:17
2022-12-06 21:40:17 2022/12/06 13:40:17 /opt/illa/builder-backend/pkg/db/connection.go:48
2022-12-06 21:40:17 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: dial error (dial tcp [::1]:5432: connect: cannot assign requested address)
2022-12-06 21:40:27
2022-12-06 21:40:27 2022/12/06 13:40:27 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:40:27 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:40:27
2022-12-06 21:40:27 2022/12/06 13:40:27 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:40:27 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:40:37
2022-12-06 21:40:37 2022/12/06 13:40:37 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:40:37 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:40:37
2022-12-06 21:40:37 2022/12/06 13:40:37 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:40:37 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:40:47
2022-12-06 21:40:47 2022/12/06 13:40:47 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:40:47 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:40:47
2022-12-06 21:40:47 2022/12/06 13:40:47 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:40:47 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:40:57 "06/Dec/2022:13:40:57 +0000" client=<IP_ADDRESS> method=GET request="GET /user/login HTTP/1.1" request_length=851 status=304 bytes_sent=245 body_bytes_sent=0 referer=http://localhost:10000/dashboard http_x_forwarded_for=- user_agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36" upstream_addr=- upstream_status=- request_time=0.000 upstream_response_time=- upstream_connect_time=- upstream_header_time=-
2022-12-06 21:40:57
2022-12-06 21:40:57 2022/12/06 13:40:57 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:40:57 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:40:57
2022-12-06 21:40:57 2022/12/06 13:40:57 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:40:57 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:41:07
2022-12-06 21:41:07 2022/12/06 13:41:07 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:41:07 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:41:07
2022-12-06 21:41:07 2022/12/06 13:41:07 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:41:07 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:42:02 "06/Dec/2022:13:42:02 +0000" client=<IP_ADDRESS> method=GET request="GET / HTTP/1.1" request_length=765 status=304 bytes_sent=245 body_bytes_sent=0 referer=- http_x_forwarded_for=- user_agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36" upstream_addr=- upstream_status=- request_time=0.000 upstream_response_time=- upstream_connect_time=- upstream_header_time=-
2022-12-06 21:42:02 "06/Dec/2022:13:42:02 +0000" client=<IP_ADDRESS> method=GET request="GET /user/login HTTP/1.1" request_length=805 status=304 bytes_sent=245 body_bytes_sent=0 referer=http://localhost:10000/dashboard http_x_forwarded_for=- user_agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36" upstream_addr=- upstream_status=- request_time=0.000 upstream_response_time=- upstream_connect_time=- upstream_header_time=-
2022-12-06 21:47:03 "06/Dec/2022:13:47:03 +0000" client=<IP_ADDRESS> method=GET request="GET /assets/en.f34410aa.js.map HTTP/1.1" request_length=428 status=200 bytes_sent=1412 body_bytes_sent=1085 referer=- http_x_forwarded_for=- user_agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36" upstream_addr=- upstream_status=- request_time=0.000 upstream_response_time=- upstream_connect_time=- upstream_header_time=-
2022-12-06 21:47:03 "06/Dec/2022:13:47:03 +0000" client=<IP_ADDRESS> method=GET request="GET /assets/index.669b49d2.js.map HTTP/1.1" request_length=431 status=200 bytes_sent=24325968 body_bytes_sent=24325633 referer=- http_x_forwarded_for=- user_agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36" upstream_addr=- upstream_status=- request_time=0.693 upstream_response_time=- upstream_connect_time=- upstream_header_time=-
2022-12-06 21:54:08
2022-12-06 21:54:08 config init.
2022-12-06 21:54:08
2022-12-06 21:54:08 API_SERVER_PORT not defined, skip.
2022-12-06 21:54:08
2022-12-06 21:54:08 config init done.
2022-12-06 21:54:08
2022-12-06 21:54:08
2022-12-06 21:54:08 init illa database.
2022-12-06 21:54:08
2022-12-06 21:54:08 Running postgres-entrypoint.sh
2022-12-06 21:54:08 now user is: 0
2022-12-06 21:54:08 total 36K
2022-12-06 21:54:08 drwxr-xr-x 1 root     root     4.0K Oct  5 09:05 .
2022-12-06 21:54:08 drwxr-xr-x 1 root     root     4.0K Oct  4 00:00 ..
2022-12-06 21:54:08 drwxr-xr-x 1 root     root     4.0K Dec  2 10:41 apt
2022-12-06 21:54:08 drwxr-xr-x 1 root     root     4.0K Dec  2 10:41 dpkg
2022-12-06 21:54:08 drwxr-xr-x 2 root     root     4.0K Sep  3 12:10 misc
2022-12-06 21:54:08 drwxr-xr-x 2 root     root     4.0K Oct  4 00:00 pam
2022-12-06 21:54:08 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 postgresql
2022-12-06 21:54:08 drwxr-xr-x 1 root     root     4.0K Oct  5 09:04 systemd
2022-12-06 21:54:08 drwxr-xr-x 3 root     root     4.0K Oct  5 09:05 ucf
2022-12-06 21:54:08 total 8.0K
2022-12-06 21:54:08 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 .
2022-12-06 21:54:08 drwxr-xr-x 1 root     root     4.0K Oct  5 09:05 ..
2022-12-06 21:54:08 drwxrwxrwx 1 root     root     4.0K Dec  6 13:54 data
2022-12-06 21:54:08 total 4.0K
2022-12-06 21:54:08 drwxrwxrwx 1 root     root     4.0K Dec  6 13:54 .
2022-12-06 21:54:08 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 ..
2022-12-06 21:54:08 Running postgres-entrypoint.sh
2022-12-06 21:54:08 now user is: 999
2022-12-06 21:54:08 total 36K
2022-12-06 21:54:08 drwxr-xr-x 1 root     root     4.0K Oct  5 09:05 .
2022-12-06 21:54:08 drwxr-xr-x 1 root     root     4.0K Oct  4 00:00 ..
2022-12-06 21:54:08 drwxr-xr-x 1 root     root     4.0K Dec  2 10:41 apt
2022-12-06 21:54:08 drwxr-xr-x 1 root     root     4.0K Dec  2 10:41 dpkg
2022-12-06 21:54:08 drwxr-xr-x 2 root     root     4.0K Sep  3 12:10 misc
2022-12-06 21:54:08 drwxr-xr-x 2 root     root     4.0K Oct  4 00:00 pam
2022-12-06 21:54:08 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 postgresql
2022-12-06 21:54:08 drwxr-xr-x 1 root     root     4.0K Oct  5 09:04 systemd
2022-12-06 21:54:08 drwxr-xr-x 3 root     root     4.0K Oct  5 09:05 ucf
2022-12-06 21:54:08 total 8.0K
2022-12-06 21:54:08 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 .
2022-12-06 21:54:08 drwxr-xr-x 1 root     root     4.0K Oct  5 09:05 ..
2022-12-06 21:54:08 drwx------ 1 postgres root     4.0K Dec  6 13:54 data
2022-12-06 21:54:08 total 4.0K
2022-12-06 21:54:08 drwx------ 1 postgres root     4.0K Dec  6 13:54 .
2022-12-06 21:54:08 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 ..
2022-12-06 21:54:08 The files belonging to this database system will be owned by user "postgres".
2022-12-06 21:54:08 This user must also own the server process.
2022-12-06 21:54:08
2022-12-06 21:54:08 The database cluster will be initialized with locale "en_US.utf8".
2022-12-06 21:54:08 The default database encoding has accordingly been set to "UTF8".
2022-12-06 21:54:08 The default text search configuration will be set to "english".
2022-12-06 21:54:08
2022-12-06 21:54:08 Data page checksums are disabled.
2022-12-06 21:54:08
2022-12-06 21:54:08 fixing permissions on existing directory /var/lib/postgresql/data ... ok
2022-12-06 21:54:08 creating subdirectories ... ok
2022-12-06 21:54:08 selecting dynamic shared memory implementation ... posix
2022-12-06 21:54:08 selecting default max_connections ... 100
2022-12-06 21:54:08 selecting default shared_buffers ... 128MB
2022-12-06 21:54:08 selecting default time zone ... Etc/UTC
2022-12-06 21:54:08 creating configuration files ... ok
2022-12-06 21:54:15 running bootstrap script ... ok
2022-12-06 21:54:26 performing post-bootstrap initialization ... ok
2022-12-06 21:54:32 syncing data to disk ... ok
2022-12-06 21:54:32
2022-12-06 21:54:32
2022-12-06 21:54:32 Success. You can now start the database server using:
2022-12-06 21:54:32
2022-12-06 21:54:32     pg_ctl -D /var/lib/postgresql/data -l logfile start
2022-12-06 21:54:32
2022-12-06 21:54:32 waiting for server to start....2022-12-06 13:54:32.346 UTC [66] LOG:  starting PostgreSQL 14.5 (Debian 14.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
2022-12-06 21:54:32 2022-12-06 13:54:32.351 UTC [66] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-12-06 21:54:32 2022-12-06 13:54:32.421 UTC [67] LOG:  database system was shut down at 2022-12-06 13:54:26 UTC
2022-12-06 21:54:32 2022-12-06 13:54:32.515 UTC [66] LOG:  database system is ready to accept connections
2022-12-06 21:54:32  done
2022-12-06 21:54:32 server started
2022-12-06 21:54:32
2022-12-06 21:54:32 /opt/illa/database/postgres-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/
2022-12-06 21:54:32
2022-12-06 21:54:32 2022-12-06 13:54:32.932 UTC [66] LOG:  received fast shutdown request
2022-12-06 21:54:32 waiting for server to shut down....2022-12-06 13:54:32.940 UTC [66] LOG:  aborting any active transactions
2022-12-06 21:54:32 2022-12-06 13:54:32.942 UTC [66] LOG:  background worker "logical replication launcher" (PID 73) exited with exit code 1
2022-12-06 21:54:32 2022-12-06 13:54:32.943 UTC [68] LOG:  shutting down
2022-12-06 21:54:33 2022-12-06 13:54:33.109 UTC [66] LOG:  database system is shut down
2022-12-06 21:54:33  done
2022-12-06 21:54:33 server stopped
2022-12-06 21:54:33
2022-12-06 21:54:33 PostgreSQL init process complete; ready for start up.
2022-12-06 21:54:33
2022-12-06 21:54:33
2022-12-06 21:54:33 2022/12/06 13:54:33 /opt/illa/builder-backend/pkg/db/connection.go:48
2022-12-06 21:54:33 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: dial error (dial tcp [::1]:5432: connect: cannot assign requested address)
2022-12-06 21:54:33 [GIN-debug] [WARNING] Running in "debug" mode. Switch to "release" mode in production.
2022-12-06 21:54:33  - using env:       export GIN_MODE=release
2022-12-06 21:54:33  - using code:      gin.SetMode(gin.ReleaseMode)
2022-12-06 21:54:33
2022-12-06 21:54:33
2022-12-06 21:54:33 2022/12/06 13:54:33 /opt/illa/builder-backend/pkg/db/connection.go:48
2022-12-06 21:54:33 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: dial error (dial tcp [::1]:5432: connect: cannot assign requested address)
2022-12-06 21:54:43
2022-12-06 21:54:43 2022/12/06 13:54:43 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:54:43 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:54:43
2022-12-06 21:54:43 2022/12/06 13:54:43 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:54:43 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:54:51
2022-12-06 21:54:51 config init.
2022-12-06 21:54:51
2022-12-06 21:54:51 API_SERVER_PORT not defined, skip.
2022-12-06 21:54:51
2022-12-06 21:54:51 config init done.
2022-12-06 21:54:51
2022-12-06 21:54:51 Running postgres-entrypoint.sh
2022-12-06 21:54:51
2022-12-06 21:54:51 illa database already exists; Skipping initialization
2022-12-06 21:54:51
2022-12-06 21:54:51 now user is: 0
2022-12-06 21:54:51 total 36K
2022-12-06 21:54:51 drwxr-xr-x 1 root     root     4.0K Oct  5 09:05 .
2022-12-06 21:54:51 drwxr-xr-x 1 root     root     4.0K Oct  4 00:00 ..
2022-12-06 21:54:51 drwxr-xr-x 1 root     root     4.0K Dec  2 10:41 apt
2022-12-06 21:54:51 drwxr-xr-x 1 root     root     4.0K Dec  2 10:41 dpkg
2022-12-06 21:54:51 drwxr-xr-x 2 root     root     4.0K Sep  3 12:10 misc
2022-12-06 21:54:51 drwxr-xr-x 2 root     root     4.0K Oct  4 00:00 pam
2022-12-06 21:54:51 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 postgresql
2022-12-06 21:54:51 drwxr-xr-x 1 root     root     4.0K Oct  5 09:04 systemd
2022-12-06 21:54:51 drwxr-xr-x 3 root     root     4.0K Oct  5 09:05 ucf
2022-12-06 21:54:51 total 8.0K
2022-12-06 21:54:51 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 .
2022-12-06 21:54:51 drwxr-xr-x 1 root     root     4.0K Oct  5 09:05 ..
2022-12-06 21:54:51 drwx------ 1 postgres root     4.0K Dec  6 13:54 data
2022-12-06 21:54:51 total 48K
2022-12-06 21:54:51 drwx------ 1 postgres root     4.0K Dec  6 13:54 .
2022-12-06 21:54:51 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 ..
2022-12-06 21:54:51 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 base
2022-12-06 21:54:51 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 global
2022-12-06 21:54:51 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_commit_ts
2022-12-06 21:54:51 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_dynshmem
2022-12-06 21:54:51 -rw------- 1 postgres postgres 4.8K Dec  6 13:54 pg_hba.conf
2022-12-06 21:54:51 -rw------- 1 postgres postgres 1.6K Dec  6 13:54 pg_ident.conf
2022-12-06 21:54:51 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_logical
2022-12-06 21:54:51 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_multixact
2022-12-06 21:54:51 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_notify
2022-12-06 21:54:51 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_replslot
2022-12-06 21:54:51 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_serial
2022-12-06 21:54:51 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_snapshots
2022-12-06 21:54:51 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_stat
2022-12-06 21:54:51 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_stat_tmp
2022-12-06 21:54:51 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_subtrans
2022-12-06 21:54:51 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_tblspc
2022-12-06 21:54:51 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_twophase
2022-12-06 21:54:51 -rw------- 1 postgres postgres    3 Dec  6 13:54 PG_VERSION
2022-12-06 21:54:51 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_wal
2022-12-06 21:54:51 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_xact
2022-12-06 21:54:51 -rw------- 1 postgres postgres   88 Dec  6 13:54 postgresql.auto.conf
2022-12-06 21:54:51 -rw------- 1 postgres postgres  29K Dec  6 13:54 postgresql.conf
2022-12-06 21:54:51 -rw------- 1 postgres postgres   36 Dec  6 13:54 postmaster.opts
2022-12-06 21:54:51 -rw------- 1 postgres postgres   95 Dec  6 13:54 postmaster.pid
2022-12-06 21:54:53 Running postgres-entrypoint.sh
2022-12-06 21:54:53 now user is: 999
2022-12-06 21:54:53 total 36K
2022-12-06 21:54:53 drwxr-xr-x 1 root     root     4.0K Oct  5 09:05 .
2022-12-06 21:54:53 drwxr-xr-x 1 root     root     4.0K Oct  4 00:00 ..
2022-12-06 21:54:53 drwxr-xr-x 1 root     root     4.0K Dec  2 10:41 apt
2022-12-06 21:54:53 drwxr-xr-x 1 root     root     4.0K Dec  2 10:41 dpkg
2022-12-06 21:54:53 drwxr-xr-x 2 root     root     4.0K Sep  3 12:10 misc
2022-12-06 21:54:53 drwxr-xr-x 2 root     root     4.0K Oct  4 00:00 pam
2022-12-06 21:54:53 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 postgresql
2022-12-06 21:54:53 drwxr-xr-x 1 root     root     4.0K Oct  5 09:04 systemd
2022-12-06 21:54:53 drwxr-xr-x 3 root     root     4.0K Oct  5 09:05 ucf
2022-12-06 21:54:53 total 8.0K
2022-12-06 21:54:53 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 .
2022-12-06 21:54:53 drwxr-xr-x 1 root     root     4.0K Oct  5 09:05 ..
2022-12-06 21:54:53 drwx------ 1 postgres root     4.0K Dec  6 13:54 data
2022-12-06 21:54:53 total 48K
2022-12-06 21:54:53 drwx------ 1 postgres root     4.0K Dec  6 13:54 .
2022-12-06 21:54:53 drwxr-xr-x 1 postgres postgres 4.0K Oct  5 09:06 ..
2022-12-06 21:54:53 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 base
2022-12-06 21:54:53 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 global
2022-12-06 21:54:53 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_commit_ts
2022-12-06 21:54:53 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_dynshmem
2022-12-06 21:54:53 -rw------- 1 postgres postgres 4.8K Dec  6 13:54 pg_hba.conf
2022-12-06 21:54:53 -rw------- 1 postgres postgres 1.6K Dec  6 13:54 pg_ident.conf
2022-12-06 21:54:53 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_logical
2022-12-06 21:54:53 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_multixact
2022-12-06 21:54:53 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_notify
2022-12-06 21:54:53 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_replslot
2022-12-06 21:54:53 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_serial
2022-12-06 21:54:53 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_snapshots
2022-12-06 21:54:53 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_stat
2022-12-06 21:54:53 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_stat_tmp
2022-12-06 21:54:53 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_subtrans
2022-12-06 21:54:53 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_tblspc
2022-12-06 21:54:53 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_twophase
2022-12-06 21:54:53 -rw------- 1 postgres postgres    3 Dec  6 13:54 PG_VERSION
2022-12-06 21:54:53 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_wal
2022-12-06 21:54:53 drwx------ 1 postgres postgres 4.0K Dec  6 13:54 pg_xact
2022-12-06 21:54:53 -rw------- 1 postgres postgres   88 Dec  6 13:54 postgresql.auto.conf
2022-12-06 21:54:53 -rw------- 1 postgres postgres  29K Dec  6 13:54 postgresql.conf
2022-12-06 21:54:53 -rw------- 1 postgres postgres   36 Dec  6 13:54 postmaster.opts
2022-12-06 21:54:53 -rw------- 1 postgres postgres   95 Dec  6 13:54 postmaster.pid
2022-12-06 21:54:53
2022-12-06 21:54:53 PostgreSQL Database directory appears to contain a database; Skipping initialization
2022-12-06 21:54:53
2022-12-06 21:54:53 [GIN-debug] [WARNING] Running in "debug" mode. Switch to "release" mode in production.
2022-12-06 21:54:53  - using env:       export GIN_MODE=release
2022-12-06 21:54:53  - using code:      gin.SetMode(gin.ReleaseMode)
2022-12-06 21:54:53
2022-12-06 21:54:53
2022-12-06 21:54:53 2022/12/06 13:54:53 /opt/illa/builder-backend/pkg/db/connection.go:48
2022-12-06 21:54:53 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: dial error (dial tcp [::1]:5432: connect: cannot assign requested address)
2022-12-06 21:54:53
2022-12-06 21:54:53 2022/12/06 13:54:53 /opt/illa/builder-backend/pkg/db/connection.go:48
2022-12-06 21:54:53 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: dial error (dial tcp [::1]:5432: connect: cannot assign requested address)
2022-12-06 21:55:00 "06/Dec/2022:13:55:00 +0000" client=<IP_ADDRESS> method=GET request="GET / HTTP/1.1" request_length=765 status=304 bytes_sent=245 body_bytes_sent=0 referer=- http_x_forwarded_for=- user_agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36" upstream_addr=- upstream_status=- request_time=0.000 upstream_response_time=- upstream_connect_time=- upstream_header_time=-
2022-12-06 21:55:01 "06/Dec/2022:13:55:01 +0000" client=<IP_ADDRESS> method=GET request="GET /user/login HTTP/1.1" request_length=805 status=304 bytes_sent=245 body_bytes_sent=0 referer=http://localhost:10000/dashboard http_x_forwarded_for=- user_agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36" upstream_addr=- upstream_status=- request_time=0.000 upstream_response_time=- upstream_connect_time=- upstream_header_time=-
2022-12-06 21:55:03
2022-12-06 21:55:03 2022/12/06 13:55:03 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:55:03 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:55:03
2022-12-06 21:55:03 2022/12/06 13:55:03 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:55:03 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:55:13
2022-12-06 21:55:13 2022/12/06 13:55:13 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:55:13 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:55:13
2022-12-06 21:55:13 2022/12/06 13:55:13 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:55:13 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:55:23
2022-12-06 21:55:23 2022/12/06 13:55:23 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:55:23 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:55:23
2022-12-06 21:55:23 2022/12/06 13:55:23 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:55:23 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:55:33
2022-12-06 21:55:33 2022/12/06 13:55:33 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:55:33 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:55:33
2022-12-06 21:55:33 2022/12/06 13:55:33 /opt/illa/builder-backend/pkg/db/connection.go:61
2022-12-06 21:55:33 [error] failed to initialize database, got error failed to connect to host=localhost user=illa database=illa: server error (FATAL: role "illa" does not exist (SQLSTATE 28000))
2022-12-06 21:40:17 {"level":"error","ts":1670334017.3700395,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":6,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:40:17 {"level":"error","ts":1670334017.36993,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.Initialize\n\t/opt/illa/builder-backend/cmd/http-server/wire_gen.go:38\nmain.main\n\t/opt/illa/builder-backend/cmd/http-server/main.go:20\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:40:17 {"level":"error","ts":1670334017.3728876,"caller":"zap@v1.21.0/sugar.go:191","msg":"Ignored key without a value.","ignored":6,"stacktrace":"go.uber.org/zap.(*SugaredLogger).Errorw\n\t/go/pkg/mod/go.uber.org/zap@v1.21.0/sugar.go:191\ngithub.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:40:17 {"level":"error","ts":1670334017.3724332,"caller":"db/connection.go:56","msg":"Failed to connect to database, %d","stacktrace":"github.com/illa-family/builder-backend/pkg/db.NewDbConnection\n\t/opt/illa/builder-backend/pkg/db/connection.go:56\nmain.initEnv\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:54\nmain.main\n\t/opt/illa/builder-backend/cmd/websocket-server/main.go:127\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"}
2022-12-06 21:40:17 2022-12-06 13:40:17.430 UTC [40] LOG:  starting PostgreSQL 14.5 (Debian 14.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
2022-12-06 21:40:17 2022-12-06 13:40:17.431 UTC [40] LOG:  listening on IPv4 address "<IP_ADDRESS>", port 5432
2022-12-06 21:40:17 2022-12-06 13:40:17.431 UTC [40] LOG:  listening on IPv6 address "::", port 5432
2022-12-06 21:40:17 2022-12-06 13:40:17.443 UTC [40] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-12-06 21:40:17 2022-12-06 13:40:17.486 UTC [69] LOG:  database system was interrupted; last known up at 2022-12-06 13:38:20 UTC
2022-12-06 21:40:22 2022-12-06 13:40:22.749 UTC [69] LOG:  database system was not properly shut down; automatic recovery in progress
2022-12-06 21:40:22 2022-12-06 13:40:22.783 UTC [69] LOG:  redo starts at 0/16FAFB8
2022-12-06 21:40:22 2022-12-06 13:40:22.783 UTC [69] LOG:  invalid record length at 0/16FAFF0: wanted 24, got 0
2022-12-06 21:40:22 2022-12-06 13:40:22.783 UTC [69] LOG:  redo done at 0/16FAFB8 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2022-12-06 21:40:22 2022-12-06 13:40:22.924 UTC [40] LOG:  database system is ready to accept connections
2022-12-06 21:40:27 2022-12-06 13:40:27.386 UTC [87] FATAL:  role "illa" does not exist