MicroStrategy ONE

Viewing and Analyzing the S2 Adapter Log

The log database is used to record the activity of the physical access control system adapter. You can analyze the log entries to understand potential issues.

Use a MySQL client to connect to the MySQL log database you set up when preparing to install the S2 NetBox adapter, as described in Integrating S2 NetBox® with MicroStrategy Identity. Then you can execute SQL statements to retrieve information.

The S2 adapter log is stored in the database specified in the WEB-INF/log4j.properties file, as shown in the example below:

log4j.appender.mysql.URL=jdbc:mysql://IPAddress:portNumber/S2?useUnicode=true&characterEncoding=UTF-8

where:

  • IPAddress is the IP address of the machine hosting the log database
  • portNumber is the port number of the machine hosting the log database (the default is 3306)

You can search the logs at different levels to find potential issues. For example, you can check for a log level of FATAL, ERROR, or WARN to find detailed messages using a SQL statement as follows:

Select * from log where level in ('FATAL','ERROR','WARN');

The detailed error stack trace is logged in these levels as well.

Related Topics

Integrating S2 NetBox® with MicroStrategy Identity

Verifying that the S2 Adapter Installation is Correct

Optimizing the S2 Adapter for MicroStrategy Identity

Diagnosing the S2 Adapter Health

Refreshing the S2 Adapter Cache