@nj This happens when the initial db install task runs out of memory. I have seen this often in our tests as well. The fix is simply to reinstall.

@subven Thank you! I had not seen those docs 😯

It turned out that the Docker image of Mattermost used PostgreSQL, whereas on Cloudron if I'm not mistaken MySQL is used.

I tried converting migrating the PostgreSQL database to MySQL but it was a bit of a headache, so I have gone down the conventional route of using Mattermost's bulk export/import.

@girish said in Connect to lamp app mysql db from outside with db client like tableplus/navicat over ssh tunnel:

@andirahmat Try this - https://forum.cloudron.io/topic/3237/remote-sql-support-on-a-per-app-basis/2 . I haven't used tableplus/navcat but if you can post a screenshot maybe it helps debugging further. I think instead of mysql you just need to put in the IP of the mysql container using docker inspect mysql | grep IPAddress

ah this is it : docker inspect mysql | grep IPAddress

Thank you @girish !

I will mark this as solved for now but I suspect this will come back some day.

@fbartels said in MySQL tuning with my.cnf settings optimisation:

@lonk said in MySQL tuning with my.cnf settings optimisation:

when do we run / apply it?

Mysql tuning is best applied after a few days of database usage. Applications usually have different load patterns.

Gotcha, thanks for the tip! ☺️

@girish Just bookmarked your reply since I know I'll need it for other apps in the future. You have no idea how grateful I am. ☺️

ok. I gave mysql more RAM. Since then the backups have been running smoothly.

I have added a clear section in the guide - https://cloudron.io/documentation/guides/import-mysql/#import

@woke If you don't mind, I would like to debug further if possible and fix up the docs as needed. Can you enable SSH support and send a mail to support@cloudron.io with the IP address? Thanks

@girish Thanks for the answer, but I didn't mean the internal server. I would like to install MySQL or another standalone server. I would like to try some things. Try and Error 🙂 I have three instances of Cloudron and I would like to install my own applications and if I can understand all things and requirements ... I do not know what can happen ....

First I have successfull ended a course on udemy.com for Docker.

This is possible but will increase complexity in deploys and maintenance. I have also noticed that MySQL changes things between patch releases a lot. Maybe because their release numbers don't follow semver .

@Trankery Yup, I will mark this as a feature request for a future release.

@girish said in mysql password ?:

The server only listens on localhost

I tried as root on the ubuntu (not inside a container)
this time it work, it must be the fault of cornavirus 🦇

There is no easy way to make the internal mysql server public without changing the code and I don't know what that will break.

I think you can setup a ssh tunnel between your minecraft server and the Cloudron.

Something like https://www.linode.com/docs/databases/mysql/create-an-ssh-tunnel-for-mysql-remote-access/

Do this on Cloudron:

docker inspect mysql | grep IPAddress "IPAddress": "172.18.0.4",

So, 172.18.0.4 is the IP of mysql server. Then, you can get the db credentials using the web terminal of the LAMP app:

env | grep CLOUDRON_MYSQL_

You can then connect using the above credentials as:

mysql --host=172.18.0.4 --user=<username> --password=<password> <db>

After the above works, you just setup SSH tunnel accordingly.

@girish In trying to host an app in the LAMP stack (Specifically GNU Social) and the installation fails due to this still being in use.

When can this be applied to cloudron? I believe this will fix many apps not able to be hosted otherwise.

I tried this quickly now and it seems to work here atleast out of the box:

0_1542074779961_6c53a4c5-1f77-4795-9adb-ef616b499b96-image.png