{"type":"doc","content":[{"type":"paragraph"},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"cb3eb68a-33c3-439c-836a-9390dfefe99a"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"79e6a9ee-d1af-445f-903f-5278f56b5a8c"}},{"type":"heading","attrs":{"level":1},"content":[{"text":"Defaults","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]},{"type":"paragraph","content":[{"text":"For both the GUI and the CLI, there is logging to the console. Both the GUI and the CLI are configured to send log messages at level DEBUG and above to file ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":"daticaldb.log","type":"text","marks":[{"type":"code"}]},{"text":". ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]},{"type":"paragraph","content":[{"text":"The system also automatically creates date-stamped versions of the ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":"daticaldb.log","type":"text","marks":[{"type":"code"}]},{"text":" file. It automatically deletes log files older than 30 days.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]},{"type":"heading","attrs":{"level":1},"content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"_Toc356829782"},"legacyAnchorId":{"value":"ConfiguringLogginginLiquibaseEnterprise-_Toc356829782"}},"macroMetadata":{"macroId":{"value":"e6a3d231-d230-4a2f-945b-670ff1f38ded"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"91cb81f0-687e-4179-bbe4-3c2e3651d286"}},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"_Toc492882596"},"legacyAnchorId":{"value":"ConfiguringLogginginLiquibaseEnterprise-_Toc492882596"}},"macroMetadata":{"macroId":{"value":"df9082cb-3876-4619-ab22-88117f0a5d7b"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"271cb954-54c8-44a8-9d58-d7a1e075dd9d"}},{"text":"Logging Systems","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]},{"type":"paragraph","content":[{"text":"The logging systems (SLF4J and Logback) define basic logging concepts.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"_Toc356829783"},"legacyAnchorId":{"value":"ConfiguringLogginginLiquibaseEnterprise-_Toc356829783"}},"macroMetadata":{"macroId":{"value":"d13d7b24-7146-4ac9-838f-3c8c1d7a292e"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"a663011b-db83-4ecf-8bb7-931f8fd3550e"}},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"_Toc492882597"},"legacyAnchorId":{"value":"ConfiguringLogginginLiquibaseEnterprise-_Toc492882597"}},"macroMetadata":{"macroId":{"value":"f370d501-8ee4-44da-b886-434241764d17"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"e1ed3949-6845-419c-87fe-d39c74ef7695"}},{"text":"Log Levels","type":"text"}]},{"type":"paragraph","content":[{"text":"SLF4J defines logging levels. The levels are used during development and at runtime. When a developer puts a line in the code to log a message, they select the level of that message. At run time, the logging system presents log messages at the level selected.","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":1800.0,"localId":"76be5716-cf61-4762-8205-89144d3d042c"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[214.0]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"Log Level","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}},{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1585.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}},{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[214.0]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"ALL","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1585.0]},"content":[{"type":"paragraph","content":[{"text":"When set, messages from all logging levels will be recorded in the configured logs.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[214.0]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"ERROR","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1585.0]},"content":[{"type":"paragraph","content":[{"text":"This level will only record error or exception messages to the log.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[214.0]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"WARNING","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1585.0]},"content":[{"type":"paragraph","content":[{"text":"This level is used to communicate application conditions that could lead to an error. Also includes ERROR messages.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[214.0]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"INFO","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1585.0]},"content":[{"type":"paragraph","content":[{"text":"This level is used to communicate general information about application usage. Also includes ERROR & WARNING messages.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[214.0]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"DEBUG","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1585.0]},"content":[{"type":"paragraph","content":[{"text":"This level includes more specific information about the operation environment to assist in diagnosing runtime issues in errors. Also includes ERROR, WARNING & INFO messages.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[214.0]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"TRACE","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1585.0]},"content":[{"type":"paragraph","content":[{"text":"This level is available, but not used in Datical DB. The output is identical to the DEBUG option.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[214.0]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"OFF","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1585.0]},"content":[{"type":"paragraph","content":[{"text":"Turns off all logging.","type":"text"}]}]}]}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":2},"content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"_Toc356829784"},"legacyAnchorId":{"value":"ConfiguringLogginginLiquibaseEnterprise-_Toc356829784"}},"macroMetadata":{"macroId":{"value":"acd844ff-076e-41d9-8645-f15d72bcdd61"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"f2ea7ec6-5435-408a-8e83-64063bfe7b21"}},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"_Toc492882598"},"legacyAnchorId":{"value":"ConfiguringLogginginLiquibaseEnterprise-_Toc492882598"}},"macroMetadata":{"macroId":{"value":"b6d39ff5-a234-4a0c-97b8-cef58e9b1936"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"bb882ca1-2299-41c5-8a43-8bf2b6366ab0"}},{"text":"Configuring Other Aspects of Logging","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Locations","type":"text"}]},{"type":"paragraph","content":[{"text":"The two logging configuration files are located in your product installation directories.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"For desktop client/Eclipse GUI operations: ","type":"text"},{"text":"/logging-config.xml","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"For command line/hammer operations: ","type":"text"},{"text":"/repl/logging-config.xml","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Main Logger","type":"text"}]},{"type":"paragraph","content":[{"text":"The main logger to adjust is the liquibase logger and this line:","type":"text"}]},{"type":"codeBlock","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"Update to:","type":"text"}]},{"type":"codeBlock","content":[{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Full Sample File","type":"text"}]},{"type":"paragraph","content":[{"text":"Expand open below to see a sample logging-config.xml file:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\n\n\n\n \n\n\nOFF\n \n\n\n\n%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n\n\n\n\n\n\n\ndaticaldb.log\n\n \n\nDEBUG\n \n\n \n\n\ndaticaldb.%d{yyyy-MM-dd}.log\n\n\n30\n\n\n \n\n%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n\n\n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Modification Example ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#33475b"}}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"How to include the date in the timestamps in daticaldb.log","type":"text","marks":[{"type":"textColor","attrs":{"color":"#33475b"}}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"For that example, you would find both of the lines in your logging-config.xml files that by default have this:","type":"text","marks":[{"type":"textColor","attrs":{"color":"#33475b"}}]}]}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n","type":"text","marks":[{"type":"textColor","attrs":{"color":"#33475b"}}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"And replace it with this instead on both lines:","type":"text","marks":[{"type":"textColor","attrs":{"color":"#33475b"}}]}]}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Upgrade Note","type":"text","marks":[{"type":"textColor","attrs":{"color":"#33475b"}}]}]},{"type":"paragraph","content":[{"text":"If you modify your logging-config.xml files, note that when you upgrade to a newer version of Liquibase Enterprise/Datical DB in the future that the new installation directory will have the default logging-config.xml. So you will need to modify the logging-config.xml files in your installation of your newer Liquibase Enterprise version after each upgrade.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#33475b"}}]}]}],"version":1}

Browser not supported