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 databaseportNumber
is the port number of the machine hosting the log database (the default is3306
)
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