Change the location of DDAudit database files

By default, DDAudit database files are stored in the Tomcat working directory. In some configurations this path may not be the DigDash Enterprise installation directory.

For example, on Linux the Tomcat working directory may be the Tomcat installation folder (e.g. /var/lib/tomcatX), and user rights may prevent the server from writing and/or modifying files in this directory. In this case, DDAudit will not work.

Another example is under Windows, when Tomcat is started as a service, the DDAudit database files may be in the Windows/system32 directory.

See chapter "Externalizing parameters in a properties file"to perform the following operation.

You can change the location of the DDAudit database files as follows:

1. Stop the DigDash Enterprise server
2. Open the file <DigDash Enterprise installation directory>/digdash.properties.
   • Change the value of the parameter audit.db.url
     from jdbc:h2:DDAudit_${server.DomainName};AUTO_SERVER=TRUE
     to jdbc:h2:file:/home/audit/DDAudit_${server.DomainName};AUTO_SERVER=TRUE (pay attention to the "file:" inserted at the beginning of the URL).
3. Check that the specified folder exists and move all existing DDAudit*.db files to the new location
4. Start the DigDash Enterprise server

Note: The audit.db.url, audit.db.user, audit.db.password and audit.db.tcpServer parameters can also be specified as JVM launch parameters, for example by adding to the JAVA_OPTS variable (setenv.bat, setenv.sh...) or in catalina.properties:
JAVA_OPTS=[...] -Daudit.db.url=jdbc:h2:file:/home/DDAudit;AUTO_SERVER=TRUE [...]

An alternative is to change the value of the h2.baseDir parameter, which changes the overall behaviour of the H2 databases (DDAudit, but also DDComments):

1. Stop the DigDash Enterprise server
2. Find and edit the catalina.properties file on the server (e.g. <DDE Install>/apache-tomcat/conf/catalina.properties on a Windows installation)
3. Add the following line: h2.baseDir=/the/new/path

Note: This path must be an absolute path.

1. Check that this folder exists and move all existing DDAudit*.db files to the new location.
2. Start the DigDash Enterprise server.