SYSADMIN_VDB Procedures

The procedures described on this page enable you to manage virtual databases and SSH tunnels.

SYSADMIN_VDB.createVdb

This procedure creates a virtual database:

SQL

SYSADMIN_VDB.createVdb("name" => 'string_name');;

Example

SQL

CALL "SYSADMIN_VDB.createVdb"("name" => 'newVDB');;

SYSADMIN_VDB.dropVdb

This procedure removes a virtual database by ID:

SQL

SYSADMIN_VDB.dropVdb("id" => biginteger_id);;

To view the ID of the virtual database you need to delete, you can use the SYSADMIN_VDB.VirtualDatabases table.

Please be aware that this operation cannot be undone, and a dropped virtual database is gone for good.

Example

SQL

CALL "SYSADMIN_VDB.dropVdb"("id" => 10);;

SYSADMIN_VDB.getJavaProp

This procedure gets the translator-related client secret:

SQL

SYSADMIN_VDB.getJavaProp(IN key1 string NOT NULL, OUT value1 string RESULT)

Example

SQL

CALL "SYSADMIN_VDB.getJavaProp"("key1" => 'user.language');;

SYSADMIN_VDB.setJavaProp

This procedure sets the translator-related client secret:

SQL

SYSADMIN_VDB.setJavaProp(IN key1 string NOT NULL, IN value1 string)

Example

SQL

CALL "SYSADMIN_VDB.setJavaProp"("key1" => 'user.language', "value1" => 'en');;

SYSADMIN_VDB.createSSHTunnel

This procedure creates an SSH tunnel. It takes the following parameters:

To view the full table, click the expand button in its top right corner

Parameter name	Parameter type	Mandatory	Description
`name`	string	`NOT NULL`	Unique name of an SSH tunnel
`localHost`	string	`NULL`	Host of a client's machine (default: localhost)
`localPort`	integer	`NOT NULL`	Port of a client's machine
`remoteHost`	string	`NOT NULL`	Host of a remote machine
`remotePort`	integer	`NOT NULL`	Port of a remote machine
`host`	string	`NOT NULL`	Username and host used for connecting to a remote machine via SSH protocol (format: `username@host`)
`sshKeyPairId`	integer	`NULL`	ID of a key-pair in the `SYSADMIN_VDB.SSHCredentials` table
`sshPort`	integer	`NULL`	Port used by SSH server on a remote machine (default: `22`)
`sshProperties`	string	`NULL`	SSH comma-separated properties in CSV-like form: `property1=<value1>,property2=<value2>`. Used to provide a timeout, cypher parameters, key parameters like used algorithms, a possibility to provide classes for custom algorithms, and so on
`password`	string	`NULL`	Password used for simple authentication on the SSH server
`passPhrase`	string	`NULL`	Password phrase used in case of a secured private key and key authentication on the SSH server
`privateKeyPath`	string	`NULL`	Private key path or the private key itself as a string in case of key authentication on the SSH server
`proxy`	string	`NULL`	Possible values: `NONE`, `HTTP`, `SOCKS4`, `SOCKS5` (if this setting is not set via `importSSHTunnel`, proxy configuration set via System Properties will be considered)
`proxyHost`	string	`NULL`	Host address of the proxy (if this setting is not set via `importSSHTunnel`, proxy configuration set via System Properties will be considered)
`proxyPort`	integer	`NULL`	Port used by the proxy (if this setting is not set via `importSSHTunnel`, proxy configuration set via System Properties will be considered)
`proxyUser`	string	`NULL`	User at the proxy (if this setting is not set via `importSSHTunnel`, proxy configuration set via System Properties will be considered)
`proxyPassword`	string	`NULL`	Password for the proxy server (if this setting is not set via `importSSHTunnel`, proxy configuration set via System Properties will be considered)

SYSADMIN_VDB.removeSSHTunnel

This procedure removes an SSH tunnel. It takes the following parameter:

Parameter name	Parameter type	Mandatory	Description
`name`	string	`NOT NULL`	Unique name of the SSH tunnel intended for removal

SYSADMIN_VDB.importSSHTunnel

This procedure imports or refreshes an SSH tunnel. It takes the following parameters:

To view the full table, click the expand button in its top right corner

