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)

+-----------+---------+-------------------------+------+---------------------+---------+
| Category  | Version | Description             | Type | Installed On        | State   |
+-----------+---------+-------------------------+------+---------------------+---------+
| Versioned | 1       | Initial Schema          | SQL  | 2023-11-11 11:39:55 | Success |
| Versioned | 2       | Audit Tables            | SQL  | 2023-11-11 11:39:56 | Success |
| Versioned | 3       | Audit Cleanup           | SQL  | 2023-11-11 11:39:56 | Success |
| Versioned | 4       | Action Plugin           | SQL  | 2023-11-11 11:39:56 | Success |
| Versioned | 5       | Training Data Storage   | SQL  | 2023-11-11 11:39:56 | Success |
| Versioned | 6       | Policy Matched          | SQL  | 2023-11-11 11:39:56 | Success |
| Versioned | 7       | FeatureCorrelator Batch | SQL  | 2023-11-11 11:39:56 | Success |
| Versioned | 8       | Normalization Model     | SQL  | 2023-11-11 11:39:57 | Success |
| Versioned | 9       | UnauthenticatedRequests | SQL  | 2023-11-11 11:39:57 | Success |
| Versioned | 10      | RenamingNevisDetect     | SQL  | 2023-11-11 11:39:57 | Success |
| Versioned | 11      | Whitelist Users         | SQL  | 2023-11-11 11:39:57 | Success |
| Versioned | 12      | Add Foreign Key Indexes | SQL  | 2023-11-11 11:39:57 | 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:

• MariaDB
• Oracle
• PostgreSQL

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.

PostgreSQL

If you use PostgreSQL with Flyway, the Flyway schema history table name has to be in lower case.