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


Skip to content
  • NocoDB and Metabase on my Cloudron instance

    Discuss
    4
    0 Votes
    4 Posts
    21 Views
    L
    Hi Cloudron Support, We have a fresh Cloudron Pro installation (domain dados.server.seuimovel.com.br). All the apps we plan to use are already installed and the admin user (admin@cloudron.local) is working, so we have full administrative access in the UI. Our stack will consist of the following Cloudron apps (plus a few external services that must be connected to them): Category Cloudron App Purpose Data & Processes NocoDB Low‑code relational data store (tables/funnels) Automations n8n Workflow engine (triggered by webhooks, timers, etc.) Customer Service Chatwoot Live‑chat / ticketing system Email Marketing Listmonk Newsletter & bulk‑email campaigns Analytics Metabase BI dashboards and reporting Exportar Copiar External services we need to connect: Z‑API – WhatsApp gateway (to be called from Chatwoot and n8n) Amazon SES – high‑deliverability SMTP for Listmonk The core open question is how to provide a single PostgreSQL database that can be used by both NocoDB and Metabase (and optionally by n8n for its own data). We have identified three possible approaches, but we need confirmation on whether each is supported on Cloudron, and, if so, the exact steps to implement them: 1️⃣ Use the internal PostgreSQL instance that NocoDB runs on (the one that is not exposed in the Cloudron UI). Is it possible to expose that internal database to other apps (Metabase, n8n) via a network‑allowed hostname/port? If it is possible, what configuration changes (e.g., Cloudron networking, app permissions, environment variables) are required? 2️⃣ Deploy a dedicated PostgreSQL app on Cloudron (the “PostgreSQL” addon) and configure both NocoDB and Metabase to connect to it. What are the exact steps to: Create the PostgreSQL app (or enable the addon) on Cloudron Pro Retrieve the connection credentials (host, port, database, user, password) from the Cloudron UI Configure NocoDB to use this external PostgreSQL (via its Settings → Database page) Configure Metabase (Admin → Databases → Add database) with the same credentials Optionally point n8n to the same PostgreSQL instance (if we want to store workflow data there) 3️⃣ Use an external PostgreSQL service (e.g., Supabase, Amazon RDS, Neon) and have all Cloudron apps connect to it. What is the recommended way to store the external credentials securely in each app (environment variables, Cloudron Secrets, etc.)? Are there any Cloudron‑specific networking restrictions we need to be aware of when an app connects to an external host? Additional integration questions n8n Chatwoot – We want n8n to listen to Chatwoot webhook events (new tickets, status changes) and also to push updates back to Chatwoot. Is there a built‑in “Chatwoot” node in n8n, or do we need to use generic HTTP/Webhook nodes? Any documentation for the required authentication (API token, JWT) would be appreciated. Chatwoot Z‑API (WhatsApp) – We plan to forward incoming WhatsApp messages from Z‑API to Chatwoot and send replies back through Z‑API. What is the recommended webhook configuration on Z‑API, and does Chatwoot support a custom “WhatsApp” channel out‑of‑the‑box, or must we use the generic “API” channel? Listmonk Amazon SES – We intend to use Amazon SES as the SMTP relay for Listmonk. Are there any Cloudron‑specific steps (e.g., adding SES credentials as a “Mail Server” addon, or setting environment variables) to make this work reliably? Metabase NocoDB tables – Once the PostgreSQL connection is established (options 1‑3 above), will Metabase automatically discover the NocoDB tables (including the separate tables we will create for each funnel: Captação, Oportunidades, Follow‑up, Relacionamento, Gestão)? If not, what is the minimal configuration needed in NocoDB to expose those tables to external queries? Automation of “Responsável” field – In NocoDB we need the “Responsável” column to be automatically populated based on the ticket owner in Chatwoot (or the workflow owner in n8n). Is there a native NocoDB trigger we can use, or should we create an n8n workflow that updates the record via NocoDB’s REST API? Any example workflow would be helpful. Documentation request – Could you provide (or point us to) a consolidated Cloudron documentation page that covers: Managing app‑to‑app networking and permissions (especially for database sharing) Storing and retrieving secret credentials for external services (SES, Z‑API, external PostgreSQL) Exporting/importing NocoDB schemas so that we can version‑control our funnel tables Summary of what we need Confirmation on whether Option 1 (internal NocoDB PostgreSQL) can be exposed, and the exact steps if it is possible. Full, step‑by‑step guide for Option 2 (dedicated Cloudron PostgreSQL), including how to point NocoDB, Metabase, and optionally n8n to it. Guidance for Option 3 (external PostgreSQL), especially regarding secret handling and network policies. Answers to the integration questions (n8n Chatwoot, Chatwoot Z‑API, Listmonk SES, Metabase NocoDB tables, automation of “Responsável”). Links to any relevant Cloudron documentation or example repositories that cover the above topics. We prefer to keep everything inside Cloudron whenever possible to reduce external dependencies, but we are open to using external services (SES, Z‑API, external PostgreSQL) if they are required for robustness. Thank you for your help – we look forward to a detailed response so we can move forward without further trial‑and‑error. Best regards, Luis
  • What's coming in Cloudron 9

    Pinned Announcements
    107
    22 Votes
    107 Posts
    24k Views
    humptydumptyH
    [image: 1765502622090-fixed.gif]
  • DB migration failed after upgrade to 9.0.13

    Unsolved Support database migrations
    3
    1 Votes
    3 Posts
    28 Views
    D
    Hi, --apply-db-migrations had the same error before updating tasks table. I inserted column because of this repeating error in box.log: 2025-12-07T15:23:51.233Z box:server ========================================== 2025-12-07T15:23:51.234Z box:server Cloudron 9.0.13 2025-12-07T15:23:51.234Z box:server ========================================== 2025-12-07T15:23:51.234Z box:platform initialize: start platform 2025-12-07T15:23:51.236Z box:tasks stopAllTasks: 0 tasks are running. sending abort signal 2025-12-07T15:23:51.236Z box:shell tasks: /usr/bin/sudo --non-interactive /home/yellowtent/box/src/scripts/stoptask.sh all 2025-12-07T15:23:51.293Z box:locks releaseAll: all locks released 2025-12-07T15:23:51.297Z box:reverseproxy writeDashboardConfig: writing dashboard config for cloud.voxellab.rs 2025-12-07T15:23:51.309Z box:shell reverseproxy: /usr/bin/sudo --non-interactive /home/yellowtent/box/src/scripts/restartservice.sh nginx 2025-12-07T15:23:51.646Z box:updater notifyBoxUpdate: update finished from 8.3.2 to 9.0.13 2025-12-07T15:23:51.648Z Error starting servers 2025-12-07T15:23:51.648Z BoxError: Unknown column 'completed' in 'field list' 2025-12-07T15:23:51.648Z at Object.query (/home/yellowtent/box/src/database.js:96:22) 2025-12-07T15:23:51.648Z at process.processTicksAndRejections (node:internal/process/task_queues:105:5) 2025-12-07T15:23:51.648Z at async list (/home/yellowtent/box/src/tasks.js:163:21) 2025-12-07T15:23:51.648Z at async Object.setCompletedByType (/home/yellowtent/box/src/tasks.js:172:21) I referred to forum post here where user had missing pending column after the same version upgrade. Anyway, I used this: USE box; SHOW COLUMNS FROM tasks; ALTER TABLE tasks ADD COLUMN completed TINYINT(1) NOT NULL DEFAULT 0; SHOW COLUMNS FROM tasks; This restored working dashboard and my server is operational at the moment, but I should resolve the oidc issue at some point. Thanks
  • 0 Votes
    1 Posts
    4 Views
    No one has replied
  • Announcing n8n version 2.0 - coming soon!

    Moved N8N
    6
    2 Votes
    6 Posts
    374 Views
    U
    It looks like they will continue to bug fix v1 while v2 is distributed. How is that going to be handled by the Cloudron updater? Will we be able to stay on v1 with Cloudron if we don't want to or cannot upgrade to v2 but need the v1 patches?
  • Cloudron 9: UI Issues in the system and email eventlog

    Unsolved Support user interface eventlog
    6
    4 Votes
    6 Posts
    66 Views
    milian.hackradtM
    Apologies, I got hung up on your point about the 'combination of search and filters' since I'm experiencing only getting the amount of entries that's set in the per_page value even when using only the search box without any additional filters active. I'm really looking forward to the rework then because right now even basic stuff like checking if a specific email was delivered or if a specific user logged in is a bit of a pain since I have to unfold the details of the first entries just to make the scrollbar appear to load more.
  • Staging environment for custom apps

    Feature Requests
    1
    0 Votes
    1 Posts
    17 Views
    No one has replied
  • Backups still not verified or what?

    Unsolved Support cifs backups
    9
    1
    1 Votes
    9 Posts
    66 Views
    J
    @philkunz also, none of the app backups (i.e backup of other apps) work and not just a specific one, correct? If not, can you please try to clone a couple of other apps, just to rule out some obvious guesses.
  • Restoring Backups fails

    Unsolved Support backups restore
    24
    1 Votes
    24 Posts
    1k Views
    P
    @dylightfu That is the main problem.... the restoration, not the backup... Can you give us storage provider company name?
  • 4 Votes
    2 Posts
    488 Views
    S
    It would be a good thing to have a data warehouse like clickhouse on the same sever as superset or metabase and n8n.
  • Downloaded file is 0kb

    Jirafeau
    5
    1
    0 Votes
    5 Posts
    141 Views
    M
    In the end, I disabled encryption for a while. Switched it on again recenly and it just worked now.
  • 2 Votes
    41 Posts
    7k Views
    robiR
    @joseph oh geez, ok thx ️
  • GitLab - Package Updates

    Pinned GitLab
    219
    1 Votes
    219 Posts
    177k Views
    Package UpdatesP
    [1.110.1] Update gitlab-foss to 18.6.2 Full Changelog
  • HumHub - Package Updates

    Pinned Humhub
    40
    0 Votes
    40 Posts
    9k Views
    Package UpdatesP
    [1.8.6] Update humhub to 1.17.5 Full Changelog Fix #​7835: Truncate application name in the theme header Fix #​7841: Send user approval notification only to active group managers Fix #​7891: Edge shows blank home page
  • OpenProject - Package Updates

    Pinned OpenProject
    144
    0 Votes
    144 Posts
    88k Views
    Package UpdatesP
    [3.44.3] Update openproject to 16.6.3 Full Changelog Bugfix: Shared WP inaccessible to non-project members (Error 404) #​68852 [#​68921] Bugfix: User not fully deleted if that user created a recurring meeting [#​69517] Bugfix: No message when using "forgot password" with unknown email [#​69730]
  • Nextcloud - Package Updates

    Pinned Nextcloud
    115
    1 Votes
    115 Posts
    65k Views
    Package UpdatesP
    [5.6.3] Update server to 32.0.3 Full Changelog
  • Can Syncthing tell me when it fails?

    Syncthing
    2
    2 Votes
    2 Posts
    23 Views
    J
    Closest upstream thread I found is https://forum.syncthing.net/t/syncthing-failed-to-notify-sync-failed-for-months/21279 but maybe worth asking in their forum .
  • oPodSync - Package Updates

    Pinned oPodSync
    7
    1 Votes
    7 Posts
    745 Views
    Package UpdatesP
    [1.1.0] Update opodsync to 0.5.0 Full Changelog Add URL of instance on homepage, with copy button Add support for being used as an external app inside KaraDAV
  • 1 Votes
    8 Posts
    111 Views
    T
    Looks like the latest Freescout release fixes this - Thanks for packaging and releasing it already.
  • Stirling-PDF - Package Updates

    Pinned Stirling-PDF
    139
    0 Votes
    139 Posts
    57k Views
    Package UpdatesP
    [3.1.2] Update Stirling-PDF to 2.1.2 Full Changelog SMTP not working under SSL, new settings.yml entries had been added for advanced customisation for this use case Extra font support for text editor Change password/username UI added for users Change password for admins added Possible fix for swagger access issues Fix for admin ui showing for users (Although not usable) Add admin password reset option for users by @Frooodle in Stirling-Tools#5180 Add configurable SMTP TLS/SSL options by @Frooodle in Stirling-Tools#5204 extra font support in text editor by @Frooodle in Stirling-Tools#5208 Fix: Access to Swagger UI when login enabled by @DarioGii in Stirling-Tools#5194