enable teiid logging 8.6

[gadeyne.bram]

Hi,

I'm trying to enable logging for Teiid 8.6. I've setup a very basic standalone version. I assume that I have to alter the standalone-teiid.xml file to enable logging.

At startup some org.teiid.RUNTIME and CONNECTOR INFO log messages appear. I'd like to enable some additional loggers like SECURITY.

Below is my full logging configuration. However no Security or other messages appear in my log file while executing query's. Do I need to alter some other files?

<subsystem xmlns="urn:jboss:domain:logging:1.2">

            <console-handler name="CONSOLE">

                <level name="INFO"/>

                <formatter>

                    <pattern-formatter pattern="%d{HH:mm:ss,SSS} %-5p [%c] (%t) %X{teiid-session} %s%E%n"/>

                </formatter>

            </console-handler>

            <periodic-rotating-file-handler name="FILE" autoflush="true">

                <formatter>

                    <pattern-formatter pattern="%d{HH:mm:ss,SSS} %-5p [%c] (%t) %X{teiid-session} %s%E%n"/>

                </formatter>

                <file relative-to="jboss.server.log.dir" path="server.log"/>

                <suffix value=".yyyy-MM-dd"/>

                <append value="true"/>

                <level name="INFO" />

            </periodic-rotating-file-handler>

            <logger category="com.arjuna">

                <level name="WARN"/>

            </logger>

            <logger category="org.apache.tomcat.util.modeler">

                <level name="WARN"/>

            </logger>

            <logger category="org.jboss.as.config">

                <level name="DEBUG"/>

            </logger>

            <logger category="sun.rmi">

                <level name="WARN"/>

            </logger>

            <logger category="jacorb">

                <level name="WARN"/>

            </logger>

            <logger category="jacorb.config">

                <level name="ERROR"/>

            </logger>

            <logger category="org.teiid">

                <level name="INFO"/>

                <handlers>

                    <handler name="FILE" />

                </handlers>

            </logger>

            <root-logger>

                <level name="INFO"/>

                <handlers>

                    <handler name="CONSOLE"/>

                    <handler name="FILE"/>

                </handlers>

            </root-logger>

        </subsystem>

Kind regards,

Bram

[rareddy]

Bram,

Here is list of all the logging contexts in Teiid. https://github.com/teiid/teiid/blob/master/api/src/main/java/org/teiid/logging/LogConstants.java

Enable log at "DEBUG" level, you will see SECURITY and other context based messages. You can fine tune by adding specific context too.

Ramesh..

[tom9729]

Bram,

It may just be that there aren't many SECURITY messages logged at INFO. For example, at info I pretty much only see SECURITY messages during startup or when connections die. Try changing your log level to DEBUG or TRACE (don't forget to also do the same for your handlers).

Also you may be interested in AUDIT logging (Logging - Teiid 8.7 (draft) - Project Documentation Editor).

[gadeyne.bram]

Thank You!

This indeed works fine. The DEBUG messages will suffice.

Kind regards

Bram