How do i configure my Knowi Agent as a Proxy Server
In rare on-premise deployments, you can configure the Agent as a Proxy server between the Knowi WebApp and API connector. Though keep in mind this functionality is only supported with direct queries and not scheduled queries. When used, the direct query runs through the Agent Proxy first before hitting your database.
In contrast, in normal mode, and without a Proxy, direct queries are sent directly to your database. In this mode, the Agent assumes it's the default functionality of outbound connectivity for scheduled queries.
That said, to configure the Agent as a proxy server:
- Navigate to your Agent directory and add the following properties to your config.json file:
{
Note: If tls=true then an ssl Keystore is required. This can be added as an environment variable to your Agent run.sh file or in your Knowi server cloud9.properties file. More information here!
"port": <port_number_to_listen>,
"tls": true
}
For Agent run.sh add:
-Djavax.net.ssl.keyStore=<path_to_jks_key> -Djavax.net.ssl.keyStorePassword=<password>
For Knowi server cloud9.properties add:
sslKeyStore=<path_to_jks_key>
If both are provided, the environment variable in run.sh will override values in cloud9.properties.
sslKeyStoreEncryptedPass=<password>
- On your deployed instance, on the UI navigate to Settings and then Cloud9 Agent settings and edit the Agent properties with the Proxy Address with the host and port to listen on. For example: http://13.57.254.56:9000
3. On the Datasources page, select the datasource to configure with the Agent Proxy and enable the Proxy option.
- Note: The "Proxy" action is only visible after a Proxy Address has been set up (from step 2)
4. That's it! Now you can now create and execute direct queries with the datasources using the Agent as a Proxy server.
Please sign in to leave a comment.
0 comments