2.3 - SQL Database Installation

Mailismus can optionally be configured to use a relational database for some of its functions.
Currently that means Greylisting, which is an optional feature, but does require a backing database if it is to be used.

Section §4.11 goes through the supported database types, and the basic config settings which underpin them all, so this section explains how to do any prior installation and setup that may be required before Mailismus can access a database.

Mailismus uses Java's JDBC interface to connect to the database, so you will need to install the appropriate driver for each database. A JDBC driver is simply a vendor-provided JAR file.
Having obtained the JAR file and put it somewhere on your system, "installation" simply consists of adding its pathname to the Mailismus classpath, and the most convenient way to do this is to add it to the dependjars config item in the naf.xml config file. See section §3 for more info on NAF, but this basic example illustrates how to do it.

<naf>
    ...
    <dependjars>%DIRTOP%/lib/extra/h2-1.3.162.jar</dependjars>
    ...
    <dispatchers> ... </dispatchers>
</naf>

 
You can easily locate the download sites for the database types listed in §4.11, and while some of them may offer more or less elaborate installation procedures, all that Mailismus needs is their JARs, not the full system.
For the vast majority of databases (and at the time of writing, all the ones listed in section §4.11), the JDBC driver maps to a single self-contained JAR file, but in other cases this may have dependencies on other JARs, or even on underlying native libraries (.so files for Unix, DLLs for Windows), so in those cases, you would need to put such native libraries on your Path as well.