Setting up Secure UDFs
The process for setting up secure UDFs is as follows:
1. Shut down Vector.
2. Install a container runtime capable to run the Open Container Initiative (OCI) container images. Docker is one such runtime container. The installation process depends on the operating system and OCI runtime.
3. Install the Vector UDF runtime container from the Actian Docker hub repository.
Use the tooling of the container runtime to download and install the Vector UDF engine container.
For Linux, use the following command to pull the Linux-based container:
docker pull actian/vectorwise-udf:6.2
For Windows, use the following command to pull the Windows-based container:
docker pull actian/vectorwise-udf-win:6.2
Note: To use the Windows container, Docker must be configured to use Windows containers and Hyper-V must be enabled.
Note: Python UDFs use a Docker container based on the Microsoft Nano Server. This is not supported on the Windows Server 2019 hosts file. Please contact Actian Support if you need to run Python UDFs on Windows 2019.
4. Configure the database to use secure UDFs by doing the following:
5. Restart the database server and verify if the secure UDF engine is running.
The container should automatically start when you connect to Vector database.
The UDF languages available will be the same as those enabled in the udf_languages property in config.dat.
No change to existing UDF code is needed except for Javascript UDF import paths. All existing UDFs should continue to run assuming they are not accessing secured machine resources.
Last modified date: 03/21/2024