Installation steps on a cloud environment

Applies to: Denodo 7.0 , Denodo 6.0 , Denodo 5.5
Last modified on: 01 Jul 2019
Tags: Installation Cloud Firewall

Download document

Goal

This document describes the steps needed to install and configure the Denodo Platform on a Cloud environment like Amazon EC2, Azure Compute or Google Compute Engine.

Content

Server Side:

1. When creating a new VM instance in EC2 the only additional step you need to do is add a firewall rule. In Step 6 of creating a new instance, click on ‘Add Rule’ and select ‘Custom TCP Rule’ in the ‘Type’ column. Enter the value ‘9996-9999’ and ‘19996-19999’ in the ‘Port Range’ text box and give a source IP. You can also specify another custom rule for the Denodo web container (9090)  and Solutions Manager web container (19090):

Similarly in Google Compute Engine, after creating a new instance add a new firewall rule for Denodo:

You can add the Google Cloud command that includes all ports :

gcloud compute --project=denodo4gcp-dev firewall-rules create denodo --description=Denodo\ Platform\ 7.0\ plus\ ssh --direction=INGRESS --priority=1000 --network=default --action=ALLOW --rules=tcp:9996,tcp:9997,tcp:9998,tcp:9999,tcp:9090,tcp:19996,tcp:19997,tcp:19998,tcp:19999,tcp:19090 --source-ranges=172.16.0.0/25

2. Perform a headless installation of the Denodo Platform (See the Knowledge Base article Headless installation).

3. Next, you have to add an entry to the hosts file. First, get the local IP address with the below command:

$ ifconfig | grep 'inet addr:'| grep -v '127.0.0.1'

You will get an output like below, showing the internal IP address of the server:

inet addr:10.240.84.182  Bcast:10.240.84.182  Mask:255.255.255.255

4. Now you need to add an entry to the hosts file with the match between this IP address and the hostname that will be used for the connections from the clients. This hostname can be either resolvable by the client’s DNS (a public hostname) or a private one. To configure the hosts file follow these steps:

  1. Edit the /etc/hosts file in the Cloud server and add an entry with the private IP and the hostname.

Example of entry with public hostname:

10.240.84.182 ec2-35-35-252-633-compute-1.amazonaws.com

Example of entry with private hostname:

10.240.84.182 denodovm

  1. Add the same value of hostname to the registryURL parameter of the conf/vdp/VDBConfiguration.properties file so it will be look like:

com.denodo.vdb.vdbinterface.server.VDBManagerImpl.registryURL=<hostname>

(replace <hostname> with the hostname used in the previous step)

5. Finally, regenerate the startup scripts and start the VDP server:

$<DENODO_HOME>/bin/regenerateFiles.sh

$<DENODO_HOME>/bin/vqlserver_startup.sh

(replace <DENODO_HOME> with the path configured during installation)

Client Side:

In order for clients to be able to connect to this Denodo running in the Cloud server, they need to be able to resolve the hostname used during the configuration of the server.

If you used a hostname that can be resolved by the client’s DNS (a public hostname) you don’t need to do any additional configuration. However, if the hostname cannot be resolved by the clients, you need to add it to the hosts file of the clients.

As an example, if you are using a private hostname like denodovm, you can follow the next steps:

1. On the client side, you have to add an entry in the hosts file with the public IP of the instance. First, you need to identify the public IP address of your Cloud server. The procedure depends on the Cloud provider that you are using:

Finding the public IP in Google Compute Engine

Finding the public IP in Amazon EC2

2. Then you need to add this public IP address to the hosts file. For example, if the public IP is 146.148.52.51, you can add an entry like the one below:

146.148.52.51 denodovm

(the hosts file location in Linux is /etc/hosts and in Windows: %SYSTEMROOT%\System32\Drivers\etc\hosts)

3. You can now connect to the VDP server using the VDP Administration tool:

connect.png

References

Headless installation of the Denodo Platform: Headless installation

Google Compute Engine: https://cloud.google.com/compute/

Amazon EC2: http://aws.amazon.com/ec2/

Azure Compute: https://azure.microsoft.com/en-us/services/virtual-machines/

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