By default, an Exasol virtual machine (VM) is configured to use a host-only network. This configuration allows to access the database and the EXAoperation management interface locally from the host machine. Nevertheless, this configuration prevents the use of publically available hosts and services on the internet from the virtual machine. This How-To provides information about configuring Exasol to be able to access the internet and enables users to:
use DNS to access publicly reachable servers for making backups or in database IMPORT/EXPORT statements
use LDAP servers of your choice for database or EXAoperation accounts
use standard repositories for the installation of UDF packages
use the Exasol Version Check (only if this feature has not been disabled)
If not already done, import the Exasol OVA file into the VM tool of your choice (in Virtualbox: File -> Import Appliance). Accept the "End User License Agreement" and the "Privacy Statement" and wait until the image has been successfully loaded.
How to enable internet access for Exasol Community Edition
Configuration of VM network
Now, a new VM has been created. Change its network settings to use NAT (in Virtualbox: right click on VM -> Settings -> Network -> Adapter 1 -> Attached to NAT)
Define port forwardings to guest ports 8563 (database) and 443 (EXAoperation management interface) (in Virtualbox: Adapter 1 -> Port Forwarding -> Add rule -> Host Port 8563 and Guest Port 8563 -> Add rule -> Host Port 4443 and Guest Port 443). The port forwarding rules will enable you to use the VM from the physical host machine.
Start the VM and wait until Exasol is up and running.
Configuration of DNS server
Browse to EXAoperation and login.
Go to Network. In the System tab, click on "Edit".
Add one or two DNS servers reachable from the VM (e.g. "126.96.36.199" for an environment that can reach internet DNS servers) and click "Apply".
Firewalls and/or company proxy servers may block or restrict traffic to internet hosts.