Cloudron Forum

Or you could just, Place a copy of the database backup on the app's volume mayhaps Seems the need/request for alternate backup strategies has been out there for a long time (seen a post from 2020 asking for it -> https://forum.cloudron.io/topic/2503/nextcloud-backup-without-data -> kinda left at an unsatisfactory resolve; settling for rsync with some hackarounds). My backup today with an incremental btrfs snapshot just took a couple minutes to transfer to the USB drive - and in fact, I later realized I didn't need it at all! The prior snapshot already existed (as it has to increment from one shot to the next, the previous snapshot remains in place), so I could've just browsed that - even if I lost all my files.

Regardless, I found my friend in this at the "Terminal" for the Nextcloud app:

PGPASSWORD=${CLOUDRON_POSTGRESQL_PASSWORD} pg_dump -h postgresql -U ${CLOUDRON_POSTGRESQL_USERNAME} -d ${CLOUDRON_POSTGRESQL_DATABASE} -f /your/backup/location/database.sql

Takes just a couple seconds, bang-bang and done, database secured. Would be nice to have a button to "export database" or the like, for alternate backup modes like this. I don't expect to be able to one-click restore it without support for this btrfs mechanism, but I know the data is there - and in case of disaster, there's a lot bigger things to worry about.

The current backup mechanism might work for non-data-centric apps, but for Nextcloud, it's enormous and needs outside-the-box thinking for efficiently managing terabytes of data in backup.

(Not going to use it, but I think I also located the database itself, at /home/yellowtent/platformdata/postgresql - not something to be directly backed-up or manipulated of course )

I'm also just realizing the database might not be in the volume I think it is... that means I'd better figure out where it is, and fast. I expected everything to be stored on the volume I installed the app to If it were, a btrfs snapshot (with "btrfs send | btrfs receive" cloning and management to the external backup drive) would just Thanos-snap it into persistent security... (btrfs is pretty freaking awesome, imo... 10/10 would store life on it)

Guidance on where to manually back-up/otherwise protect the database would be appreciated

Thanks for the offer to help! Actually, the update that triggered the scare was buried a few layers further - it seems it hadn't been updated since installation (or near after) - with the version I was running released late 2024, and the system installed October '24. When I first hit the "update" button, it took me a Nextcloud version newer, then once again, then after those two upgrades (to .5, I think), I was offered the LDAP change - but it seemed totally normal.

I definitely can't say the system did much to notify me of the updates or the change (I don't really hear much from Cloudron itself, but the Nextcloud app pings me about "app updates" available). When clicking through it, it presented the usual changelog, which I read - and the bit about the auth change sounded like a "that should be fine?" by the way it was presented.

Unfortunately I can't recall for sure what settings I chose at the time of install. Is there any way to determine that after-the-fact?

As far as diagnosis, I did download the logs at the time (during my repair attempts). 15 MB of logs, spanning back with lots of personal activity and filenames, etc... maybe I can try and sanitize that (e.g. trim to just the upgrade points) and send it along?

As for restoring from a backup, is it okay to just restore the app volume's structure (containing "apps", "config", "data", etc) but omit the file tree (/data/myname/*)? That is, is there additional metadata about the app that might get corrupted by doing so? If I were able to do that, I believe it contains the database and everything should just snap into place if I "stop" the app, restore everything, then "start" it, I'd imagine...

