Request: Map the internal SQL IP address to something like my.sql.domain.tld

[Lonkle]

Thinking about it, maybe @girish might have an answer for me. He taught me the tunneling technique that it appears all SQL Clients have that I just never knew about - last fall: https://forum.cloudron.io/post/13959

So maybe, Girish, do you have a solution that doesn't involve me manually changing the IP address of the "Internal MySQL Host" in my Remote SQL client every time mysql gets a new IP address (often)?

[girish]

Good request. The only way I can think of is to give static IPs to all the addon containers. This is entirely doable and we haven't had a reason to hard code IPs so far. I will let this sit a bit to understand the implications of hardcoding the IPs.

[marcusquinn]

from here - save me swearing at DBeaver periodically.

[Lonkle]

@girish You can also simply add + update a local DNS query to "point to IP address of mySQL". Since that would only need to be local cause the desktop client is SSHed in already and can use a local dns query from there.

[robi]

@girish said in Request: Map the internal SQL IP address to something like my.sql.domain.tld:

Good request. The only way I can think of is to give static IPs to all the addon containers. This is entirely doable and we haven't had a reason to hard code IPs so far. I will let this sit a bit to understand the implications of hardcoding the IPs.

Perhaps hardcoding isn't necessary, but simply using an internal DNS mapping, internal resolver for known service containers like you have in docker

OR

If you do hardcode it, use xip.io as explained here
https://forum.cloudron.io/topic/3574/xip-io-access-any-dev-app-via-internal-ip-using-a-magic-domain

Alternatively, see here:
https://sslip.io/

which includes a noteworthy mention of LocalTLS

[girish]

Not 100% sure but I don't think the DNS resolution will work from inside the SSH tunnel. For example, you cannot add an entry in /etc/hosts (on Cloudron server) and don't think the connection will pick that up.

[robi]

@girish Any tunnel uses the DNS resolution of the source host connection, hence Mac or Windows hosts file.

[Lonkle]

Any further knowledge gained in the past couple years on the ability to make this happen?

[girish]

@Lonkle The internal IP addresses are now hardcoded in 7.4 - https://docs.cloudron.io/networking/#internal-network for exactly this reason.

[marcusquinn]

@Lonkle He's alive! Where you been for 2 years?