Cloudron Forum

Hi there,
migration of bookstack worked pretty quick for me, however this time its not synced with SSO, as we use this for documentation together with clients.

Therefore we add clients with as users to the app directly.

1. creating temporary domain for bookstack in cloudron,
2. checking that versions are in sync in old and cloudron instance,
3. copying bookstack /upload folder to the new instance (contains images in books etc.)
4. exporting database and importing it into cloudron as per: https://docs.cloudron.io/guides/import-mysql/
5. tested it, working fine
6. moving it to the final destination location.

Done.

Hi there,
short description, how I managed the migration of an existing Matomo instance to cloudron. It was a bit more tough, than migrating Yourls (https://forum.cloudron.io/topic/10737/migrating-yourls/10).

I didn't use any app specific migration, as I didn't want to kill any cloudron specific configurations.

These were the steps:

1. Making sure, Old Matomo had the same release level as the one in Cloudron.
2. Setting up Matomo on an intermediate domain in cloudron.
3. Merging Matomo config.ini.php manually - as it consists of data related to the application system setup, but also about our custom settings in Matomo. Also merging the plugin settings.
4. Moving Plugins folder to Cloudron.
5. Exporting old Matomo database, but leave out "user*" tables (we want to use the cloudron SSO login anyway) - but then also leave out "access" table (I forgot about this and had initially some trouble with collations and not working user management in Matomo).
6. Importing Matomo Export as described in https://docs.cloudron.io/guides/import-mysql/ (except we didn't drop any tables in Cloudron Matomo before). We only dropped tables we imported.

This should be the straight way to do it. With less trouble than I experienced

So far everything seems to work.

Ok, finally success. It was a lot more difficult, as our Mautic instance is more than 6 years old, started with Mautic version 2.x.x and had a lot of migrations in between.

Therefore biggest issues were the transfer of the database, which was MariaDB before and is MySQL now in cloudron.

I setup the user management with cloudron.

These were the steps:

1. Making sure, Old Mautic had the same release level as the one in Cloudron.
2. Setting up Mautic on an intermediate domain in cloudron.
3. Make sure, you leave mail settings to the app (see https://forum.cloudron.io/post/80364) if you plan to send via a different mail service provider. Those settings get overwritten with each restart, if you leave default mail settings to be managed by cloudron.
4. Merging Mautic config/local.php manually - as it consists of data related to the application system setup, but also about our custom settings in Mautic. Have a copy at hand from the original cloudron setup. Important - certain paths, like for cache, are links in cloudron, which will be added automatically at start of Mautic App. You can remove tmp and cache entries for the Mautic config.
5. Copying media, themes and custom plugins folders from old to new instance.
6. Try to do some maintenance with your database, e.g. run mautic:maintenance:cleanup, for my old database, I also removed page_hits, which were not linked to leads. Tried to get the database as small as possible. I also had some old collations for tables, like utf8 instead of utf8mb4, which is needed for some major tables, like leads, companies etc.
7. Exporting old Mautic database, if its MariaDB, make sure you export it with phpMyAdmin with compatibility settings activated (I used MySQL4 for the export).
8. Import mautic database into as described in https://docs.cloudron.io/guides/import-mysql/ - you can also drop tables from the existing cloudron Mautic database before, the relevant settings for user management are in the merged config file.
9. Clear cache for Mautic.
10. If you want to use single sign on, you probably need to delete those imported users from Mautic and let cloudron do its magic, when users logon the first time after migration with their cloudron user name.
11. Check all your settings - open leads, companies etc., have a look if everything is there.
12. Move the app to its new (old) location.
13. Test your mail settings (I needed to set them again, they got lost in the process, although added in the config file).
14. Increase your PHP Memory limit, if you have enough resources. Edit the php.ini in your cloudron folder and add this line (adjust as you like):

memory_limit = "2G";

That should be it. Also look into the discussion about cronjobs (https://forum.cloudron.io/topic/10255/adjust-cron-jobs-for-mautic-is-it-possible/11) to stay updated.

So far everything seems to work fine. Except I miss Alias Domains for now.

Hi there,
I have certain usernames in my catchall domain that are 100% spam. I'm trying to filter them out using a custom SpamAssassin rule:

DELETE MISSLEADING CODE

However, those emails are still getting through. Also, it seems the score isn't being adjusted when I check the headers. Any ideas?

UPDATE:
Wrong approach. No custom rule needed. Just a regular one rule is needed. Adding to addresses into the "Custom Spamassassin rule" will do it.

Nothing more - Spamassassin will add 10 points to the score.

The initial code was an over engineered approach bei KI

Node RED is not just about home automation. We use it regularly to integrate several Cloud Services.

For Hetzner... it looks like the PTR setting for an IPv6 is not checking if its correctly set. You will need to add the last piece - in my case "::1" - to the PTR record - even if Hetzner also accepts "::" only. I guessed this will cover the whole range - but I was wrong.

@micmc never ever upgrade from within the app
Especially not when you are using the managed version here in Cloudron.

Hi there @girish ...
Version 5.0.2 with bug fixes is supposed to be released today.

Those are helpful documents:

• https://github.com/mautic/mautic/blob/5.x/UPGRADE-5.0.md
• https://www.mautic.org/blog/community/mautic-5-beyond-expectations-beyond-limits

As I'm still pretty new to cloudron, how will you handle upgrades? I'm happy to jump in and to beta testing with migration of an existing Mautic Instance to version 5, if that helps.

@girish no that won't work, as the installation needs the central composer.json and also update it. It also loads more directories into the vendor directory, which is read-only in Cloudron. Did you come to some conclusion with your experiments?

Looks to me like the Mautic plugin concept doesn't work well with the Cloudron way of things.

Potential Scenarios:

1. Plugins should be installed with composer, a lot of directories and the central composer.json would need to be writable... not good.
2. Cloudron Mautic image would have some basic required plugins preinstalled, how to decide which? For me it would be (AWS)Mail, Custom Objects, Multi Domain plugins. Probably it would need to be different mailers. But this would increase maintenance, as plugins may have urgent updates outside of release cycles of Mautic.
3. Cloudron set up like WordPress (Dev) - like a preinstall but without continuous updates of core (because that would kill customizations). A little improvement, as the initial installation is fine and working (at least causing 50% of Mautic beginners trouble otherwise).
4. Cloudron self maintained on LAMP stack. Almost all the benefits of Cloudron lost.

Which other options did I miss?

Hi there,
the community of Mautic users is having a "Community Sprint" in Berlin in June.
If you are interested to join - find out more about the agenda and participants here:
https://mautic.org/blog/join-us-in-berlin-help-build-the-future-of-mautic/

I will be there as well on the first day

Hi @timconsidine
thanks a lot for providing Excalidraw as a community package. Do you have any plans to add a way to store draws on the server?

Thanks!

I only found third party providers that add their own layer to excalidraw, as the open source community edition probably doesn't have it. I didn't yet investigate if that layer is open sourced too. Will let you know what I find.

For me 4.40.1 works - thanks!

I have a subdomain, which - by mistake - linked to an old ip. Later it indexed a lot of wrong pages, not related to our domain.

I now want to remove it from google index and issue an error 410 for each calls to this subdomain. What would be the easiest way? Setting up a LAMP stack?

Or can this be done simpler?

Hi,
is there a way we can easily setup a cloudron instance for a client, run it for a while and then hand it over to a clients own license? Like an agency model?

No I directly used models without router. After a manual restart of OpenWebUI (it was automatically updated), the problem was gone. No issue anymore.

Hi there,
as we are using some apps with partners and some only internally - can I force access control to not automatically default to "all users of this cloudron instance"?

... how about mounting an additional file space (temporarily) to your server? Then moving apps there for the time updating. Depending on your provider, they might be offering file space.

OK - with admin user no problem.

Debugged further:

• user is operator via group membership - login fails
• user is operator via selected users - login works.

That might be the reason?

Yep, I think so too