Installation of nevisDetect Persistency

You install the component nevisDetect Persistency by means of the software package nevisdetect-persistency-<version>.noarch.rpm, according to the description in the chapter General installation.

After the installation of nevisDetect Persistency, it is possible to manually create and maintain the database schema, e.g., with Flyway, an open-source database migration tool. See the sample command below:

root@nevisrdf-1:/var/opt/rpms# nevisdetect-persistency flyway info
Flyway 4.1.2 by Boxfuse

Database: jdbc:oracle:thin:@oravml11.zh.adnovum.ch:41010:DCHNEV01 (Oracle 11.2)

+---------+-------------------------+---------------------+---------+
| Version | Description             | Installed on        | State   |
+---------+-------------------------+---------------------+---------+
| 1       | Initial Schema          | 2018-04-24 10:10:44 | Success |
| 2       | Audit Tables            | 2018-04-24 10:10:45 | Success |
| 3       | Audit Cleanup           | 2018-04-24 10:10:45 | Success |
| 4       | Action Plugin           | 2018-07-10 12:46:42 | Success |
| 5       | Training Data Storage   | 2018-08-08 20:03:09 | Success |
| 6       | Policy Matched          | 2018-08-16 08:58:38 | Success |
| 7       | FeatureCorrelator Batch | 2018-08-28 16:12:02 | Success |
| 8       | Normalization Model     | 2018-10-09 15:51:35 | Success |
| 9       | UnauthenticatedRequests | 2019-01-07 15:53:03 | Success |
| 10      | RenamingNevisDetect     | 2019-03-06 17:18:15 | Success |
+---------+-------------------------+---------------------+---------+

The database connection configured in /var/opt/nevisdetect/persistency/conf/persistency.properties is used, but it is also possible to configure the parameters with the command line. Flyway supports the following commands:

Name	Description
migrate	Migrates the database.
clean	Drops all objects in the configured schemas.
info	Prints the details and status information about all the migrations.
validate	Validates the applied migrations against the ones available on the classpath.
baseline	Baselines an existing database, excluding all migrations up to and including the baseline version.
repair	Repairs the schema history table.

Supported databases

nevisDetect supports the following databases:

• Oracle
• MariaDB

To load the data types for the Flyway script, perform the following steps:

1. Determine the database vendor from the JDBC URL (it should contain either the string jdbc:oracle or jdbc:mysql / jdbc:mariadb).
2. Depending on the database vendor, load the data types for the Flyway script either from the flyway_mariadb.properties file or the flyway_oracle.properties file.

MariaDB

If you use MariaDB, do the following:

• Set the parameter useMysqlMetadata to "true" in your JDBC connection URL. For example: jdbc:<mariadb://127.0.0.1:3306/nevisdetect?useMysqlMetadata=true>
• Set the attribute lower_case_table_names to 1 in the MySQL settings (my.cnf).

Oracle

If you use an Oracle database, either copy or create a link to the JDBC drivers in the /var/opt/nevisdetect/persistency/libs and /var/opt/nevisadapt/libs directories.