What i've ended up implementing so far:
Just need to figure out how to maintain backups of the db, externally.
And then, hope that it all works out if the need to restore everything arises.
@girish said in Auto-update to 8.3 - various apps down - database issue:
but the failure makes the end user do this manually
Well, this manual process costed me several hours of downtime of 'production' services, as well as another couple of hours for restoring them (at lot of backup files are really big, e.g. immich) 🫤
@nebulon said in Storage management in Immich?:
After rereading the thread, you want metadata/database to be backed up but not the actual pictures?
Pretty much. The media files can be stored in a mounted volume.
But currently, if i store everything in the Data Directory (that gets backed up, when enabled globally), then i'm at a big loss, because, i can neither set a separate (more lenient than other apps) backup frequency, nor can i escape the pain of having to manage my backup storages efficiently (i realised today that immich's backups were enabled in my case, which is 4 times a day, for a month, and around 150GB every time!!).
@d19dotca I too, have 4GB allocated to the Postgres service. Besides that, the resource graphs didn't even go anywhere near the threshold, during the update process.
This is a rather incomprehensible blunder on the part of Cloudron! The postgres databases have all been nuked!
I'm having to manually restore almost all of the affected apps, which is a very time-intensive task, not to mention the several hours of unscheduled downtime these services have been under.
My Cloudron instance for auto upgraded last night and now more than 50 apps are down!
Retry > Restart isn't working either, for a lot of them.
@girish is there any workaround/solution planned for this (capability to add/modify features)?
Example, i'm trying to add SMS Auth and Webhook Events capabilities, by first adding the .jar files to the providers folder > add/edit the corresponding conf/env variables in keycloak.conf > trigger the build operation. But it simply restarts the container, while removing all of my changes to the .conf file.
Hi @joseph @girish
I'm in a similar situation as well, with Cloudron v8.2.4, backups stored in DigitalOcean Spaces, via rsync.
I changed the Retention Policy to 1 month, instead of 3 months, and the older backups never got deleted.
I deleted most of them manually, but some are still left.
The Cleanup Backups process doesn't seem able to find the older/stale backups and delete.
P.S. Is this issue (https://forum.cloudron.io/post/71556) still unresolved?
Summary: InvenTree is an open-source inventory management system which provides intuitive parts management and stock control. InvenTree is designed to be extensible, and provides multiple options for integration with external applications or addition of custom plugins.
Notes: Still trying it out for Inventory and partly, Manufacturing Execution System requirements, but looks like promising so far.
@luckow Thanks for the recommendation!
Although, in my case, i do need features that they consider as "Enterprise", example: API access. Also, Odoo Studio is not available on Self-hosted.
Besides that, i've been seeing too much of mixed reviews regarding their support and pricing. So, not so sure about them.
Hi all!
Would anyone here have experience/knowledge of, and would like to share, a decent Manufacturing optimised ERP, or MES (Manufacturing Execution System), preferably FOSS but not too expensive either way, for a small manufacturing startup, focussing on Engineer-to-Order model (which basically implies highly dynamic BOMs) ?
@joseph
btw, i ended up uninstalling and reinstalling the Keycloak app and this the process went about as depicted in your video.
@joseph
I'm aware those are the prescribed steps, but the issue exists despite them, hence this post (as also stated before).
@joseph
that's also part of the reported error, as well as shown in the shared screenshots.
@joseph yeah, my 2nd image corresponds to your 3rd one. There's no dropdown option available in my case because I've already added all the available roles, although, the 'admin' role is not one of them.
@joseph said in How to add a permanent admin?:
you have to create a new User in the master realm with 'admin' role
Hi @joseph, this is pretty much the reason for my post; there's no option available to select the 'admin' role.
I've tried to add every role available, but the 'admin' role option is nowhere to be found in my instance.
Even though, the role does exist:
How to add a permanent admin?
Creating a user via the UI doesn't have the option to assigning them the role of 'admin'.
And as per https://github.com/keycloak/keycloak/discussions/33803#discussioncomment-10921141, the new user should be added to the admin role via the CLI, but, when i try that, i get this error:
Failed to create config file: /root/.keycloak/kcadm.config
Seem to have finally resolved the issue, by deleting those empty directories, using find . -type d -empty -delete, for now.
Although, the app is steadily creating new empty directories already!
@nebulon said in Since update to v8.2.1 backups fail with "Too many empty directories":
so are all those empty dirs within the upload folder in your case?
Except for :
/mnt/immich/i/typesense
all of the paths seems to be:
/mnt/immich/i/upload/upload/b4fe288d-66ef-42ac-b74a-14ec12220a71/../..
@nebulon said in Since update to v8.2.1 backups fail with "Too many empty directories":
Also did you happen to change the data layout at some point in the past?
I think i migrated the app storage from local disk to a volume, around 5 months ago.