Audit log database setup

Audit record messages are stored in a relational database. Currently, nevisDataPorter supports MySQL and Oracle RDBMS. Persisting audit record messages in a relational database requires the database tables and users to be created and set up with the following command:

nevisdp <INST> create-db [mysql|oracle]

Before executing this command specify the database properties in

/var/opt/nevisdp/<INST>/conf/db.properties

An example of db.properties:

Example of Oracle database connection properties in db.properties

ORACLE_HOME=/share/xpository/oracle/instantclient/11.2.0.3/i486-linux-gcc3/
dist-bin/instantclient_11_2/
DBSYSTEM_USER=system
DBSYSTEM_PASSWORD=managed
DBSID=DCHNDP01
DBHOST=oravms01
DBPORT=49100
DBSCHEMA=ndp
DBOWNER_NAME=undp01
DBOWNER_PASSWORD=undp01
DBUSER_NAME=undp02
DBUSER_PASSWORD=undp02

Executing create-db first substitutes the placeholders of the sql files in /opt/nevisdp/sql/ with the configured properties and then execute the substituted sql scripts. The substituted sql scripts can be found in /var/opt/nevisdp/<INST>/.sql/.

After successfully creating the database, the nevis-audit.properties file is automatically adapted to the new database connection settings. The nevis-audit.properties file is used by the dataporter to set connection parameters for the persistence layer.