Set Parameter: Rds.json
Notes¶
When changing parameters, please refer to "Confirmation When Changing Parameters".
Setting Values¶
The setting values of this parameter file are as follows.
| Parameter name | e.g. | Description |
|---|---|---|
| Dbms | "SQLServer" | Specify "SQLServer" or "PostgreSQL" according to the database you are using. In the .NET Framework version, you cannot change from "SQLServer". |
| Provider | "Local" | Normally, specify "Local". Specify "Azure" when using Azure SQL Database. |
| SaConnectionString | sa authority connection string | Specify the connection string to connect to the database instance with sa authority. |
| OwnerConnectionString | dbowner authority connection string | Specify the connection string to connect to the Pleasanter database with dbowner authority. |
| UserConnectionString | dbreader,dbwriter authority connection string | Specify the connection string to connect to the Pleasanter database with dbreader,dbwriter authority. |
| SqlCommandTimeOut | 600 | Specify the timeout time of the SQL command in seconds. |
| MinimumTime | 3 | Specify the minimum time unit that the database can identify in milliseconds. This parameter cannot be changed. |
| DeadlockRetryCount | 4 | Specify the maximum number of retries when a deadlock occurs. |
| DeadlockRetryInterval | 1000 | Specify the interval in milliseconds until retrying when a deadlock occurs. |
| DisableIndexChangeDetection | false | Specify true if you do not want to detect differences in database indexes when upgrading. Specify true to prevent the indexes you set up when setting indexes manually. |
| SysLogsSchemaVersion | 1 | Specify 2 if you are using the "System Log Extended Function". |
From a security perspective, to prevent this parameter file from being accidentally disclosed externally, a function has been added to obtain credentials from the OS's system environment variables (ver.1.2.21.0).
System environment variable naming convention:
User type and database type can be omitted.
Example Setting:
You can also set it in this parameter file as before. For Azure, you can add/edit these values via [App Service Settings] -> [Configuration] -> [Application Settings].
Example Settings SaConnectionString¶
| Database | Variable | Value |
|---|---|---|
| SQL Server | Implem.Pleasanter_Rds_SQLServer_SaConnectionString | Server=(local);Database=master;UID=sa;PWD=＜password you set＞;Connection Timeout=30; |
| PostgreSQL | Implem.Pleasanter_Rds_PostgreSQL_SaConnectionString | Server=localhost;Database=postgres;UID=postgres;PWD=＜password you set＞ |
Example Settings for OwnerConnectionString¶
| Database | Variable | Value |
|---|---|---|
| SQL Server | Implem.Pleasanter_Rds_SQLServer_OwnerConnectionString | Server=(local);Database=#ServiceName#;UID=#ServiceName#_Owner;PWD=＜password you set＞;Connection Timeout=30; |
| PostgreSQL | Implem.Pleasanter_Rds_PostgreSQL_OwnerConnectionString | Server=localhost;Database=#ServiceName#;UID=#ServiceName#_Owner;PWD=＜password you set＞ |
Example Settings for UserConnectionString¶
| Database | Variable | Value |
|---|---|---|
| SQL Server | Implem.Pleasanter_Rds_SQLServer_UserConnectionString | Server=(local);Database=#ServiceName#;UID=#ServiceName#_User;PWD=＜password you set＞;Connection Timeout=30; |
| PostgreSQL | Implem.Pleasanter_Rds_PostgreSQL_UserConnectionString | Server=localhost;Database=#ServiceName#;UID=#ServiceName#_User;PWD=＜password you set＞ |
If a parameter is set in both this parameter file and the system environment, or if a parameter is set in an abbreviated form, the priority is as follows:
SaConnectionString Priority Order¶
| Priority order | Set value |
|---|---|
| 1 | "SaConnectionString" in this parameter file |
| 2 | "（Service name）Rds（Database type）_SaConnectionString" in the environment variable |
| 3 | "（Service name）Rds（Database type）_ConnectionString" in the environment variable |
| 4 | "（Service name）_Rds_SaConnectionString" in the environment variable |
| 5 | "（Service name）_Rds_ConnectionString" in the environment variable |
OwnerConnectionString Priority Order¶
| Priority order | Set value |
|---|---|
| 1 | "OwnerConnectionString" in this parameter file |
| 2 | "（Service name）Rds（Database type）_OwnerConnectionString" in the environment variable |
| 3 | "（Service name）Rds（Database type）_ConnectionString" in the environment variable |
| 4 | "（Service name）_Rds_OwnerConnectionString" in the environment variable |
| 5 | "（Service name）_Rds_ConnectionString" in the environment variable |
UserConnectionString Priority Order¶
| Priority order | Set value |
|---|---|
| 1 | "UserConnectionString" in this parameter file |
| 2 | "（Service name）Rds（Database type）_UserConnectionString" in the environment variable |
| 3 | "（Service name）Rds（Database type）_ConnectionString" in the environment variable |
| 4 | "（Service name）_Rds_UserConnectionString" in the environment variable |
| 5 | "（Service name）_Rds_ConnectionString" in the environment variable |