cannot create new users when starting from docker

[junxu-ai]

after statring from docker compose, I can see the page http://127.0.0.1:8080/admin-reg.
but the user creation is not successful, it shows internal server error.

Below is the information from the terminal.

2025-02-22 14:51:12 backend-1 | getUserByEmail
2025-02-22 14:51:12 postgresdb-1 | 2025-02-22 06:51:12.573 UTC [46] ERROR: relation "users" does not exist at character 15
2025-02-22 14:51:12 postgresdb-1 | 2025-02-22 06:51:12.573 UTC [46] STATEMENT: SELECT * FROM users WHERE email = $1
2025-02-22 14:51:12 backend-1 | Error getting user by email: error: relation "users" does not exist
2025-02-22 14:51:12 backend-1 | at /app/node_modules/pg-pool/index.js:45:11
2025-02-22 14:51:12 backend-1 | at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {
2025-02-22 14:51:12 backend-1 | length: 104,
2025-02-22 14:51:12 backend-1 | severity: 'ERROR',
2025-02-22 14:51:12 backend-1 | code: '42P01',
2025-02-22 14:51:12 backend-1 | detail: undefined,
2025-02-22 14:51:12 backend-1 | hint: undefined,
2025-02-22 14:51:12 backend-1 | position: '15',
2025-02-22 14:51:12 backend-1 | internalPosition: undefined,
2025-02-22 14:51:12 backend-1 | internalQuery: undefined,
2025-02-22 14:51:12 backend-1 | where: undefined,
2025-02-22 14:51:12 backend-1 | schema: undefined,
2025-02-22 14:51:12 backend-1 | table: undefined,
2025-02-22 14:51:12 backend-1 | column: undefined,
2025-02-22 14:51:12 backend-1 | dataType: undefined,
2025-02-22 14:51:12 backend-1 | constraint: undefined,
2025-02-22 14:51:12 backend-1 | file: 'parse_relation.c',
2025-02-22 14:51:12 backend-1 | line: '1449',
2025-02-22 14:51:12 backend-1 | routine: 'parserOpenTable'
2025-02-22 14:51:12 backend-1 | }

[junxu-ai]

other warning information during docker compose:

backend-1 | Server running on port http://localhost:3000/
backend-1 | Checking if tables exist...
backend-1 | Some tables are missing. Creating tables...
backend-1 | SQL file not found at path: /app/dist/database/SQL_Commands.sql

postgresdb-1 | 2025-02-22 07:01:04.545 UTC [48] LOG: invalid length of startup packet
postgresdb-1 | 2025-02-22 07:01:05.618 UTC [49] LOG: invalid length of startup packet
postgresdb-1 | 2025-02-22 07:01:05.620 UTC [51] LOG: invalid length of startup packet
postgresdb-1 | 2025-02-22 07:01:05.624 UTC [52] LOG: invalid length of startup packet
postgresdb-1 | 2025-02-22 07:01:06.921 UTC [53] LOG: invalid length of startup packet

---

note that the database cannot be connected via http://localhost:5433/ or http://localhost:5432/

[eieimon]

@junxu-ai , have you run ./install.sh. There is an instruction in INSTALLATION.md

[junxu-ai]

Thanks! any chance to create a dos/powershell script for docker in Windows?

[junxu-ai]

running in linux now.

but cannot add more than 1 project, and cannot add team in the settings...

so the current version is very preliminary.

[gorkem-bwl]

Currently we haven't made the release yet. You should be able to add additional projects though.

Thanks! any chance to create a dos/powershell script for docker in Windows?

We don't have plans to support Windows, yet.