Take my upvote! Dolibarr and ERPNext could be alternatives but OrangeHRM is focused on HR management only.
subven
Posts
-
OrangeHRM -
Can't login after upgrade to 1.88@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.
-
AVX Support in your VPS/Server@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).
-
AVX Support in your VPS/ServerBye 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
-
Not able to restore / migrate - Addons Error - Unexpected response code or HTTP error when piping@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.
-
Not able to restore / migrate - Addons Error - Unexpected response code or HTTP error when piping@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 ^^
-
Not able to restore / migrate - Addons Error - Unexpected response code or HTTP error when pipingSo 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.
-
Firefox Sync/Accounts ServerPushing 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.
-
AVX Support in your VPS/Server@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.
-
AVX Support in your VPS/Server@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.
-
AVX Support in your VPS/Server@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
-
My password, 2 factor and reset not workingIt's in the docs --> Password reset (ssh) This one time password will bypass 2FA for the superadmin.
-
Delete all logs of connectivity from users to server@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?
-
Updates for apps sorted by size@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.
-
Updates for apps sorted by sizeOne 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
-
Updates for apps sorted by size@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.
-
Updates for apps sorted by size@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).
-
Updates for apps sorted by size@jdaviescoates said in Updates for apps sorted by size:
That does sound insanely expensive!
Just to also add, I'm doing daily back-ups of 49 apps that total 247.12 GB (plus a few other small Cloudrons too) and my backups (all tarball backups) comes to a total of 3.63 TB and I've got all that stored on a 5TB Hetzner that only costs €13.08/mo
Same for me ^^ I also use the same storagebox for my Laptop, mobile and Desktop backups mostly done with Duplicati.
As my Cloudron grows I want to switch over to RSYNC because at the moment, TGZ is still faster because of many, many, many small files.
-
Ability for apps to update while shutdown@nebulon said in Ability for apps to update while shutdown:
I don't think we should start the app, update it and stop it again, as that means any potential update error within the app (like some data migration bug) will be unnoticed until the next time you actually have the use-case to use the app again. So I think while the app is dormant it should also be kept like that.
Thats the correct approach and a good philosophy.
@ChristopherMag said in Ability for apps to update while shutdown:
That app updates so frequently that it has taken over a month of it updating every day on its own plus me clicking manually to tell it to update an additional time many weekdays when I check cloudron's health and it has just now finally caught up.
You can fix this behavior by adjusting automatic updates. This way you just need to start the apps in question and within 24h you can (in theory) have 24 update checks per app. Keep in mind to not interfere with the backup schedule.
You can even automate the procedure to 1: Start individual apps 2: Temporary change autoupdate schedule 3: Stop apps and change schedule to normal behavior.
-
pricing too high@nebulon said in pricing too high:
the goal for us is not to spend much time on accounting and invoicing, but rather work on the product.
our business is in enabling self-hosting, not working in accounting
Even if you (Cloudron) would become much more attractive by lowering the barrier for small groups and (single) private users? The field were small self hosting has a real impact because business users have much more options and ressources. 17$ for Cloudron, 8$ for a VPS, 4$ for backup = ~30$/month....not reasonable for single users and also a hurdle for smaller teams/non profits. If you are doing business and involve Cloudron, the price is ridiculously low because support is already included.
The free plan is good for evaluation, development and understanding the product but for productive use limited to two apps, it is not reasonable (in most cases) to run a whole server with it.
For a smaller plan you could:
- cut direct support
- only offer yearly plans
- limit app use (obvious) to....I would say 5-7
- lower referral credits to a price that equals 1 month (for both)
- price something between 7-11$ which equals to 84-132$/year...how about 99$?
To end my point: I know I asked this already but if accounting is a pain and you (both) have to focus on development AND support....why not hire someone (part time) to do all the accounting/billing/contracting and maybe communications too? It's not that hard of a job and even if it costs more then you would earn from it, you would save yourself the stress/pain which is, in the end, much more beneficial to yourself AND the product.