How to enable debug logging permanently

Introduction

In the cases where you need to have a closer look at what the table grid editor is executing in the background, you can enable logging as described in this article.

Open the log4j.properties file using a text editor such as notepad++ (windows) or vi (unix) and paste following properties
to the end of the file.  This file is located under <JIRA installation>/atlassian-jira/WEB-INF/classes/ (for JIRA standalone versions)

Steps to enable logging 

Jira 6.0 and further

##################################################### # IDALKO DEV LOGGING JIRA 6.0 and higher ##################################################### log4j.appender.igridlog=com.atlassian.jira.logging.JiraHomeAppender log4j.appender.igridlog.File=igrid-dev.log log4j.appender.igridlog.MaxFileSize=20480KB log4j.appender.igridlog.MaxBackupIndex=5 log4j.appender.igridlog.layout=org.apache.log4j.PatternLayout log4j.appender.igridlog.layout.ConversionPattern=[%d] <%c{1}> %m%n   log4j.logger.com.idalko = DEBUG, igridlog, console log4j.additivity.com.idalko = false # # Disable some verbose classes #   log4j.logger.com.idalko.jira.plugins.igrid.providers.hibernate.tasks.HibernateTask = OFF log4j.logger.com.idalko.jira.plugins.igrid.license.PluginLicenseManagerImpl = OFF # # Sql log logs all sql statements sent to the database server # log4j.appender.isqllog=com.atlassian.jira.logging.JiraHomeAppender log4j.appender.isqllog.File=igrid-sql.log log4j.appender.isqllog.MaxFileSize=20480KB log4j.appender.isqllog.MaxBackupIndex=5 log4j.appender.isqllog.layout=org.apache.log4j.PatternLayout log4j.appender.isqllog.layout.ConversionPattern=[%d] <%c{1}> %m%n log4j.logger.org.hibernate.SQL = DEBUG, isqllog log4j.additivity.org.hibernate.SQL = false log4j.logger.org.hibernate.tool.hbm2ddl = DEBUG, isqllog log4j.additivity.org.hibernate.tool.hbm2ddl = false log4j.logger.org.hibernate.util = DEBUG, isqllog log4j.additivity.org.hibernate.util = false log4j.logger.org.hibernate.tool.hbm2ddl.SchemaUpdate = DEBUG, isqllog log4j.additivity.org.hibernate.tool.hbm2ddl.SchemaUpdate = false



Jira 4.4 and further

##################################################### # IDALKO DEV LOGGING JIRA 4.4 and higher ##################################################### log4j.appender.igridlog=com.atlassian.jira.logging.MultiTenantJiraHomeAppender log4j.appender.igridlog.File=igrid-dev.log log4j.appender.igridlog.MaxFileSize=20480KB log4j.appender.igridlog.MaxBackupIndex=5 log4j.appender.igridlog.layout=org.apache.log4j.PatternLayout log4j.appender.igridlog.layout.ConversionPattern=[%d] <%c{1}> %m%n log4j.appender.isqllog=com.atlassian.jira.logging.MultiTenantJiraHomeAppender log4j.appender.isqllog.File=igrid-sql.log log4j.appender.isqllog.MaxFileSize=20480KB log4j.appender.isqllog.MaxBackupIndex=5 log4j.appender.isqllog.layout=org.apache.log4j.PatternLayout log4j.appender.isqllog.layout.ConversionPattern=[%d] <%c{1}> %m%n log4j.logger.com.idalko = INFO, igridlog, console log4j.additivity.com.idalko = false log4j.logger.org.hibernate.SQL = INFO, isqllog log4j.additivity.org.hibernate.SQL = false log4j.logger.org.hibernate.tool.hbm2ddl = INFO, isqllog log4j.additivity.org.hibernate.tool.hbm2ddl = false log4j.logger.org.hibernate.util = INFO, isqllog log4j.additivity.org.hibernate.util = false log4j.logger.org.hibernate.tool.hbm2ddl.SchemaUpdate = INFO, isqllog log4j.additivity.org.hibernate.tool.hbm2ddl.SchemaUpdate = false

Jira 4.2

##################################################### # IDALKO DEV LOGGING JIRA 4.2 ##################################################### log4j.appender.igridlog=org.apache.log4j.RollingFileAppender log4j.appender.igridlog.File=igrid-dev.log log4j.appender.igridlog.MaxFileSize=20480KB log4j.appender.igridlog.MaxBackupIndex=5 log4j.appender.igridlog.layout=org.apache.log4j.PatternLayout log4j.appender.igridlog.layout.ConversionPattern=[%d] <%c{1}> %m%n log4j.appender.isqllog=org.apache.log4j.RollingFileAppender log4j.appender.isqllog.File=igrid-sql.log log4j.appender.isqllog.MaxFileSize=20480KB log4j.appender.isqllog.MaxBackupIndex=5 log4j.appender.isqllog.layout=org.apache.log4j.PatternLayout log4j.appender.isqllog.layout.ConversionPattern=[%d] <%c{1}> %m%n log4j.logger.com.idalko = INFO, igridlog, console log4j.additivity.com.idalko = false log4j.logger.org.hibernate.SQL = INFO, isqllog log4j.additivity.org.hibernate.SQL = false log4j.logger.org.hibernate.tool.hbm2ddl = INFO, isqllog log4j.additivity.org.hibernate.tool.hbm2ddl = false log4j.logger.org.hibernate.util = INFO, isqllog log4j.additivity.org.hibernate.util = false log4j.logger.org.hibernate.tool.hbm2ddl.SchemaUpdate = INFO, isqllog log4j.additivity.org.hibernate.tool.hbm2ddl.SchemaUpdate = false

 

Â