Logging incoming web requests

Goal

This document shows how to log incoming web requests and their IPs using the embedded Apache Tomcat configuration files.

Content

Denodo Virtual DataPort has an embedded Apache Tomcat server that is used for the web administration tools and also to deploy published web services. In some cases it will be very useful to store in the logs the accessed URLs.

To enable the logging for incoming http requests modify the file 

<SOLUTION_MANAGER_HOME>/resources/apache-tomcat/conf/server.xml (for the Denodo Solution Manager)

and

<DENODO_HOME>/resources/apache-tomcat/conf/server.xml (for the Denodo Platform).

In these files, uncomment the following section that is commented by default:

Once the configuration change is performed, for all Denodo versions, restart the Denodo Platform services.

Once the logging is enabled after executing a request against one of the web services hosted on the Denodo Platform, a log file will be created under

<DENODO_HOME>/logs/apache-tomcat called http_access.<DATE>.log

In the file, a new line for each request with the following pattern will be appended:

<IP> - - <DATE> <HTTP Method> <URL Requested> <HTTP Code> <Size>

For example, after browsing to http://<DENODO_HOST>:<PORT>/denodo-restfulws/admin, something similar to the following line will be added to the log file:

0:0:0:0:0:0:0:1 - - [03/Apr/2024:10:26:11 +0200] "GET /denodo-restfulws/admin HTTP/1.1" 200 1300