Set Parameter: Rds.json
The Japanese version of the manual is the latest.
Please also check.
Please also check.
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:
(Service name)_Rds_(Database type)_(User type)ConnectionStringUser type and database type can be omitted.
Example Setting:
(Service name)_Rds_ConnectionStringYou 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 |
