Cloudron Forum

SansGuidon

Hey
On Desktop, on Cloudron 9.0.17, it seems we need to scroll to the right in order to access the file manager settings, that's even more annoying on mobile

This was probably already mentioned in the early feedback for Cloudron 9 but I cannot recall if it was taken into account.
Thanks anyway!

SansGuidon

I encountered the same issue which I described here https://forum.cloudron.io/topic/14912/immich-stopped-working-since-last-cloudron-upgrade and as a workaround I restored Immich to last backup to access it again
For now I just disable the updates

SansGuidon

18 06:34:19 7670:C 18 Jan 2026 05:34:19.029 * Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB
Jan 18 06:37:25 2026-01-18 05:37:25,586 INFO reaped unknown pid 85694 (terminated by SIGTERM)
Jan 18 06:37:25 2026-01-18 05:37:25,586 WARN exited: server (exit status 1; not expected)
Jan 18 06:37:25 Killing api process
Jan 18 06:37:25 at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26)
Jan 18 06:37:25 at Readable.push (node:internal/streams/readable:392:5)
Jan 18 06:37:25 at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9)
Jan 18 06:37:25 at Socket.emit (node:events:519:28)
Jan 18 06:37:25 at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
Jan 18 06:37:25 at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
Jan 18 06:37:25 at addChunk (node:internal/streams/readable:561:12)
Jan 18 06:37:25 at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6)
Jan 18 06:37:25 at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
Jan 18 06:37:25 code: '42501',
Jan 18 06:37:25 file: 'aclchk.c',
Jan 18 06:37:25 line: '2950',
Jan 18 06:37:25 microservices worker error: PostgresError: must be owner of extension vchord, stack: PostgresError: must be owner of extension vchord
Jan 18 06:37:25 microservices worker exited with code 1
Jan 18 06:37:25 routine: 'aclcheck_error'
Jan 18 06:37:25 severity: 'ERROR',
Jan 18 06:37:25 severity_local: 'ERROR',
Jan 18 06:37:25 }
Jan 18 06:37:26 2026-01-18 05:37:26,589 INFO spawned: 'server' with pid 85706
Jan 18 06:37:27 2026-01-18 05:37:27,590 INFO success: server entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
Jan 18 06:37:28 (Use `node --trace-warnings ...` to show where the warning was created)
Jan 18 06:37:28 (node:85706) ExperimentalWarning: WASI is an experimental feature and might change at any time
Jan 18 06:37:28 Missing history for endpoint: Retrieve auth status
Jan 18 06:37:28 Starting api worker
Jan 18 06:37:28 Starting microservices worker
Jan 18 06:37:30 => Healthcheck error: Error: connect ECONNREFUSED 172.18.20.11:2283
Jan 18 06:37:30 Missing history for endpoint: Retrieve auth status
Jan 18 06:37:30 Missing history for endpoint: Retrieve auth status
Jan 18 06:37:31 2026-01-18T05:37:31Z
Jan 18 06:37:31 [Nest] 85706 - 01/18/2026, 5:37:31 AM LOG [Microservices:DatabaseService] Updating VectorChord extension to 0.5.3
Jan 18 06:37:31 [Nest] 85706 - 01/18/2026, 5:37:31 AM LOG [Microservices:WebsocketRepository] Initialized websocket server
Jan 18 06:37:31 [Nest] 85706 - 01/18/2026, 5:37:31 AM WARN [Microservices:DatabaseService] The VectorChord extension can be updated to 0.5.3.
Jan 18 06:37:31 (Use `node --trace-warnings ...` to show where the warning was created)
Jan 18 06:37:31 (Use `node --trace-warnings ...` to show where the warning was created)
Jan 18 06:37:31 (node:85706) ExperimentalWarning: WASI is an experimental feature and might change at any time
Jan 18 06:37:31 (node:85717) ExperimentalWarning: WASI is an experimental feature and might change at any time
Jan 18 06:37:31 2026-01-18 05:37:31,405 INFO reaped unknown pid 85717 (terminated by SIGTERM)
Jan 18 06:37:31 2026-01-18 05:37:31,405 WARN exited: server (exit status 1; not expected)
Jan 18 06:37:31 Immich attempted to update the extension, but failed to do so.
Jan 18 06:37:31 Killing api process
Jan 18 06:37:31 Please run 'ALTER EXTENSION vchord UPDATE' manually as a superuser.
Jan 18 06:37:31 PostgresError: must be owner of extension vchord
Jan 18 06:37:31 Query failed : {
Jan 18 06:37:31 See https://docs.immich.app/guides/database-queries for how to query the database.
Jan 18 06:37:31 This may be because Immich does not have the necessary permissions to update the extension.
Jan 18 06:37:31 at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26)
Jan 18 06:37:31 at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26)
Jan 18 06:37:31 at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26)
Jan 18 06:37:31 at Readable.push (node:internal/streams/readable:392:5)
Jan 18 06:37:31 at Readable.push (node:internal/streams/readable:392:5)
Jan 18 06:37:31 at Readable.push (node:internal/streams/readable:392:5)
Jan 18 06:37:31 at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9)
Jan 18 06:37:31 at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9)
Jan 18 06:37:31 at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9)
Jan 18 06:37:31 at Socket.emit (node:events:519:28)
Jan 18 06:37:31 at Socket.emit (node:events:519:28)

