Cloudron Forum

@girish

Twenty already has version 1.0. Please integrate it into Cloudron. Cloudron’s ecosystem will be much more powerful and excellent when this ecosystem is added. Twenty is finally out of beta!

https://github.com/twentyhq/twenty/releases/tag/v1.0.0

https://twenty.com/releases

@girish It seems that every time the app restarts, the nginx configuration resets to default, right? Is there any way to keep it fixed so it doesn’t change when the app restarts? Thank you.

@nebulon I tried adding both BigQuery and Postgres but couldn't connect to either. I saw logs from Cloudron indicating that the worker couldn't start.

@ChristopherMag

Could you share the reasons behind switching from Redash to Metabase?
I'm also currently evaluating Briefer: https://forum.cloudron.io/topic/12467/briefer-run-sql-and-python-and-turn-notebooks-into-dashboards
From what I understand, is Redash more suited for technical teams, while Metabase seems more user-friendly for general business users? I'd appreciate hearing about your experience with both platforms and what drove the decision to migrate.

Connection Test Failed:
Unknown error occurred while performing connection test. Please try again later

I just installed and tried running Redash, but I can't connect to any data sources.

@girish
Can you review it one more time? The software version has improved - it's now stable and receives regular updates. It has moved beyond the Beta testing phase.

0.52.0

https://twenty.com/releases

https://github.com/twentyhq/twenty/releases

@girish I added your code snippet above, and it doesn't work. But when I add a block like mine, it works.

location /mcp {
    gzip off;
    proxy_buffering off;
    proxy_cache off;
    
    proxy_http_version 1.1;
    proxy_set_header Host $host;
    proxy_set_header X-Real-IP $remote_addr;
    proxy_set_header X-Forwarded-For $remote_addr;
    proxy_set_header X-Forwarded-Host $host;
    
    proxy_pass http://172.18.20.102:5678;
}

1. search for gzip_proxied any;

2. Add this location block right after the existing location block in the NGINX configuration file:

location /mcp {
gzip off;
proxy_buffering off;
proxy_cache off;

proxy_http_version 1.1;
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $remote_addr;
proxy_set_header X-Forwarded-Host $host;

proxy_pass http://ip:5678;

}

3. After adding this code, check the NGINX configuration:

nginx -t

4. If there are no errors, reload NGINX:

systemctl reload nginx

The n8n MCP server has connected and is working properly. Thank you for your guidance. @girish

When running the new version of n8n with the MCP server, it does not work. I have identified some causes. Is it possible to configure this in Cloudron?

https://community.n8n.io/t/error-could-not-connect-to-your-mcp-server-when-integrating-external-tool-via-sse-in-ai-agent/100957/6

v0.51.0

https://github.com/twentyhq/twenty/releases

v0.50.0

https://github.com/twentyhq/twenty/releases

V0.44.0

https://github.com/twentyhq/twenty/releases

@jdaviescoates They have updated to version v0.43.0.

https://github.com/twentyhq/twenty/releases

https://techcrunch.com/2024/11/18/twenty-is-building-an-open-source-alternative-to-salesforce/
This CRM looks great, hope it will be available on Cloudron soon.​​​​​​​​​​​​​​​​I just found out that they have raised $5 million USD.​​​​​​​​​​​​​​​​

I installed another application on Cloudron and I saw that the application has Redis. Can I leverage that Redis for the queue in my n8n, or do I need to install Redis elsewhere? Thank you.

Get notify on cloudron and click reboot

After restarting, n8n cannot connect and there is a log as I sent above

@nebulon

I have tried restarting all other apps, and they are working except for n8n, which is having issues. Below is the log after restarting n8n.

