SSH into App Directly with External Tool (No Browser Terminal)

[applecrusher]

My goal is to SSH directly into my app so that I could use that as a tunnel into the MYSQL database instance (Wordpress). The browser ssh terminal is not sufficient and does not allow for this. I tried running the following command to connect:

ssh karl@wordpress.myappdomain.com with the same password I use for the cloudron portal, but I get access denied.

I also tried adding an app password in the App Passwords section in the profile. But that seems to be for SFTP. What are the steps to remote access a cloudron app with SSH? I could not find much on this topic and feel I am missing something obvious. Thank you.

[girish]

@applecrusher the app databases are purely "internal" and not easily accessible from outside. This is done for security reasons.

With the CLI tool, you can do cloudron exec to get a shell and also execute mysql commands directly - https://docs.cloudron.io/packaging/cli/#execute-a-command . Not sure if that helps with your use case.

[girish]

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.