Linux

Requirements

Due to certain dependencies, if installing on a 64-bit operating system (OS), the target system will require >=512 MB of RAM.

Debian 9

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 separate system because number of system-wide dependencies like NGINX, Memcached and database clients are installed.

1. Change to root
sudo su
2. Download latest DEB package.
wget -c https://downloads.slashdb.com/latest/slashdb.deb
3. Install MySQL APT repository and SlashDB.

Deabian 9 requires adding MySQL Client library which is not available in standard Debian repository. MySQL APT repository has to be added.

Install allowing unauthenticated MySQL repository.

apt-get update    
apt-get install -y software-properties-common        
add-apt-repository 'deb http://repo.mysql.com/apt/debian/ stretch mysql-8.0'        

apt-get update        
apt-get install -y ./slashdb.deb --allow-unauthenticated

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

apt-get update 
apt-get install -y ./slashdb.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 18.04

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 separate system because number of system-wide dependencies like NGINX, Memcached and database clients 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/latest/slashdb.deb
add-apt-repository universe
apt-get update
apt-get -yf install ./slashdb.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 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.

RedHat or CentOS

The following instructions were produced on RedHat Enterprise Linux 7 and 8, but should work the same on CentOS.

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

If installing on RedHat Enterprise Linux 7 or CentOS 7 additionally add MySQL community repository

rpm -ivh https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
3. Download and install SlashDB package with dependencies
yum install -y https://downloads.slashdb.com/latest/slashdb.rpm

Alternatively (i.e. in case you need to alter specific versions of dependencies) you can install the SlashDB in two steps:

yum install -y gcc gcc-c++ python2 python2-pip python2-virtualenv libaio memcached nginx \
postgresql-devel mysql-devel unixODBC unixODBC-devel freetds

rpm -ivh https://downloads.slashdb.com/latest/slashdb.rpm
4. Once installation is complete SlashDB should be accessible at http://your-ip-address.

Use command ifconfig to find what is your IP address.

6. To finish setup see:

Oracle for RedHat or CentOS

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

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 SlashDB service.

service slashdb restart

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

results matching ""

    No results matching ""