Skip to Content
InstallationInstallationInstallation Guide - setup.v2.sh

Installation Guide - setup.v2.sh

Introduction

This installation guide explains how to install QueryPie server on a single server computer in a simple configuration. Even with a simple configuration installation, you can test most QueryPie features.

The setup.v2.sh installation program introduced in this guide automatically performs the existing installation process. The automated installation process is largely the same as the existing installation process. For the existing installation process, please refer to this document: Installation Guide - Simple Configuration

This installation method is not suitable for use in actual production environments. For installation methods suitable for actual production environments, please refer to the separately provided [QueryPie Installation Guide].

This is an installation guide for PoC purposes targeting QueryPie 10.3.0 or later versions.

Prerequisites

Before proceeding with installation, you must prepare the following. In summary, they are as follows.

  • 1 Linux server
  • 1 PC with a web browser installed

For details, please refer to the following document: Prerequisites

System Architecture

Please refer to the following document: System Architecture and Network Access Control

Installation Process

Running setup.v2.sh

Download and run the setup.v2.sh script from the shell of the Linux server where you will install QueryPie. You can see the commands that setup.sh actually performs during the execution process.

$ # Download setup.v2.sh and execute it.
$ bash <(curl -s https://dl.querypie.com/setup.v2.sh)

You can also save setup.v2.sh as a file and then run it as follows.

$ curl -s https://dl.querypie.com/setup.v2.sh -o setup.v2.sh
$ bash setup.v2.sh

setup.v2.sh automatically selects and installs the version recommended by the manufacturer. For available versions, please refer to this document: Product Versions

If you want to install a specific version, you can use the following commands.

$ bash setup.v2.sh --install 10.3.4
$ bash setup.v2.sh --upgrade 11.0.1
$ bash setup.v2.sh --help
#### setup.v2.sh - QueryPie Installer 25.08.8, /usr/bin/bash 4.4.20(1)-release on Linux x86_64 ####
setup.v2.sh 25.08.8, the QueryPie installation script.
Usage: setup.v2.sh [options]
    or setup.v2.sh [options] --install <version>
    or setup.v2.sh [options] --install-container-engine
    or setup.v2.sh [options] --install-compose-package <version>
    or setup.v2.sh [options] --upgrade <version>
    or setup.v2.sh [options] --uninstall
    or setup.v2.sh [options] --help
 
FOR AWS AMI BUILD MAINTAINER:
    or setup.v2.sh [options] --install-partially-for-ami <version>
    or setup.v2.sh [options] --resume
    or setup.v2.sh [options] --verify-installation
    or setup.v2.sh [options] --verify-not-installed
    or setup.v2.sh [options] --populate-env <env-file>
    or setup.v2.sh [options] --reset-credential <env-file>
 
ENVIRONMENT VARIABLES:
 
  DOCKER_REGISTRY                Default: 'docker.io/querypie/'
    The Docker registry to pull images from.
    You may specify a private registry such as 'myregistry.example.com/querypie/'.
    Note that the trailing slash is required, if you set this variable.
    Actual image names will be like 'myregistry.example.com/querypie/querypie:11.1.1'.
 
OPTIONS:
  --yes               Assume "yes" to all prompts and run non-interactively.
  -V, --version       Show the version of this script.
  -x, --xtrace        Print commands and their arguments as they are executed.
  -h, --help          Show this help message.
$

Installing QueryPie in Podman Environment

Starting from setup.v2.sh version 25.08.8, it supports execution environments with Podman + Docker Compose combination.

The following Linux distributions recommend execution environments with Podman + Docker Compose combination.

  • Red Hat Enterprise Linux 8, 9, 10
  • Rocky 8, 9

For detailed installation methods, please refer to this document: Configuring Rootless Mode with Podman

Tasks Automatically Performed by setup.v2.sh

setup.v2.sh automatically proceeds with the following main installation procedures.

  1. Download configuration files for Compose such as docker-compose.yml and .env
    • The name of the environment variable configuration file compose-env has been changed to .env. compose-env is used as a template for creating configuration files.
  2. Set environment variable values in .env
  3. Download docker images
    • Downloads images from the docker.io/querypie/ registry. Therefore, Harbor login process is not required.
  4. Run mysql and redis containers
  5. Run querypie-tools container and perform migration
  6. Run querypie-app container
  7. Create a symbolic link ./querypie/current pointing to the currently running version.

After setup.v2.sh successfully starts the querypie-app container, you will see the following execution success notification message.

+ docker exec querypie-app-1 readyz
########################################################################
#                                                                      #
#     ██████╗ ██╗   ██╗███████╗██████╗ ██╗   ██╗██████╗ ██╗███████╗    #
#    ██╔═══██╗██║   ██║██╔════╝██╔══██╗╚██╗ ██╔╝██╔══██╗██║██╔════╝    #
#    ██║   ██║██║   ██║█████╗  ██████╔╝ ╚████╔╝ ██████╔╝██║█████╗      #
#    ██║▄▄ ██║██║   ██║██╔══╝  ██╔══██╗  ╚██╔╝  ██╔═══╝ ██║██╔══╝      #
#    ╚██████╔╝╚██████╔╝███████╗██║  ██║   ██║   ██║     ██║███████╗    #
#     ╚══▀▀═╝  ╚═════╝ ╚══════╝╚═╝  ╚═╝   ╚═╝   ╚═╝     ╚═╝╚══════╝    #
#                                                                      #
########################################################################
.--------------------------------------------------------.
|  🚀 QueryPie Server has been successfully started! 🚀  |
|  Timestamp in UTC: Mon Jul 28 17:04:31 UTC 2025        |
|  Timestamp in KST: Tue Jul 29 02:04:31 KST 2025        |
'--------------------------------------------------------'
+ popd
~
## Create a symbolic link 'current' pointing to 11.0.1
+ pushd ./querypie/
~/querypie ~
+ rm -f current
+ ln -s 11.0.1 current
+ popd
~
### Installation completed successfully
### Access QueryPie at http://172.31.11.201:8000 or https://172.31.11.201:8443 in your browser
### Determine the public IP address of your host machine if needed
[ec2-user@ip-172-31-11-201 ~]$

Installation Complete

Great job. Now you can see QueryPie in action.

Please try accessing the URL like http://172.31.11.201:8000 shown at the end of setup.v2.sh execution. This address uses the IP Address to connect from Local PC to Linux Server. You may need to change Firewall, AWS Security Group settings, etc. by referring to network connection configuration: System Architecture and Network Access Control

Entering License

License files can be entered on the web console screen.

Enter the license in PEM format.

Enter the license in PEM format.

Basic Configuration Procedures

After installation is complete, you need to proceed with initial configuration according to your operating environment. For detailed configuration procedures, please refer to the following document: Post Installation Setup

Last updated on
Installation Guide - Simple ConfigurationComparison of setup.sh and setup.v2.sh