VOS.VirtWTDServerSetup

Virtuoso Server WebID?+TLS+Delegation Setup

The following steps guide you through the process of configuring a Virtuoso instance to accept SQL or HTTP connections over TLS, where the server in question is identified using a Self-Signed Certificate:

1. Create a Self-Signed Certificate using the System Admin -> Security -> Public Key Infrastructure tab of the Virtuoso Conductor:
   
   
   
   
2. Complete the CA Root Certificate details and click generate button, note the Name value must be the hostname for the HTTPS listener to be created in a later step:
   
   
   
   
3. The certificate is now created, click on the ?Configure HTTPS Listeners? button to configure the server for secure HTTP access:
   
   
   
   
4. Enter the required parameters for the HTTPS Listener and click the Generate New button to generate a new self signed certificate for use by the server and then click the Save button to save the HTTPS Listener which will be automatically started. Note if running on the default 443 https port then Virtuoso must have been started with Admin or root level privileges for the port usage to be allowed by the OS:
   
   
   
   
5. The new HTTPS Listener should now be listed as and available as a started interface.
   
   
   
   
6. Use the Virtuoso generated self signed cer/tificate stored in the Virtuoso database to setup the SQL SSL port, by referencing the certificate by name (i.e. https_key_opluswin7qa_usnet_private in the example) proceeded by the db: prefix, in the [Parameters] section of the virtuoso.ini file as below:
   

   
   SSLServerPort            = 1113
   SSLCertificate           = db:https_key_opluswin7qa_usnet_private
   SSLPrivateKey            = db:https_key_opluswin7qa_usnet_private
   X509ClientVerify         = 3
   X509ClientVerifyDepth    = 15
   X509ClientVerifyCAFile   = db:https_key_opluswin7qa_usnet_private
   

   
   
7. Restart the Virtuoso Server to active the SQL SSL server listener and check the virtuoso.log file to ensure it has successfully started:
   

   
   11:21:44 OpenLink Virtuoso Universal Server
   11:21:44 Version 07.20.3217-threads for Win64 as of Apr 19 2016
   11:21:44 uses parts of OpenSSL, PCRE, Html Tidy
   11:21:44 Registered to Virtuoso
   11:21:44 Personal Edition license for 50 connections
   11:21:44 Issued by OpenLink Software
   11:21:44 This license will expire on Tue Sep 27 06:20:12 2016 GMT
   11:21:44 Enabled Cluster Extension
   11:21:44 Enabled Column Store Extension
   11:21:44 Database version 3126
   11:21:44 SQL Optimizer enabled (max 1000 layouts)
   11:21:45 Compiler unit is timed at 0.000354 msec
   11:21:47 Roll forward started
   11:21:47 Roll forward complete
   11:21:48 Checkpoint started
   11:21:48 Checkpoint finished, log reused
   11:21:48 SSL server online at 1113
   11:21:48 HTTP/WebDAV server online at 8890
   11:21:48 Server online at 1111 (pid 3420)
   11:21:49 ZeroConfig registration Virtuoso
   

   
   
8. The following Virtuoso applications should be installed from the System Admin -> Packages tab of the Conductor:

• Sponger Cartridge VAD - To enable querying of remote resource URIs
• Faceted Browser VAD - To provide human readable form of Web ID Profile documents and ACLs
• Virtuoso Authentication Layer (VAL) VAD - To enable ACLs for be setup and enforced
• Note the [URIQA] DefaultHost? param in INI file (virtuoso.ini) must be set to valid hostname to be used by VAL