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 or Ubuntu

The following installation instructions were tested on Ubuntu 14.04, 16.04 and 17.04, but should work the same on equivalent Debian releases.

Our installation script automatically installs SlashDB with support for SQLite, MySQL, PostgreSQL as well as MS SQL Server, Oracle and IBM DB2 databases.

1. In the Linux system install the latest pip. (This is optional but recommended)

wget -c https://bootstrap.pypa.io/get-pip.py -O - | python
wget -c https://bootstrap.pypa.io/ez_setup.py -O - | python

2. Download the latest SlashDB install script.

wget -c http://downloads.slashdb.com/latest/install-slashdb.sh
chmod +x ./install-slashdb.sh
sudo ./install-slashdb.sh

3. Once installation is complete, start SlashDB by typing:

sudo service slashdb start

4. SlashDB should be accessible at http://your-ip-address

Use command ifconfig to find what is your IP address.

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

RedHat or CentOS

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

This installation provides SlashDB with support for SQLite, MySQL, 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 repository

rpm -ivh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.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++ make crypto-utils m2crypto wget sqlite memcached \
python-devel python2-pip python-virtualenv \
gdbm-devel readline-devel ncurses-devel zlib-devel bzip2-devel \
openssl-devel tk-devel libxslt-devel libxml2-devel db4-devel nginx \
mariadb-devel postgresql-devel unixODBC unixODBC-devel freetds

rpm -ivh https://downloads.slashdb.com/latest/slashdb.rpm

4. Once installation is complete, start SlashDB by typing:

sudo service slashdb start

5. SlashDB should be accessible at http://your-ip-address.

Use command ifconfig to find what is your IP address.

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

Oracle for RedHat or CentOS

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

rpm -ivh oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
rpm -ivh oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm
rpm -ivh oracle-instantclient12.1-odbc-12.1.0.2.0-1.x86_64.rpm
rpm -ivh oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm

add library

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

install DBAPI in virtualenv

source /opt/slashdb/bin/activate
pip install cx-Oracle==5.2

finally restart SlashDB service

service slashdb stop
service slashdb start

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

results matching ""

    No results matching ""