Toggle database publishing details on and off in server.log?

Rhythmyx Technical Discussion
1

We have a lot of detailed output from database publishing in our server.log. It logs each SQL transaction, as in this example:
…
2009-07-13 11:27:44,447 INFO [STDOUT] [Debug] UPDATE dbo.MW_SEMINAR_LOCATIONS SET country=?, state=?, name=?, city=? WHERE CONTENTID=?
2009-07-13 11:27:44,447 INFO [STDOUT] [Debug] bind value 0: US
2009-07-13 11:27:44,447 INFO [STDOUT] [Debug] bind value 1: MD
2009-07-13 11:27:44,447 INFO [STDOUT] [Debug] bind value 2: Goddard Space Flight Center
2009-07-13 11:27:44,447 INFO [STDOUT] [Debug] bind value 3: Greenbelt
2009-07-13 11:27:44,447 INFO [STDOUT] [Debug] bind value 4: 38517
…

Is there a way to toggle this detail off until we need it for debugging?

-Kathleen

2

Debug on may not be configurable for database publishing in 6.5.2 or any of the previous releases.

However, this should not be an issue in the latest release 6.7.

If upgrade is not an option and this is a serious issue for you, you may contact Percussion tech support.

3

Now I need to ask this question again, in the context of 6.7.

The detail has disappeared from the server.log, and now I want it back for debugging! Is there a way to configure logging so that I can see the SQL query details for database publishing?

-Kathleen

4

Hello Kathleen,

You will need to make a modification to your log4j.xml located in [RhythmyxRoot]\AppServer\server\rx\conf located the section that is commented out that looks like this:

 <logger name="com.percussion.util.PSSQLStatement">
      <level value="ERROR" />
   </logger>

if you uncomment this section you should then see all sql commands. You should not have to restart the server to see this change.

5

For those of you attempting to capture the same information as we are, a level of DEBUG is necessary.


<logger name="com.percussion.util.PSSQLStatement">
      <level value="DEBUG" />
</logger>

You’ll also need to change the Threshold on the RXFILE appender to a comparable level.


   <appender name="RXFILE" class="org.jboss.logging.appender.RollingFileAppender">
      <errorHandler class="org.jboss.logging.util.OnlyOnceErrorHandler"/>
      <param name="File" value="${jboss.server.home.dir}/../../../console.log"/>
      <param name="Append" value="true"/>
      <param name="Threshold" value="DEBUG"/>
      <param name="MaxFileSize" value="10MB"/>
      <param name="MaxBackupIndex" value="10"/>

      <layout class="org.apache.log4j.PatternLayout">
         <!-- The default pattern: Date Priority [Category] Message
 -->
         <param name="ConversionPattern" value="%d %-5p [%c{1}] %m%n"/>
      </layout>
   </appender>

Fight the urge to lower the log level of the com.percussion logger. You’ll be inundated if you do. The above configuration should be sufficient.


   <!-- Rhythmyx root logger -->
   <logger name="com.percussion">
      <level value="INFO" />
      <appender-ref ref="RXFILE"/>
   </logger>