This HTML5 document contains 44 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

Subject Item

n6:this

foaf:made

n4:VirtWTDServerSetup

Subject Item

n23:this

sioc:creator_of

n4:VirtWTDServerSetup

Subject Item

n2:item

n3:services_of

n4:VirtWTDServerSetup

Subject Item

n13:this

sioc:creator_of

n4:VirtWTDServerSetup

Subject Item

n9:VOS

sioc:container_of

n4:VirtWTDServerSetup

atom:entry

n4:VirtWTDServerSetup

atom:contains

n4:VirtWTDServerSetup

Subject Item

n4:VirtWTDSoftwareAgentDocCreation

sioc:links_to

n4:VirtWTDServerSetup

Subject Item

n4:VirtWTDACLTesting

sioc:links_to

n4:VirtWTDServerSetup

Subject Item

n4:VirtWTDServerSetup

rdf:type

atom:Entry sioct:Comment

dcterms:created

2018-04-13T12:09:33.019200

dcterms:modified

2019-07-11T06:48:42.068818

rdfs:label

VirtWTDServerSetup

foaf:maker

n6:this n25:this

dc:title

VirtWTDServerSetup

opl:isDescribedUsing

n27:rdf

sioc:has_creator

n13:this n23:this

sioc:attachment

n16:png n17:png n18:png n19:png n20:png n21:png n22:png n24:txt

sioc:content

%META:TOPICPARENT{name="VirtWTDStepByStepConfigGuide"}% ---++ 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 <code>System Admin -> Security -> Public Key Infrastructure</code> tab of the Virtuoso Conductor: %BR%%BR% <img src="%ATTACHURLPATH%/VirtWTDServerSetup-01.png" style="wikiautogen" height="480" width="640"/> %BR%%BR% 1 Complete the CA Root Certificate details and click <code>generate</code> button, note the <code>Name</code> value must be the hostname for the HTTPS listener to be created in a later step: %BR%%BR% <img src="%ATTACHURLPATH%/VirtWTDServerSetup-02.png" style="wikiautogen" height="480" width="640"/> %BR%%BR% 1 The certificate is now created, click on the ?Configure HTTPS Listeners? button to configure the server for secure HTTP access: %BR%%BR% <img src="%ATTACHURLPATH%/VirtWTDServerSetup-03.png" style="wikiautogen" height="480" width="640"/> %BR%%BR% 1 Enter the required parameters for the HTTPS Listener and click the <code>Generate New</code> button to generate a new self signed certificate for use by the server and then click the <code>Save</code> 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: %BR%%BR% <img src="%ATTACHURLPATH%/VirtWTDServerSetup-04.png" style="wikiautogen" height="480" width="640"/> %BR%%BR% 1 The new HTTPS Listener should now be listed as and available as a <code>started</code> interface. %BR%%BR% <img src="%ATTACHURLPATH%/VirtWTDServerSetup-05.png" style="wikiautogen" height="200" width="640"/> %BR%%BR% 1 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. <nowiki>https_key_opluswin7qa_usnet_private</nowiki> in the example) proceeded by the <code>db:</code> prefix, in the <code>[Parameters]</code> section of the virtuoso.ini file as below: <verbatim> 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 </verbatim> 1 Restart the Virtuoso Server to active the SQL SSL server listener and check the virtuoso.log file to ensure it has successfully started: <verbatim> 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 </verbatim> 1 The following Virtuoso applications should be installed from the <code>System Admin -> Packages</code> 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 %BR%%BR% <img src="%ATTACHURLPATH%/VirtWTDServerSetup-06.png" style="wikiautogen" height="300" width="640"/> %BR%%BR% <nop>9. From the <code>System Admin -> Packages</code> tab (or click the <code>back to packages</code> button) of the Conductor, for the newly installed <code>VAL</code> package select the <code>configure</code> option on the right, and enable the <code>Default</code> and <code>SQL</code> Realms for the following ACL scopes and click the <code>save</code> button: * Enable Query ACL Scope ACLs * Enable Private Named Graphs ACL Scope ACLs * Enable Restrictions ACL Scope ACLs %BR%%BR% <img src="%ATTACHURLPATH%/VirtWTDServerSetup-07.png" style="wikiautogen" height="480" width="640"/> %BR%%BR% ---++Related * [[VirtWTDSoftwareAgentDocCreation][Virtuoso WebID+TLS+Delegation Step by Step Configuration Guide]] * [[VirtWTDSoftwareAgentDocCreation][Software Agent & WebID Profile Document Creation]] * [[VirtWTDVALACLCreation][WebID+TLS+Delegation VAL ACL Creation]] * [[VirtWTDACLTesting][WebID+TLS+Delegation ACL Testing]] * [[VirtWTDWebIdProfileDocInNamedGraph][Using Named Graph for hosting WebID Profile Document Data]] * [[https://medium.com/virtuoso-blog/web-logic-sentences-and-the-magic-of-being-you-e2a719d01f73][Web, Logic, Sentences, and the Magic of Being You!]]

sioc:id

08ad30ad253b865c19cee9a06cc7e45a

sioc:link

n4:VirtWTDServerSetup

sioc:has_container

n9:VOS

n3:has_services

n2:item

atom:title

VirtWTDServerSetup

sioc:links_to

n14:web-logic-sentences-and-the-magic-of-being-you-e2a719d01f73 n15:WebID n15:DefaultHost

atom:source

n9:VOS

atom:author

n6:this

atom:published

2018-04-13T12:09:33Z

atom:updated

2019-07-11T06:48:42Z

sioc:topic

n9:VOS

Subject Item

n4:VirtWTDVALACLCreation

sioc:links_to

n4:VirtWTDServerSetup

Subject Item

n4:VirtWTDWebIdProfileDocInNamedGraph

sioc:links_to

n4:VirtWTDServerSetup