Question

Executing Vkconfig without having access to vertica Nodes..

Forum|Forum|7 years ago
April 12, 2019
4 replies
14 views

+1

esangrame
Participating Frequently

Hi,

Can we schedule and execute Vkconfig if I don't have access to ssh to vertica Nodes.
I could login to vertica using Vsql from my local system as well as Non-prod clusters.

Found in below page, that we can Install and use the vkconfig utility on a non-Vertica host

https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/KafkaIntegrationGuide/Kafka_Job_Scheduler.htm

Could any one please guide me, how to do this.
1. Where can I get Vkconfig file or the bin folder having it.
2. Can I simply place the file and execute it like we do with Vsql.

Thanks.

+2

Jim_Knicely
Participating Frequently
Forum|Forum|7 years ago
April 12, 2019

On that doc page you linked to, check out the Note section:

You can install and use the vkconfig utility on a non-Vertica host. You may want to do this if:

You do not want the scheduler to use Vertica host resources.
You want users who do not have shell accounts on the Vertica hosts to be able to set up and alter schedulers.

The easiest way to install vkconfig on a host is to install the Vertica server RPM. You must use the RPM that matches the version of Vertica installed on your database cluster. Do not create a database after installing the RPM. The vkconfig utility and its associated files will be in the /opt/vertica/packages/kafka/bin directory on the host.