If you are working from a corporate proxy and need to bypass it, this article will guide you through setting up an SSH tunnel using PuTTY. We will also cover how to configure your local environment to connect to your remote database server.

Bypassing HTTP Proxy Server

When working behind a corporate proxy server, accessing external resources can be challenging. To overcome this limitation, we need to create an SSH tunnel that forwards traffic from our local machine to the remote server. This allows us to access the remote server as if we were directly connected to it.

Configuring PuTTY for SSH Tunnel

To set up an SSH tunnel using PuTTY, follow these steps:

1. Launch PuTTY and enter the host name or IP address of your remote server.

2. Select 'SSH' as the connection protocol and click 'Open'.

3. In the PuTTY configuration window, go to 'Connection' > 'Tunnels' and select 'Auto' under 'Local ports accept connections from anywhere'.

4. Enter a port number that is not already in use (e.g., 443) and enter the remote server's IP address and port number (e.g., XX.XX.XX.XX:443).

5. Click 'Add' to add the tunnel configuration.

Updating Hosts File

To ensure that our local machine can connect to the remote server, we need to update the hosts file on our system. This will allow us to access the remote server using its IP address instead of its host name.

1. Open a terminal or command prompt and navigate to the directory where you want to create the hosts file.

2. Create a new file called 'hosts' with your favorite text editor (e.g., vi, nano).

3. Add an entry to the file that maps the remote server's IP address to its host name (e.g., 127.0.0.1 XX.XX.XX.XX).

Setting Up MariaDB

Now that we have set up our SSH tunnel and updated the hosts file, we can connect to our remote database server using MariaDB.

1. Install MariaDB on your local machine if you haven't already.

2. Start MariaDB by running the command 'mysql' in your terminal or command prompt.

3. Log in to MariaDB using the credentials provided by Uberspace (username and password).

In this article, we have covered how to set up an SSH tunnel using PuTTY and configure our local environment to connect to a remote database server. We also touched on how to update the hosts file to ensure that our local machine can access the remote server. With these steps, you should be able to bypass your corporate proxy server and connect to your remote database server using MariaDB.

Ssh tunnel putty couchdb