Database

Rasa Enterprise is officially compatible with the following databases:

• PostgreSQL

• Oracle ≥ 11.0

By default, Rasa Enterprise uses PostgreSQL as a database. It can be configured to use an on-premise database or your own cloud provided database. Using Oracle as your Rasa Enterprise database instead of PostgreSQL also requires some additional setup (see below).

PostgreSQL#

The default database started by the Rasa Enterprise Helm chart is PostgreSQL, which refers to the PostgreSQL subchart. See the page on configuring the subcharts to configure the default instance or to use an external Postgres instance.

Oracle#

Using Oracle as your Rasa Enterprise database instead of PostgreSQL requires some additional setup, which we’ll go over here.

1. Database Setup

   In your Oracle database, create an empty database called rasa and configure a user/password that has access to it. You can also use a database with a different name, as long as it is empty and you specify this in the DB_DATABASE environment variable (read more in Adding Environment Variables).

2. Rasa Enterprise Configuration

   Next you have to extend the Rasa Enterprise image to include the necessary drivers and clients. First download the Oracle Instant Client, rename it to oracle.rpm and store it in the directory from where you’ll be building the Docker image.

   Copy the following into a file called Dockerfile:

   Copy

   FROM rasa/rasa-x:1.1.3

   # Switch to root user to install packages

   USER root

   RUN apt-get update -qq && apt-get install -y --no-install-recommends alien libaio1 && apt-get clean && rm -rf /var/lib/apt/lists/* /tmp/* /var/tmp/*

   # Copy in oracle instaclient

   # [https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html](https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html)

   COPY oracle.rpm oracle.rpm

   # Install the Python wrapper library for the Oracle drivers

   RUN pip install cx-Oracle

   # Install Oracle client libraries

   RUN alien -i oracle.rpm

   USER 1001

   Then build the Docker image:

   docker build . -t rasa/rasa-x:1.1.3-oracle

   Then push it to your private image registry.

   You can now use this image instead of the standard one, by replacing it in your values.yml:

   Copy

   rasax:

   name: "<your-registry/your-extended-image>"

   tag: "<tag-for-extended-image>"

You will also have to disable installing Postgres and configure the following environment variables and a secret for the rasax, eventService and dbMigrationService sections.

Create the secret as follows:

And update the values.yaml as follows:

Alternatively, you can also directly pass the database connection URL to the container, by defining the DB_URL variable (this is not advised as it leaves the database password in plaintext):