Skip to content

Linux

Requirements

  • Due to certain dependencies, if installing on a 64-bit operating system (OS), the target system will require >=512 MB of RAM.
  • Python 3.6 - 3.8 (Comes default with Debian 10, Ubuntu 18.04 - 20.04, Centos 7 - 8, RedHat 7 - 8. All others distros/versions will need to install the correct version beforehand)

Debian

If using Debian 10 then an acceptable version of Python will already be installed. Otherwise, you will need to install a Python version between 3.6 - 3.8 before proceeding.

Our installation script automatically installs SlashDB with support for SQLite, MySQL 8, PostgreSQL as well as MS SQL Server and IBM DB2 databases. Oracle requires a few additional but simple steps - see instructions below. It's recommended to install the package in a separate system because there are a number of system-wide dependencies like NGINX, Memcached, and database clients that are installed.

1. Change to root
sudo su
2. Install MySQL APT repository and SlashDB.

Debian requires adding the MySQL Client Library which is not available in the standard Debian repository. The MySQL APT repository has to be added instead.

apt-get update
apt-get install -y wget software-properties-common
wget https://dev.mysql.com/get/mysql-apt-config_0.8.15-1_all.deb
apt-get install -y ./mysql-apt-config_0.8.15-1_all.deb
apt-get update 

Or follow the instructions at https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en to install MySQL repository and then

3. Download and install the latest DEB package.
wget -c https://downloads.slashdb.com/versions/1.5.0/slashdb_1.5.0_amd64.deb
apt-get install -y ./slashdb_1.5.0_amd64.deb
4. Once installation is complete SlashDB should be accessible at http://your-ip-address

Use command hostname -I to find what is your IP address.

5. To finish setup see:

Ubuntu

If using Ubuntu 18.04 - 20.04 then an acceptable version of Python will already be installed. Otherwise, you will need to install a Python version between 3.6 - 3.8 before proceeding.

Our installation script automatically installs SlashDB with support for SQLite, MySQL 8, PostgreSQL as well as MS SQL Server and IBM DB2 databases. Oracle requires a few additional but simple steps - see instructions below. It's recommended to install the package in a separate system because there are a number of system-wide dependencies like NGINX, Memcached, and database clients that are installed.

1. Change to root
sudo su
2. Download the latest SlashDB DEB package, update repository and install package.
wget -c https://downloads.slashdb.com/versions/1.5.0/slashdb_1.5.0_amd64.deb
add-apt-repository universe
apt-get update
apt-get -y install ./slashdb_1.5.0_amd64.deb
3. Once installation is complete SlashDB should be accessible at http://your-ip-address.

Use command hostname -I to find what is your IP address.

4. To finish setup see: Logging in for the first time.

Oracle for Ubuntu or Debian

Go to https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html and download Oracle instant client basic and sqlplus version 19.5 RPMs.

In the folder you should have the files:

  • oracle-instantclient19.5-basic-19.5.0.0.0-1.x86_64.rpm
  • oracle-instantclient19.5-sqlplus-19.5.0.0.0-1.x86_64.rpm

Change to root

sudo su

Then covert *.rpm to *.deb packages using alien

apt-get update
apt-get install alien
alien -v oracle-instantclient19.5-*.rpm

When done your folder will contain new files:

  • oracle-instantclient19.5-basic_19.5.0.0.0-2_amd64.deb
  • oracle-instantclient19.5-sqlplus_19.5.0.0.0-2_amd64.deb

Install Oracle DEB packages and setup system environment

apt-get install -y ./oracle*.deb

echo "/usr/lib/oracle/19.5/client64/lib/" >> /etc/ld.so.conf.d/oracle.conf
ldconfig

echo 'export ORACLE_HOME=/usr/lib/oracle/19.5/client64' >> /etc/profile.d/oracle.sh
echo 'export PATH=$PATH:$ORACLE_HOME/bin' >> /etc/profile.d/oracle.sh
echo 'export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH' >> /etc/profile.d/oracle.sh
echo 'export NLS_LANG=American_America.UTF8' >> /etc/profile.d/oracle.sh
echo 'export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"' >> /etc/profile.d/oracle.sh

