Compose help and best practise

[dan-sweden]

Hi,
I am unable to run semaphore error free for mysql or postgress without luck. Bolt on other hand is installing fine.
Can anyone provide a best practice compose file to use for this? 🙏

Im on Redhat 8.10 and is using Podman compose.

get the same setup error over and over in the setup log on both mysql and postgress. and i cant login as admin user. trying to fix it get similar error:

Setup log:
Pinging database on postgres port 5432...
No additional python dependencies to install
Starting semaphore server
Loading config
Validating config
time="2024-11-27T10:49:42Z" level=warning msg="pq: database "semaphore" already exists"
panic: dial tcp: lookup postgres on 192.168.0.1:53: no such host

goroutine 1 [running]:
github.com/semaphoreui/semaphore/db/sql.(*SqlDb).Connect(0xc000118728, {0x1a?, 0x0?})
/go/src/semaphore/db/sql/SqlDb.go:299 +0x996
github.com/semaphoreui/semaphore/cli/cmd.createStore({0xc8b2b8, 0x4})
/go/src/semaphore/cli/cmd/root.go:122 +0x62
github.com/semaphoreui/semaphore/cli/cmd.runService()
/go/src/semaphore/cli/cmd/root.go:63 +0x3c
github.com/semaphoreui/semaphore/cli/cmd.init.func9(0xc000193000?, {0xc8b2ec?, 0x4?, 0xc8b2f0?})
/go/src/semaphore/cli/cmd/server.go:18 +0xf
github.com/spf13/cobra.(*Command).execute(0x1e3c640, {0xc00015bd20, 0x2, 0x2})
/go/src/semaphore/vendor/github.com/spf13/cobra/command.go:989 +0xab1
github.com/spf13/cobra.(*Command).ExecuteC(0x1e3b500)
/go/src/semaphore/vendor/github.com/spf13/cobra/command.go:1117 +0x3ff
github.com/spf13/cobra.(*Command).Execute(...)
/go/src/semaphore/vendor/github.com/spf13/cobra/command.go:1041
github.com/semaphoreui/semaphore/cli/cmd.Execute()
/go/src/semaphore/cli/cmd/root.go:56 +0xc5
main.main()
/go/src/semaphore/cli/main.go:8 +0xf
Pinging database on postgres port 5432...
No additional python dependencies to install
Starting semaphore server
Loading config
Validating config
time="2024-11-27T10:49:42Z" level=warning msg="pq: database "semaphore" already exists"

Tring to fix login:
[xxx@xxx compose]$ podman exec -it compose_semaphore_1 /bin/bash
f8daa1c33c00:~$ semaphore user list
Loading config
Validating config
WARN[0000] pq: database "semaphore" already exists
panic: dial tcp: lookup postgres on 192.168.0.1:53: no such host

goroutine 1 [running]:
github.com/semaphoreui/semaphore/db/sql.(*SqlDb).Connect(0xc000068738, {0x0?, 0x0?})
/go/src/semaphore/db/sql/SqlDb.go:299 +0x996
github.com/semaphoreui/semaphore/cli/cmd.createStore({0x0, 0x0})
/go/src/semaphore/cli/cmd/root.go:122 +0x62
github.com/semaphoreui/semaphore/cli/cmd.init.func17(0xc000105300?, {0xc8b2ec?, 0x4?, 0xc8b2f0?})
/go/src/semaphore/cli/cmd/user_list.go:17 +0x32
github.com/spf13/cobra.(*Command).execute(0x1e3dd40, {0x1ea6660, 0x0, 0x0})
/go/src/semaphore/vendor/github.com/spf13/cobra/command.go:989 +0xab1
github.com/spf13/cobra.(*Command).ExecuteC(0x1e3b500)
/go/src/semaphore/vendor/github.com/spf13/cobra/command.go:1117 +0x3ff
github.com/spf13/cobra.(*Command).Execute(...)
/go/src/semaphore/vendor/github.com/spf13/cobra/command.go:1041
github.com/semaphoreui/semaphore/cli/cmd.Execute()
/go/src/semaphore/cli/cmd/root.go:56 +0xc5
main.main()
/go/src/semaphore/cli/main.go:8 +0xf

f8daa1c33c00:$ ping postgres
PING postgres (10.89.0.2): 56 data bytes
64 bytes from 10.89.0.2: seq=0 ttl=42 time=0.031 ms
64 bytes from 10.89.0.2: seq=1 ttl=42 time=0.092 ms
64 bytes from 10.89.0.2: seq=2 ttl=42 time=0.067 ms
^C
--- postgres ping statistics ---
3 packets transmitted, 3 packets received, 0% packet loss
round-trip min/avg/max = 0.031/0.063/0.092 ms
f8daa1c33c00:$

[dan-sweden]

Found the problem. The installation script couldnt handle dns rotate that i had enabled in the resolv.conf.
xxxx:~$ cat /etc/resolv.conf
search dns.podman xxx.io
nameserver 10.31.0.1
nameserver 192.168.0.1
nameserver 192.169.0.1
nameserver 192.170.0.1
options timeout:1 attempts:1 rotate