Cloudron Forum

Yep, as usual. It's user error. I was using the box config backup. I just had to adjust the backup path to point to the app. I figured out the correct path by logging into my Backblaze dashboard, browsed through the bucket (by date) and the file "name" is your path. Copy/paste into the import box along with the box settings and voila!

This was sorted out in support.

@joack said in Cloudron partial install but server seems active:

I tried installing it on my recently updated ubuntu20.04 desktop

As others warned, don't do this! It's not meant to be run this way. You can create a VM on your desktop and install it in the VM though.

The error itself is happening because you probably are using MySQL already and this is conflicting with Cloudron installation.

@jonslab did you find what it was?

@nebulon I restored the server from a backup, as it must be working at this time.
I don't have Vaultwarden installed. Only redmine and a couple of other applications.
I sent the ticket to support.

@cleveradmin OK, I reread your original post and understood now. You are offering your setup as a way to understand how to recover MySQL which is in some indeterminate state. In general, we don't attempt to recover databases unless it's super crucial. It's almost always just easy to recover from a backup and we also don't support setups with no backup.

(IMO, MySQL recovery is very complicated and kind of arcane. Fixing one issue leads to another and it can take days really. So, not worth the effort.)

@girish haha true, just wanted to throw that in there 😄

I have given these stable IPs now - https://git.cloudron.io/cloudron/box/-/commit/582994b9d646989b42e27dde1ae0c27bbb964834

@natzilla Ah ok, I think I will improve the docs to say how to exactly recover if mysql is not even running. The troubleshooting guide assumes mysql is running but corrupt.

@UDGC What happens when you hit "Restart"?

@harrowsmith can you run docker network inspect cloudron to see if the network it tries to bind on is actually created?

@necrevistonnezr I wasn't aware of the setting, good to know.

Also, see https://forum.cloudron.io/topic/3237/remote-sql-support-on-a-per-app-basis?_=1652377131316 on how one can connect with a SSH tunnel.

(please read warning in above comment before following instructions below).

If you want to make config file changes:

docker exec -ti mysql /bin/bash Edit /run/mysql/my.cnf as needed supervisorctl restart mysql

It is important to note that the changes to config files are not persistent across container restarts and server reboot. In general, we have not envisioned Cloudron as a development environment, but we do have many devs using it as such. So, if there is interest, maybe we need to improve things for such use cases.

@iamthefij Ok. Just restored matomo from backup again and it's all good.

I put some docs on how to fix the mysql addon here - https://docs.cloudron.io/troubleshooting/#mysql-addon . It's not "complete" but it's very hard to write those docs since there's a lot of things that can go wrong with mysql....

@vladimir-d DBeaver Database Dashboard? Or you thinking longer timeframe and more detail?

@jordanurbs thanks! I will look into making this automatic. https://git.cloudron.io/cloudron/box/-/issues/800

Ok, I will mark this as solved but let's investigate further if this comes up again.

FWIW, if you do docker exec -ti mysql /bin/bash then the details mysql logs are located at /tmp/mysqld.err .

@vladimir-d This is already fixed in the coming release - https://git.cloudron.io/cloudron/box/-/commit/6d044bfbf384b8ae98f1beac0f9d1c50005e8d34 . For now, you can ignore the warning, it's harmless.