Install Cirro manually on a Ubuntu 14x (or above) server.

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).

Installation 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, 30GB at least for query history retention.

Network

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

Before You Start

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  

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

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 file.

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
Copy the files. cd /cirro_dem
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.