7.2. Running LinOTP with Oracle on RedHat

This describes howto setup LinOTP with a connection to an Oracle database on a RedHat system. On other distributions this may vary.

7.2.1. Overview

You need to install the following packages:

  • Oracle client (out of the scope of this document)
  • cx_Oracle python module
  • LinOTP

Therefore you need to change the following config files:

  • /etc/linotp2/linotp.ini

7.2.2. Installation

7.2.2.1. Install cx_Oracle python module

Change to your virtualenv and install cx_Oracle [1] to your virtualenv:

pip install cx_Oracle
[1]You can also download and install cx_Oracle from http://cx-oracle.sourceforge.net/ for your given Python version.

7.2.2.2. Install LinOTP

Starting with version 2.4.3-4 LinOTP runs nicely with Oracle. So install the latest LinOTP package:

pip install --upgrade /path/to/package/LinOTP-2.4.3-4.tar.gz

7.2.3. Configuration

7.2.3.1. LinOTP

Adapt the config file /etc/linotp2/linotp.ini:

sqlalchemy.url = oracle://user:pass@host:port/dbname

7.2.3.2. Create the database tables

The database tables are created in the usual way:

paster setup-app /etc/linotp2/linotp.ini