FlowCore 2.0 - Deploy on Windows(System Environment and prerequisites)

>> Deploy

FlowCore 2.0 - Deploy on Windows(System Environment and prerequisites)

FlowCore 2.0 built with .NET 6.0/ASP.NET Core 6.0.
FlowCore includes a .NET cross-platform Kestrel web server, which can be used alone or with a reverse proxy server.
The FlowCore application <runroot> folder contains the ASP.NET Core directory structure.

Hosting on Windows Server:

l Hosting FlowCore with IIS for Windows Server 2022, 2019, 2016.

Hosting on Windows 10, Windows 11:

l Use Windows service to host FlowCore.

(1) Deploy the FlowCore Installation Package

1.1 Download FlowCore 2.0 and unpack the installation package.
Move to the target deployment path, for example <D:\FlowCoreApproot>.

Download the latest version of FlowCore 2.0
www.paicore.com/en/flowcore/downloads/2.0

1.2 Install fonts.
Open the folder <fonts>, select all font files, right-click <install for all users>.

important note

On Windows Server 2022, 2019, 2016, select all font files, right-click< install or all users>.

On Windows 10,11, select all font files, right-click <Show more options>, find <Install for all users>.

1.3 Install dependent programs.
Install Visual C++ 2010 Redistributable dependencies.
Open the FlowCore package <microsoft-visual-c++_redistributable> folder and install <vcredist_x86.exe>.

1.4 Set file system permissions for the FlowCore 2.0 directory structure.
The list of Windows Users group Users file system permissions is as follows. Digital

Path	File system permissions	Purpose
fonts	Read	Font file
license	Read, Write	Store the license file
runroot	Read, execute	ASP.NET Core directory structure
storagePath	Read, Write	Storage path
temp	Read, Write	Temporary folder
certarchive.json	Read	Archive (Digital Certificate Configuration).
cloudstorage.json	Read	Cloud storage configuration (Azure Blob and Amazon S3).
database.json	Read	Configure the database connection

(2) Install the database Microsoft SQL Server or PostgreSQL

FlowCore 2.0 supports three types of databases.

l SQL Server 2022, 2019, 2017。
l SQL Server Express 2022, 2019, 2017 (free for commercial use).
l PostgreSQL 16, 15, 14, 13, 12, 11, 10 (free for commercial use).

2.1 Install Microsoft SQL Server or PostgreSQL database.

SQL Server 2019 download
https://www.microsoft.com/en-us/sql-server/sql-server-downloads
SQL Server 2019 Express download
https://www.microsoft.com/en-us/download/details.aspx?id=101064
SQL Server Management Tools download
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

PostgreSQL download
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

2.2 Create a <FlowCore> database structure.
The FlowCore package, under the <database-sql-statements> folder, contains SQL statements that create the database structure.

2.3.1 SQL Server Database.
Use SQL Server Query Analyzer to execute SQL statements <microsoft-sqlserver.... sql>。
(1) System core data structure.

microsoft-sqlserver_core.sql

(2) Basic presentation workflow (processes design and form templates).

microsoft-sqlserver_demo.sql

2.3.2 PostgreSQL database.
Using PostgreSQL - pgAdmin, execute SQL statements <postgresql.... sql>。
(1) System core data structure.

postgresql_core.sql

(2) Basic presentation workflow (processes design and form templates).

postgresql_demo.sql

(3) Configure SQL Server or PostgreSQL database connections.

Use Notepad to open <database.json > configure the database connection information.
Use SQL Server databases: DatabaseType is <empty string> or <SQLServer>.
Use a PostgreSQL database: DatabaseType is <PostgreSQL>.

Important: In the JSON configuration file, use two <\\> to represent a <\>.

{
  "DatabaseType": "",
  "ConnectionStrings": {
    "SQLServer": "database=FlowCore; Data Source=localhost; User ID=sa; password=YourPassword; Connect Timeout=60",
    "PostgreSQL": "Database=FlowCore; Host=localhost; Username=postgres; Password=YourPassword"
  }
}

SQL Server Knowledge Point

You can install and run multiple instances of SQL Server on a single computer.
Instances are further divided into <default instance> and <named instance>, and there is at most one <default instance> on a computer, <the default instance> has no specific name.
If you want to access SQL Server <default instance>, use <computer name, localhost, or IP address>.
If you want to access SQL Server <named instance>, use the <computer name, localhost, or IP address>\\<instance name>.

Example (1) SQL Server is installed locally as the default instance, and the Data Source is as follows:
localhost
Example (2) SQL Server Expres is installed locally, the instance name is <SQLEXPRESS>, and the Data Source is as follows:
localhost\\SQLEXPRESS
Example (3) The SQL Server server IP address is "10.1.2.3", the instance name is <MSSQL>, and the Data Source is as follows:
10.1.2.3\\MSSQL