Cloudron Forum

Cryptomator is the best FOSS solution I found while searching for ways to encrypt+mount folders/drives and share access among users. I ended up running Cryptomator Hub on a Synology Diskstation. Would appreciate to have it as a tool on Cloudron.

@humptydumpty said in backup failed - 3 times in one week period:

8 vCPUs 24GB 32GB RAM and barely use 1/3 of them

Check your network speeds and if you really can use the CPU performance you're paying for. Maybe you have "noisy neighbors" on your VPS that constantly use up all ressources.

22 minutes backup upload for a 700mb app seems too much even for a known weak performing hoster like Contabo. Upload speed of 1MBps also seems way too low. Does your server have enough RAM to perform the backup task? The error is just an box backup task crash.

Have you benchmarked the server? Is your load, RAM and network speed fine? My guess is that your server lacks ressources or is under high load.

If it's just weak performance from Contabo I would recommend to move to known good hoster like Hetzner or Netcup.

Take my upvote! Dolibarr and ERPNext could be alternatives but OrangeHRM is focused on HR management only.

@klawitterb said in Can't login after upgrade to 1.88:

Using Sign in with Cloudron gives me an "Email already in use" error.

Does your Cloudron username and email match the username and mail within Gitlab or did you maybe change your mail within Cloudron after creating the corresponding Gitlab account? Most of the time a "Email already in use" error means the app trys to create a new account because the username was not found while login is valid.

Login with Cloudron username + password over OIDC works for me with the current (cloudronapp@1.88.0) version. Maybe you could create another account within Cloudron and give it access to Gitlab.

@jdaviescoates said in AVX Support in your VPS/Server:

Although seems odd that most of their VPS options are sold out

They appear to be a very small company that limits their offerings to the number of users they can support. After the big Christmas sale, they marked most of the offers as sold out in order to be able to serve all new customers.

@robi it is shared vCPU though but a big upgrade from SATA SSD's and even the network seems faster. My external backup takes half the time now (around 1h).

Bye the way I moved from my Netcup to Unesty and their servers have AVX.

RYZEN GEN2 VPS | 12,61€/month (permanent 50% discount with xmas voucher)

• 6 AMD RYZEN 9 7950X3D vCores @ 4,2 - 5,7 GHz
• 16 GB DDR5 ECC RAM
• 400 GB NVMe SSD
• 1 IPv4-Address
• 1 Gbit/s Link

@girish thank you for explaining. In my case it is easier to:

• spin up my old server
• modify my (local) host file to point the dashboard domain to the old IP
• use the Cloudron web terminal to access MySQL and apply the fixes
• press the apps backup button and download to backup config afterwards
• revert host entries and import the apps backup config on my new Cloudron

This way I am only using tools that are already shipped with Cloudron without the need of other software.

@girish said in Not able to restore / migrate - Addons Error - Unexpected response code or HTTP error when piping:

if you go to Services -> MySQL and check the logs, can you paste the error from there,

Yes I can Dunno when I installed the Vaultwarden service but it was mostly around 2 years ago.

Dec 28 09:38:53[POST] /databases
Dec 28 09:38:53add: adding database 1f5cda718fda970f
Dec 28 09:38:53[POST] /databases/1f5cda718fda970f/clear
Dec 28 09:38:53clear: database 1f5cda718fda970f
Dec 28 09:38:56[POST] /databases/1f5cda718fda970f/restore
Dec 28 09:38:56restore: restoring database 1f5cda718fda970f
Dec 28 09:39:00restore: stderr from db import: ERROR 3780 (HY000) at line 528: Referencing column 'organization_uuid' and referenced column 'uuid' in foreign key constraint 'auth_requests_ibfk_2' are incompatible.
Dec 28 09:39:00restore: failed to restore database. code=1

Okay I remember reading something in the forums regarding organization_uuid!

EDIT: Found it - trying to fix it myself now ^^

So today I migrated from my Ubuntu 20.04 Netcup RS4000 to a Unesty RYZEN GEN2 VPS 16 GB Ubuntu 22.04. Everything went smooth besides the restore of two Vaultwarden instances.

Cloudron version for both servers is v7.6.2 and Vaultwarden version 1.30.1.

Restore errors out with:

Addons Error - Unexpected response code or HTTP error when piping /home/yellowtent/appsdata/2466709f-f01a-445a-aaed-5ab0e7768690/mysqldump to http://172.18.30.1:3000/databases/1f5cda718fda970f/restore?access_token=d9c32cd84c2fbf74996273bd9f156280707ccad132502a817a1e03fc65b99e4214c89b9d5aeb9ab28c0dd58e805ead61144928a570e1347d75c21774d389e6a21d5dec3d2dff7c7b2cc3d039ce700ab6320d483d2105ec5fb0665089c6b9f1098afeecc80c9cada0bc67e36f13971b67bd74ba170d0eaad3e821cbac693276db: status 500 complete false

