Optimal Method for Using a Terminal with Seamless SSH Connection

Connection Structure SSH Client → Agent CLI → ARiSA Proxy Server → Target Server

Component Overview

Usage Example

With Seamless SSH Connection, server developers can continue using familiar techniques even in an environment with access control solutions.

For example, suppose you need to apply a specific configuration to test servers numbered 1 through 10. Manually entering SSH commands and executing them one by one on each server would be inefficient. Instead, you can use the following method to execute the same command across multiple servers simultaneously.

Executing Commands on Multiple Servers Using iTerm2

In iTerm2, you can split the terminal into multiple panes and execute commands simultaneously across them:

• Press Cmd + D to split the window vertically.
• Press Cmd + Shift + D to split the window horizontally.
• Press Option + Cmd + I to enable synchronized input, allowing you to type the same command in all panes at once.

This feature helps streamline command execution across multiple servers with minimal input, significantly improving efficiency.

With QueryPie’s Seamless SSH Connection feature, you can continue using these existing methods without any changes in usability.

Writing Scripts for Multiple Server Connections

If you are not using iTerm2 as your terminal or prefer scripting for automation, you can write a script to connect to multiple servers and execute commands efficiently. This approach is particularly useful when managing multiple servers simultaneously in a more programmatic way.

#!/bin/bash
# List of target servers
SERVERS=("test1.querypie.io" "test2.querypie.io" "test3.querypie.io" "test4.querypie.io")
# User account
USER="ryan"
# Commands to execute on each server
COMMANDS=(
  "echo 'TMOUT=300' >> ~/.bashrc"
  "source ~/.bashrc"
)
# Connect to each server and execute commands
for SERVER in "${SERVERS[@]}"; do
  echo "Connecting to ${SERVER}..."
  ssh "${USER}@${SERVER}" <<EOF
    $(printf "%s\n" "${COMMANDS[@]}")
EOF
  if [ $? -eq 0 ]; then
    echo "Commands executed successfully on ${SERVER}"
  else
    echo "Failed to execute commands on ${SERVER}"
  fi
done

This script connects to test servers 1 through 4 and modifies the timeout settings. Since the script executes the commands automatically on all servers, there is no need to open an interactive shell for each server, making the process much more efficient.

Connecting to Multiple Servers Simultaneously Using tmux

You can also use tmux-cssh, an open-source tool, to connect to multiple servers at the same time. With this tool, you can run the following command to establish simultaneous SSH sessions:

tmux-cssh -ns -ss
'ssh -oProxyCommand='\''qpa ssh %r %h %p'\''
-oStrictHostKeyChecking=no -oUserKnownHostsFile=/dev/null'
-u admin test{001..01}.querypie.io

Conclusion

Implementing an access control solution is a crucial step in strengthening an organization's security, but it should not come at the cost of user experience. Traditional GUI-based access control solutions have enhanced security but often hindered the productivity of developers and system administrators who rely on CLI-based workflows.

QueryPie’s Seamless SSH Connection achieves both security and usability. It ensures secure access control while allowing users to continue utilizing their familiar SSH workflows and tools—such as iTerm2 multi-pane sessions, automation scripts, and tmux—without disruption. The ability to maintain existing workflows with just a simple configuration change offers significant productivity benefits for the entire organization.

By striking the right balance between security and usability, QueryPie provides a seamless, efficient working environment, ensuring that access control solutions do not interfere with users' daily operations.