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

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.

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 (e.g. cfServiceSQL).
• 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.

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. 

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 (e.g. cfServiceSQL).

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

When creating a service account, you must disable password expiration.

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

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 the Axidian CertiFlow installation package (\IndeedCM.Server\Misc).change

1. Create a database in the 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 (e.g. CertiFlowDB). Select the created service account in the Owner list and click Save.

2. Select the database (CertiFlowDB) 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.

• Click Execute/Refresh button .

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

• Press  button in Query Tool menu and select Clear Query.

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

Setting up a remote connection to the database

Open the PostgreSQL configuration file pg_hba.conf.

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:

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.