The developers are responsive and intelligent. The community rallies behind one another even the non-developers cheering on the developers.

There's a new update at least every few weeks to Cloudron so it's clearly actively maintained and it's just a brilliant platform with exciting new features that the community actually gets to weigh in on. So, yeah, thanks everyone for putting up with my incessant posting and allowing me to be part of the future of the web (I really believe that's what the Cloudron concept is going to be).

It was @fbartels live coding video on Matterbridge that helped me understand Docker, and Cloudron's context within it. I searched high and low for everything I could because I hate watching video tutorials (I'm a reader). But I really got into the video and it successfully helped me create my first app. So, I just wanted to thank him in a public way because without his video, I may not have even joined the forums - and all of you guys are great! ️

Edit: Video link in the forum below. It inspired me to become a Cloudron developer enthusiast. You should check it outtttt!

I'm making this a separate request from WP Multisite Official Support because it actually would cover a lot of use cases way beyond Wordpress. Almost every control panel allows for aliases in this way, and would be very helpful for Cloudron to add this as a base feature in the Location tab of every app (choosing whether you want a domain to be treated as a redirection to the primary domain, or as an alias to the primary domain - to which the web app would handle the routing - and that is currently already built in to Wordpress' Multisite feature).

@marcusquinn I love being a developer user myself. Contributing to the code that I'm using to run my web apps (custom or otherwise) I find very fulfilling. I followed @mehdi's advice and submitted the contributors agreement so I hope to contribute to Cloudron in a meaningful way. ️

@nebulon That's absolutely amazing what the two of you have created. Like, seriously, this is fantastic. I haven't been this excited about development in a lonk time (if you couldn't tell from my over-zealousness in the forums, I forgot how much I enjoy development).

I think this thread is valuable for @girish and @nebulon - because there are people like us who are passionate about open-source and we all have different reasons why we want to develop for and maintain apps for Cloudron and though I don’t have any issue with “semi-open-source” - I know a lot of other developers that do. Which this discussion and girish's / nebulon's reaction to the entire thread of opinions - may be a way to attract new develoeprs: “Cloudron goes fully open source” kind of headline.

I will say tho - if Cloudron became closed source I would stop creating apps for it (and I have 5 apps I have in mind to continue to port already)...okay maybe, I'm 50 / 50 on that (I really like Cloudron ). But I couldn't have created the apps I have now without direct access to their very readable and commented source. Though, they’ve made it decently clear thats not what the developers want to do (close the source entirely).

So yeah, I want to continue to hear people’s passion about their open source software beliefs and how they feel about it in the Cloudron context.

I’d def like to be part of an online get-together. The forum is great, don’t get me wrong - but an intentional online get together I think would be incredibly beneficial to the community since we all seem to have a lot of passion for the platform.

I see some people have “app dev” labels on the forum. And I know my VPN Client isn’t on the store yet. But I wanted to ask that once girish and I figure that out - I wanted to ask if I’d get that cool label too? 🥺

This was a recently upvoted feature that was closed out but I see it as an important one for casual users. Customization of the UI by adding or removing the various links and elements is part of the “Branding” experience that was recently released. @andres-moya put it this way in Gitlab which I very much agreed with:

“ One of the useful features of Cloudron is to give users a single panel with all the apps they need in one place. But if we need to use some app that is not viable to be packed into Cloudron, this feature is lost.

But if we were able to add custom buttons to external apps, this would be great.”

@malvim That’s exactly how I feel about @nebulon and @girish. When I found out there was only two main developers, it blew my mind. I have so much respect for their company and the software their built / build - it’s probably why I’m so invested in making it the best it can be. I should cool it with the feature requests.

Cause they have enough on their plate, but despite that @nebulon has taken a lot of time out of his day to debate with me about a Cloudron procedure in another thread. It’s touching that he’s taken so much time to explain his perspective and consideration of my opinions.

@girish often goes out of his way to help me understand box code too. Like linking to individual lines in the git just to help me understand. Like what other creator of a huge project like this would do that for me? Answer: @girish is one of a kind!

My favorite thing about both of them though is sometimes, people will request something for box and they’ll have it done and committed in an hour for the next upgrade of Cloudron. I plan on packaging a lot more apps but this has been a fun and wild ride. Thanks to the @appdevs and @girish / @nebulon.

Note: I believe this will also allow me to host a main TLD at one Cloudron and all of it's subdomains at another. Which would be a further benefit to users.

@girish That would solve my problem completely actually. If it's not difficult? I mean, I can live with setting up each subdomain separately; this is just a QOL thing. But it would be nice to have a "wildcard" subdomain so I don't have "set up" each new subdomain, yeah.

@girish You can also simply add + update a local DNS query to "point to IP address of mySQL". Since that would only need to be local cause the desktop client is SSHed in already and can use a local dns query from there.

Since I can easily reproduce this I did a bunch of tests. Could never pinpoint it but after I updated to V6.3.4, I can't reproduce it at all. So, lucky release for me.

Okay, looks like if I open 20 backend "edit post" pages in new tabs at once I can kill SQL at will. But...how...and why. I understand it running out of memory, but...wait, what if it runs out of memory and doesn't realize it because of swap and so it doesn't kill itself.

Further hunting. There's a plugin called WP Time Capsule that provides a "staging" server to test things out before making them live. It just copies the WP DB and files to a folder at the root called "staging" and if "staging is currently activated" and then I I try to backup Cloudron, I get this Cloudron crashed/stopped.

But if I delete the staging folder and DB tables (you just hit delete in the plugin). Then Cloudron backs up fine.

Theories?

Oh, I forgot the Error reconnecting to the database This means that we lost contact with the database server at mysql:3306. This could mean your host’s database server is down. Are you sure the database server is running? Are you sure the database server is not under particularly heavy load? If you’re unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums error from Wordpress if you wait till timeout.

That's why it was so obvious that the SQL server was going down.

@nebulon said in How do you diagnose PHP-based SQL problems?:

@lonkle just to be on the same page, since this sounds far out with some plugin spawning a mysql process. The logs you have pasted earlier here, are those from the app or from the mysql service running in your Cloudron?

That is from the my SQL logs. I found out that's why the entire server would stop functioning for 5 minutes at a time - MySQL unexpectedly dies, retries, dies, retries, dies. I know it's gotta be a plugin. When you said it was spawning an SQL process somehow, I just ran with the idea since you're the expert but I realized that you just thought I was showing you app logs.

I'v watched the app logs even during one of the random MySQL deaths, and there's nothing on the logs except normal PHP stuff. I cleaned up all the notices and it still happens. I have ONE lead:

PHP Notice: Undefined offset: 1 in phar:///app/pkg/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php(1197) : eval()'d code on line 70

I don't use the WP-CLI, which means it can only be that the 1 minute cron job set up that sometimes runs into some huge task. Something is throwing an undefined offset in the Cron anyway. I'm hoping that's it. If I can find it.

I'll have to time the next time it happens and see if it aligns with a cron job.

I like managing my main TLD emails separately (externally) than my subdomains. With Cloudron right now I have to enter each subdomain as a "domain" to give them each different mail capabilities than the TLD.

@girish said in How do you diagnose PHP-based SQL problems?:

Could be getting killed because it's running out of memory. Maybe you can bump the increase the memory limit of mysql service?

That's happened to me before but Cloudron always reports it and I adjust memory. Cloudron is reporting no memory limitations. But just in case, I set it really high IF that is the problem occurring.