I've stopped the app as it was endlessly crashing then have attempted a restore to last backup but the restore action does nothing, the popup asking confirmation for the restore action just stays visible when I confirm the restore.

It's confusing.

Should I go mess up with postgres somewhere? And what happened ??
Thanks for any help!

SansGuidon

@nebulon said in Docs - Alternative to Notion / Outline with OIDC, GDPR compliant, PDF Export (with template) etc...:

yes I keep an eye on that also, it seems very good. Only downside why we haven't packaged it already is the hard-dependency on S3 to store docs instead of the filesystem. With minio being in some limbo state recently this is not a great match for the moment for Cloudron, but hopefully this changes in the future

Minio alternative is garage: https://github.com/deuxfleurs-org/garage

SansGuidon

For me I miss 2 things on the UX part:

the history of notifications
a way to reload the main view on mobile. By default I end up on https://my.domain.tld/#/apps and I guess because of the URL pattern (#/apps is not an URL but a client side routing pattern) the only way to refresh the UI is to manually edit the URL to remove the client side routing part.
There are other small glitches I encounter on mobile, like the Cron part is more difficult to reach by default as the button to configure apps it not visible by defaults in the main view also we need to do extra clicks to see where the "Cron" config is.

Other than this, it works great!

SansGuidon

I also had similar issues as soon as I migrated to Cloudron 9.x and after a while or maybe after successful login attempts with an alternative auth flow, I had no longer any issues authenticating through OpenID.
weird indeed but I have noticed similar complains about Cloudron 9 and OIDC in other threads.

SansGuidon

It has integration with Gitea !
And I love the whole list of features, I guess I'm the perfect target customer for this kind of niche product.
Maybe I could replace TickTick

SansGuidon

My 2 cents, I never upgraded the same VM with Cloudron running on it, I just bootstraped a new VM with a fresh upgraded Ubuntu and migrated Cloudron to it ^^ , which allows me to test safely.

Reason: too many topics about problematic Ubuntu upgrades that break things or Cloudron

SansGuidon

It seems that yt-dlp is now requiring a js runtime
https://github.com/yt-dlp/yt-dlp/issues/15012
I didn't adapt yet, it's on my low-priority to do list so I'll happily reuse anyone's solution instead

SansGuidon

Thanks @andreasdueren
I'm trying
Yet we are not the only ones suffering from this product making things unnecessarily more complicated than it should : https://github.com/toeverything/AFFiNE/discussions/11722#discussioncomment-14674564

Even after trying your options I feel I'll just give up with AFFINE. This tool just feels like rushed to support specific scenarios and is difficult to adapt to my scenarios. The UI just does not fit my expectations. Compared to many tools I'm using, the quality is a bit inconsistent and UX is not helpful.
I had already attempted to use AFFINE in the past in a Cloudron competitor for self host and I gave up. My hope that it would be better in Cloudron has just vanished for now.

I might retry later, anyway for now I guess I'm better off vibe coding a simple markdown editor for myself with Mistral integration and sync to my Obsidian.

EDIT: @andreasdueren I've read about selfhosted=true parameter that need to be passed in order to enable third party API/AI models. https://torchtree.com/en/post/affine-selfhost-ai-configuration/ via https://github.com/toeverything/AFFiNE/discussions/11722#discussioncomment-14980258
Maybe worth trying as a last attempt...

SansGuidon

@andreasdueren said in AFFiNE - open-source Notion, Miro, Monday, Outline, Appflowy alternative:

@SansGuidon Hmm yes it doesn't seem to be very flexible about what kind of models you use.

I've reached out to the AFFINE's community on some issue to have an idea if i's difficult to solve I'll keep you posted!
Anyway, thank you ️

SansGuidon

