[SELF-HOSTED] No such table "page".

[Souipi]

Hi ! I'm trying to setup OpenStatus locally using Docker, but I'm running into database errors with the status-page and dashboard services. I followed the Docker setup guide: https://github.com/openstatusHQ/openstatus/blob/main/DOCKER.md. However, it seems that the database migrations are not being executed properly.

I ran the following command to verify whether migrations were executed docker compose logs workflows | grep -A 5 "Running database migrations" but I get no output, which suggests that migrations did not run.

I then tried to run the migrations manually docker compose exec workflows sh -c "cd /app/packages/db && bun src/migrate.mts" but this failed with sh: 1: bun: not found.

I have some questions so:

• Are migrations supposed to run automatically in the workflows container?
• Is there an additional step required to trigger database setup?
• Should bun be available inside the container?
• Am missing an environment variable or configuration step?

Any guidance would be greatly appreciated ^^

Thanks in advance!

"status-page" service error

{
  hostnames: [ 'localhost', '3000' ],
  pathnames: [ '', '' ],
  host: 'localhost:3000',
  urlHost: '0.0.0.0:3000',
  subdomain: '0.0.0.0:3000'
}
{
  pathname: '/',
  type: 'pathname',
  prefix: '0.0.0.0:3000',
  subdomain: '0.0.0.0:3000'
}

Error: Failed query: select "id", "workspace_id", "title", "description", "icon", "slug", "custom_domain", "published", "force_theme", "password", "password_protected", "access_type", "auth_email_domains", "homepage_url", "contact_url", "legacy_page", "configuration", "show_monitor_values", "created_at", "updated_at" from "page" where lower("page"."slug") = ? OR lower("page"."custom_domain") = ?

