Sales Creatio, commerce edition
PDF
This documentation is valid for Creatio version 7.16.0. We recommend using the newest version of Creatio documentation.

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

Configure the application site on IIS.

Set up websockets.

Switching from HTTP to HTTPS

Did you find this information useful?

How can we improve it?