## Notes When changing parameters, please refer to "[Confirmation When Changing Parameters](/en/manual/parameter-edit)". ## 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)ConnectionString ``` User type and database type can be omitted. Example Setting: ``` (Service name)_Rds_ConnectionString ``` 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|