Skip to content

How To Install Creatio

Kyryl Krylov, CPA edited this page Jan 31, 2021 · 2 revisions

Steps

Step 1 - Install necessary components

Make sure that you install the following components, you may try running PowerShell script to help with installation. You may need to set execution policy to Unrestricted to allow PowerShell script to run.

Set-ExecutionPolicy Unrestricted

imgUnrestricted

./InstallRequiredFeatures.ps1

Step 2 - Obtain files

Step 2 - Restore Database

  • Restore database from the backup file located in C:\inetpub\wwwroot\Demo\db\
USE [master]
RESTORE DATABASE [Demo] 
FROM  DISK = N'C:\inetpub\wwwroot\Demo\db\FileName.bak' --this file will vary depending on the version
WITH  FILE = 1,  
MOVE N'TSOnline_Data' TO N'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\StudioENU_3185404_0406.mdf',  
MOVE N'TSOnline_Log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\StudioENU_3185404_0406_1.ldf',  
NOUNLOAD,  STATS = 5
GO
  • Grant db_owner membership to the webuser
    • Right click on Security-->Logins-->webuser ands elect properties and grant db_owner role UserMapping

Step 4 - Configure Creatio

  • Update redis and db properties in C:\inetpub\wwwroot\Demo\ConnectionStrings.config file, my hostname is K_KRYLOV_NB, you can find out your hostname by executing hostname command in your console. If you need to install follow to this repository or download from here. If you don't want to install redis on your local machine consider running it in docker.
<?xml version="1.0" encoding="utf-8"?>
<connectionStrings>
  <add name="redis" connectionString="host=k_krylov_nb;db=14;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=gs-es; Password=DEQpJMfKqUVTWg9wYVgi;" />
  <add name="influx" connectionString="url=http://10.0.7.161:30359; user=; password=; batchIntervalMs=5000" />
  <add name="db" connectionString="Data Source=K_KRYLOV_NB\SQLEXPRESS;Initial Catalog=Demo;User ID=webuser;Password=webuser;MultipleActiveResultSets=True;Pooling=true;Max Pool Size=100" />
</connectionStrings>

Step 5 - Create WebSite

  • Add Web Site with IIS Manager AddWebsite

  • Add Application inside Demo Web site with IIS manager AddWebsite

Give it a try If all went well, you should see login page and be able to login with:
Username: Supervisor
Password: Supervisor

Related Academy Articles

INSTALLING CREATIO academy article.

Clone this wiki locally