[BUG] database fails to start with Postgres query syntax error

[cidrmill]

Bug Description:

The database container fails on its initial launch, which causes a chain of issues resulting in osintbuddy authentication to fail since Casdoor relies on a working database.

How to Reproduce:

1. Launch OSB ./launch start
2. Run ./launcher logs db
3. Find that it's causing Casdoor and frontend authentication to also fail.

Expected behavior:

Postgres should launch and the queries should execute without error.

Screenshots & Logs:

https://paste.c-net.org/PraisesWarriors

The log output is large. A snippet of the error causing the Postgres database to fail during its launch sequence:

2024-04-16 09:14:24.538 UTC [35] FATAL:  zero-length delimited identifier at or near """" at character 12
2024-04-16 09:14:24.538 UTC [35] STATEMENT:  ALTER USER ""postgres"" WITH PASSWORD E'"password"';

Environment:

• OS: Linux
• Browser: irrelevant

Additional context:

...

[jerlendds]

Hey @cidrmill , thanks for reporting this! Currently I'm working on the big rewrite so I can't promise I'll be able to get a fix for this issue out anytime soon, perhaps you might have some luck restarting the db in another terminal, iirc the command for that is ./launcher restart db or something similiar - the CLI will be changing to a Go binary in the upcoming release :)