MicroStrategy ONE

Storage Service Configuration Properties

This topic explains each Storage service configuration property and helps you to configure the Storage service.

This topic explains each Storage service configuration property and provides assistance with configuring the Storage service manually. However, MicroStrategy recommends you configure the Storage service automatically with no modifications to the default on-premises or cloud environments.

Overview

Modify configuration properties for the Storage service by editing configOverride.properties.

All parameters are case-sensitive and must be entered correctly for changes to take effect.

The configOverride.properties file can be found in:

Windows: <DEPLOY_LOCATION>\webapps\MicroStrategyLibrary\WEB-INF\classes\config\ConfigOverride.properties

Linux: <DEPLOY_LOCATION>/webapps/MicroStrategyLibrary/WEB-INF/classes/config/configOverride.properties

Configuration File

The configOverride.properties file includes the following properties.

Entry Type Example Description
datasource.url string

jdbc:postgresql://your.own.ipv4.address:5432/mstr_library

or

jdbc:postgresql://YourDBHost:5432/mstr_library

This parameter specifies the IP or the hostname of a remote Postgres server.

The default port number for PostgreSQL is 5432.

datasource.admin.username

string

mstr_library

The admin username to connect to PostgreSQL.
datasource.admin.password string <password for mstr_library> The admin password to connect to PostgreSQL.
datasource.username

string

mstr_library_application

The application username to connect toPostgreSQL.
datasource.password string <password for mstr_library_application> The application password to connect to PostgreSQL
datasource.tlsEnabled

Boolean

false

The feature flag for a TLS connection. The default value is false.
datasource.sslMode string require The SSL mode for PostgreSQL. The default value is ‘prefer’.
datasource.sslRootCert

string

/LOCATION_OF_FILE/root.crt

The absolute path to the SSL root certificate file.
datasource.sslCert string /LOCATION_OF_FILE/mstr_library_application.crt The absolute path to application user certificate file
datasource.sslKey

string

/LOCATION_OF_FILE/mstr_library_application.pk8

The absolute path to the application user private key file.
datasource.admin.sslCert string /LOCATION_OF_FILE/mstr_library.crt The absolute path to the admin user certificate file.
datasource.admin.sslKey

string

/LOCATION_OF_FILE/mstr_library.pk8

The absolute path to the admin user private key file.

Repositories

The Storage service uses MicroStrategy Repository or Remote Repository to create database, schema, and database users.

MicroStrategy Repository

See Installation for more information about installing MicroStrategy Repository.

The credential information is stored in Default_Accounts.txt. The default location is:

Windows: C:\Program Files (x86)\Common Files\MicroStrategy\<MSTR_INSTALL>\Repository

Linux: /opt/mstr/MicroStrategy/<MSTR_INSTALL>/Repository

Default_Accounts.txt should include the following lines:

Copy
[MicroStrategy Repository]
mstr=<password for mstr>
mstr_library=<password for mstr_library>
mstr_library_application=<password for mstr_library_application>

Remote Repository

See Remote Repository for Windows and Linux for more information about installing Remote Repository.

You may need to enter your repository credentials twice for both admin and application users.

It is recommended to configure the two users with different privileges for security reasons.

  • datasource.admin.username: mstr_library is the owner of the mstr_library database and should have create/alter/drop tables privileges.

  • datasource.username: mstr_library_application is an application user of the mstr_library database and should have CRUD privileges on tables.