Page History

The Indeed Log Server component allows recording events from all Indeed Certificate Manager servers in a unified 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 ОК.
     

     Scroll Pagebreak

     
     
     

2. Перейдите в каталог Edit the cmSqlTarget.config file (C:\inetpub\wwwroot\ls\targetConfigs и отредактируйте файл \cmSqlTarget.config в соответствии с настройками ниже) according to the settings below:
   <Settings> … </Settings>:
   • Data Source - имя сервера Microsoft SQL Server или именованного экземпляра Microsoft SQL Server this defines the server instance. The parameter is mandatory for all connections. Admissible values are: network name or server IP address, local or  localhost for local connections
   • Database - database name Database - имя базы данных (ILS)
   • User Id - сервисная учётная запись для работы с базами данных Indeed CM the service account name to connect to the database

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

     <Settings> <ConnectionString>Server=sql\Named instance; ... <

     /ConnectionString>
     </Settings>

     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

     
     

3. Edit the configuration file clientApps.config (C:\inetpub\wwwroot\ls\clientApps.config) to working with cmSqlTarget.config as follows:

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

     
     

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