Full log output:

Dec 28 06:25:23box:services restoreMySql
Dec 28 06:25:23box:services pipeFileToRequest: piping /home/yellowtent/appsdata/2466709f-f01a-445a-aaed-5ab0e7768690/mysqldump to http://172.18.30.1:3000/databases/1f5cda718fda970f/restore?access_token=d9c32cd84c2fbf74996273bd9f156280707ccad132502a817a1e03fc65b99e4214c89b9d5aeb9ab28c0dd58e805ead61144928a570e1347d75c21774d389e6a21d5dec3d2dff7c7b2cc3d039ce700ab6320d483d2105ec5fb0665089c6b9f1098afeecc80c9cada0bc67e36f13971b67bd74ba170d0eaad3e821cbac693276db
Dec 28 06:25:23box:services pipeFileToRequest: piped /home/yellowtent/appsdata/2466709f-f01a-445a-aaed-5ab0e7768690/mysqldump to http://172.18.30.1:3000/databases/1f5cda718fda970f/restore?access_token=d9c32cd84c2fbf74996273bd9f156280707ccad132502a817a1e03fc65b99e4214c89b9d5aeb9ab28c0dd58e805ead61144928a570e1347d75c21774d389e6a21d5dec3d2dff7c7b2cc3d039ce700ab6320d483d2105ec5fb0665089c6b9f1098afeecc80c9cada0bc67e36f13971b67bd74ba170d0eaad3e821cbac693276db
Dec 28 06:25:26box:services pipeFileToRequest: request completed with status code 500
Dec 28 06:25:26box:apptask run: app error for state pending_restore: BoxError: Unexpected response code or HTTP error when piping /home/yellowtent/appsdata/2466709f-f01a-445a-aaed-5ab0e7768690/mysqldump to http://172.18.30.1:3000/databases/1f5cda718fda970f/restore?access_token=d9c32cd84c2fbf74996273bd9f156280707ccad132502a817a1e03fc65b99e4214c89b9d5aeb9ab28c0dd58e805ead61144928a570e1347d75c21774d389e6a21d5dec3d2dff7c7b2cc3d039ce700ab6320d483d2105ec5fb0665089c6b9f1098afeecc80c9cada0bc67e36f13971b67bd74ba170d0eaad3e821cbac693276db: status 500 complete false at ClientRequest.<anonymous> (/home/yellowtent/box/src/services.js:1292:60) at ClientRequest.emit (node:events:513:28) at HTTPParser.parserOnIncomingClient (node:_http_client:701:27) at HTTPParser.parserOnHeadersComplete (node:_http_common:119:17) at Socket.socketOnData (node:_http_client:542:22) at Socket.emit (node:events:513:28) at addChunk (node:internal/streams/readable:324:12) at readableAddChunk (node:internal/streams/readable:297:9) at Readable.push (node:internal/streams/readable:234:10) at TCP.onStreamRead (node:internal/stream_base_commons:190:23) { reason: 'Addons Error', details: {} }
Dec 28 06:25:26box:taskworker Task took 68.559 seconds
Dec 28 06:25:26box:tasks setCompleted - 14860: {"result":null,"error":{"stack":"BoxError: Unexpected response code or HTTP error when piping /home/yellowtent/appsdata/2466709f-f01a-445a-aaed-5ab0e7768690/mysqldump to http://172.18.30.1:3000/databases/1f5cda718fda970f/restore?access_token=d9c32cd84c2fbf74996273bd9f156280707ccad132502a817a1e03fc65b99e4214c89b9d5aeb9ab28c0dd58e805ead61144928a570e1347d75c21774d389e6a21d5dec3d2dff7c7b2cc3d039ce700ab6320d483d2105ec5fb0665089c6b9f1098afeecc80c9cada0bc67e36f13971b67bd74ba170d0eaad3e821cbac693276db: status 500 complete false\n at ClientRequest.<anonymous> (/home/yellowtent/box/src/services.js:1292:60)\n at ClientRequest.emit (node:events:513:28)\n at HTTPParser.parserOnIncomingClient (node:_http_client:701:27)\n at HTTPParser.parserOnHeadersComplete (node:_http_common:119:17)\n at Socket.socketOnData (node:_http_client:542:22)\n at Socket.emit (node:events:513:28)\n at addChunk (node:internal/streams/readable:324:12)\n at readableAddChunk (node:internal/streams/readable:297:9)\n at Readable.push (node:internal/streams/readable:234:10)\n at TCP.onStreamRead (node:internal/stream_base_commons:190:23)","name":"BoxError","reason":"Addons Error","details":{},"message":"Unexpected response code or HTTP error when piping /home/yellowtent/appsdata/2466709f-f01a-445a-aaed-5ab0e7768690/mysqldump to http://172.18.30.1:3000/databases/1f5cda718fda970f/restore?access_token=d9c32cd84c2fbf74996273bd9f156280707ccad132502a817a1e03fc65b99e4214c89b9d5aeb9ab28c0dd58e805ead61144928a570e1347d75c21774d389e6a21d5dec3d2dff7c7b2cc3d039ce700ab6320d483d2105ec5fb0665089c6b9f1098afeecc80c9cada0bc67e36f13971b67bd74ba170d0eaad3e821cbac693276db: status 500 complete false"}}
Dec 28 06:25:26box:tasks update 14860: {"percent":100,"result":null,"error":{"stack":"BoxError: Unexpected response code or HTTP error when piping /home/yellowtent/appsdata/2466709f-f01a-445a-aaed-5ab0e7768690/mysqldump to http://172.18.30.1:3000/databases/1f5cda718fda970f/restore?access_token=d9c32cd84c2fbf74996273bd9f156280707ccad132502a817a1e03fc65b99e4214c89b9d5aeb9ab28c0dd58e805ead61144928a570e1347d75c21774d389e6a21d5dec3d2dff7c7b2cc3d039ce700ab6320d483d2105ec5fb0665089c6b9f1098afeecc80c9cada0bc67e36f13971b67bd74ba170d0eaad3e821cbac693276db: status 500 complete false\n at ClientRequest.<anonymous> (/home/yellowtent/box/src/services.js:1292:60)\n at ClientRequest.emit (node:events:513:28)\n at HTTPParser.parserOnIncomingClient (node:_http_client:701:27)\n at HTTPParser.parserOnHeadersComplete (node:_http_common:119:17)\n at Socket.socketOnData (node:_http_client:542:22)\n at Socket.emit (node:events:513:28)\n at addChunk (node:internal/streams/readable:324:12)\n at readableAddChunk (node:internal/streams/readable:297:9)\n at Readable.push (node:internal/streams/readable:234:10)\n at TCP.onStreamRead (node:internal/stream_base_commons:190:23)","name":"BoxError","reason":"Addons Error","details":{},"message":"Unexpected response code or HTTP error when piping /home/yellowtent/appsdata/2466709f-f01a-445a-aaed-5ab0e7768690/mysqldump to http://172.18.30.1:3000/databases/1f5cda718fda970f/restore?access_token=d9c32cd84c2fbf74996273bd9f156280707ccad132502a817a1e03fc65b99e4214c89b9d5aeb9ab28c0dd58e805ead61144928a570e1347d75c21774d389e6a21d5dec3d2dff7c7b2cc3d039ce700ab6320d483d2105ec5fb0665089c6b9f1098afeecc80c9cada0bc67e36f13971b67bd74ba170d0eaad3e821cbac693276db: status 500 complete false"}}
Unexpected response code or HTTP error when piping /home/yellowtent/appsdata/2466709f-f01a-445a-aaed-5ab0e7768690/mysqldump to http://172.18.30.1:3000/databases/1f5cda718fda970f/restore?access_token=d9c32cd84c2fbf74996273bd9f156280707ccad132502a817a1e03fc65b99e4214c89b9d5aeb9ab28c0dd58e805ead61144928a570e1347d75c21774d389e6a21d5dec3d2dff7c7b2cc3d039ce700ab6320d483d2105ec5fb0665089c6b9f1098afeecc80c9cada0bc67e36f13971b67bd74ba170d0eaad3e821cbac693276db: status 500 complete false
at ClientRequest.<anonymous> (/home/yellowtent/box/src/services.js:1292:60)
at ClientRequest.emit (node:events:513:28)
at HTTPParser.parserOnIncomingClient (node:_http_client:701:27)
at HTTPParser.parserOnHeadersComplete (node:_http_common:119:17)
at Socket.socketOnData (node:_http_client:542:22)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10)
at TCP.onStreamRead (node:internal/stream_base_commons:190:23)