Parameter name	Parameter type	Mandatory	Description
`name`	string	`NOT NULL`	Unique name of an SSH tunnel
`localHost`	string	`NULL`	Host of a client's machine (default: localhost)
`localPort`	integer	`NOT NULL`	Port of a client's machine
`remoteHost`	string	`NOT NULL`	Host of a remote machine
`remotePort`	integer	`NOT NULL`	Port of a remote machine
`host`	string	`NOT NULL`	Username and host used for connecting to a remote machine via SSH protocol (format: `username@host`)
`portForwardingType`	string	`NULL`	Type of SSH port forwarding (`L` by default). As the Data Virtuality Server supports only local port forwarding at the moment, the field can have only the `L` value
`sshKeyPairId`	integer	`NULL`	ID of a key-pair in the `SYSADMIN_VDB.SSHCredentials` table
`sshPort`	integer	`NULL`	Port used by SSH Server on a remote machine (default: `22`)
`encryptedSshProperties`	string	`NULL`	SSH comma-separated properties in CSV-like form: `property1=<value1>,property2=<value2>`. Used to provide a timeout, cypher parameters, key parameters like used algorithms, a possibility to provide classes for custom algorithms, and so on. It can consist of sensitive data, and this is why the value should be encrypted
`encryptedPassword`	string	`NULL`	Encrypted password used for simple authentication on the SSH server
`encryptedPassPhrase`	string	`NULL`	Encrypted password phrase used in case of secured private key and key authentication on the SSH server
`encryptedPrivateKey`	string	`NULL`	Encrypted private key in case of key authentication on the SSH server
`proxy`	string	`NULL`	Possible values: `NONE`, `HTTP`, `SOCKS4`, `SOCKS5` (if this setting is not set via importSSHTunnel, proxy configuration set via System Properties will be considered)
`proxyHost`	string	`NULL`	Address of the proxy (if this setting is not set via `importSSHTunnel`, proxy configuration set via System Properties will be considered)
`proxyPort`	string	`NULL`	Port used by proxy (if this setting is not set via `importSSHTunnel`, proxy configuration set via System Properties will be considered)
`proxyUser`	string	`NULL`	User at the proxy (if this setting is not set via `importSSHTunnel`, proxy configuration set via System Properties will be considered)
`encryptedProxyPassword`	string	`NULL`	Encrypted password for the proxy server
`sshProperties`	string	`NULL`	SSH comma-separated properties in CSV-like form: `property1=<value1>,property2=<value2>`. Used to provide a timeout, cypher parameters, key parameters like used algorithms, a possibility to provide classes for custom algorithms, and so on
`password`	string	`NULL`	Password used for a simple authentication on the SSH server
`passPhrase`	string	`NULL`	Password phrase used in case of a secured private key and key authentication on the SSH server
`privateKey`	string	`NULL`	Private key in case of key authentication on the SSH server
`proxyPassword`	string	`NULL`	Password for the proxy server

SYSADMIN_VDB.createSSHKeyPair

This procedure creates a key pair. It takes the following parameters:

Parameter name	Parameter type	Mandatory	Description
`name`	string	`NULL`	Unique name of a key pair
`publicKey`	string	`NOT NULL`	Public key
`id`	integer	`NOT NULL`	ID of the key pair

SYSADMIN_VDB.renameSSHKeyPair

This procedure renames a key pair. It takes the following parameters:

Parameter name	Parameter type	Mandatory	Description
`name`	string	`NOT NULL`	Unique name of a key pair
`publicKey`	string	`NOT NULL`	Public key
`id`	integer	`NOT NULL`	ID of the key pair

SYSADMIN_VDB.removeSSHKeyPair

This procedure removes a key pair. It takes the following parameters:

Parameter name	Parameter type	Mandatory	Description
`id`	integer	`NOT NULL`	ID of the key pair

SYSADMIN_VDB.importSSHKeyPair

This procedure creates a key pair. It takes the following parameters:

Parameter name	Parameter type	Mandatory	Description
`name`	string	`NULL`	Unique name of a key pair
`publicKey`	string	`NULL`	Public key
`privateKey`	string	`NULL`	Private key
`encryptedPrivateKey`	string	`NULL`	Encrypted private key
`id`	integer	`NOT NULL`	ID of the key pair