Thanks @andreasdueren.
I tried wiring AFFiNE’s openai provider to Mistral (baseUrl=https://api.mistral.ai/v1, model mistral-large-latest + scenarios override), but AFFiNE is calling the new OpenAI Responses API (/v1/responses), while Mistral only exposes the older /v1/chat/completions, so I get 404s ("no Route matched with those values").

This seems to be the same limitation described in GitHub issues #13617 and #13480, where the suggested fix is to set "oldApiStyle": true under copilot.providers.openai in config.json to force the old chat/completions style. I've tried that without success despite it's part of the code https://github.com/toeverything/AFFiNE/blob/62fe6982fbdbfa9d6fcbad78019e4d6cda62338a/packages/backend/server/src/plugins/copilot/providers/openai.ts#L55

I’m not sure whether the Cloudron AFFiNE package already includes any other workaround, so right now Mistral isn’t really usable as an OpenAI-compatible backend in this setup.

Nov 17 09:50:05 APICallError [AI_APICallError]: Not Found
Nov 17 09:50:05 at file:///run/affine/affine-build/node_modules/@ai-sdk/provider-utils/dist/index.mjs:890:14
Nov 17 09:50:05 at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
Nov 17 09:50:05 at async postToApi (file:///run/affine/affine-build/node_modules/@ai-sdk/provider-utils/dist/index.mjs:721:28)
Nov 17 09:50:05 at async OpenAIResponsesLanguageModel.doStream (file:///run/affine/affine-build/node_modules/@ai-sdk/openai/dist/index.mjs:3631:50)
Nov 17 09:50:05 at async fn (file:///run/affine/affine-build/node_modules/ai/dist/index.mjs:4987:27)
Nov 17 09:50:05 at async file:///run/affine/affine-build/node_modules/ai/dist/index.mjs:1544:22
Nov 17 09:50:05 at async _retryWithExponentialBackoff (file:///run/affine/affine-build/node_modules/ai/dist/index.mjs:1695:12)
Nov 17 09:50:05 at async streamStep (file:///run/affine/affine-build/node_modules/ai/dist/index.mjs:4943:15)
Nov 17 09:50:05 at async fn (file:///run/affine/affine-build/node_modules/ai/dist/index.mjs:5284:9)
Nov 17 09:50:05 at async file:///run/affine/affine-build/node_modules/ai/dist/index.mjs:1544:22 {
Nov 17 09:50:05 cause: undefined,
Nov 17 09:50:05 url: 'https://api.mistral.ai/v1/responses',
Nov 17 09:50:05 requestBodyValues: {
Nov 17 09:50:05 model: 'mistral-large-latest',
Nov 17 09:50:05 input: [ [Object], [Object] ],
Nov 17 09:50:05 temperature: 0,
Nov 17 09:50:05 top_p: undefined,
Nov 17 09:50:05 max_output_tokens: 4096,
Nov 17 09:50:05 max_tool_calls: undefined,
Nov 17 09:50:05 metadata: undefined,
Nov 17 09:50:05 parallel_tool_calls: undefined,
Nov 17 09:50:05 previous_response_id: undefined,
Nov 17 09:50:05 store: undefined,
Nov 17 09:50:05 user: '<REDACTED>',
Nov 17 09:50:05 instructions: undefined,
Nov 17 09:50:05 service_tier: undefined,
Nov 17 09:50:05 include: [ 'web_search_call.action.sources' ],
Nov 17 09:50:05 prompt_cache_key: undefined,
Nov 17 09:50:05 safety_identifier: undefined,
Nov 17 09:50:05 top_logprobs: undefined,
Nov 17 09:50:05 truncation: undefined,
Nov 17 09:50:05 tools: [
Nov 17 09:50:05 [Object], [Object],
Nov 17 09:50:05 [Object], [Object],
Nov 17 09:50:05 [Object], [Object],
Nov 17 09:50:05 [Object], [Object]
Nov 17 09:50:05 ],
Nov 17 09:50:05 tool_choice: 'auto',
Nov 17 09:50:05 stream: true
Nov 17 09:50:05 },
Nov 17 09:50:05 statusCode: 404,
Nov 17 09:50:05 responseHeaders: {
Nov 17 09:50:05 'access-control-allow-origin': '*',
Nov 17 09:50:05 'alt-svc': 'h3=":443"; ma=86400',
Nov 17 09:50:05 'cf-cache-status': 'DYNAMIC',
Nov 17 09:50:05 'cf-ray': '99fdfa7caeef2c00-FRA',
Nov 17 09:50:05 connection: 'keep-alive',
Nov 17 09:50:05 'content-encoding': 'br',
Nov 17 09:50:05 'content-type': 'application/json; charset=utf-8',
Nov 17 09:50:05 date: 'Mon, 17 Nov 2025 08:50:04 GMT',
Nov 17 09:50:05 server: 'cloudflare',
Nov 17 09:50:05 'set-cookie': '_cfuvid=<REDACTED>-1763369404992-<REDACTED_IP>-604800000; path=/; domain=.mistral.ai; HttpOnly; Secure; SameSite=None',
Nov 17 09:50:05 'strict-transport-security': 'max-age=15552000; includeSubDomains; preload',
Nov 17 09:50:05 'transfer-encoding': 'chunked',
Nov 17 09:50:05 'x-content-type-options': 'nosniff',
Nov 17 09:50:05 'x-kong-response-latency': '1'
Nov 17 09:50:05 },
Nov 17 09:50:05 responseBody: '{\n' +
Nov 17 09:50:05 ' "message":"no Route matched with those values",\n' +
Nov 17 09:50:05 ' "request_id":"<REDACTED>"\n' +
Nov 17 09:50:05 '}',
Nov 17 09:50:05 isRetryable: false,
Nov 17 09:50:05 data: undefined,
Nov 17 09:50:05 [Symbol(vercel.ai.error)]: true,
Nov 17 09:50:05 [Symbol(vercel.ai.error.AI_APICallError)]: true
Nov 17 09:50:05 }

Also interesting read: https://sneekes.app/posts/getting_affine_ai_copilot_working_with_custom_models_and_ollama/

TLDR: Too bad for me

EDIT: after deleting the keys from table app_configs and forcing the oldApiStyle: true in openai provider config, I get a different stack trace but still not solving the issue , see below

Nov 17 10:06:30 [Nest] 72 - 11/17/2025, 9:06:30 AM ERROR [OpenAIProvider] <selfhosted:event:27148b39-55a5-4e71-91ec-ce77dd2bb451> Failed to fetch available models
Nov 17 10:06:30 ZodError: [
Nov 17 10:06:30 {
Nov 17 10:06:30 "code": "invalid_type",
Nov 17 10:06:30 "expected": "array",
Nov 17 10:06:30 "received": "undefined",
Nov 17 10:06:30 "path": [
Nov 17 10:06:30 "data"
Nov 17 10:06:30 ],
Nov 17 10:06:30 "message": "Required"
Nov 17 10:06:30 }
Nov 17 10:06:30 ]
Nov 17 10:06:30 at get error (file:///run/affine/affine-build/node_modules/zod/dist/esm/v3/types.js:51:31)
Nov 17 10:06:30 at ZodObject.parse (file:///run/affine/affine-build/node_modules/zod/dist/esm/v3/types.js:126:22)
Nov 17 10:06:30 at file:///run/affine/affine-build/dist/main.js:122774:66
Nov 17 10:06:30 at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
Nov 17 10:06:30 at async OpenAIProvider.refreshOnlineModels (file:///run/affine/affine-build/dist/main.js:122769:34)
Nov 17 10:06:30 <REDACTED_IP> - - [17/Nov/2025:09:06:30 +0000] "GET /api/auth/session HTTP/1.1" 200 193 "https://affine.zoemp.be/workspace/4Ob0-Wxj2fHaDhkgaW6gC/Y4cspZCWKz" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/<REDACTED_IP> Safari/537.36"
...

...
Nov 17 10:06:37 [Nest] 72 - 11/17/2025, 9:06:37 AM DEBUG [CopilotProviderFactory] <selfhosted:http:ef38c027-0882-4057-9f12-f7a552f391a6> Resolving copilot provider for output type: object
Nov 17 10:06:37 [Nest] 72 - 11/17/2025, 9:06:37 AM ERROR [Sse] <selfhosted:http:ef38c027-0882-4057-9f12-f7a552f391a6> no_copilot_provider_available ({"sessionId":"<REDACTED>","params":{"messageId":"79b66a60-8f15-43fe-ac11-6b90e2a7e300"},"throwInStream":false})
Nov 17 10:06:37 no_copilot_provider_available: No copilot provider available: mistral-large-latest
Nov 17 10:06:37 at CopilotController.chooseProvider (file:///run/affine/affine-build/dist/main.js:130026:19)
Nov 17 10:06:37 at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
Nov 17 10:06:37 at async CopilotController.prepareChatSession (file:///run/affine/affine-build/dist/main.js:130080:37)
Nov 17 10:06:37 at async CopilotController.chatStreamObject (file:///run/affine/affine-build/dist/main.js:130214:64)
Nov 17 10:06:37 at async CopilotController.<anonymous> (file:///run/affine/affine-build/dist/main.js:6374:20)

SansGuidon

@andreasdueren said in AFFiNE - open-source Notion, Miro, Monday, Outline, Appflowy alternative:

@SansGuidon said in AFFiNE - open-source Notion, Miro, Monday, Outline, Appflowy alternative:

I don't understand how to make Affine work with my AI subscription (Mistral)

I haven't tested any of the AI features. But in theory you should be able to enter any openai compatible endpoint. I assume, Mistral does have one?

What are your issues with the admin view? It's pretty basic with few variables able to be set up, most things are set up with env and should be ready with the package as is.

What I'm confused about is the onboarding flow: we are directed to the Admin view in the accounts list (which are not verified but I don't see how to solve that).
I'm trying to configure AI but no way to confirm if my entered settings are valid? The save button is just an icon without text, on a corner of the page, not really a good UX.
Then how do we find the main app from the Admin view? The main icon at top left is not even a link. Maybe the Admin view is the poor part of the UX, but that's where we land first and it looks like an escape game.

I find it just not super user friendly, maybe we gets used to it but it looks like the Frontend part is worth improving.

EDIT: I tried to use Mistral but it fails on copilot provider not available, something like that
I found this blog post, which mentions that maybe we have to tweak the code of Affine to make things work. https://sneekes.app/posts/getting_affine_ai_copilot_working_with_custom_models_and_ollama/

I'll dig deeper in that later , kids require attention

SansGuidon

@andreasdueren I'm happy to try it on my instance thanks to you! Installed and deployed , I'll test

EDIT: in the end, I notice I don't understand how to make Affine work with my AI subscription (Mistral) and I'm also lost in Affine Admin View . Maybe it's just not mature enough for me at this stage

Your packaging looks great, at least it works like a charm for me (I just had to clone the repo so I have the CloudronManifest available for install).

Thanks!

SansGuidon

I came here after facing this issue for the first time
I first rebooted and retried.
Then I found this thread, I saved the config, remount the storage, re-entered the private ssh key each time on each screen just in case.
It seems to have solved the issue

fortunately there is the forum, otherwise it's easy to panic

I got no email for backup failed error, is that expected? @girish I have backup failed "enabled" in the notification settings

SansGuidon

I came here to learn about Hetzner having periodic issues. Thanks @girish !
I'm currently facing a similar issue on a Cloudron 9.x instance and was looking for old threads mentioning the exact same error. Here am I.

Damn Hetzner then

@girish is there a support ticket open with Hetnzer or anything that we can do?

SansGuidon

Thanks @girish, this will work

SansGuidon

Hey,
I'm worried that some API calls I made in the past are no longer working with V9, and that's both with my instance and with Cloudron demo instance.
I'm trying to simply use the API Token and get system disk usage via the route documented in the API.
e.g with the demo instance of cloudron and a token:

$ curl -H 'Content-Type: application/json' -H 'Authorization: Bearer <REDACTED>' https://my.demo.cloudron.io/api/v1/system/info
{
  "info": {
    "sysVendor": "FUJITSU",
    "productName": "CELSIUS-FTS",
    "uptimeSecs": 410396,
    "rebootRequired": false,
    "activationTime": "2025-01-02T18:04:55.000Z"
  }
}

$ curl -H 'Content-Type: application/json' -H 'Authorization: Bearer <REDACTED>' https://my.demo.cloudron.io/api/v1/system/disk_usage
{
  "status": "Not Found",
  "message": "No such route"
}

Did some routes change compared to the API Docs?
https://docs.cloudron.io/api.html#tag/System/operation/getDiskUsage

Thanks!

SansGuidon

IMHO some of the bug reports and user feedbacks above should be in different threads (e.g https://forum.cloudron.io/topic/14359/cloudron-9.0-beta-bug-reports ) so we can keep this one for staff announcements and other general concerns or questions to the staff?

SansGuidon

@sparkwise said in Kuma Uptime - ERROR: Database migration failed:

Wanted to share a working solution, lightly adapted for Cloudron from Github issue comment referenced above:

Enter Recovery Mode

On the app's terminal: bash sqlite3 /app/code/data/kuma.db "DELETE FROM setting WHERE key = 'migrateAggregateTableState';"

Exit Recovery Mode

I've just tried this, without the initial bash and it seems to have worked. And now I'm starting the major Cloudron upgrade ...

Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.

Cloudron Forum

SansGuidon

Posts