In the Database Connection/SSH Settings category under the General tab, you can specify an SSH Keep-Alive Interval to minimize the risk that the tunnel is disconnected due to inactivity, and an SSH Known Hosts File so you don't have to accept connections to known SSH hosts every time you connect. 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. 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. Ssh -p -L:: the placeholders correspond to the fields in the Connect and Use SSH Tunnel sections, except for which is any available port, determined at connect time. 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. 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. Click on it to load its details in the lower part of the page. Find the instance you just created from the list in the main section of the page. Select Instance>Instances on the left side. Go to the AWS Management Console and select Compute>EC2. 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. Enable forwarding from the SSH server to the database. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |