Righ now we're connecting via SSH to the host used for reverse tunneling using the same user as fivetran user used for replicating data. Also all our envs are connecting using the exact same user account and SSH keys.
This is not ideal state. We'd like to have:
- separate user from each environment (we replicate data from many of them) and we'd like to use separate users for each environment. To remove stale sessions occupying port we could use:
and handle all the restarts properly.
Fivetran should use completely separate user to replicate data. All ports are available via localhost and I do not see any reason for not separating them.
It'd be nice to have possiblity to create those separate users on those host from the web dashboard and assign to those users:
- ssh keys
- multiple IP addresses that particular users can connect from (those addresses should be added to the authorized_keys file)