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.9 (Comes default with Debian 9 - 11, 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.9 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.

Due to an MySQL issue before getting the latest package a new GPG Key has to be also installed.

cd /tmp
apt-get update
apt-get install -y wget software-properties-common gnupg
wget https://dev.mysql.com/get/mysql-apt-config_0.8.22-1_all.deb
DEBIAN_FRONTEND=noninteractive dpkg -i ./mysql-apt-config_0.8.22-1_all.deb  

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.

apt-get update
wget -c https://downloads.slashdb.com/versions/1.6.0/slashdb_1.6.0_amd64.deb
apt-get install -y ./slashdb_1.6.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.9 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.6.0/slashdb_1.6.0_amd64.deb
add-apt-repository universe
apt-get update
apt-get -y install ./slashdb_1.6.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-instantclient-basic-21.6.0.0.0-1.x86_64.rpm
  • oracle-instantclient-sqlplus-21.6.0.0.0-1.x86_64.rpm

1. Change to root

sudo su

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

apt-get update
apt-get install alien
alien -v oracle-instantclient-*.rpm

When done your folder will contain new files:

  • oracle-instantclient-basic_21.6.0.0.0-2_amd64.deb
  • oracle-instantclient-sqlplus_21.6.0.0.0-2_amd64.deb

3. Install Oracle DEB packages and setup system environment

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

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

echo 'export ORACLE_HOME=/usr/lib/oracle/21/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

If your Oracle server runs inside a docker container and is version 19 or above, you will need to disable the Out Of Band breaks feature. To do that add this line to sqlnet.ora

echo "DISABLE_OOB=ON" >> ~/.sqlnet.ora

4. Add DBAPI

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

5. Finally, restart SlashDB service

systemctl restart slashdb

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

CentOS 7

If using CentOS 7 then an acceptable version of Python will already be installed. Otherwise, you will need to install a Python version between 3.6 - 3.9 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. Enable additional required repositories

yum install -y epel-release

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
yum install -y https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
# disable all mysql repositories
sed -i 's/enabled=1/enabled=0/' /etc/yum.repos.d/mysql-community.repo
# enable only mysql80-community 
yum-config-manager --enable mysql80-community

3. Download and install SlashDB package

yum install -y https://downloads.slashdb.com/versions/1.6.0/slashdb-1.6.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:

CentOS 8

If using CentOS 8 then an acceptable version of Python will already be installed. Otherwise, you will need to install a Python version between 3.6 - 3.9 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. Use vault repository due to CentOS reaching End-Of-Life

This is optional step. In case you run into problem that yum cannot find repositories e.g.

[root@f8844059eb4e /]# yum repolist
Failed to set locale, defaulting to C.UTF-8
CentOS-8 - AppStream                                        113  B/s |  38  B     00:00    
Failed to download metadata for repo 'AppStream'
Error: Failed to download metadata for repo 'AppStream'

then update mirror list URLs with below commands:

sed -i -e "s|mirrorlist=|#mirrorlist=|g" /etc/yum.repos.d/CentOS-*
sed -i -e "s|#baseurl=http://mirror.centos.org|baseurl=http://vault.centos.org|g" /etc/yum.repos.d/CentOS-*

after that change yum should be able to fetch metadata of repositroes

[root@c3a011ee9566 /]# yum repolist
Failed to set locale, defaulting to C.UTF-8
Last metadata expiration check: 0:01:46 ago on Mon Aug  8 09:44:37 2022.
repo id                     repo name                               status
AppStream                   CentOS-8 - AppStream                    5596
BaseOS                      CentOS-8 - Base                         1896
extras                      CentOS-8 - Extras                         38

3. Enable additional required repositories

yum install -y epel-release
sed -i 's/enabled=0/enabled=1/' /etc/yum.repos.d/CentOS-*PowerTools.repo

4. Download and install SlashDB package

yum install -y https://downloads.slashdb.com/versions/1.6.0/slashdb-1.6.0.x86_64.rpm

5. 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 then an acceptable version of Python will already be installed. Otherwise, you will need to install a Python version between 3.6 - 3.9 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. Enable required repositories

Add Red Hat repositories

subscription-manager repos \
  --enable rhel-7-server-optional-rpms \
  --enable rhel-server-rhscl-7-rpms \
  --enable rhel-7-server-devtools-rpms

Add EPEL repository

yum install -y https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm

Add MySQL 8 Community repository. Due to a MySQL issue a new GPG Key has to be also installed before getting the latest package.

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
yum install -y https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm

Get list of enabled repositories

yum repolist enabled

The list of enabled repositories should contain below

repo id                                                                          repo name                                                                                                      status
epel/x86_64                                                                      Extra Packages for Enterprise Linux 7 - x86_64                                                                 13756
mysql-connectors-community/x86_64                                                MySQL Connectors Community                                                                                       199
mysql-tools-community/x86_64                                                     MySQL Tools Community                                                                                             92
mysql80-community/x86_64                                                         MySQL 8.0 Community Server                                                                                       364
rhel-7-server-devtools-rpms/x86_64                                               Red Hat Developer Tools RPMs for Red Hat Enterprise Linux 7 Server                                              5258
rhel-7-server-optional-rpms/7Server/x86_64                                       Red Hat Enterprise Linux 7 Server - Optional (RPMs)                                                            23509
rhel-7-server-rpms/7Server/x86_64                                                Red Hat Enterprise Linux 7 Server (RPMs)                                                                       33163
rhel-server-rhscl-7-rpms/7Server/x86_64                                          Red Hat Software Collections RPMs for Red Hat Enterprise Linux 7 Server                                        14117

3. Support for PostgreSQL 10+ (optional)

This part can be skipped if you plan to connect to PostgreSQL up to vesion 9.6 or you don't need PostgreSQL support at all.

If you plan to connect to PostgreSQL servers from version 10 than PostgreSQL provided by RHEL 7 is not suitable and newer packages must be installed from official PostgreSQL repository.

The pg_config v10+ has to be available before installing SlashDB.

Run below command to check if you already have PostgreSQL development package

pg_config | grep VERSION
  • if error "command not found" was returned then it means no PostgreSQL client was found you can continue with instruction below to install newer PostgreSQL devel
  • if returned VERSION is greater of equal 10 then you can skip the following update
  • if returned VERSION is lower than 10 then the below instructions may not be suitable

Follow the instructions below To update PostgreSQL development package.

Add the PostgreSQL repository.

yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

Install development package

yum install -y postgresql14-devel

After installation the pg_config is not linked. Add the missing alternative with command

update-alternatives --install /usr/bin/pg_config pg_config /usr/pgsql-14/bin/pg_config 20

Finally check if pg_config is right version

pg_config | grep VERSION

Expected output is PostgreSQL version 14.x e.g.

VERSION = PostgreSQL 14.2

All ready, you can install SlashDB package now.

4. Download and install SlashDB package

yum install -y https://downloads.slashdb.com/versions/1.6.0/slashdb-1.6.0.x86_64.rpm

5. 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. Enable required repositories

Add EPEL repository.

dnf install -y https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm

Add MySQL 8 Community repository. Due to a MySQL issue a new GPG Key has to be also installed before getting the latest package.

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
dnf install -y https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm

Add Red Hat CodeReady Linux Builder repository for SAML integration.

subscription-manager repos --enable codeready-builder-for-rhel-8-x86_64-rpms

3. Download and install SlashDB package

dnf install -y https://downloads.slashdb.com/versions/1.6.0/slashdb-1.6.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.

5. To finish setup see:

RedHat 9

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. Enable required repositories

Add EPEL repository.

dnf install -y https://dl.fedoraproject.org/pub/epel/epel-release-latest-9.noarch.rpm

Add MySQL 8 Community repository. Due to a MySQL issue a new GPG Key has to be also installed before getting the latest package.

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
dnf install -y https://dev.mysql.com/get/mysql80-community-release-el9-1.noarch.rpm

Add Red Hat CodeReady Linux Builder repository for SAML integration.

subscription-manager repos --enable codeready-builder-for-rhel-9-x86_64-rpms

3. Download and install SlashDB package

dnf install -y https://downloads.slashdb.com/versions/1.6.0/slashdb-1.6.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.

5. To finish setup see:

Oracle for RedHat or CentOS

Before Installing - Requirements

1. Change to root

sudo su

2. Install additional system dependencies required by Oracle driver.

For Red Hat / CentOS 8 or newer versions package libnsl is needed.

yum install -y libnsl

3. Install RPM files for oracle

Go to Oracle Instant Client Downloads download and install version 21 of:

  • Instant Client Basic Package
  • SQL*Plus Package of version 21
yum install -y ./oracle-instantclient-*.rpm

4. Setup system environment

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

echo 'export ORACLE_HOME=/usr/lib/oracle/21/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

If your Oracle server runs inside a docker container and is version 19 or above, you will need to disable the Out Of Band breaks feature. To do that add this line to sqlnet.ora

echo "DISABLE_OOB=ON" >> ~/.sqlnet.ora

5. Add DBAPI

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

6. Restart the SlashDB service.

systemctl restart slashdb

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