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?

@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).

@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

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.

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.

@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?

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?

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

@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/

Hi, I setup a system, created a local admin account with User Manager role in it (https://docs.cloudron.io/user-management/#user-manager), but he has no access to create mailboxes for the user - is there any way to enable that feature, without giving Admin permissions?

And just in case, as it's not quite clear in official documentation: e-mail mailboxes are backed up and will be restored in case of the disaster recovery, is that a correct assumption?

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!

@girish what about just a normal organization level rights separation?
I mean - it's really two different set of roles:

• 1st line support, dealing with mailboxes
• 2nd or 3rd, making sure the system and services are up and running.

I don't need hiding anything, I just want to ensure my users can manage they mailboxes and users for they own.

For now I have to temporary give admin permissions to the 1st line and that's kind of risky...

@BENOIT, merci bien, indeed!

@marcusquinn full-scale for me means threads, calls, rich formatting, notifications management. Guess it's everything that most people found confusing, indeed.

It seems like out experience matches: Rocket.Chat - extremely buggy; Element - specs are not complete, not yet ready for mass production use as team management; Mattermost - looks just right, but quite slow in some of the features and unpredictable with the prices (they managed to change the pricing overnight with no trace of that anywhere at all; twice).

Shall we go back to IRC or XMPP based chats?

@humptydumpty thank you, but my server is already monitored - both from inside (with the monitoring agent) and from the outside (via http ping), so my only task now, it’s to ensure I can drop an e-mail notification to myself, so that if my monitoring shows that the server is not available, I can see an e-mail next to the monitoring saying, that the server was going to reboot itself, which will help me to understand and fix that in no time, instead of guessing what could went wrong.