Any clues? AFAIK it is MySQL related.

Pushing this topic! Google (again) postponed the rollout of manifest V3 in Chrome (and therefore every other Chromium based browser). I hope/think with the introduction of manifest V3 there will be a big shift in browser market share towards Firefox. By the time of writing, Chrome (and Chromium based browsers like Edge/Opera etc.) has a combined market share of >70%! Having the opportunity to easily host your own sync server at Cloudron would convince more users to migrate to Firefox and I would really appreciate that.

@erikscholz said in AVX Support in your VPS/Server:

to a Contabo VPS

Did you benchmark it? From my experience, Contabo has good prices but terrible performance compared to Netcup. I had lots of customers migrating from Contabo to Hetzner/Netcup over the years.

Currently looking for 4-5 small servers to replace Netcups VPS 500 and VPS 1000 for some customers. Next best option seems to be Netcup RS 1000 G9.5. Any other ideas? Looking for servers located in the EU, under 10€/month with comparable ressources and features.

@maxkreg said in AVX Support in your VPS/Server:

Netcup vServers would be very impactful for us. We´d have to convince a lot of customers to move to rServers or another hosting service, not even mentioning our time spent on migrating their servers

Same issue here. I always recommended Netcups vservers as they are cheap and there was no real disadvantage compared to their “root” servers. Now I have to migrate a lot of small customer servers telling them its because of an technical issue they are not able to understand.

