Privacy data access groups configuration¶
When using the privacy methods activate the option and fill in the storage
block with database settings for storing the private data:
privacy { storage { enabled = true url = "jdbc:postgresql://"${POSTGRES_ADDRESS}":"${POSTGRES_PORT}"/"${POSTGRES_DB} driver = "org.postgresql.Driver" profile = "slick.jdbc.PostgresProfile$" user = ${POSTGRES_USER} password = ${POSTGRES_PASSWORD} connectionPool = HikariCP connectionTimeout = 5000 connectionTestQuery = "SELECT 1" queueSize = 10000 numThreads = 20 schema = "public" migration-dir = "db/migration" } }
Parameters description
enabled
- the option activation.url
- the PostgreSQL DB address.driver
- the JDBC driver name.profile
- a profile name for the JDBC access.user
- a user name for the DB access.password
- a password for the DB access.connectionPool
- a connection pool name. Default isHikariCP
.connectionTimeout
- a connection timeout.connectionTestQuery
- a query name for the connection test.queueSize
- a requests queue size.numThreads
- a number of parallel connections.schema
- an interaction scheme.migration-dir
- a path to the data migration directory.
DB PostgreSQL is using as a database for the confidential data storage. The database should be installed on the same machine with the node and should have an DB access account. You can use the PostgreSQL tutorial for download and install the database according with your operation system type.
During the installation the system will offer to create an access account. These credentials must be entered into the appropriate user/password
parameters.
Specify the URL for the PostgreSQL connection into the url
parameter. URL consists of:
POSTGRES_ADDRESS - a PostgreSQL host address.
POSTGRES_PORT - a PostgreSQL host port number.
POSTGRES_DB - a PostgreSQL name.
You can specify the PostgreSQL credentials with the URL in the same string. The example is represented bellow, where user=user_privacy_node_0@we-dev
is a login, password=7nZL7Jr41qOWUHz5qKdypA&sslmode=require
- a password with require option during the authorization.
Example
privacy.storage.url = "jdbc:postgresql://vostk-dev.postgres.database.azure.com:5432/privacy_node_0?user=user_privacy_node_0@we-dev&password=7nZL7Jr41qOWUHz5qKdypA&sslmode=require"