How to log the requests issued on a VDP server

Applies to: Denodo 7.0 , Denodo 6.0 , Denodo 5.5 , Denodo 5.0
Last modified on: 23 Mar 2018
Tags: Administration Server configuration

Download document

Content

The file vdp-requests.log located under <DENODO_HOME>\logs\vdp can be used to log information about the requests executed on a Virtual DataPort server.

For a single request we will see the following information:

61381 [RMI(14)-192.168.0.45-20] INFO  2018-03-23T11:22:35.524 com.denodo.vdp.requests  - SELECT * FROM phone_inc CONTEXT ('i18n'='us_pst')

where:

  • 61381 is the time since the first log message was written once the server was started.
  • 14 is the connection identifier.
  • 192.168.0.45 is the ip of the client computer.
  • 20 is the session identifier.
  • 2018-03-23T11:22:35.524 is the timestamp when the query was executed.
  • SELECT * FROM phone_inc CONTEXT ('i18n'='us_pst') TRACE  is the request executed.

By default, the information about requests will not be logged. To enable it follow these steps:

  1. Go to the <DENODO_HOME>/conf/vdp folder
  2. Open the log4j.xml file
  3. Replace the lines:

<logger name="com.denodo.vdp.requests">

<level value="error"/>

<appender-ref ref="REQUESTOUT"/>

</logger>

with:

<logger name="com.denodo.vdp.requests">

<level value="info"/>

<appender-ref ref="REQUESTOUT"/>

</logger>


        
Note that the only change is the level value from  "error" to "info”.

  1. Restart the VDP server.

After these changes the requests arriving to the VDP server will be logged to the vdp-requests.log file.

Questions

Ask a question
You must sign in to ask a question. If you do not have an account, you can register here

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training