DronaHQ Studio enables you to use databases by configuring their connectors and now Shell Script Connector is available in the studio.
The Shell Script connector enables you to execute a list of shell commands on a remote server such as AWS, Azure, Droplet, and more by establishing an SSH connection.
- The Shell Script connector works with the use of an SSH Key. So, you need to ensure that you have SSH key available in your Studio account. You can learn more about SSH key and SSH key management here.
- The server you want to connect to must have the Studio-generated public key/SSH Key saved in it. Then only the Shell Script connector will be able to connect to the server from the Studio.
We need to save the SSH public key in the remote cloud server.
Usually, you put the SSH key in the authorized SSH key file under
Configuring a Shell Script connector
To add a third-party DB connector, under Studio > Connectors, click (+) Connector. Select Shell Script connector.
Enter the Connector name.
In the next step, we need to fill in the general details to generate the connection with the server. You will find these details from the server itself, which you want to connect to. Enter the details in Host, Port, and Username. The host is the server where the public key is saved and for the port number, we have 22 which is generally used to create an SSH connection.
Moving on to the Admin section you have to select the same SSH key/public key saved in the server from the SSH Keys dropdown.
Once these configurations are added, click Test connection. If the authentication is successful, you will get a response accordingly. Click to Save your configuration.
Adding Queries to the connector
Now that you have configured the connector you will find it under the Custom Database connectors list.
There are several actions that users can perform in the server from the backend using the shell script, but to some extent, it can be complex to use the shell. So, in spite of using the terminal, you can have the option to use a more user-friendly platform to perform actions, click the Add query option available after your connection is ready.
You can add commands such as start and stop to carry out the action in the workflow of the server. These actions of workflow can be used in the trigger actions of several controls to interact with the server without the need of using a shell script terminal.
You can select the Manage Environment option from the edit button of the configured connector. Here you can manage different environments such as production, staging, development, test environment, and others, of a single account by adding different credentials and other details corresponding to different environments.
Select either the environments which you haven’t configured yet, by clicking on configure or clicking on the configured environments to make further changes and edits.
You can make changes from a single place and these changes will reflect on your respective environments.
Once done, click on Save.