Cloudron Forum

@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 I think the issue with MySQL Workbench is I can't use the latest version as they don't support macOS 10.14 past a certain version, and a colleague on a later macOS can get it working on a later MySQL Workbench version but I can't update my OS at the moment until some other software I use is updated to work with the later OS. Classic catch-22 on that one. I think the solution to this should just be to use DBeaver, it's free on all platforms, and seems to work on all OS versions. too. Maybe better to save your time for the odd additional /phpmyadmin/ that might be useful on certain apps. Certainly appreciate the help and looking, but I don't want to distract you too much given it's a software version compatibility issue and not a Cloudron issue really. Thank you all the same though!!

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

By now the internal IP for mysql is hardcoded to 172.18.30.1 so this command is not required anymore: https://docs.cloudron.io/guides/connect-mysql/#internal-ip-address

@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: [image: 1542074780361-6c53a4c5-1f77-4795-9adb-ef616b499b96-image-resized.png]