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.8 - 3.10. Comes by default with Debian 11, Ubuntu 20.04 - 22.04, Oracle Linux 8 - 9, Red Hat 8 - 9. All others distros/versions will require installation of a supported Python version beforehand).

Debian

If using Debian 11 then an acceptable version of Python will already be installed. Otherwise, you will need to install a Python version between 3.8 - 3.10 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

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.

apt-get update
apt-get install -y wget software-properties-common gnupg
cd /tmp
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
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.

apt-get update
wget -c https://downloads.slashdb.com/versions/1.7.29/slashdb_1.7.29_amd64.deb
apt-get install -y ./slashdb_1.7.29_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:

• Logging in for the first time.
• Enable HTTPS/SSL

Ubuntu

If using Ubuntu 20.04 - 22.04 then an acceptable version of Python will already be installed. Otherwise, you will need to install a Python version between 3.8 - 3.10 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.

cd /tmp
wget -c https://downloads.slashdb.com/versions/1.7.29/slashdb_1.7.29_amd64.deb
add-apt-repository universe
apt-get update
apt-get -y install ./slashdb_1.7.29_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 21.6 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. Download and install Oracle plugin

wget -c https://downloads.slashdb.com/versions/1.7.29/slashdb-oracle_1.1.0_amd64.deb
apt-get install -y ./slashdb-oracle_1.1.0_amd64.deb

If specific version of cx_Oracle is needed then set environment variable CX_ORACLE_VER before installing the plugin.

export CX_ORACLE_VER=8.3.0; apt-get install -y ./slashdb-oracle_1.1.0_amd64.deb

5. Finally, restart SlashDB service

systemctl restart slashdb

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

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.8 - 3.10 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.7.29/slashdb-1.7.29.x86_64.rpm

5. Once installation is complete SlashDB should be accessible at http://your-ip-address

Use command ip a to find what your IP address is.

6. To finish setup see:

• Logging in for the first time.
• Enable HTTPS/SSL.

Red Hat 8

Please check the Requirements before installing.

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.7.29/slashdb-1.7.29.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:

• Logging in for the first time.
• Enable HTTPS/SSL.

Red Hat 9

Please check the Requirements before installing.

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.7.29/slashdb-1.7.29.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:

• Logging in for the first time.
• Enable HTTPS/SSL.

Oracle Linux 8

Please check the Requirements before installing.

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 epel-release

Add CodeReady Linux Builder repository for SAML integration.

dnf config-manager --set-enabled ol8_codeready_builder

3. Download and install SlashDB package

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

• Logging in for the first time.
• Enable HTTPS/SSL.

Oracle Linux 9

Please check the Requirements before installing.

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 epel-release

Add CodeReady Linux Builder repository for SAML integration.

dnf config-manager --set-enabled ol9_codeready_builder

3. Download and install SlashDB package

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

• Logging in for the first time.
• Enable HTTPS/SSL.

Oracle for Red Hat, Oracle Linux or CentOS

Before Installing - Requirements

1. Change to root

sudo su

2. Install RPM files for Oracle

Visit Oracle Instant Client Downloads to download and install:

• Instant Client Basic Package v21
• SQL*Plus Package v21

yum install -y ./oracle-instantclient-*.rpm

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

4. Download and install Oracle plugin

dnf install -y https://downloads.slashdb.com/versions/1.7.29/slashdb-oracle-1.1.0.x86_64.rpm

If a specific version of cx_Oracle is needed, set the environment variable CX_ORACLE_VER before installing the plugin.

export CX_ORACLE_VER=8.3.0; yum install -y ./slashdb-oracle-1.1.0.x86_64.rpm

5. Restart the SlashDB service.

systemctl restart slashdb

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