Configure System Network Settings
This section describes the network settings that are required for the installation and operation of the database, and the details of the default ports.
Firewall
The firewall settings are described in the following sections.
Installation
Allow the following for the installation of the Exasol database:
- SSH access to the license node (TCP port 20 + 22)
- LOM access to the license node (KVM, Exasol installation ISO mounted)
- LOM access to the data nodes (KVM) HTTP/S access to all cluster nodes (EXAoperation web UI ,TCP 80/443). The web UI is running as a cluster service and can be accessed from any cluster node.
Operation
Allow the following for the operation of the Exasol database:
- Database port clients use to connect to the database (default TCP 8563)
- HTTP/S access to all cluster nodes (EXAoperation web UI, TCP 80/443)
- SSH access to all cluster members (TCP port 20 + 22)
- To get most out of the web UI each cluster node should be able to access the LOM of each other (ipmitool is used for providing basic hardware vitality information)
- NTP (TCP/UDP 123)
- DNS (TCP/UDP 53)
- optional: LDAP (TCP/UDP 389)
Default Ports
Many of the following protocols and DBMSs can be manually configured to use different ports.
The File Transfer Protocol (FTP) data connections require additional ports to be available (depending on the transfer mode).
Incoming Ports
Protocol | Port | Source | Destination | Description |
---|---|---|---|---|
TCP | 8563 | Exasol Client | Exasol database nodes | Exasol server port |
TCP | Range from 20000 to 21000 | Exasol database nodes (source) | Exasol database nodes (target) | Exasol subconnection ports (for EXA-to-EXA loading) |
TCP | 443 | Customer network / Exasol support VPN | EXAoperation | Web front-end |
TCP | 22 | Customer network / Exasol support VPN | Exasol Operating System | Shell access |
TCP | 2580 | Exasol Client | Exasol database nodes |
Default BucketFS service For each BucketFS service you create, a port (HTTP or HTTPs) must be assigned to access it. |
Outgoing Ports
Protocol | Port | Source | Destination | Description |
---|---|---|---|---|
TCP | 8563 | Exasol database nodes | Exasol database client | Exasol database client connection port |
TCP | Range from 20000 to 21000 | Exasol database nodes (source) | Exasol database nodes (target) | Exasol subconnection ports (for EXA-to-EXA loading) |
TCP | 20 | Exasol database nodes | FTP server | FTP data port for IMPORT/EXPORT |
TCP | 21 | Exasol database nodes | FTP server | FTP command port for IMPORT/EXPORT |
TCP | 22 | Exasol database nodes | SFTP server | SFTP port for IMPORT/EXPORT |
TCP | 80 | Exasol database nodes | HTTP server | HTTP port for IMPORT/EXPORT |
TCP | 443 | Exasol database nodes | HTTPS server | HTTPS port for IMPORT/EXPORT |
TCP | 990 | Exasol database nodes | FTPS server | FTPS port for IMPORT/EXPORT |
TCP | 389 | Exasol nodes | LDAP server | LDAP port |
TCP | 636 | Exasol nodes | LDAPS server | LDAPS port |
TCP | 123 | Exasol nodes | NTP server | NTP port |
TCP | 53 | Exasol nodes | DNS server | DNS port |
TCP | 1521 | Exasol database nodes | Oracle database | Oracle server port (JDBC/ORA connection) |
TCP | 1433 | Exasol database nodes | SQL Server database | SQL Server port (JDBC connection) |
TCP | 3306 | Exasol database nodes | MySQL database | MySQL server port (JDBC connection) |
TCP | 50000 | Exasol database nodes | DB2 database | DB2 server port (JDBC connection) |
TCP | 5432 | Exasol database nodes | PostgreSQL database | PostgreSQL server port (JDBC connection) |
TCP | 5000 | Exasol database nodes | Sybase ASE database | Sybase ASE server port (JDBC connection) |