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've packaged an OpenVPN Client for Cloudron that can:

• Change VPN Servers on-demand using a full PHP / Apache based backend
• Connect to other Cloudron apps for all of their traffic (except for incoming traffic to the web app itself) to go through the VPN Server's container (which will allow for some cool intranet webapp stuff I'm sure)
• It mandates the use of LDAP so it has a log in system and only administrators are allowed to change the server the OpenVPN Client app is connected to.

So basically a VPN Client that accepts any .ovpn or .conf file to allow for connection to a new server that a different Cloudron app would be using.

I'll update this with the Github for the project. I haven't pushed it since it was finalized.

@girish You said you wanted to discuss if there needs box code changes. I outlined the 15 lines of codes that need to change to make the app work. I also have not written a dropdown box for the Cloudron Dashboard's App Settings page to "Choose which OpenVPN Client app to route your traffic through?" since I just got the hotfix tool working. Having the OVPN Client app choose the other app to connect to is possible in-app if you'd prefer to put it in there. But I'll need to make a few adjustments with the token access to make that happen seamlessly. But I do see a case for allowing users to know they're connected to an OpenVPN Client on the dashboard, just my two cents. So, the dashboard stuff is optional and up to you. But the slight box changes are unavoidable and outlined in your DMs on this forum from me. ️

Oh, POLL TIME:
• How many of you would actually want to connect more than one other app to the OpenVPN Client Cloudron app a time. It's possible (with caveats right now), but if there is demand, I'll think more of a solution to make the amount of apps able to connect to it more than 1 at a time (with no caveats which I may need to pick @appdev's brains' for help on that one).

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.”

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.