(that is, if a future situation puts me in a situation where I need to restore such a backup... I'm good at the moment; it seems everything is working!)

Let me know about that log, and maybe how to determine its user config, and I'll give you what I can

edit to add: my Cloudron username is, indeed, the same as my Nextcloud username.

Boo.

Didn't think it warranted another post, so I went to edit my last reply to add:

But because I love staring death in the face to take a leap into a better place, I finished the remaining hop, hop, hop, hop, hop, hop... each one taking 2-3 minutes to process... and finally sitting at NextCloud 31.0.6 (package 5.5.2) with my user account still intact after the fix. Yay.

Happy news: back to my (unhappy) old web-admin roots, I dug into the PostgreSQL database and found that the "oc_users" entry for me had completely disappeared - but I still existed as a "ghost" all over the system (e.g. "recent admins", I'm there). Something seems to have just deleted me from "oc_users" in a "dirty" way. Simply re-adding myself back (directly to "oc_users" with an INSERT, with a garbage string as a password, the same UID as before, and the same UID as "uid_lower") and then "occ user:resetpassword" on my account... I'm back in! Everything is back.

God let me never have to deal with a scare like that again. Now I'm afraid to apply any updates...

Cloudron has a few issues I've had to work around... (1) lack of support for Cloudflare tunnel led me to needing a complex workaround for Cloudron trying desperately and angrily to generate its own certificates (not needed, just let me handle it!). And (2) file-storage being a primary purpose of my Cloudron system, leading to me disabling auto-backups and using btrfs snapshots onto an external device instead (tar.gz and rsync are both unacceptable options for storage space & efficiency reasons). There is no way the backup system would be capable of handling 3+ TB backups... nor do I want to spend the kind of money on storage to flatten my de-duplicated BTRFS array and slog it all out the front door as a *.tar.gz. The system I have with BTRFS snapshots/clones works beautifully and I do have a backup of the whole volume the Nextcloud app is "homed" in - from before these updates.

Today I embarked upon "realizing that auto-updates were not working at all in Cloudron", and processing a number of Nextcloud updates: 30.0.3.3(?) -> 30.0.4 -> 30.0.5 -> (Now we're gonna break your accounts with LDAP to OIDC) -> everything broke.

I don't use "log in with Cloudron" - it wasn't offered during setup, so I used the "admin" account to create my own account, then made that an admin and deleted the "admin" account, as recommended. My Nextcloud account (with all my data) never had an association with an external ID provider (like Cloudron).

After the update, I tried logging in - and got an error that some error had occurred, and try again. Next time I tried, "unknown username/password".

I used the console "occ user:list" command to discover: only the admin account exists now. My own user account is just gone.

Trying to "log in with Cloudron" just gives an error about OpenID:

First thing on my mind: can we not make updates that, without explicit warning and options, may lead to deleting user accounts? The update that I suspect broke everything, wasn't even a version update - it explcitly said it would make changes to accounts and login, but this seemed to be a necessary intermediate step that, I had hoped/imagined, wouldn't affect me (not using SSO).
Second thing on my mind: how the hell do I get my user account back and all its files/settings/functionality?

Woohoo! Yep, I set it up with the "generic" option. Almost immediately ran into an issue with the installer backgrounding a text-UI yes/no prompt that it never answered (so it hung), with the UI written into the log file hovering over the "no" box... but... after Ctrl+C'ing out of it and trying again, it worked.

Now I'm stuck trying to get cert set up. Let's Encrypt seems not to be responding... just hangs at "renewing certs" and visibly 1% on the progress bar forever. Hmm...

Trying to get started, as the promise of Cloudron is to provide self-hosting for cloud services (at least, as I was pitched ). Less than zero interest in using any cloud server provider.

The first thing required by the Setup script -- before you can even get the script to run -- is a "provider" option. However, there's no documentation W H A T S O E V E R for this option. I tried "--help" at first to see if it would explain the options, or even what the question is asking (is it asking for a music service provider? internet service provider? food service provider? ELABORATE on the question, please!).

I had no direction to what to pick or when to pick the "Generic" option. Didn't even know what that means, and I also didn't know what 9/10 of the available options were even referring to.

I know my domain is bought through Godaddy, so I was looking for the Godaddy DNS option there, as the docs dive head-first from "run this command line with options a/b/d/g/b/sb/sdf/generic and when it comes back, read on!", right into DNS options, so I thought it was referring to DNS.

Could you just take a few minutes and write a couple more lines in this page explaining what the heck the "provider" option refers to? https://cloudron.io/documentation/installation/