Configuring the Database

This step is required only if the SingServer runs with a database management system.

Configuring the Database Driver

Add the MariaDB database driver by hot-deploying it into the deployment directory. The driver will be picked up by WildFly and deployed, allowing the creation of the data source in the next step. You can use a generic name, without a version number to get the generic driver-name for the data source command.

# cp mariadb-java-client-2.1.0.jar APPSRV_HOME/standalone/deployments/mariadb-java-client.jar 

Configuring the Data Source

To add a data source for SignServer to use, run the command below with JBoss CLI (by using APPSRV_HOME/bin/jboss-cli.sh).

#data-source add --name=signserverds --driver-name="mariadb-java-client.jar" --connection-

url="jdbc:mysql://127.0.0.1:3306/signserver" --jndi-name="java:/SignServerDS" --use-ccm=true --driverclass="org.mariadb.jdbc.Driver" --user-name="signserver" --password="signserver" --validate-onmatch=true --background-validation=false --prepared-statements-cache-size=50 --share-preparedstatements=true --min-pool-size=5 --max-pool-size=150 --pool-prefill=true --transaction-

isolation=TRANSACTION_READ_COMMITTED --check-valid-connection-sql="select 1;" --enabled=true :reload

The MariaDB data source example configuration uses the driver deployed in the previous step Configuring the Database Driver. The --jindi-name above is the default database.properties value.