This section explains on how to configure CipherMail with support for Oracle DB.
It is assumed that Oracle DB is already installed (either on the same system as CipherMail or an external system) and that it is accessible from the CipherMail system.
CipherMail requires requires a database named
djigzo which is owned by database user
If the database or the database user is named differently, update the required configuration files accordingly.
Login as the database administrator:
Execute the following SQL commands to create a database user and database:
CREATE USER djigzo IDENTIFIED BY djigzo default tablespace USERS; GRANT CREATE SESSION TO djigzo; GRANT CREATE TABLE TO djigzo; GRANT CREATE VIEW TO djigzo; GRANT CREATE PROCEDURE TO djigzo; GRANT CREATE SEQUENCE TO djigzo;
Set quota for the user 1:
ALTER USER djigzo QUOTA 300M ON USERS;
Replace 300M should be sufficient for most setups. If the DLP quarantine functionality will be used, the quota might need to be increased.
Import table definitions.
Login as the database user:
Import the table definitions:
CipherMail requires a number of changes.
CipherMail should be configured to use Oracle instead of PostgreSQL.
sudo vi /usr/share/djigzo/wrapper/wrapper-additional-parameters.conf
Add the following line to the end of
The database connection, hostname of database server etc., should be configured in the file
sudo vi /usr/share/djigzo/conf/database/hibernate.oracle.connection.xml
By default the database connection is configured to connect to Oracle on localhost. Change this to the IP address (or fully qualified domain name) of the Oracle server if the database server runs on a different host.
Disable backup page¶
The built-in backup/restore functionality only works with a locally configured PostgreSQL database. The web GUI backup option can be disabled by adding the following option to the tomcat options:
The option should be added to the tomcat default settings file
sudo bash -c 'echo "JAVA_OPTS=\"\$JAVA_OPTS \ -Dciphermail.backup.enabled=false\"" >> /etc/default/tomcat8'
Add the option
-Dciphermail.backup.enabled=false to the last
JAVA_OPTS line in the tomcat config file:
JAVA_OPTS line should look similar to:
JAVA_OPTS="-Ddjigzo-web.home=/usr/share/djigzo-web -Djava.awt.headless=true -Xmx128M -Dciphermail.backup.enabled=false"