www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Virtuoso Functions Guide

Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
dsig_template_ext
md5
md5_final
md5_init
md5_update
tree_md5
x509_certificate_ver...
xenc_spki_read
xenc_x509_certificat...
xenc_bn2dec
xenc_decrypt_soap
xenc_delete_temp_key...
xenc_encrypt
xenc_get_key_algo
xenc_get_key_identif...
xenc_key_3des_create
xenc_key_3des_rand_c...
xenc_key_3des_read
xenc_key_aes_create
xenc_key_aes_rand_cr...
xenc_key_dsa_create
xenc_key_dsa_read
xenc_key_rsa_read
xenc_key_create_cert
xenc_key_exists
xenc_key_inst_create
xenc_key_remove
xenc_key_serialize
xenc_pem_export
xenc_pkcs12_export
xenc_set_primary_key
xenc_x509_generate
xenc_x509_ss_generat...
LDAP
Locale
Mail
Miscellaneous
Number
RDF data
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY

Functions Index

xenc_pem_export

Export of a certificate and optionally private key in PEM format
xenc_pem_export (in key_name varchar, in pk_flag integer);
Description

The function is used to export certificate in PEM format, optionally it can export also private key (if present)

Parameters
key_name – The key name which keeps the certificate
pk_flag – A flag : 1 or 0, by default 0. It denotes to export or to skip exporting private key.
Return Types

Errors

This function can generate the following errors:

.

Examples
Creating a certificate and exporting it in PEM format

The example bellow imports a client public key, then it creates a certificate and sign it with CA's private key and finally it exports the generated certificate in PEM format.

       kname := xenc_SPKI_read (null, replace (get_keyword ('key', params), '\r\n', ''));
       xenc_x509_generate ('id_rsa', kname, sequence_next ('ca_id_rsa'), 365, 
		vector (
			'CN', get_keyword ('name', params, name),
			'C',  get_keyword ('c', params, name),
			'O',  get_keyword ('o', params, name),
			'OU', get_keyword ('ou', params, name),
			'emailAddress', get_keyword ('email', params)
			), 
		vector ('subjectAltName', 'URI:'||webid, 'nsComment', 'Virtuoso Generated Certificate', 
			'authorityKeyIdentifier', 'keyid,issuer:always'));
       cvalue := xenc_pem_export (kname);

See Also

xenc_SPKI_read

xenc_xenc_x509_generate