Long (or mid?) term there will be the point were apps demand Cloudron v7.6.0 as minimum version and everybody who does not migrate to another server will be screwed.

Can someone make a table listing "known good" hosters + products? I know for a fact that Netcups RS (the fake root servers) have AVX as my main Cloudron runs on a RS 4000.

@girish said in AVX Support in your VPS/Server:

My Netcup server doesn't have AVX.

Netcup RS4000

root@my:~# cat /proc/cpuinfo | grep -i avx
flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm rep_good nopl cpuid extd_apicid tsc_known_freq pni pclmulqdq ssse3 fma cx16 sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm cmp_legacy cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw perfctr_core ssbd ibrs ibpb stibp vmmcall fsgsbase tsc_adjust bmi1 avx2 smep bmi2 rdseed adx smap clflushopt 
clwb sha_ni xsaveopt xsavec xgetbv1 xsaves clzero xsaveerptr wbnoinvd arat umip rdpid arch_capabilities

It's in the docs --> Password reset (ssh) This one time password will bypass 2FA for the superadmin.

@murgero said in Delete all logs of connectivity from users to server:

that can delete user data on demand?

You mean for like GDPR (EU) or DSGVO (Germany) compliance?

@privsec said in Updates for apps sorted by size:

I want to know where that's from so I can prune as needed.

Again...where do you get the 6TB number from? You can search through your backup files by domain like app_domain.com* to figure out what app consumes how much within your backup.

So in my case, 25GB compressed appdata ending up as 275GB in my backup. 1 backup per day and 7 days retention. Keep in mind that another another full mirror is stored in the backups "storage" folder under different naming.

Because you have one big app (the light blue one...is it Nextcloud?) with lots of data in it, this could be the reason for your backup size. Also consider using RSYNC if you have lots of huge files that don't change that often.

One of my main Cloudrons with ~75GB in appdata including mail + box.

Daily backups with 1 week retention.

Backup storage usage is 552GB in total. Some folders are older then they should be but they do not contain full backups as I also have stopped apps.

Total size for the "out of scope" folders is 57GB.

Lets do the math! Assumed backup size = 75GB * 7 days = 525 GB (without compression).
If I factor in compression it is 55-60GB * 7 days = 385-420 GB.

Real size 552GB so it is around 1/3 more then I would assume. This seems fine to me since additional plattform backups and app backups before updates are also included.

btw. this is from a 5TB Hetzner storage box

@privsec said in Updates for apps sorted by size:

My backup size though should not be anywhere nere 6 TBs

Where do you get the 6TB number from? Is it the green bar from your Wasabi account? Go into your invoices at Wasabi and take a look at the Deleted Storage vs Total Storage numbers.

Also: 4 backups per month = 4 x ~500GB + extra backups for plattform and app backups. This could be something around 3-4TB in actual backup size + even more "dead" (deleted) storage you use because of the retention policy.

@privsec said in Updates for apps sorted by size:

I have 5.6 tb of data in wasabi, but I have no idea as to why its that high

Just purge (empty) your Cloudron bucket at Wasabi. Utilisation for your account should be 0 now. Make a (manual) backup afterwards. If you use TGZ, your app backups are compressed and it should be easy to determine individual size. Also check back overall utilisation of storage within your Wasabi. Now make another backup and compare the groth per backup done. If you keep track on this process over lets say a week, you will find out whats going wrong.

PS: How many data does your Cloudron + apps store? You can find out at System Info.

EDIT: I guess I found the answer to your question.

@privsec said in Updates for apps sorted by size:

This is my utilization overview

Take a look at this: How does Wasabi's minimum storage duration policy work?

I did not read the page but at first glance I can safely assume what is going on Maybe move away from Wasabi and use other known good services like Hetzner Storagebox. In case it is not obvious: Wasabi lets you pay for data you did already delete (the black bar in the graph) in addition to data you store at the moment (green bar).