Yes we will soon release a new Cloudron version which will bring MySQL 8.4 with it.

@jakomo-freshi I have added it here - https://git.cloudron.io/packages/matomo-app/-/merge_requests/26

Same issue here, looks like the latest update activates a new plugin, but does not run its db migration automatically. The fix is to run console core:update a second time.

thanks, does this help reduce i/o in a meaningful way? I guess we should continue back in the other thread.

Ah ok, I am not a PHP developer, not sure what libraries for php there are to connect to a mysql instance via an SSH tunnel, maybe someone with more PHP knowledge has some recommendations?

OK, as a hint for others: I found out, that some tables had different database collations. Thats why some migrations didn't work. Its most likely due to the fact, we imported an existing Matomo instance into cloudron: https://forum.cloudron.io/topic/10759/migrating-matomo/2?_=1762191084826 With help of AI we fixed thos database errors pretty quick now. Annotations work again. Also another plugin in Matomo, which complained about missing tables.

Cloudron package always ensure the platform related configs on app restart. This is required to know a consistent state for updates. In your case if you need to tweak those, then you may have to fork the package repo and customize the app for such needs. Overall Cloudron is not built for horizontal scaling and maybe for millions of daily users, it is likely not the best option. We try to strike some balance here, but solving too much in one would make life hard for other use-cases.

I retried this morning to be able to get the logs and at my surprise, that worked?! lol. Well, not sure why the other day it didn't want to install but now it seem to work. So all good. Thanks

I think unless the package is modified heavily, it's not going to work .

Yes they are on the same server BTW. Great information, we will give it a try. Thank you so much. I am bookmarking this!

Indeex /app/code/misc is a read-only location. I guess we can make this one file a symlink and maybe that will work with the updater. I just tried to reproduce this abut at least I can't make it trigger an update. I have added https://download.db-ip.com/free/dbip-city-lite-2024-10.mmdb.gz and saved that form but thats it? Also given that the URL contains the actual year and month I am kinda curious how refetching this will update to a newer version, does anyone know?

@luckow thanks for reporting. I have made js a runtimeDirs now. Should be fixed in latest package.

@girish I found this answer: Tracking 1 million page views per month or less One server can be sufficient to host both the database and app server App server minimum recommended configuration: 4 CPU, 8 GB RAM, 250GB SSD disk.

@jfrere this got recently fixed - https://github.com/ip2location/ip2location-piwik/issues/91#event-11698953657

Also https://matomo.org/faq/troubleshooting/faq_25610/

@girish since I recently had another issue as well, I was just thinking that maybe all this is related to the fact that I initially migrated from an older Piwik installation. With that, I mean that after I installed the Cloudron app about 2 years ago, I imported existing data from that older Piwik installation. This might explain why I'm faced with those issues during upgrades while others aren't

Great, thanks for sharing your solution!

@girish, fair enough. I definitely understand your reasoning, but on the other side there is probably a good reason why the issue was added to the Matomo FAQ

This is a FABULOUS found, it makes every website/domain on Cloudron having it’s own analytics domain and it works flawless!!