In the Database Connection/SSH Settings category under the General tab, you can specify: If you use the SSH Tunnel feature, you may also want to configure a few things in Tools->Tool Properties. The URL that is used for the connection is shown at the top of the Object View tab for the database connection when a connection is established, along with a certificate icon if the connection is made through an SSH tunnel.
#Dbvisualizer kerberos driver#
like this for the Oracle Thin driver when is other words, the JDBC driver connects to the SSH tunnel's local port, which then forwards all communication to the database server. The JDBC URL is constructed using 127.0.0.1 as the Database Server portion and as the Database Port portion, e.g. If the database server is running on the SSH host, you can therefore set Database Server to localhost in case the database only accepts local connections. Note that when using an SSH tunnel, the Database Server is evaluated on the SSH host. The tunnel corresponds to the tunnel you would set up with the ssh command like this:
If you're familiar with using the ssh command to set up a tunnel manually, you may be interested in more details. When SSH tunneling is enabled, a tunnel is established when you connect to the database and the connection is then made through the tunnel by constructing a JDBC URL that uses information from both the Connection and Use SSH Tunnel sections.
#Dbvisualizer kerberos password#
The SSH Password field is then replaced by a Key Passphrase field where you can enter the passphrase if the private key is protected with one.
Alternatively, you can enter the path to a private key file (using either the RSA or DSA algorithms) in the Private Key File field. You may also enter the userid and password for your SSH host account in the SSH Userid and SSH Password fields, but see Setting Common Authentication Options for other options. Enter the port for SSH connections in the SSH Port field. The SSH Host is typically the same as the Database Server. The SSH Host is the name or IP address for the host accepting SSH connections. When it is enabled, five additional fields are shown. not for embedded databases or when using the TNS Connections Type for an Oracle database, or similar).Įnable SSH tunneling by clicking on the checkbox. ="/etc/krb5.This area is only shown when the Server Info settings format is selected, and only for databases identified by at least a Database Server and a Database Port (i.e. Tools>Tool Properties>Specify anycodings_dbvisualizer overridden Java VM Properties here: =true I used kinit and here is the result of anycodings_dbvisualizer klist: etc]$ klistĭefault principal: starting Expires Service principal #default_tkt_enctypes = aes des3-cbc-sha1 rc4 des-cbc-md5 #default_tgs_enctypes = aes des3-cbc-sha1 rc4 des-cbc-md5 On the client, here is the /etc/nf anycodings_dbvisualizer (copy/paste from one of the cluster's anycodings_dbvisualizer machine): cat nf
The client anycodings_dbvisualizer (where I am using DBVisualizer from) is a anycodings_dbvisualizer Centos 7 Machine. I am trying to connect to Hive with anycodings_dbvisualizer DBVisualizer, without success. We have a HDP (3.1.0) cluster with Hive anycodings_dbvisualizer (3.0.0.3.1).
0 kommentar(er)
