Cloudron Forum

This actually seems like an app internal error. Maybe it cannot deal with some characters in your path? The big error notification you are seeing comes from the app crashing on that request, delivering the error page from the reverse proxy.

The crash seems to come from https://github.com/advplyr/audiobookshelf/blob/930bacd45d232b44a967c0744c9cfb82dcc592f4/server/managers/CoverManager.js#L129 so maybe that code cannot deal with that path? Can you ask upstream about this and or try to add a library on a path without spaces and "special" characters?

yes, the snapshot folder is the folder where the backup is initially made and then from there it is rotated. In your case it was also part of the previous config.

I'd be very interested to hear what you think about running it on the LAMP stack.

Yes, @murgero is right, it should install fairly easily into a LAMP stack

What modes do you operate? Any interest in DMR? 73s de EI8FDB/M5FDB

Currently, I'm only a beginner, got my licence using a handheld so 20m and 70cm.
But my home is in a bad position for a handheld, so I am trying to install some donated kit, proper aerial etc. Sadly the project is delayed by other stuff, but I would like to get it going.
I'm not a "prepper" but I do believe amateur radio is going to be valuable in future.
DMR is interesting but I am not there yet.

I don't think there is any backup option out there which can do what you are hoping can be done. The one exception is if you are manually extracting the data to be restored, and putting them in different locations. I just say this so you don't go feeling like this is some sort of weakness of Cloudron. Backups rely on timestamps and exact conditions. You couldn't restore the second backup because it would look for the time slot from which it was built, in the records, and those records aren't going to be in the currently restored backup. But if it is the media you want, then the fact you do have separate sets of backups does mean you can at least navigate through the backup and find that media, and then as @nebulon said, manually add them back to your Mastodon. But I gotta say, why do you need to have this media? I mean, Mastodon IS social media, and it's meant to be ephemeral. If there is some info you like, then screenshot it, or click the link and bookmark it, print it out to PDF, or follow the poster (to then check them out post-restore to see that specific post) etc. But saving it and keeping it to be viewable only within your Mastodon seems like a use even Mastodon wasn't really meant for.

Anyway, good to hear you are back up and running. Hope the new year remains happier. I'm @shane@social.futurnumerique.com if you want to expand your follow/followers!

@girish perhaps include printing memory usage as part of the stats in the logs

@nebulon That seemed to fix it. Thanks! 👍

ok. a quick try.

Download https://www.kaggle.com/datasets/justin2028/total-emissions-per-country-2000-2020 Install LAMP (important: give more RAM) import CSV into openrefine export sql from openrefine
0e0699da-938b-4096-9fb4-3f4d9bbd02c7-image.png import sql export into lamp via phpmyadmin
fd1ff46c-5bb3-4cfb-a82e-b4124d356097-image.png fire up the filemanager in lamp and look for credentials.txt
b2b2ff22-f824-4c6f-866e-a76c6e2ce58a-image.png install superset or metabase. in my case adding the mysql credentials into superset
5b95644f-5c44-4977-9dd7-ac7366b387e1-image.png a click on connect brings
1917edfd-dc57-40ee-b762-6ef1d7685cc1-image.png et voilà
ec702395-b5b2-4166-9e9e-9d4fae5e7457-image.png

Without being a pro in mysql, this worked for me

7b177fcb-2227-4219-89ab-ae503e43d6f3-image.png

@ei8fdb said in Delete volume name, mount point (in UI) when no longer in use?:

reference to volume name and mount point in Volumes section still present

Can you post a screenshot of this? Are you referring to the Volumes view i.e the view where you add/remove volumes ? FWIW, what you said in Expected behaviour section is what is supposed to happen. I checked quickly and it does happen that way but not clear what you mean by Volumes section still present.

@ei8fdb said in Cannot load certificate key .../_.sub.domain.org.key failed - No such file or directory:

_.sub.domain.org.key

One of the nginx config files is referencing this key. You can delete the config file and the key/cert file. You can find out which file is referencing it by grep'ing inside /etc/nginx/applications . Once deleted, you can systemctl restart nginx

@jdaviescoates Yes, cron not working is a symptom of docker not working (stuck in configuring)

@ei8fdb Apparently, this was limited in time and seems to not be accessible anymore. Too bad.
Thanks for sharing.

@ei8fdb

I delete the dump file, then decide to backup from that's date - restore will fail?

No, a copy a the postgresql file is in the backup. The file at /home/yellowtent/platformdata/<appid>/postgresqldump is a temporary file. When we want to backup an app, we create a dump from postgresql and save it to that file. Then we upload that file to wherever the backup is located . After the backup is done, that file has no real use but we just keep it around because in some rare cases where you don't have backups it can help in recovery.

So, to summarize:

Safe to delete /home/yellowtent/appsdata/app-container-id/postgresqldump . But this will be created as part of the backup process, so it's going to be a pain. You have to delete this file everyday. Your final backup location will have a copy of the above file. Under <timestamp>/appid/postgresqldump . This is your backup, don't delete this file!

@ericdrgn said in Jitsi self-hosting behind NAT hair-pinning:

@ei8fdb did you get it working? I have had that port open since installation (I also self host) but mine has no audio or video either. Similar problem I have to audio calls through matrix... It all works fine on the same network but not if devices are on different networks and as far as I can tell the logs show everything working fine.

Hi @ericdrgn I was waiting to have the time to test this morning.

I have tested just now:

server (8GB memory & 30% CPU dedicated) on home internet IP clientA (laptop, browser) on external WiFi network clientB (mobile android device, jitsi client) on mobile network

I did have video, and audio from both clients.

If you try some calls and grep for the messages I got? You can see them in the paste link.

Lemme know if you want any more information/help.

There's this guide - https://docs.cloudron.io/guides/upgrade-ubuntu-20/ in case you haven't seen it already. Main gotcha is that the mysql server sometimes upgrades and sometimes doesn't. In the end, we want MySQL server 8. Sometimes, it asks you whether you want to remove mysql data. Be sure not to remove it!

@jdaviescoates said in Recommendations for document signing applications:

Nextcloud recently added this:

By the looks of it this is only an integration of a third party service into the Nextcloud ui.

The app uses eID Easy as its signing back-end. eID Easy handles the signing process. Refer to eID Easy's pricing to see the cost of each signing method.

@nebulon said in Support "standard" Cloudron login screen with LDAP creds?:

the need for upstream LDAP support.

Yup, understood. Just to let you know, LDAP has already been requested.

@nebulon said in Support "standard" Cloudron first-time usage?:

I guess it still makes sense to explain that one needs to signup and that the first user becomes admin.

Exactly. I mention it as (from memory) there was another app that required the user to register an account with an email address.

Obviously it's not a high priority - I mentioned it for consistency.

@ei8fdb yes, I can take a direct look at it, I guess I would need remote SSH support for both Cloudrons then. If you want to do that, send us a mail at support@cloudron.io with the two dashboard domains you are using.

@nebulon said in Install a docker container on a LAMP app:

I think the easiest production-ready app package with go is https://git.cloudron.io/cloudron/simple-torrent-app maybe you can check that as reference.

Thanks @nebulon I'll take a look at it. Packaging is still something I'm not fully sure about.