Postinstallation Tasks in the Denodo Web Container¶
Due to a behavior change in the latest Apache Tomcat versions (the web container of Denodo), you need to perform the following steps:
- Edit the file
- Add the following attribute to all the Connector elements:
relaxedQueryChars=""if needed. Note that some of the Connector elements may have already been automatically updated.
By default, the monitoring interface - Java Management Extensions (JMX) - of the Denodo web container (Apache Tomcat)
does not require authentication to connect to it. Note that by default,
only applications that run in the same host as the Denodo server can connect to this interface.
That is because the value of the property
localhost by default so only connections from that host are allowed.
We recommend enabling authentication in the monitoring interface of the web container, even though only local connections can connect. To do this, follow these steps:
Stop all the Denodo Platform servers. The goal is to stop the web container of Denodo. It is important to stop them all so the Denodo web container is stopped as well. If for example, you leave the Data Catalog started, the web container will not shut down and the changes in the file
tomcat.propertieswill not take effect.
Edit the file
<DENODO_HOME>/resources/apache-tomcat/conf/tomcat.propertiesand set the property
Edit the file
<DENODO_HOME>/resources/apache-tomcat/conf/jmxremote.access(this is the value of the property
Make sure this file contains at least one line for the role
readwriteaccess level. That is, at least one line of this file is like this:
Any other role definitions are optional. See https://docs.oracle.com/javase/8/docs/technotes/guides/management/agent.html for details on JMX access files.
Edit the file
<DENODO_HOME>/resources/apache-tomcat/conf/jmxremote.password(this is the value of the property
In this file, the line that starts with
controlRolecontains the password of that user.
So if the line is like this:
The default password is “denodojmx”. That means that, for a monitoring application that wants to monitor the web container, the user name is
controlRoleand the password
To change the password, replace “denodojmx” with the desired password.
This file must contain an entry for all the roles defined in the file “jmxremote.access”. See https://docs.oracle.com/javase/8/docs/technotes/guides/management/agent.html for details on JMX password files.
Change the privileges of the file
<DENODO_HOME>/resources/apache-tomcat/conf/jmxremote.passwordso it can only be read by the same user account that starts the Denodo servers.
To do this, execute these commands:
- On Linux, run the following from the user account that starts the Denodo servers:
chmod 600 <DENODO_HOME>/resources/apache-tomcat/conf/jmxremote.password
On Windows, right-click the icon Command Prompt of the Windows menu and click Run as administrator.
In these prompt, run the following commands (replace
<denodo_user>with the user account with which the Denodo servers are started):
cd <DENODO_HOME>\resources\apache-tomcat\conf\ icacls jmxremote.password /setowner <denodo_user> icacls jmxremote.password /grant <denodo_user>:F icacls jmxremote.password /inheritance:r