How to Connect to the Cluster from External Network
You can also connect to the TIBCO ComputeDB cluster from a different network as a client (DbVisualizer, SQuirreL SQL etc.). For example, to connect to a cluster on AWS from your local machine set the following properties in the conf/locators and conf/servers files:
client-bind-address: Set the hostname or IP address to which the locator or server listens on, for JDBC/ODBC/thrift client connections.
hostname-for-clients: Set the IP address or host name that this server/locator sends to the JDBC/ODBC/thrift clients to use for the connection. The default value causes the
client-bind-addressto be given to clients. This value can be different from
client-bind-addressfor cases where the servers/locators are behind a NAT firewall (AWS for example) where
client-bind-addressneeds to be a private one that gets exposed to clients outside the firewall as a different public address specified by this property. In many cases, this is handled by the hostname translation itself, that is, the hostname used in
client-bind-addressresolves to internal IP address from inside and to the public IP address from outside, but for other cases, this property is required.
By default, the locator or server binds to localhost. You may need to set either or both these properties to enable connection from external clients. If not set, external client connections may fail.
Port Settings: Locator or server listens on the default port 1527 for client connections. Ensure that this port is open in your firewall settings.
You can also change the default port by setting the
client-portproperty in the conf/locators and conf/servers.
For ODBC clients, you must use the host and port details of the server and not the locator.