ConnectionStrings.config setup for PostgreSQL
Edit the ConnectionStrings.config file that is located in the root folder of Creatio. Specify the connection parameters (connectionString) for the restored database (name=”db”) as well as Redis Server (name=”redis”).
To set up the ConnectionStrings.config file:
1.Go to the root directory of the Creatio application ~\WebAppRoot\Creatio.
2.Open the ConnectionStrings.config file in a text editor.
3.Specify the connection parameters (connectionStrings).
a.For the restored database (name=”db”).
<add name="db" connectionString="Server=[Creatio database server name];Port=[Database server port];Database=[Database name];User ID=[PostgreSQL public user for connecting to the Creatio database];password=[PostgreSQL public user password];Timeout=500; CommandTimeout=400;MaxPoolSize=1024;" />
b.For Redis Server (name=”redis”):
<add name="redis" connectionString="host=[Computer name];db=[Redis DB number];port=6379;maxReadPoolSize=10;maxWritePoolSize=500" />
Note
Starting with Creatio version 7.13.4, you can set up a password-protected connection with Redis. To do this, specify the password when setting up the ConnectionStrings.config file:
<add name="redis" connectionString="host=[Computer name];db=[Redis DB number];port=6379;password=xxx;maxReadPoolSize=10;maxWritePoolSize=500" />
A sample ConnectionStrings.config file.
<?xml version="1.0" encoding="utf-8"?>
<connectionStrings>
<add name="db" connectionString="Server=[Database server name];Port=[Database server port];Database=[Database name];User ID=[PostgreSQL user for connecting to the database];password=[PostgreSQL user password];Timeout=500; CommandTimeout=400;MaxPoolSize=1024;" />
<add name="redis" connectionString="host=[Computer name];db=[Redis DB number];port=6379;maxReadPoolSize=10;maxWritePoolSize=500" />
<add name="redisSentinel" connectionString="sentinelHosts=localhost:26380,localhost:26381,localhost:26382;masterName=mymaster;scanForOtherSentinels=false;db=1;maxReadPoolSize=10;maxWritePoolSize=500" />
<add name="defPackagesWorkingCopyPath" connectionString="%TEMP%\%APPLICATION%\%APPPOOLIDENTITY%\%WORKSPACE%\TerrasoftPackages" />
<add name="tempDirectoryPath" connectionString="%TEMP%\%APPLICATION%\%APPPOOLIDENTITY%\%WORKSPACE%\" />
<add name="sourceControlAuthPath" connectionString="%TEMP%\%APPLICATION%\%APPPOOLIDENTITY%\%WORKSPACE%\Svn" />
<add name="elasticsearchCredentials" connectionString="User=[The ElasticSearch user name]; Password=[The ElasticSearch user password];" />
<add name="influx" connectionString="url=http://10.0.7.161:30359; user=; password=; batchIntervalMs=5000" />
</connectionStrings>
See also
•Checking Windows mandatory components
