This section describes ways to create Axidian CertiFlow data stores in:

Microsoft SQL
Postgre SQL

Microsoft SQL

The database used as data storage is created manually. To populate the database, use the Storage.sql script included in the Axidian CertiFlow installation package (\IndeedCM.Server\Misc).CHANGE

Creating a database

1. Create a database in SQL Management Studio environment with an arbitrary name:

In Object Explorer, right-click on Databases tab.
Select New Database.
Specify the Database Name (e.g. CertiFlowDB) and click OK.

Axidian CertiFlow Documentation > Data storage creation > createsqlstorage.png

2. Use a local SQL account (for example, cfServiceSQL) or Windows domain account and define permissions for your database. This account will be used to perform read and write operations to the database. You can connect this account to the database in Axidian CertiFlow Setup Wizard.

Define Logins for the created database.
Click Security→Logins, select an account from the list.
Go to User Mapping tab.
Grant permissions for the selected login to work with the database, specify permissions: db_owner and public.
Click OK.

Axidian CertiFlow Documentation > Data storage creation > sqlpermissions.png

3. Select the created database in Object Explorer and execute the Storage.sql script:

Choose File→Open→File (or Ctrl+O), specify the path to Storage.sql file (located in ..\IndeedCM.Server\Misc CHANGE directory) and click Open.
Before executing the script, uncomment: --USE [<database name>] --GO and specify the name of the database for which the script is applied (CertiFlowDB): --USE [CertiFlowDB] --GO. Or select the required database in the drop-down menu.
Click Execute.

Axidian CertiFlow Documentation > Data storage creation > populatedatabase.png

Postgre SQL

Creating a service account

To enable the Axidian CertiFlow system to operate with the database, create a service account and grant it the required permissions:

1. Open pgAdmin, enter master password and connect to server.
2. In Browser section right-click on Login/Group Roles menu item.
3. Select Create→Login/Group Role.

4. Go to General tab and enter the role name in the Name field.

Axidian CertiFlow Documentation > Data storage creation > Create user-role Name.png

5. Go to Definition tab and enter your password in the Password field. Account expires field should be set to No Expiry.

Axidian CertiFlow Documentation > Data storage creation > Create user-role Password.png

When creating a service account, disable password expiration.

6. Go to Privileges tab and turn on the Can Login? parameter.

Axidian CertiFlow Documentation > Data storage creation > Create user-role Privileges.png

7. Leave the rest of the fields with default values and click Save.

Creating a database

The database used as data storage is created manually. To populate the database, use the Storage-Postgre.sql script included in Axidian CertiFlow installation package (\IndeedCM.Server\Misc).CHANGE

1. Create a database in pgAdmin environment with an arbitrary name:

In Browser section right-click on Databases menu item.
Select Create→Database.

Go to General tab and enter a name in the Database field. Select the created service account in the Owner list and click Save.

Axidian CertiFlow Documentation > Data storage creation > CreateDBNameOwner.png

2. Select the database in Browser section and execute the Storage-Postgre.sql script:

Select Tools→Query Tool.
Click on Open iconin Query Tool menu and specify a path to the file Storage-Postgre.sql (\IndeedCM.Server\Misc CHANGE), click Select.

Axidian CertiFlow Documentation > Data storage creation > OpenFile.png

Click Execute/Refresh button .

Axidian CertiFlow Documentation > Data storage creation > ExecuteScript.png

3. Grant privileges to service account for the database tables:

Press button in Query Tool menu and select Clear Query.

Axidian CertiFlow Documentation > Data storage creation > clear_query_eng.png

Enter the text of the request, specifying the account name:

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO "specify service account";

Example:

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO cfServiceSQL;

Setting up a remote connection to the database

Open the PostgreSQL configuration file pg_hba.conf.

pb_hba.conf file location:

For Windows OS: C:\Program Files\PostgreSQL\<version number>\data

For *nix OS: /etc/postgresql/<version number>/main

Add a line with the following format:

CONNECTIONTYPE DATABASE USER ADDRESS METHOD

Where values are referred to as:

CONNECTIONTYPE – connection type. "Host" is specified, TCP/IP connection is used.
DATABASE – name of the database.
USER – database user name.
ADDRESS – IP-address of the Axidian CertiFlow Server.
METHOD – user authentication method.

Example:

host CertiFlowDB cfServiceSQL 192.200.1.0/32 md5