How To
ForgeRock Identity Platform
Does not apply to Identity Cloud

How do I enable database logging in IDM (All versions)?

Last updated Apr 8, 2021

The purpose of this article is to provide information on enabling database logging in IDM. Database logging is useful for troubleshooting query related performance issues.


Enabling database logging

You can enable database logging by amending the logging.properties file (located in the /path/to/idm/conf directory).

Note

All the examples show the level being set to FINEST, which is the most detailed logging level and recommended for troubleshooting; however, you can also set them to FINER, FINE, CONFIG, INFO, WARNING and SEVERE (least detailed) to achieve different levels of logging.

You can change the global logging level to FINEST (although this affects all logging) by amending the .level value as follows:

.level=FINEST

Alternatively, you can set logging levels for specific items to override the global level:

  • To set logging to FINEST for JDBC databases only, you can add the following line: org.forgerock.openidm.repo.jdbc.level = FINEST
  • Where the logging entries are being generated by the Microsoft® SQL driver rather than IDM, you need to add the following line instead: com.microsoft.sqlserver.jdbc.level = FINEST

See Also

How do I enable OpenICF logging for the .NET Connector Server in IDM (All versions) to investigate server crashes?

How do I add logging to JavaScript files in IDM (All versions)?

How do I add logging to Groovy scripts in IDM (All versions)?

Related Training

ForgeRock Identity Management Core Concepts (IDM-400)

Related Issue Tracker IDs

N/A


Copyright and Trademarks Copyright © 2021 ForgeRock, all rights reserved.