. /etc/profile.d/oracle.sh

Add DBAPI

/opt/slashdb/bin/pip install cx-Oracle==7.3

Finally, restart SlashDB service

service slashdb restart

All done. SlashDB should be able to connect with Oracle databases.

CentOS

If using CentOS 7 - 8 then an acceptable version of Python will already be installed. Otherwise, you will need to install a Python version between 3.6 - 3.8 before proceeding.

This installation provides SlashDB with support for SQLite, MySQL 8, PostgreSQL, MS SQL Server and IBM DB2 out of the box. Oracle requires a few additional but simple steps - see instructions below.

1. Change to root
sudo su
2. Add EPEL and MySQL repositories
yum install -y epel-release
3. Download and install SlashDB package
yum install -y https://downloads.slashdb.com/versions/1.5.0/slashdb-1.5.0.x86_64.rpm
4. Once installation is complete SlashDB should be accessible at http://your-ip-address.

Use command ifconfig to find what your IP address is.

6. To finish setup see:

RedHat 7

If using RedHat 7 - 8 then an acceptable version of Python will already be installed. Otherwise, you will need to install a Python version between 3.6 - 3.8 before proceeding.

This installation provides SlashDB with support for SQLite, MySQL 8, PostgreSQL, MS SQL Server and IBM DB2 out of the box. Oracle requires a few additional but simple steps - see instructions below.

1. Change to root
sudo su
2. Add EPEL and MySQL repositories
yum install -y https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
yum install -y https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
3. Download and install SlashDB package
yum install -y https://downloads.slashdb.com/versions/1.5.0/slashdb-1.5.0.x86_64.rpm
4. Once installation is complete SlashDB should be accessible at http://your-ip-address.

Use command ifconfig to find what your IP address is.

6. To finish setup see:

RedHat 8

Before Installing - Requirements

This installation provides SlashDB with support for SQLite, MySQL 8, PostgreSQL, MS SQL Server and IBM DB2 out of the box. Oracle requires a few additional but simple steps - see instructions below.

1. Change to root
sudo su
2. Add EPEL and MySQL repositories
dnf install -y https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm
dnf install -y https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm'
3. Download and install SlashDB package
dnf install -y https://downloads.slashdb.com/versions/1.5.0/slashdb-1.5.0.x86_64.rpm
4. Once installation is complete SlashDB should be accessible at http://your-ip-address.

Use command ifconfig to find what your IP address is.

6. To finish setup see:

Oracle for RedHat or CentOS

Before Installing - Requirements

Go to https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html and download Oracle instant client basic and version 19.5 of the sqlplus RPMs, then install them.

Change to root

sudo su

Install system dependencies

yum install -y libnsl

Install RPM files for oracle

rpm -ivh oracle-instantclient19.5-basic-19.5.0.0.0-1.x86_64.rpm
rpm -ivh oracle-instantclient19.5-sqlplus-19.5.0.0.0-1.x86_64.rpm

Setup system environment

echo "/usr/lib/oracle/19.5/client64/lib/" >> /etc/ld.so.conf.d/oracle.conf
ldconfig

echo 'export ORACLE_HOME=/usr/lib/oracle/19.5/client64' >> /etc/profile.d/oracle.sh
echo 'export PATH=$PATH:$ORACLE_HOME/bin' >> /etc/profile.d/oracle.sh
echo 'export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH' >> /etc/profile.d/oracle.sh
echo 'export NLS_LANG=American_America.UTF8' >> /etc/profile.d/oracle.sh
echo 'export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"' >> /etc/profile.d/oracle.sh

. /etc/profile.d/oracle.sh

Add DBAPI

/opt/slashdb/bin/pip install cx-Oracle==7.3

Finally, restart the SlashDB service.

service slashdb restart

All done. SlashDB should be able to connect with Oracle databases.