Connecting via SSH Tunnel

Brewit supports SSH tunneling for the following data sources if they are hosted on a private network:

Getting Started with SSH Tunnels

You can configure SSH tunneling when creating a new data source or update the configuration of an existing resource.

Select the Enable SSH tunnel checkbox in the Advanced Options section.

Select or create a new tunnel

If you have an existing tunnel, select it from the dropdown. Otherwise, go to tunnels page create a new tunnel.

Enter the Bastion host and Bastion port with which Brewit connects, then download Brewit’s public key.

Add public key to your host

Create a user account for Brewit. Below is a sample script run for different environments.

ec2-user@bastion:~$ sudo adduser brewit --password NP

To authorize Brewit to connect to the host, add the public keys from step two on a new line in /home/brewit/.ssh/authorized_keys.

# Login as root
sudo su

# Create the authorized_keys file if it does not exist yet
mkdir -p /home/brewit/.ssh
touch /home/brewit/.ssh/authorized_keys

# Use your favorite editor to add Brewit's public key to the file
vim /home/brewit/.ssh/authorized_keys

# Set permissions on the authorized_keys file
chmod 644 /home/brewit/.ssh/authorized_keys

# Change owner of authorized_keys file to Brewit
chown brewit:brewit /home/brewit/.ssh/authorized_keys

Test database connection

Once that has been successfully configured, you can now test the connection to your database.

If you have any issues with the SSH tunnel, please contact mark@brewit.ai for support.

CSV Chat

Get Started

Integrations

Data Agent

Visualization

Workspace

Others

Connecting via SSH Tunnel

Getting Started with SSH Tunnels

​Getting Started with SSH Tunnels

Getting Started with SSH Tunnels