Cloudron Forum

We developed an app that does resources (CPU, disk, RAM) monitoring for Cloudron. Cloudron currently does a wonderful job for quite many things, but it was a couple of times when I was finding that the disk is overflown, or my server is running out of RAM, after the apps stopped responding.

I understand you can always setup Zabbix, etc, but those systems are quite complicated to setup and I wanted to keep the spirit of 'simply works' of Cloudron.

So, we created a software called nomon. The original name's meaning is 'no-monitor' - as a follow for (now falling) trend of 'no-code' things, 'no cloud' (as it requires no cloud services) and to reflect it's simplicity - as it's not that much a monitor - just a simple service that makes it best to inform on the resources shortage.

With this said, we would like it to be added to the Cloudron AppStore, ideally keeping the source code at GitHub, as we got a few automations, including building and pushing to GitHub Docker registry there.

@girish , @nebulon , could you possibly let us know on the next steps?

@girish @nebulon , just wanted to add my voice to ARM (RPi) support.

More and more hostings appears with RPi with a very attractive pricing (8Gb RAM, 4CPU Cores * 2Ghz, 30Gb network HDD) for ~$15/month.

It would be also very handy for a private in-office use, for a more private use cases.

Hello! Is there any way for CloudRon to have unattended install - so that I launch the installation script, specify the file with all of the options and enjoy installation to be up and running in X minutes with all of the configuration and apps installed?

I wonder if it's even practical to expect this to be integrated into Cloudron, as it feels a bit conflicting...

@benborges I'm not an expert, but I would be completely satisfied with a generic webhooks that cloudron will trigger and I can then proceed them as required, for example, using n8n

@luckow thanks for digging this out - I just realized I have vaultwarden broken since the latest update, which is happened at 24th of Dec for me.

Here is the short instructions and extract based on @luckow findings:

On Web GUI:

• go the app
• click terminal

Now on the terminal:

echo ${CLOUDRON_MYSQL_DATABASE} # note the output - it's 35629ca3ac8992ec in my case
mysql --user=${CLOUDRON_MYSQL_USERNAME} --password=${CLOUDRON_MYSQL_PASSWORD} --host=${CLOUDRON_MYSQL_HOST} ${CLOUDRON_MYSQL_DATABASE}

Now starts making database voddoo - make sure you have database backup first.

SELECT * FROM information_schema.SCHEMATA WHERE schema_name = "35629ca3ac8992ec";
SELECT CONCAT('ALTER TABLE `', TABLE_NAME,'` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;')   
    AS CharSetConvert
    FROM INFORMATION_SCHEMA.TABLES
    WHERE TABLE_SCHEMA="35629ca3ac8992ec"
    AND TABLE_TYPE="BASE TABLE";
ALTER DATABASE `35629ca3ac8992ec` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
SET foreign_key_checks = 0;
/* execute all queries from CharSetConvert output earlier here */
ALTER TABLE `__diesel_schema_migrations` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `attachments` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `ciphers` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `ciphers_collections` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `collections` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `collections_groups` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `devices` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `emergency_access` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `event` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `favorites` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `folders` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `folders_ciphers` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `groups` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `groups_users` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `invitations` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `org_policies` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `organizations` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `sends` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `twofactor` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `twofactor_incomplete` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `users` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `users_collections` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
ALTER TABLE `users_organizations` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
SET foreign_key_checks = 1; /* verify CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci is on the place */

Now restart the app (via big button at the top of the terminal).

@girish , guess Vaultwarden 1.27.0 is a braking change and/or the patch before updating is required (as per above).

Today my Cloudron instance crashed during the automatic upgrade process - it's the first time in like 3 years, but it's pretty much enough for me to disable automatic platform upgrades anywhere until you can make it atomic (for example using snap or other Ubuntu Core or any other ways), just like you did for the apps.

But I can see that you have one switch for both - apps and the platform.

Could you please, separate that configuration?

Considering last upgrade issues in 7.5 and my specific issue, where the whole configuration is lost, I would like to ask you to make it as a priority, if possible.

I've noticed that branding is not complete - Cloudron name is at least displayed at authorization page and 500 error pages.

Is there any chance that Cloudron will be replaced with 'Cloudron Name' from Branding, please?

I believe I assembled a first version, but got stuck with OpenID auth on Cloudron side: https://forum.cloudron.io/topic/13648/openid-uri-configuration-issue-for-synapse-s-mas

I would appreciate any help here - it would be beneficial for the work to be done by @vladimir.d or whoever would be solving the same task.

@nebulon it would be lovely to see those credentials, for example, on the system settings or service settings somewhere - could be hidden by default, unveiled only after the click on some button, like 'show me the password'

As a follow up for a previously discussed feature request - I would like to have an option to automatically reboot the server at the updates time window.

At the meantime, I guess a simple shell script at cron will do the trick:

if test -f /var/run/reboot-required; then
    shutdown -r now
fi

If that looks right, there is one more thing that I would like to add to the script (and automated reboot procedure as well) - it's e-mail notification that the server is going to be rebooted and, ideally, that it came back on-line - could you please, assist me with simple command line, that will work inside of the server and send e-mail to the admin using configured e-mail?

Thanks in advance?

@joseph got it, thanks. Would it be possible to remove 'Cloudron' from the mails templates in all languages then, as a part of white-label-ization in progress, please?

To enable completely self hosted Mattermost experience, this service (https://developers.mattermost.com/contribute/mobile/push-notifications/service/ ) is a must.

It’s rarely updated and have ready to use Docker image on Dockerhub.

It doesn’t include mobile part, which has to be handled automatically, but pretty much well documented.

I would like to see OpenFire (easy to use and administer XMPP server) on Cloudron.

I've prepared a private image - what is required to push it to your AppStore?

@robi removed them from my trustworthy since they managed to keep MacOS AppStore version, advertised on the landing, out of date for half of the year, after it was reported as an issue on GitHub.

To be more precise, it was a cherry on the cake, the cake was an enormous amount of bugs I've encountered during the usage and for me, that is a sign of malfunctioning engineering culture - you can't fix it anytime soon...

Agh, an important thing - the notifications are delivered to the messenger / service or your choice, including Mattermost, Zulip (not at Cloudron, hopefully only for now), Slack, Telegram or any generic webhook, using shoutrrr library.

All of configuration is just in a single yml file - file example to follow:

cpu_alert_threshold: 50 #percentage
ram_alert_threshold: 50 #percentage
disk_alert_threshold: 50 #percentage
check_every: 30  # time between alert checks in seconds
port: 8000
old_data_cleanup: 4  # when database cleans up: 0-23
log_level: 5  # https://github.com/sirupsen/logrus
urls: [ 'mattermost://username@host:port/token/channel' ]  # url examples: https://containrrr.dev/shoutrrr/0.7/

fixed by removing IPv6 IP address from Hetzner completely and cleaning up old AAA entries from DNS - they seems like confused Outlook servers.

I found a service, that converts Telegram to RSS: https://docs.rsshub.app/en/

Once installed, you add to your RSS reader https://rsshub.app/telegram/channel/$channel_name

And you are good to go.

A reaaaaly nice way to leave messenger to message and keep things under my control (meaning the service won't disappear with all of my subscriptions list).

@fbartels agh... I didn't intend to, but it happened to be a mystery release / announcement
Thanks for the demystification!

and nc -vv u12121212.your-storagebox.de 23 from the server - does not

@BrutalBirdie , as stupid as it could be - I might get trapped with Hetzner's fail2ban - thanks for pointing that out.