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!!

@SamGreenwood on which page/section is this? All the pages of matomo?

@girish thanks! Can you share what stats you use, and how similar or different they are from the stats NodeBB has by default?

@d19dotca said in Hosting this is insanely expensive: Umami Yeah, I've never really used any analytics that much, but I really like Umami because it just so simple and easy, does the basics really nicely, and displays the information clearly.

Seems the latest release fixed the issue, I presume because they modified the plugin code for the LDAP access to Matomo. Can mark this as Solved I think.