Virtuoso Server WebID?+TLS+Delegation Setup

The following steps can be used to Setup a Virtuoso Server ready for WebID?+TLS+Delegation connections.

  1. Create Self Signed Certificate in the Virtuoso from the System Admin -> Security -> Public Key Infrastructure tab:



  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 create, click on the ?Configure HTTPS Listeners? button to config 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 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 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:db:https_key_opluswin7qa_usnet_private

  7. Restart the Virtuoso Server to active the SQL SSL 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:
  1. From the System Admin -> Packages tab (or click the back to packages button) of the Conductor.and for the newly installed VAL package select the configure option on the right, and enable the Default and SQL Realms for the following ACL scopes and click the save button: