Cloudron Forum

@girish Yes, I'm referring to the host MySQL. And I already followed the steps in that document, but even at innodb_force_recovery = 4, it will not start. Regarding backups, the last backup in /var/backups/snapshot is from last November.

And just to reiterate what I said in my post, this is purely educational. I've verified that the Baserow application's data has been copied elsewhere. So if it might be worth it to the community on a whole to dig into this, I'm happy to. But if you deem it a waste of time/resources, don't sweat it. Thanks.

I've run into an interesting issue here that I'm wondering if there may be value in troubleshooting. We have a Cloudron server that we used for Baserow. It's not a critical device, but I suspect it might have a few databases on it that I'd like to get access to. We did not have Cloudron setup to backup, but we did have a full image snapshot image that ran nightly on it (3rd party). Cloudron is running on a KVM VPS and this morning it was suspended due to non-payment (100% my error, forgot to update them with my new credit card). NBD, paid it and the server came back online. However, Cloudron was not starting properly and it appears to be MySQL related. So I set out to the MySQL recovery, but even with innodb_force_recovery = 4 it will not start (Performance schema tables initialization failed).

So I decided to restore to a local VM so I could at least get into Cloudron and see if the databases actually have data I care about (it's Baserow and we moved away to Nocodb, so I suspect it doesn't). The backup is from about 4 hours before the server was suspended, but I'm having the same issue. Now, this could make sense because it is a snapshot of a running system, I'm guessing the "damage" would be similar. Anyone interested in working through this? We can do a lot of messing around on the restored VM and then attempt a final run on the production. Let me know, thanks!

@nebulon I'm chatting with Rocket.Chat via their own server. They've asked me to provide docker setup & version and docker config. Is there a way to get this information from Cloudron?

@nebulon I don't disagree, but unfortunately, it doesn't help my current situation.

And just another note on this. I can't even work around this by setting the business hours in UTC because it doesn't allow going past midnight. So if I set a start time of 2PM and an end time of 2AM, it doesn't work at all.

@girish A user can't set the timezone, it pulls from the server. So the reason I came across this is setting business hours so that when we embed the live chat-functionality on our website, it doesn't show after business hours. I don't believe there is a way to show the set timezone. We just know it's not setting the timezone correctly because our live chat shows offline even though it's within the set business hours.

@girish As it turns out, this didn’t work. It still acts like it’s UTC.

@girish That worked, thank you!

How would I go about setting the timezone for the Rocket.Chat app? Anything I searched for suggested php.ini, but RC is via docker. I'm guessing the env file, but I'm not exactly sure how this should be formatted. RC doesn't have the ability to edit the timezone from within the app and uses the server timezone. Thanks.