Dabatase 2.x
Configure Tomcat data sources
Edit the file $TOMCAT_HOME/remote-signature.properties:
MySQL:
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/remote-signature?useUnicode=true&characterEncoding=UTF8&serverTimezone=CET
spring.datasource.username=openkm
spring.datasource.password=*secret*
MariaDB:
spring.datasource.driver-class-name=org.mariadb.jdbc.Driver
spring.datasource.url=jdbc:mariadb://localhost:3306/remote-signature?autoReconnect=true&useUnicode=true&characterEncoding=UTF8
spring.datasource.username=openkm
spring.datasource.password=*secret*
PostgreSQL:
spring.datasource.driver-class-name=org.postgresql.Driver
spring.datasource.url=jdbc:postgresql://localhost:5432/remote-signature
spring.datasource.username=openkm
spring.datasource.password=*secret*
spring.datasource.validationQuery=SELECT 1
SQL Server:
spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.datasource.url=jdbc:sqlserver://localhost:1433;databaseName=remote-signature
spring.datasource.username=openkm
spring.datasource.password=*secret*
spring.datasource.validationQuery=SELECT 1
H2:
spring.datasource.driver-class-name=org.h2.Driver
spring.datasource.url=jdbc:h2:./remote-signature
spring.datasource.username=openkm
spring.datasource.password=*secret*
With the MariaDB can use the following driverClassName values:
- org.mariadb.jdbc.Driver ( suggested )
- com.mysql.jdbc.Driver
In recent MySQL versions, you need to add useSSL=false to the connection URL.
Configures the values of the attributes named:
- Username.
- Password.
- URL ( change to your hosts and port )