Install Cirro manually on a Centos 7.0x (or above) server.

Server Requirements

Your server needs to meet these minimum requirements to install Cirro.

Hardware

Each server must include:

  • Minimum: 2 Core CPU, 4GB
  • Recommended: 4 Core CPU, 8 GB (Additional 4 GB per 10,000 queries per hour)
  • Hard Drive: 5 GB for installer, additional space for query history retention.

Network

  • Outgoing traffic - Whitelist all Database IP addresses.
  • Network - enable the network so the system can download packages.

Overview

Once you’ve setup an appropriate server, you’ll need to get a Cirro account and setup a License plan. Then download the license and the server installer. Connect to your server and perform the installation. And last, complete post-installation tasks, reset the root password and setup the SMTP server.

Additionally, you can download and install SCP and SSH applications on the source computer such as WinSCP and Putty on Windows.

Get a Cirro account and license

Start by creating a Cirro account and license plan.

Then download the license and installer.

  • Click Account at the top right of your account.

  • Download the License file.

  • Download the server installer.

Setup Centos server

In these steps, you’ll set the firewall, the hostname, download Java Develoment Kit (JDK) and copy files to the server.

Connect to machine and login

If you haven’t already done so, connect to your server machine using your SSH application.

You’ll perform all these commands as root.

sudo su -

Set Firewall

Set the firewall to accept connections for the Cirro server and databases.

Description Command
Enable and start firewalld. systemctl enable firewalld
systemctl start firewalld
Open SSH port firewall-cmd –permanent –add-port=22/tcp
Open Cirro Web Interface port firewall-cmd –permanent –add-port=443/tcp
Open JDBC port firewall-cmd –permanent –add-port=1527/tcp
Open SQL Server direct port firewall-cmd –permanent –add-port=3306/tcp
Open MySQL direct port firewall-cmd –permanent –add-port=1433/tcp
Open Oracle port firewall-cmd –permanent –add-port=1521/tcp
Open Postgres port firewall-cmd –permanent –add-port=5432/tcp
Restart firewall. systemctl restart firewalld
Test the ports. firewall-cmd –list-ports

Set hostname

Next, set a hostname on the server to ensure IP address changes won’t affect Cirro.

Description Command Example Values
Edit hostname vi /etc/sysconfig/network  
Modify the HOSTNAME= value   HOSTNAME=cirroserver.domain.com
Quit Vi with these keyboard buttons. ESC
:
x
ENTER
 
Edit hosts file vi /etc/hosts  
Modify this line 123.45.67.89 hostname.domain.com hostname 127.0.0.1 cirroserver.domain.com cirroserver
Add for IPv6 capable hosts ::1 ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts
 
Quit Vi with these keyboard buttons. ESC
:
x
ENTER
 
Run the hostname command. hostnamectl set-hostname hostname.domain.com hostnamectl set-hostname cirroserver.domain.com
Check hostname. hostname cirroserver.domain.com
Restart networking. /etc/init.d/network restart  

Download Java Development Kit

You’ll need to download the correct JDK for your Cirro installation. This is a two step process.

  • First, open the JDK page in your browser.

  • Second, download JDK 8u114 or greater

    • Agree to the license agreement.

    • Choose Linux x64 to download.

SCP/Curl/Wget the files to the server

If using a third party SCP application, get the server IP address.

ip addr

Example output:

Copy the files to the /tmp folder.

  • license.txt

  • cirro_install_ent.tgz

  • jdk-8unnn-linux-x64.tar.gz - where nnn is the version (e.g., 8u201)

Install Cirro

Reconnect to the server as root, then create cirro directories, copy required files and run the install script.

Create directories and copy files

Create two new folders, extract the cirro installer, then copy license and JDK files.

Description Command
Create Cirro directories cd /
mkdir /opt/cirro
mkdir /cirro_dem
Extract the installation files. This example assumes the files are in the /tmp folder. tar xzvf /tmp/cirro_install_ent.tgz
Confirm the filenames so you know they're in the correct place, and get the JDK filename. You'll substitute the correct filename in the next step. cd /tmp
ls
Copy the files. cd /cirro_dem
cp /tmp/jdk-8unnn-linux-x64.tar.gz .
cp /tmp/license.txt .

Install Cirro Server

You’ll now run the Cirro installation script. You can modify the passwords as required, but make sure the hostname matches what you set earlier.

cd /cirro_dem

./cirro_install_dem.sh --install --dir /opt/cirro --password Cirro2019 --postgresrootpassword ChangeThisPassword --install-rdbms-service --set-hostname cirroserver

Accept the license agreement when it’s displayed.

You’ll see this message if the installation was successful.

Installation completed successfully. Web console available at https://cirroserver

Troubleshooting

Check out the Installation FAQ if you get into trouble.

Login to Cirro and disable Cirro Root user

For security reasons we recommend creating your own Cirro Super-user accounts.