Install Cirro manually on a Ubuntu 14x (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 Ubuntu server

In these steps, you’ll set the firewall, the hostname, download the Java Development Kit 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
Open SSH port ufw allow 22
Open Cirro Web Interface port ufw allow 443
Open JDBC port ufw allow 1527
Open SQL Server direct port ufw allow 3306
Open MySQL direct port ufw allow 1433
Open Oracle port ufw allow 1521
Open Postgres port ufw allow 5432
Enable ufw ufw enable
Test the ports. ufw status

Set hostname

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

cat /etc/hostname

cirroserver

When complete, your hostname will change to root@cirroserver

Now alter the hosts file.

Description Command Example Values
Edit hosts file vi /etc/hosts  
Add this line   127.0.0.1 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
 
Restart the server reboot  
Check the hostname ping -c 5 cirroserver  
Restart the network so the changes persist on restart /etc/init.d/networking 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.

ifconfig

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.