params: 0.0.0.0:3000,0.0.0.0:3000
    at <unknown> (params: 0.0.0.0:3000,0.0.0.0:3000)
    at w.queryWithCache (.next/server/chunks/[root-of-the-server]__a4301528._.js:462:22018)
    at async w.values (.next/server/chunks/[root-of-the-server]__a4301528._.js:462:27929)
    at async w.get (.next/server/chunks/[root-of-the-server]__a4301528._.js:462:27510)
    at async (.next/server/chunks/[root-of-the-server]__a4301528._.js:581:2777)
    at async n8 (.next/server/chunks/[root-of-the-server]__a4301528._.js:430:59548)
    at async handler (.next/server/chunks/[root-of-the-server]__a4301528._.js:581:6084)
    at async (.next/server/chunks/[root-of-the-server]__a4301528._.js:13:35923)
    at async te (.next/server/chunks/[root-of-the-server]__a4301528._.js:13:32292) {
  query: 'select "id", "workspace_id", "title", "description", "icon", "slug", "custom_domain", "published", "force_theme", "password", "password_protected", "access_type", "auth_email_domains", "homepage_url", "contact_url", "legacy_page", "configuration", "show_monitor_values", "created_at", "updated_at" from "page" where lower("page"."slug") = ? OR lower("page"."custom_domain") = ?',
  params: [Array],
  [cause]: Error [LibsqlError]: SQLITE_UNKNOWN: SQLite error: no such table: page
      at async w.queryWithCache (.next/server/chunks/[root-of-the-server]__a4301528._.js:462:21993)
      at async w.values (.next/server/chunks/[root-of-the-server]__a4301528._.js:462:27929)
      at async w.get (.next/server/chunks/[root-of-the-server]__a4301528._.js:462:27510)
      at async (.next/server/chunks/[root-of-the-server]__a4301528._.js:581:2777)
      at async n8 (.next/server/chunks/[root-of-the-server]__a4301528._.js:430:59548)
      at async handler (.next/server/chunks/[root-of-the-server]__a4301528._.js:581:6084)
      at async (.next/server/chunks/[root-of-the-server]__a4301528._.js:13:35923) {
    code: 'SQLITE_UNKNOWN',

"dashboard" service error

params: test@test.com
    at w.queryWithCache (/app/apps/dashboard/.next/server/chunks/ssr/_ac4a4335._.js:448:22018)
    at process.processTicksAndRejections (node:internal/process/task_queues:103:5)
    at async w.values (/app/apps/dashboard/.next/server/chunks/ssr/_ac4a4335._.js:448:27929)
    at async w.get (/app/apps/dashboard/.next/server/chunks/ssr/_ac4a4335._.js:448:27510)
    at async getUserByEmail (/app/apps/dashboard/.next/server/chunks/ssr/_ac4a4335._.js:530:50081)
    at async c.<computed> [as getUserByEmail] (/app/apps/dashboard/.next/server/chunks/ssr/_ac4a4335._.js:13:83353)
    at async fo (/app/apps/dashboard/.next/server/chunks/ssr/_ac4a4335._.js:416:46633)
    at async fp (/app/apps/dashboard/.next/server/chunks/ssr/_ac4a4335._.js:416:47879)
    at async ft (/app/apps/dashboard/.next/server/chunks/ssr/_ac4a4335._.js:416:50461)
    at async fv (/app/apps/dashboard/.next/server/chunks/ssr/_ac4a4335._.js:416:54604)

[auth][details]: {
  "code": "SQLITE_UNKNOWN",
  "name": "LibsqlError"
}

[auth][error] AdapterError: Read more at [https://errors.authjs.dev#adaptererror](https://errors.authjs.dev/#adaptererror)
[auth][cause]: Error: Failed query: select "id", "tenant_id", "first_name", "last_name", "photo_url", "name", "email", "emailVerified", "created_at", "updated_at" from "user" where "user"."email" = ?
params: test@test.com
    at w.queryWithCache (/app/apps/dashboard/.next/server/chunks/ssr/_ac4a4335._.js:448:22018)
    at process.processTicksAndRejections (node:internal/process/task_queues:103:5)
    at async w.values (/app/apps/dashboard/.next/server/chunks/ssr/_ac4a4335._.js:448:27929)
    at async w.get (/app/apps/dashboard/.next/server/chunks/ssr/_ac4a4335._.js:448:27510)
    at async getUserByEmail (/app/apps/dashboard/.next/server/chunks/ssr/_ac4a4335._.js:530:50081)
    at async c.<computed> [as getUserByEmail] (/app/apps/dashboard/.next/server/chunks/ssr/_ac4a4335._.js:13:83353)
    at async fo (/app/apps/dashboard/.next/server/chunks/ssr/_ac4a4335._.js:416:46633)
    at async fp (/app/apps/dashboard/.next/server/chunks/ssr/_ac4a4335._.js:416:47879)
    at async ft (/app/apps/dashboard/.next/server/chunks/ssr/_ac4a4335._.js:416:50461)
    at async fv (/app/apps/dashboard/.next/server/chunks/ssr/_ac4a4335._.js:416:54604)

[auth][details]: {
  "code": "SQLITE_UNKNOWN",
  "name": "LibsqlError"
}

n: Read more at [https://errors.authjs.dev#adaptererror](https://errors.authjs.dev/#adaptererror)
    at c.<computed> [as getUserByEmail] (.next/server/chunks/ssr/_ac4a4335._.js:13:83382)
    at async fo (.next/server/chunks/ssr/_ac4a4335._.js:416:46633)
    at async fp (.next/server/chunks/ssr/_ac4a4335._.js:416:47879)
    at async ft (.next/server/chunks/ssr/_ac4a4335._.js:416:50461)
    at async fv (.next/server/chunks/ssr/_ac4a4335._.js:416:54604)
    at async fG (.next/server/chunks/ssr/_ac4a4335._.js:416:59918)
    at async h (.next/server/chunks/ssr/_9c0c7f29._.js:5:392) {
  type: 'AdapterError',
  kind: 'error',
  [cause]: [Object]
}

[linear]

OPE-546

[thibaultleouay]

Have you tried to run the migration before ?

[Souipi]

Have you tried to run the migration before ?

What do you mean by "before" ?

I then tried to run the migrations manually docker compose exec workflows sh -c "cd /app/packages/db && bun src/migrate.mts" but this failed with sh: 1: bun: not found.

After setting up the docker-compose stack when i try to run the migration, i get the following error.

[TreeSloths]

Have you tried to run the migration before ?

What do you mean by "before" ?

I then tried to run the migrations manually docker compose exec workflows sh -c "cd /app/packages/db && bun src/migrate.mts" but this failed with sh: 1: bun: not found.

After setting up the docker-compose stack when i try to run the migration, i get the following error.

Try creating a one shot container using an image with buns, that runs those commands, if you do not want to install the needed service on the host, that's what I did to make it work.

[Souipi]

Have you tried to run the migration before ?

What do you mean by "before" ?

I then tried to run the migrations manually docker compose exec workflows sh -c "cd /app/packages/db && bun src/migrate.mts" but this failed with sh: 1: bun: not found.

After setting up the docker-compose stack when i try to run the migration, i get the following error.

Try creating a one shot container using an image with buns, that runs those commands, if you do not want to install the needed service on the host, that's what I did to make it work.

Yay, it worked! BUT I'm still having a lot of trouble with random logouts from the dashboard when reloading a status page. I also still have the limitations of the cloud version (which, in my opinion, doesn't make sense since I'm self-hosting it). I can't (or I haven't found where) use my own "regions" or "locations" to execute my pings, etc.

Thanks for your help. The status page is pretty fun, but I think I'll pass. I feel like they don't really want us to self-host OpenStatus, but rather just give us the """possibility""" to do it ¯_(ツ)_/¯

Maybe I'm misunderstanding something, and I would love to be wrong.

[TreeSloths]

Have you tried to run the migration before ?

What do you mean by "before" ?

I then tried to run the migrations manually docker compose exec workflows sh -c "cd /app/packages/db && bun src/migrate.mts" but this failed with sh: 1: bun: not found.

After setting up the docker-compose stack when i try to run the migration, i get the following error.

Try creating a one shot container using an image with buns, that runs those commands, if you do not want to install the needed service on the host, that's what I did to make it work.

Yay, it worked! BUT I'm still having a lot of trouble with random logouts from the dashboard when reloading a status page. I also still have the limitations of the cloud version (which, in my opinion, doesn't make sense since I'm self-hosting it). I can't (or I haven't found where) use my own "regions" or "locations" to execute my pings, etc.

Thanks for your help. The status page is pretty fun, but I think I'll pass. I feel like they don't really want us to self-host OpenStatus, but rather just give us the """possibility""" to do it ¯_(ツ)_/¯

Maybe I'm misunderstanding something, and I would love to be wrong.

No problem
For reference, this is the container I wrote (I forgot to post it, and you can replace Podman with Docker, same syntax)

sudo podman run --rm -it \
  --network openstatus \
  --env-file .env.docker \
  -v "$PWD":/work:Z \
  -w /work/packages/db \
  node:22-trixie \
  bash -lc '
    set -euo pipefail
    export DEBIAN_FRONTEND=noninteractive
    apt-get update -qq
    apt-get install -y -qq curl ca-certificates unzip
    curl -fsSL https://bun.sh/install -o /tmp/bun-install.sh
    bash /tmp/bun-install.sh
    export PATH="$HOME/.bun/bin:$PATH"
    npm i -g pnpm
    pnpm install
    bun src/migrate.mts
  '

(If you've for security reasons set noexec on the /tmp dir, the bash file will not execute, you can also directly pipe the shell script .e.g | bash, although an insecure practice)

You might also want to remove :Z, dir was set as such for SElinux

As for "have the limitations of the cloud version", I found out that you needed to change directly inside the database

This is the command I used (make sure the ID is correct for your workspace if you have multiple):

curl -sS -X POST "http://localhost:8080" \
  -H "Content-Type: application/json" \
  -d "{\"statements\":[
    \"UPDATE workspace SET plan='team', paid_until=strftime('%s','now') + 315360000, ends_at=NULL WHERE id=1;\",
    \"SELECT id, plan, paid_until, ends_at FROM workspace WHERE id=1;\"
  ]}"

The "team" is the "Pro" version on the website, but in the database != to the same name. Hope this helps.

[thibaultleouay]

@TreeSloths thanks for your help,

would you like to provide an update of our docs with this?

[TreeSloths]

@TreeSloths thanks for your help,

would you like to provide an update of our docs with this?

No problem, and sure, I thought about it but was unsure where and what I'd write (about the post command or about the one shot container for the database?)