Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
Next revision Both sides next revision
tutorial:adm:czechidm_installation [2020/07/28 09:10]
urbanl predelani navodu pro centos8 		tutorial:adm:czechidm_installation [2021/08/25 08:14]
husniko
Line 17: Line 17:
  
 # Choose appropriate collation and create database. # Choose appropriate collation and create database.
-# with english collation +# with czech collation (- typical)
-CREATE DATABASE "czechidm" WITH OWNER 'czechidm' ENCODING 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8' template 'template0'; +
-# with czech collation+
 CREATE DATABASE "czechidm" WITH OWNER 'czechidm' ENCODING 'UTF8' LC_COLLATE = 'cs_CZ.UTF-8' LC_CTYPE = 'cs_CZ.UTF-8' template 'template0'; CREATE DATABASE "czechidm" WITH OWNER 'czechidm' ENCODING 'UTF8' LC_COLLATE = 'cs_CZ.UTF-8' LC_CTYPE = 'cs_CZ.UTF-8' template 'template0';
 +# or with english collation
 +# CREATE DATABASE "czechidm" WITH OWNER 'czechidm' ENCODING 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8' template 'template0';
 </code> </code>
  
Line 102: Line 102:
 org.quartz.jobStore.tablePrefix=qrtz_ org.quartz.jobStore.tablePrefix=qrtz_
 </file> </file>
-  * The **/opt/czechidm/etc/logback-spring.xml** specifies logging configuration. This is the default logging configuration that you can use out of the box.<file xml logback-spring.xml>+  * The **/opt/czechidm/etc/logback-spring.xml** specifies logging configuration. This is the default logging configuration that you can use out of the box. 
 + 
 +<file xml logback-spring.xml>
 <?xml version="1.0" encoding="UTF-8"?> <?xml version="1.0" encoding="UTF-8"?>
 <!-- https://springframework.guru/using-logback-spring-boot/ --> <!-- https://springframework.guru/using-logback-spring-boot/ -->
 <!-- http://logback.qos.ch/manual/appenders.html --> <!-- http://logback.qos.ch/manual/appenders.html -->
 <configuration> <configuration>
 +    <!-- !!!BEWARE!!! The specification of the LOG PATTERNS overrides the default configuration and increases the maximum length of the %logger{<size>} attribute. 
 +    It is neccessary for correct function of the AUDIT logging feature (redmine ticket #2717). If AUDIT logger key is longer then the set limit it gets shortened 
 +    and SIEM software is not able to parse logs properly. -->
 +    <property name="CONSOLE_LOG_PATTERN" value="%d{yyyy-MM-dd HH:mm:ss.SSS} %5level %relative --- [%thread] %logger{60}.%M : %msg%n"/>
 +    <property name="FILE_LOG_PATTERN" value="%d{yyyy-MM-dd HH:mm:ss.SSS} %5level %relative --- [%thread] %logger{60}.%M : %msg%n"/>
 +
     <include resource="org/springframework/boot/logging/logback/base.xml"/>     <include resource="org/springframework/boot/logging/logback/base.xml"/>
     <springProperty name="spring.profiles.active" source="spring.profiles.active"/>     <springProperty name="spring.profiles.active" source="spring.profiles.active"/>
Line 115: Line 123:
         <logger name="org.hibernate.SQL" level="INFO"/>         <logger name="org.hibernate.SQL" level="INFO"/>
         <logger name="org.hibernate.type.descriptor.sql.BasicBinder" level="INFO"/>         <logger name="org.hibernate.type.descriptor.sql.BasicBinder" level="INFO"/>
 +        <logger name="AUDIT" level="ERROR"/>
     </springProfile>     </springProfile>
  
Line 123: Line 132:
         <springProperty name="spring.datasource.password" source="spring.datasource.password"/>         <springProperty name="spring.datasource.password" source="spring.datasource.password"/>
  
-        <appender name="DB" class="ch.qos.logback.classic.db.DBAppender">+        <appender name="DB" class="eu.bcvsolutions.idm.core.exception.IdmDbAppender">
             <connectionSource class="ch.qos.logback.core.db.DriverManagerConnectionSource">             <connectionSource class="ch.qos.logback.core.db.DriverManagerConnectionSource">
                 <driverClass>${spring.datasource.driver-class-name}</driverClass>                 <driverClass>${spring.datasource.driver-class-name}</driverClass>
Line 144: Line 153:
         <logger name="org.hibernate.SQL" level="INFO"/>         <logger name="org.hibernate.SQL" level="INFO"/>
         <logger name="org.hibernate.type.descriptor.sql.BasicBinder" level="INFO"/>         <logger name="org.hibernate.type.descriptor.sql.BasicBinder" level="INFO"/>
 +        <logger name="AUDIT" level="ERROR"/>
  
     </springProfile>     </springProfile>
  • by kralikf