You can enable database logging by amending the logging.properties file (located in the /path/to/idm/conf directory).
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