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:
[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_libraryis the owner of themstr_librarydatabase and should have create/alter/drop tables privileges.datasource.username:mstr_library_applicationis an application user of themstr_librarydatabase and should have CRUD privileges on tables.