Functionality requirement

To enable this functionality, the VMS database and Kea DHCP database must reside on the same MySQL server.

The user used to connect to the DHCP database must have at least read-only access to the dhcp_subnet_group_dhcp_subnet and dhcp_subnet_groups tables in the VMS database.

If DHCP is not configured, the functionality with groups will be unavailable.

CODE

The DHCP database user should have the following privileges:

GRANT SELECT ON `VMS_DB`.`dhcp_subnet_group_dhcp_subnet` TO 'DHCP_USER_NAME'@'ACCESS_FROM'
GRANT SELECT ON `VMS_DB`.`dhcp_subnet_groups` TO 'DHCP_USER_NAME'@'ACCESS_FROM'
GRANT SELECT ON `mysql`.`proc` TO 'DHCP_USER_NAME'@'ACCESS_FROM'


The VMS database user should have the following privileges:

GRANT SELECT ON `DHCP_DB`.* TO 'VMS_USER_NAME'@'ACCESS_FROM'

cURL

BASH

curl -k --request POST \
	--url 'https://your-domain' \
	--header 'Content-Type: application/json' \
	--header 'Accept: application/json' \
	--data '[]'

PHP

$data = array (
);
$context = stream_context_create([
	'ssl'=>['verify_peer' => false],
	'http' => [
		'method' => '/',
		'header' => "Content-Type: application/json\r
Accept: application/json",
		'content'=>json_encode($data)
	]
]);
$result = file_get_contents('https://your-domain', false, $context);