I used Typebot since it first launched and received the email today that it is now fully open-sourced under AGPL-3.
It's really easy to use conversation app/chat/bot builder. Do check it out:
https://www.typebot.io/
https://github.com/baptisteArno/typebot.io
Big thanks to the author Baptiste Arnaud who made an already amazing app open source!
Hope it will come to Cloudron someday! 
Hi, I think some of you may have heard of this app before: Grist [https://www.getgrist.com/](link url)
. It's like Airtable + spreadsheet alternative. I have used the cloud version for a while now for serious work, and I like it so far.
They adopt an open-core model: [https://github.com/gristlabs/grist-core](link url)
There is a functional docker image available. For making it public it needs a sign in services which I think Cloudron already has established? Perhaps abit more work than I would imagine for Cloudron team, but it might be totally worth it.
Would be lovely to see such app coming over to Cloudron in addition to Typebot. These two are quite polished as it is.
Thanks!
@girish Any chance you will be able to have a look at their official package? I deployed their docker image for production in DO: https://github.com/frappe/frappe_docker
ā and it works like a charm.
Why I think ERPnext is a very beautiful project: Open-source at heart, with good developers behind it, highly supportive and very community-driven project. The project has been going on for almost a decade now.
@chrishthompson Yes, totally agree. I tried several ERPs and this one really made me almost teary. Such a rich-featured ERP and they decided to make it open source.
It's a high quality made ERP. It has integration with WordPress and n8n.
Really wish it would be in Cloudron soon.
At the moment, I'm paying for a separate server just to deploy ERPnext. But it would lovely to have it in my Cloudron along with other apps I have here.
Cloudron team, please consider bringing it here
+1 to have NocoDB to Cloudron!
I just spoke to the founder, Naveen about the possibility to bring over NocoDB to Cloudron, and he's happy to do so.
I'll send him the link to this topic, so he can come and introduce himself & the app here.
Hope the Cloudron team @nebulon @girish can get in touch with him as well to make this possible
Really excited! 
@andreasdueren Hey, sorry for the late reply. I have followed this protocol closely and it works like a charm: Youtube Video
It's fairly straightforward if you apply the same method as the video above, it uses the GitHub method that was posted here.
ERPnext is a solid system, worth the hassle. Good luck
Kind regards.
@girish hey! What do you think about this app? Not sure how it will be packaged or the amount of work required in order to have it here, yet how feasible is it for packaging this app for Cloudron in your opinion?
Any news about this? This is very useful especially if we're giving access to our clients who may overuse the storage in some of the apps on Cloudron.
@timconsidine pretty much yes, full python and excel formulas are supported, and you can have graphs and charts inside it without any difficulties or external app like metabase. Also REST API support makes it easy to integrates with other apps. Its designed a little bit different than the usual Airtable alternatives. You have to try it to know what I mean.
Update
Problem fixed with restarting Linode. Probably it was some updates in the system or server that needs a good flush. I noticed it uses more RAM for working with daily tasks. Planning to use NextCloud talk soon, so I think this will be a CPU intensive feature. Will soon upgrade my VPS.
If you have any affordable and good VPS, do give a shout
@timconsidine Hi! Thank you so much for the reply & amazing tips! Sorry for getting back so late, I only saw a notification for replies to my email today.
Yes you are right, I restarted the Linode and it worked much much better now.
Currently there are only 3 of us in the team, but we also want to share some files and work with clients with Nextcloud. 4GB will get choked pretty soon.
And wow SSDNODES really have good price.
Most of my websites or web apps are in Linode. As you said, it's expensive. I was thinking about Contabo VPS M, but I heard mixed reviews about them. I'll give them KVM / X-LARGE a try.
For storage: Wasabi - yes I've tried the trial too, they seem quite good and price is reasonable, will try to integrate them sometime next week.
@humptydumpty You are right on this point, but that was before the slowness started, I had to remove an app. Currently I only have the featured ones like deck cards, notes, and kanban add-on. I've recently tried out Collabora but I think it's resource hungry too, so I removed for now, and will add it back once I've upgraded my VPS. I did not allocate any RAM for NextCloud in Cloudron, I thought it would pull more if it needed more. Sometimes I don't run it, and use other apps.
@scooke Yes, I've checked this post earlier, I think my problem had more to do with resources that NextCloud needs vs what I have. But restarting helps.
@nj Not sure if this is what you are looking for, but if you wish to put on a donation pot, I would be happy to contribute where I can, as a token of thanks for your hard work and time!
Thank you again for all the hard work.
Thank you both @murgero @nebulon
I applied this in the Kanboard app security's tab in Cloudron:
frame-ancestors https://link-of-the-target-website.com;
Now it works!
@humptydumpty Thanks for this.
Just for someone else pondering for some alternative, I've also found another neat solution, where I use webcatalog. I can create a workspace and put all my Cloudron apps there. its just converting the website into an app-like application on Windows, Mac OS and Linux. I can create a custom lock after certain period of time to lock the entire workspace.
I can also log in and click never save password, so everytime I click the app in that workspace, I will need to log in again.
Hi there, @girish any updates on this? I've contacted Cloudron (spoke to Johannes) but I was told that you guys are going to be occupied with the upcoming updates.
So I also contacted Chatwoot, apparently they have completed the basic version and are waiting for feedback from the Cloudron team to publish it on the app store.
Would really love to use Chatwoot as a stable solution in replace of FreeScout (so many errors in Github, and I've just encountered one today). Chatwoot support is solid, I can imagine this app will be a gem if added in Cloudron.
Thank you!
@girish Yes I believe it will, Wasabi retention is 90 days anyway, so 3 months retention would work!
Thank you so much!
@timconsidine Thank you so much! Its definitely not my level of technical prowess to handle it myself now. I'll do abit of research and will let you know if I'm stuck good to learn new things.
@nebulon Thank you so much
@ChristopherMag True, very much needed. Otherwise there isn't many ways to bring over the data as banks in my country do not have wide integrations, but it has been integrated with SaltEdge.
@girish Any news on this? I am super excited for this.
Sincere thanks for the amazing work!
@girish said in SFTP port 222 not working, Firewall UFW was inactive:
iptables -t nat -L DOCKER
Hi! thank you very much for the detailed input. I have removed the port 222 from the ufw and then disabled ufw.
OK, Here's what I see:
root@vmi815992:~# iptables --numeric -L DOCKER
Chain DOCKER (2 references)
target prot opt source destination
ACCEPT tcp -- 0.0.0.0/0 172.18.0.4 tcp dpt:8000
ACCEPT tcp -- 0.0.0.0/0 172.18.0.4 tcp dpt:2004
ACCEPT tcp -- 0.0.0.0/0 172.18.0.4 tcp dpt:2003
ACCEPT tcp -- 0.0.0.0/0 172.18.0.8 tcp dpt:9995
ACCEPT tcp -- 0.0.0.0/0 172.18.0.8 tcp dpt:9993
ACCEPT tcp -- 0.0.0.0/0 172.18.0.8 tcp dpt:4190
ACCEPT tcp -- 0.0.0.0/0 172.18.0.8 tcp dpt:2587
ACCEPT tcp -- 0.0.0.0/0 172.18.0.8 tcp dpt:2465
ACCEPT udp -- 0.0.0.0/0 172.18.16.75 udp dpt:10000
ACCEPT tcp -- 0.0.0.0/0 172.18.0.15 tcp dpt:22
and
root@vmi815992:~# iptables -t nat -L DOCKER
Chain DOCKER (2 references)
target prot opt source destination
RETURN all -- anywhere anywhere
RETURN all -- anywhere anywhere
DNAT tcp -- anywhere localhost tcp dpt:8417 to:172.18.0.4:8000
DNAT tcp -- anywhere localhost tcp dpt:2004 to:172.18.0.4:2004
DNAT tcp -- anywhere localhost tcp dpt:cfinger to:172.18.0.4:2003
DNAT tcp -- anywhere anywhere tcp dpt:pop3s to:172.18.0.8:9995
DNAT tcp -- anywhere anywhere tcp dpt:imaps to:172.18.0.8:9993
DNAT tcp -- anywhere anywhere tcp dpt:sieve to:172.18.0.8:4190
DNAT tcp -- anywhere anywhere tcp dpt:smtp to:172.18.0.8:2587
DNAT tcp -- anywhere anywhere tcp dpt:submission to:172.18.0.8:2587
DNAT tcp -- anywhere anywhere tcp dpt:submissions to:172.18.0.8:2465
DNAT udp -- anywhere anywhere udp dpt:10000 to:172.18.16.75:10000
DNAT tcp -- anywhere anywhere tcp dpt:222 to:172.18.0.15:22
And the log:
Mar 27 19:01:07 2022-03-27 18:01:07,913 INFO success: filemanager entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
Mar 27 19:01:07 2022-03-27 18:01:07,917 INFO spawned: 'proftpd' with pid 20
Mar 27 19:01:07 2022-03-27 18:01:07,940 sftp proftpd[20]: LDAPServer: parsed URL 'ldap://172.18.0.1:3002/??sub' as 'ldap://172.18.0.1:3002/??sub'
Mar 27 19:01:07 2022-03-27 18:01:07,940 sftp proftpd[20]: fatal: SFTPHostKey: unable to use '/etc/ssh/ssh_host_rsa_key' as host key, as it is group- or world-accessible on line 101 of '/etc/proftpd/proftpd.conf'
Mar 27 19:01:08 2022-03-27 18:01:08,962 INFO success: proftpd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
Mar 27 19:01:08 2022-03-27 18:01:08,962 INFO exited: proftpd (exit status 1; not expected)
Mar 27 19:01:09 2022-03-27 18:01:09,967 INFO spawned: 'proftpd' with pid 21
Mar 27 19:01:09 2022-03-27 18:01:09,991 INFO exited: proftpd (exit status 1; not expected)
Mar 27 19:01:09 2022-03-27 18:01:09,989 sftp proftpd[21]: LDAPServer: parsed URL 'ldap://172.18.0.1:3002/??sub' as 'ldap://172.18.0.1:3002/??sub'
Mar 27 19:01:09 2022-03-27 18:01:09,989 sftp proftpd[21]: fatal: SFTPHostKey: unable to use '/etc/ssh/ssh_host_rsa_key' as host key, as it is group- or world-accessible on line 101 of '/etc/proftpd/proftpd.conf'
Mar 27 19:01:11 2022-03-27 18:01:10,999 INFO spawned: 'proftpd' with pid 22
Mar 27 19:01:11 2022-03-27 18:01:11,056 sftp proftpd[22]: LDAPServer: parsed URL 'ldap://172.18.0.1:3002/??sub' as 'ldap://172.18.0.1:3002/??sub'
Mar 27 19:01:11 2022-03-27 18:01:11,056 sftp proftpd[22]: fatal: SFTPHostKey: unable to use '/etc/ssh/ssh_host_rsa_key' as host key, as it is group- or world-accessible on line 101 of '/etc/proftpd/proftpd.conf'
Mar 27 19:01:11 2022-03-27 18:01:11,058 INFO exited: proftpd (exit status 1; not expected)
Mar 27 19:01:13 2022-03-27 18:01:13,064 INFO spawned: 'proftpd' with pid 23
Mar 27 19:01:13 2022-03-27 18:01:13,082 sftp proftpd[23]: LDAPServer: parsed URL 'ldap://172.18.0.1:3002/??sub' as 'ldap://172.18.0.1:3002/??sub'
Mar 27 19:01:13 2022-03-27 18:01:13,085 INFO exited: proftpd (exit status 1; not expected)
>>Mar 27 19:01:13 2022-03-27 18:01:13,083 sftp proftpd[23]: fatal: SFTPHostKey: unable to use '/etc/ssh/ssh_host_rsa_key' as host key, as it is group- or world-accessible on line 101 of '/etc/proftpd/proftpd.conf'
Mar 27 19:01:16 2022-03-27 18:01:16,091 INFO spawned: 'proftpd' with pid 24
Mar 27 19:01:16 2022-03-27 18:01:16,141 sftp proftpd[24]: LDAPServer: parsed URL 'ldap://172.18.0.1:3002/??sub' as 'ldap://172.18.0.1:3002/??sub'
>>Mar 27 19:01:16 2022-03-27 18:01:16,141 sftp proftpd[24]: fatal: SFTPHostKey: unable to use '/etc/ssh/ssh_host_rsa_key' as host key, as it is group- or world-accessible on line 101 of '/etc/proftpd/proftpd.conf'
Mar 27 19:01:16 2022-03-27 18:01:16,151 INFO exited: proftpd (exit status 1; not expected)
Mar 27 19:01:17 2022-03-27 18:01:17,153 INFO gave up: proftpd entered FATAL state, too many start retries too quickly
Mar 28 14:35:40 [GET] /files/app-188b9a37-023d-4527-a955-e6f21227de36/
Mar 28 14:35:40 get: /mnt/appsdata/188b9a37-023d-4527-a955-e6f21227de36/data as download:false
Mar 28 14:35:41 [GET] /files/app-188b9a37-023d-4527-a955-e6f21227de36/credentials.txt
Mar 28 14:35:41 get: /mnt/appsdata/188b9a37-023d-4527-a955-e6f21227de36/data/credentials.txt as download:false
Mar 28 18:04:07 [GET] /files/app-21c7ea06-6ede-4883-a02d-d52321727aed/
Mar 28 18:04:07 get: /mnt/appsdata/21c7ea06-6ede-4883-a02d-d52321727aed/data as download:false
Mar 28 18:04:45 [GET] /files/app-21c7ea06-6ede-4883-a02d-d52321727aed/public
Mar 28 18:04:45 get: /mnt/appsdata/21c7ea06-6ede-4883-a02d-d52321727aed/data/public as download:false
On the 27th it did show there are an issue :
fatal: SFTPHostKey: unable to use '/etc/ssh/ssh_host_rsa_key' as host key, as it is group- or world-accessible on line 101 of '/etc/proftpd/proftpd.conf'
@timconsidine thanks, I'll check Scaleway and Hetzner out
@girish Wow this is good news. Thank you for the hard work, really appreciate it sincerely.
@scooke it was fresh, I only setup my ssh and followed exactly whatever was in the docs, the end result of the migration was very smooth, no problems at all. I have never tried any SFTP prior to the migration so I would not be sure.
@moocloud_matt that's really true.
My concern is that for example, when user uses it in public computer in laboratory for example, and they totally forget to log out manually. This can be an issue.
For public use in research team or something, I might suggest 2FA, but it is no use too, if it keep the token alive. Alternatively, editing the config file in Nextcloud seemed to do the trick.
@timconsidine Thanks for the enthusiasm! Happy to share.
Hi, I am not sure what's going on, but I try to deploy a lamp container, and upon realising the SFTP 222 wasn't working, I checked my system.
I am not sure when this happens, but I've upgraded to the latest Cloudron a couple of days ago, and last 2 weeks I have migrated Cloudron from a different server. I rarely use any SFTP hence which is why I only discover this issue now.
I'm using Commander One and CloudMounter on Mac, and receiving an error:
"Could not connect to host error -1." ā a quick Google says: This error indicates that your web server did not accept our TCP connection request, and hence the HTTP Request could not be performed.
What I did to investigate:
oot@vmi815992:~# telnet 123.123.123.1 222
Trying 123.123.123.1...
telnet: Unable to connect to remote host: Connection refused
Check UFW status
Before when I did ufw status, it returns inactive. So I enabled it.
UFW status verbose
root@vmi815992:~# ufw status verbose
Status: active
Logging: on (low)
Default: deny (incoming), allow (outgoing), deny (routed)
New profiles: skip
To Action From
-- ------ ----
222 ALLOW IN Anywhere >>>> (I had to add this port manually)
222 (v6) ALLOW IN Anywhere (v6)
Shall I remove port 222 now? But most importantly why is UFW was inactive? @nebulon
Many thanks for the input.
@murgero HI, what do you mean by 3rd party importers? How does it work?
@Aizat on the other test, I made an App Passwords, and use the password it generated instead of my Cloudron login, and it worked, moderator granted.
Hello, I'm not sure what's going on with my Cloudron.
My apps always seem to get stuck halfway through updating.
To fix it, I need to cancel the update. Go to my server and issue "systemctl restart docker"
Then restore to the previous backup, and update.
What do I need to do to diagnose this issue? The log in Cloudron only shows the corn log, but that's it.
@murgero sadly. I actually testing on using ERPnext for my invoicing, they do have bank integration with Plaid. I've requested similar integration in Invoice Ninja forum. Hope they'll integrate it someday
Hi everyone,
Just reporting here in case anyone searching the forum about the app not responding for WP developer in Cloudron.
The issue:
The app does not respond, even after you've restarted the app, just ensure that the route to some paths is not removed/redirected by a plugin, in my case Hide My WP Ghost.
Solution:
Check the log file in the app's Cloudron setting tab.
In my case, "https://mydomain/wp-includes/version.php" returns 404. So what I did what just revert back the custom wp-includes path to "wp-includes" as it was in original form (see attached below).
Thanks to @nebulon for the help!
