Page History

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.

Image Removed

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.

Image Removed

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. 

Image Removed

• 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.

Image Removed

4. Go to General tab and enter the role name in the Name field (e.g. cfServiceSQL).

Image Removed

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

Image Removed

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

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

   Image Removed

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.

Image Removed

• 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.

Image Removed

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

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

Image Removed

• Click Execute/Refresh button Image Removed.

Image Removed

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

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

Image Removed

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

Setting up a remote connection to the database

Open the PostgreSQL config 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:

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.