Page History

The Indeed Log Server component allows recording events from all Indeed Certificate Manager servers in a unified Windows Event Log or Microsoft SQL Database.

Installation Indeed Log Server

1. Sign in to the workstation as a local administrator.
2. Install the Indeed Log Server by running Indeed.LogServer-x64.msi installer (located in the Indeed.Log.Server directory). 
   • Сopy the cmSchema.config file from the Indeed.Log.Server directory to the C:\inetpub\wwwroot\ls directory.
   • Copy the cmEventLogTarget.config and cmSqlTarget.config files from the Indeed.Log.Server\targetConfigs directory to the C:\inetpub\wwwroot\ls\targetConfigs directory.

Configuring reading and writing events to the Windows event log

1. Edit the configuration file clientApps.config (C:\inetpub\wwwroot\ls\clientApps.config) as follows:

   • In the Application section, add:

     Code Block
     language xml firstline 35
     <Application Id="cm" SchemaId="cmSchema"> <ReadTargetId>cmEventLogTarget</ReadTargetId> <WriteTargets> <TargetId>cmEventLogTarget</TargetId> </WriteTargets> <AccessControl> <!--<CertificateAccessControl CertificateThumbprint="001122...AA11" Rights="Read" />--> </AccessControl> </Application>

     
     

   • In the Targets section add a new element:

     Code Block
     language xml
     <Targets> ... <Target Id="cmEventLogTarget" Type="eventlog"/> </Targets>

     
     

2. Save the changes and close the configuration file.

Configuring event reading and writing in MS SQL

The database for storing Indeed Log Server data is created manually, and it is filled automatically.

1. Create a database with an arbitrary name in the SQL Management Studio environment:
   • In the Object Explorer right-click the Databases tab.
   • Select New database... item from the context menu.
   • Specify the Database name: , e.g., LogServer.

   • In the Owner: field, define the owner of the database being created.

     Info
     Create a new account (say, servicesql) or use any internal SQL account or Active Directory account (e.g., service account to be used with Indeed CM: servicecm). After the database is created, this account would possess db_owner, public privileges and shall be used by the system to perform read/write operations from/to the database.

     
     

   • Save the created database by clicking ОК.
     
     

2. Перейдите в каталог C:\inetpub\wwwroot\ls\targetConfigs и отредактируйте файл cmSqlTarget.config в соответствии с настройками ниже:
   <Settings> … </Settings>:
   • Data Source - имя сервера Microsoft SQL Server или именованного экземпляра Microsoft SQL Server
   • Database - имя базы данных (ILS)
   • User Id - сервисная учётная запись для работы с базами данных Indeed CM

   • Password - пароль сервисной учётной записи

     Code Block
     language xml
     <Settings> <ConnectionString>Data Source=DC\SQLEXPRESS;Database=LogServer;User Id=servicesql;Password=P@ssw0rd</ConnectionString> </Settings>

     
     

     Warning
     icon false
     В случае использования именованного экземпляра Microsoft SQL Server значение параметра Server необходимо задавать в формате <имя сервера>\<имя экземпляра>. Code Block language xml <Settings> <ConnectionString>Server=sql\Named instance; ... </ConnectionString> </Settings>

     
     

3. Отредактируйте Edit the configuration file clientApps.config (C:\inetpub\wwwroot\ls\clientApps.config для работы с файлом ) to working with cmSqlTarget.config as follows:

   • В секции Application добавьте

     In the Application section, add:

     Code Block
     language xml
     <Application Id="cm" SchemaId="cmSchema"> <ReadTargetId>cmSqlTarget</ReadTargetId> <WriteTargets> <TargetId>cmSqlTarget</TargetId> </WriteTargets> <AccessControl> <!--<CertificateAccessControl CertificateThumbprint="001122...AA11" Rights="Read" />--> </AccessControl> </Application>

     
     

   • В секции Targets добавьте новый элементIn the Targets section add a new element:

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

     
     

4. Сохраните изменения и закройте файл конфигурацииSave the changes and close the configuration file.