Feb 06 21:32:01 box:taskworker Running task of type app
Feb 06 21:32:01 box:apptask run: startTask installationState: pending_restart runState: running 
Feb 06 21:32:01 box:tasks update 4449: {"percent":10,"message":"Starting app services"}
Feb 06 21:32:01 box:tasks update 4449: {"percent":20,"message":"Restarting container"}
Feb 06 21:32:11 => Ensure directories
Feb 06 21:32:11 => Loading configuration
Feb 06 21:32:11 box:tasks update 4449: {"percent":80,"message":"Configuring reverse proxy"}
Feb 06 21:32:11 box:shell reverseproxy: openssl x509 -noout -subject -issuer
Feb 06 21:32:11 box:reverseproxy providerMatches: subject=CN = webapp.domain.com domain=webapp.domain.com issuer=C = US, O = Let's Encrypt, CN = E6 wildcard=false/false prod=true/true issuerMismatch=false wildcardMismatch=false match=true
Feb 06 21:32:11 box:shell reverseproxy: openssl x509 -startdate -enddate -subject -noout  
Feb 06 21:32:11 box:reverseproxy expiryDate: subject=CN = webapp.domain.com notBefore=Jan 9 09:12:15 2025 GMT notAfter=Apr 9 09:12:14 2025 GMT daysLeft=61.777801840277775
Feb 06 21:32:11 box:reverseproxy needsRenewal: false. force: false
Feb 06 21:32:11 box:reverseproxy ensureCertificate: webapp.domain.com acme cert exists and is up to date
Feb 06 21:32:11 box:shell reverseproxy: openssl x509 -in /home/yellowtent/platformdata/nginx/cert/webapp.domain.com.cert -noout -ocsp_uri
Feb 06 21:32:11 box:reverseproxy writeAppLocationNginxConfig: writing config for "webapp.domain.com" to /home/yellowtent/platformdata/nginx/applications/e83dd39f-2eb7-449a-bbd4-1e9186013b24/webapp.domain.com.conf with options {"sourceDir":"/home/yellowtent/box","vhost":"webapp.domain.com","hasIPv6":true,"ip":"172.18.18.255","port":5678,"endpoint":"app","redirectTo":null,"certFilePath":"/home/yellowtent/platformdata/nginx/cert/webapp.domain.com.cert","keyFilePath":"/home/yellowtent/platformdata/nginx/cert/webapp.domain.com.key","robotsTxtQuoted":"\"# Disable search engine indexing\\n\\nUser-agent: *\\nDisallow: /\"","cspQuoted":null,"hideHeaders":[],"proxyAuth":{"enabled":false,"id":"e83dd39f-2eb7-449a-bbd4-1e9186013b24","location":"/"},"upstreamUri":"","ocsp":true,"hstsPreload":false}
Feb 06 21:32:11 box:shell reverseproxy /usr/bin/sudo -S /home/yellowtent/box/src/scripts/restartservice.sh nginx
Feb 06 21:32:11 => Setting permissions
Feb 06 21:32:11 box:shell nginx: [warn] "ssl_stapling" ignored, host not found in OCSP responder "e5.o.lencr.org" in the certificate "/home/yellowtent/platformdata/nginx/cert/app1.domain.com.cert"
Feb 06 21:32:11
Feb 06 21:32:11 box:shell nginx: [warn] "ssl_stapling" ignored, host not found in OCSP responder "e5.o.lencr.org" in the certificate "/home/yellowtent/platformdata/nginx/cert/app2.domain.com.cert"
Feb 06 21:32:11
Feb 06 21:32:11 box:shell nginx: [warn] "ssl_stapling" ignored, host not found in OCSP responder "e6.o.lencr.org" in the certificate "/home/yellowtent/platformdata/nginx/cert/app3.domain.com.cert"
Feb 06 21:32:11
Feb 06 21:32:11 box:shell nginx: [warn] "ssl_stapling" ignored, host not found in OCSP responder "e6.o.lencr.org" in the certificate "/home/yellowtent/platformdata/nginx/cert/webapp.domain.com.cert"
Feb 06 21:32:11
Feb 06 21:32:12 box:tasks update 4449: {"percent":100,"message":"Done"}
Feb 06 21:32:12 box:taskworker Task took 10.636 seconds
Feb 06 21:32:12 box:tasks setCompleted - 4449: {"result":null,"error":null}
Feb 06 21:32:12 box:tasks update 4449: {"percent":100,"result":null,"error":null}
Feb 06 21:32:12 => Installing handlebars@4.7.7 jsonata@2.0.2 marked@4.3.0 bwip-js@3.3.0 ajv-formats@2.1.1 odoo-xmlrpc@1.0.8 firebase-admin@11.10.1
Feb 06 21:32:20 => Healtheck error: Error: connect ECONNREFUSED 172.18.18.255:5678
Feb 06 21:32:30 => Healtheck error: Error: connect ECONNREFUSED 172.18.18.255:5678

The process is as follows:

I saw a notification to restart after updating to the latest Cloudron version and followed that notification, restarting in Cloudron.
N8n was inaccessible and there was a log message as I sent above.
Other apps run normally, only n8n has an error.
N8n status Starting...

...
Feb 06 21:09:20 box:reverseproxy providerMatches: subject=CN = webapp.abc.com domain=webapp.abc.com issuer=C = US, O = Let's Encrypt, CN = E6 wildcard=false/false prod=true/true issuerMismatch=false wildcardMismatch=false match=true
...
box:reverseproxy writeAppLocationNginxConfig: writing config for "webapp.abc.com" to /home/yellowtent/platformdata/nginx/applications/e83dd39f-2eb7-449a-bbd4-1e9186013b24/webapp.abc.com.conf with options {"sourceDir":"/home/yellowtent/box","vhost":"webapp.abc.com","hasIPv6":true,"ip":"172.18.0.255","port":5678,"endpoint":"app"...}
...
nginx: [warn] "ssl_stapling" ignored, host not found in OCSP responder "e5.o.lencr.org" in the certificate "/home/yellowtent/platformdata/nginx/cert/app1.abc.com.cert"
nginx: [warn] "ssl_stapling" ignored, host not found in OCSP responder "e5.o.lencr.org" in the certificate "/home/yellowtent/platformdata/nginx/cert/app2.abc.com.cert"
nginx: [warn] "ssl_stapling" ignored, host not found in OCSP responder "e6.o.lencr.org" in the certificate "/home/yellowtent/platformdata/nginx/cert/app3.abc.com.cert"
nginx: [warn] "ssl_stapling" ignored, host not found in OCSP responder "e6.o.lencr.org" in the certificate "/home/yellowtent/platformdata/nginx/cert/webapp.abc.com.cert"
...
=> Healtheck error: Error: connect ECONNREFUSED 172.18.0.255:5678