Page History

The current version of Indeed Log Server supports:

• Windows Event Log
• Microsoft SQL Server
• PostgreSQL Pro

Events can be read from only one source, and recorded to several sources simultaneously.

The read and write sources are configured in the configuration file C:\inetpub\wwwroot\ils\clientApps.config in the <Application Id="pam" SchemaId="Pam.Schema"> section. 

The source for reading events is specified in the tags <ReadTargetId> .. </ReadTargetId>.

Sources for recording events are specified one by one in the <TargetId> .. </TargetId> tags and are listed in the WriteTargets section.

Configuring reading and writing events in the Windows Event Log

Go to the C:\inetpub\wwwroot\ils directory and edit the clientApps.config file by changing the item:

<!--<Application Id="pam" SchemaId="Pam.Schema">
	<ReadTargetId>pamEventLogTarget</ReadTargetId>
    <WriteTargets>
       	<TargetId>pamEventLogTarget</TargetId>
    </WriteTargets>
	<AccessControl>
		<CertificateAccessControl CertificateThumbprint="001122...AA11" Rights="Read" />
	</AccessControl>
</Application>-->

this way:

<Application Id="pam" SchemaId="Pam.Schema">
	<ReadTargetId>pamEventLogTarget</ReadTargetId>
	<WriteTargets>
		<TargetId>pamEventLogTarget</TargetId>
	</WriteTargets>
	<AccessControl>
		<!--<CertificateAccessControl CertificateThumbprint="001122...AA11" Rights="Read" />-->
	</AccessControl>
</Application>

Below, in the Targets section, make sure there is an uncommented line

    <Target Id="Pam.EventLogTarget" Type="eventlog"/>

Setting up reading and writing events in the DBMS

Microsoft SQL Server

1. Go to the directory

1. C:\inetpub\wwwroot\ils\targetConfigs

1. , create a copy of the file sampleDb.config and rename it to mssqlDb.config, then edit the mssqlDb.config file according to the settings below:
   <Settings>… </Settings>:
   • Data Source -

1. •  Name of the Microsoft SQL Server/PostgreSQL Pro server or named instance of Microsoft SQL Server

1. • Initial Catalog - 

1. • database name (ILS)
   • User ID -

1. • service account for working with Indeed PAM databases

   • Password -

1. • service account password

     Code Block
     language xml theme Confluence
     <Settings> <ConnectionString>Data Source=

1. • SQLServer;

1. • Database=ILS;Integrated Security=False;User ID=

1. • IPAMSQLService;Password=Password</ConnectionString> </Settings>

     
     

     Warning
     icon false

1. • If using a named instance of Microsoft SQL Server

1. • , the value of the Data Source parameter must be set in the format <server name>\<instance name>. Code Block language xml

1. • <Settings> <ConnectionString>Data Source=MSSQLServer\Named instance; ... </ConnectionString> </Settings>

     
     

2. In the file C:\inetpub\wwwroot\ils\clientApps.config edit the Application section for work with the mssqlDb.config file:
   

   Code Block
   language xml
   <Application Id="pam" SchemaId="Pam.Schema"> <ReadTargetId>mssqlDb</ReadTargetId> <WriteTargets> <TargetId>mssqlDb</TargetId> </WriteTargets> <AccessControl> <!--<CertificateAccessControl CertificateThumbprint="001122...AA11" Rights="Read" />--> </AccessControl> </Application>

   
   

3. Next in the same file in the Targets section add a new element:
   

   Code Block
   language xml
   <Targets> ... <Target Id="mssqlDb" Type="mssql"/> </Targets>

   
   

PostgreSQL Pro

1. Go to C:\inetpub\wwwroot\ils\targetConfigs directory, create a copy of the file sampleDb.config rename it to postgresDb.config, then edit the postgresDb.config file similar to the settings for Microsoft SQL Server.

2. In the file C:\inetpub\wwwroot\ils\clientApps.config edit the Application section for work with the postgresDb.config file:

   Code Block
   language xml
   <Application Id="pam" SchemaId="Pam.Schema"> <ReadTargetId>postgresDb</ReadTargetId> <WriteTargets> <TargetId>postgresDb</TargetId> </WriteTargets> <AccessControl> <!--<CertificateAccessControl CertificateThumbprint="001122...AA11" Rights="Read" />--> </AccessControl> </Application>

   
   

3. Next, in the same file in the Targets section add a new element:

   Code Block
   language xml
   <Targets> ... <Target Id="postgresDb" Type="pgsql"/> </Targets>

   
   

Configuring event reading in the DBMS, recording events in both the Windows Event Log and the DBMS

1. Go to C:\inetpub\wwwroot\ils\targetConfigs directory, create a copy of the file sampleDb.config, edit it in a way of the type of DBMS used according to the instructions above.

2. In the fileC:\inetpub\wwwroot\ils\clientApps.config edit the Application section this way:

   Code Block
   language xml
   <Application Id="pam" SchemaId="Pam.Schema"> <ReadTargetId>mssqlDb</ReadTargetId> <WriteTargets> <TargetId>mssqlDb</TargetId> <TargetId>Pam.EventLogTarget</TargetId> </WriteTargets> <AccessControl> <!--<CertificateAccessControl CertificateThumbprint="001122...AA11" Rights="Read" />--> </AccessControl> </Application>

   This example shows the configuration for reading events from the Microsoft SQL Server, writing events to the Microsoft SQL Server and Windows Event Log.