Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • 1 Votes
    21 Posts
    338 Views
    girishG

    This was sorted out in support.

  • 1 Votes
    4 Posts
    159 Views
    girishG

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

  • CPU stuck and using all cores at 100%

    Solved Support
    5
    1 Votes
    5 Posts
    171 Views
    girishG

    @jonslab did you find what it was?

  • 2 Votes
    22 Posts
    755 Views
    N

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

  • 1 Votes
    4 Posts
    149 Views
    girishG

    @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.)

  • 0 Votes
    6 Posts
    105 Views
    M

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

  • 0 Votes
    19 Posts
    587 Views
    girishG

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

  • 0 Votes
    5 Posts
    173 Views
    girishG

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

  • MySQL failing to start

    Moved Unsolved Support
    2
    0 Votes
    2 Posts
    66 Views
    RazielKanosR

    @UDGC What happens when you hit "Restart"?

  • Cloudron is offline. Reconnecting...

    Solved Support
    6
    0 Votes
    6 Posts
    247 Views
    nebulonN

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

  • 0 Votes
    6 Posts
    662 Views
    girishG

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

  • 0 Votes
    3 Posts
    364 Views
    girishG

    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.

  • mysql slow query log

    Solved Support
    9
    0 Votes
    9 Posts
    516 Views
    girishG

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

  • MySQL server down

    Solved Support
    6
    1 Votes
    6 Posts
    295 Views
    iamthefijI

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

  • MySQL Unresponsive!

    Solved Support
    8
    0 Votes
    8 Posts
    373 Views
    girishG

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

  • 0 Votes
    2 Posts
    256 Views
    marcusquinnM

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

  • 0 Votes
    5 Posts
    257 Views
    girishG

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

  • How do you diagnose PHP-based SQL problems?

    Solved Support
    13
    0 Votes
    13 Posts
    637 Views
    girishG

    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 .

  • mysql logs

    Solved Support
    5
    0 Votes
    5 Posts
    459 Views
    girishG

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

  • 0 Votes
    24 Posts
    990 Views
    d19dotcaD

    @girish I think that might be an improvement worth considering, no? Making the necessary changes would (I think)...

    Make it clear to monitoring tools and manual checks by users which processes being run are local to the host and which are from containers, particularly useful when multiple instances of a service are being run both on the host and container.

    Follow what appears to be "best practices" when running containers.

    Improve security in certain situations.

    Admittedly these may be minor and not worth the overhead, but now that I'm aware of the behaviour, I'm a bit irked by it as it currently prevents me from easily identifying which services are container-run and which are local to the host, as well as making it confusing to which user is actually running the process listed.