Repository database

Changing the repository database when using Docker will be described on this page. By default WriteBackExtreme Docker will use sqlite, but if that is not an option it can be changed via environment variables.

Do not use the $ character in your password. This character does not play well in the configuration file.

MS SQL Server

The following environment variables can be passed when starting a container and it will connect to the given database and its credentials.

Key	Type	Required	Description
WBE_DB_DRIVER	String		Value: sqlsrv
WBE_DB_HOST	String
WBE_DB_DATABASE	String
WBE_DB_USERNAME	String
WBE_DB_PASSWORD	String
WBE_DB_PORT	Number		Default: 1433
WBE_SQLSRV_ENCRYPT	Number		1 or 0
WBE_SQLSRV_TRUST_SERVER	String		Yes or No

Some Microsoft SQL Database servers have certificates that could not be verified by our application.

WBE_SQLSRV_TRUST_SERVER: Set to 1 to disable ssl certificate validation for the SQL Server database. More can be read here.

WBE_SQLSRV_ENCRYPT: SQL Server database uses SSL encryption Set to "yes" to use encryption. To disable encryption set to "no". Read more about this here.

PostgreSQL

The following environment variables can be passed when starting a container and it will connect to the given database and its credentials.

Key	Type	Required	Description
WBE_DB_DRIVER	String		Value: pgsql
WBE_DB_HOST	String
WBE_DB_DATABASE	String
WBE_DB_USERNAME	String
WBE_DB_PASSWORD	String
WBE_DB_PORT	Number		Default: 5432
WBE_DB_SCHEMA	String		Default: PUBLIC

MySQL

The following environment variables can be passed when starting a container and it will connect to the given database and its credentials.

Key	Type	Required	Description
WBE_DB_DRIVER	String		Value: mysql
WBE_DB_HOST	String
WBE_DB_DATABASE	String
WBE_DB_USERNAME	String
WBE_DB_PASSWORD	String
WBE_DB_PORT	Number		Default: 3306