@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.
@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:
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).
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?
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?
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).
@girish what about just a normal organization level rights separation?
I mean - it's really two different set of roles:
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...
@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
@mehdi my thoughts / use case exactly.
Doing so with ipchains is a pain (thanks Docker's intervention to firewall); and ufw just doesn't handle all of the use cases (thanks Docker again).
@benborges for an urgent notifications - yes, absolutely.
I personally prefer Telegram notifications, that are just converted mails.
@girish I guess I've been limited to install some app, because the minimum requirements for the RAM was not met.
If that logic is still in place, probably, it would be nice to have some kind of 'I understand what I'm doing' checkbox to work this around?
@girish thank you! One more reason to love Cloudron 
Granular notifications would be nice though 
@girish it's really required, as well as an option to choose a delivery method for those notifications - e-mail / push / etc.
@nebulon does Cloudron e-mail service offer e-mails filtering option?
The reason I'm asking, is because ideally I would also like to fine tune my settings, enabling some settings (like update notifications, that I'm not getting) and getting some others on my other e-mail.
@girish I see, thank you.
Would it be correct to say, that Cloudron won't let me to install the apps if my overall RAM size is not enough or those settings really doesn't affect that much?
@nebulon burst would be ideal, but I guess we are limited by a Docker Swarm architecture...
On the minimal - I have 512Mb on resources intensive Ghost, but vaultwarden and invoiceninja are 1gb... that feels like not quite consistent? Or am I missing something?
