<docbook><section><title>OdsIntegrationDrupal</title><bridgehead class="http://www.w3.org/1999/xhtml:h2">What is Drupal?</bridgehead>
<para>Drupal is a popular open-source content-management system (CMS) written in PHP.
 The steps below allow you to run it in Virtuoso.</para>
<bridgehead class="http://www.w3.org/1999/xhtml:h3">Install VAD</bridgehead>
<orderedlist spacing="compact"><listitem>Start virtuoso db using the hosting_php.so ( .dll for win users).
 In oder to use this plugin, it needs to be included in your virtuoso ini file as follows: <programlisting>...
[Plugins]
# for ex. here the location of the plugins is the plugin folder
LoadPath = ./plugin
...
Load6    = Hosting,hosting_php.so
...
</programlisting></listitem>
<listitem>Setup &quot;Local Virtuoso&quot; DSN (note the empty space in the name!) in order to access any of the application URLs.
<itemizedlist mark="bullet" spacing="compact"><listitem>For windows users, please perform the following steps: <orderedlist spacing="compact"><listitem>Go to Start &gt;&gt; Settings &gt;&gt; Control Panel &gt;&gt; Administrative Tools &gt;&gt; Data Sources (ODBC) </listitem>
<listitem>Go to tab &quot;User DSN&quot; and click &quot;Add&quot; </listitem>
<listitem>Select the &quot;<ulink url="OpenLink">OpenLink</ulink> Virtuoso (version)&quot; driver and click &quot;Finish&quot; </listitem>
<listitem>Enter &quot;Name&quot;: Local Virtuoso</listitem>
<listitem>Enter &quot;Description&quot;: My Local Virtuoso</listitem>
<listitem>For &quot;Server&quot;, enter your Virtuoso&#39;s hostname and ISQL port, e.g., localhost:1116</listitem>
<listitem>Click &quot;Next&quot; </listitem>
<listitem>Enter a username for &quot;Login ID&quot;, e.g., dba</listitem>
<listitem>Enter the user&#39;s &quot;Password&quot;.
 For dba, the default password is dba</listitem>
<listitem>Click &quot;Next&quot; </listitem>
<listitem>Click &quot;Finish&quot;.
</listitem>
</orderedlist></listitem>
</itemizedlist></listitem>
<listitem>From ISQL execute: <programlisting>SQL&gt; DB.DBA.VAD_INSTALL(&#39;tmp/drupal_fs.vad&#39;,0);
</programlisting> </listitem>
</orderedlist><bridgehead class="http://www.w3.org/1999/xhtml:h3">RDF View Scripts</bridgehead>
<orderedlist spacing="compact"><listitem>After you have installed the Drupal drupal_fs.vad package, before running the <ulink url="OdsIntegrationDrupal/Drupal_rdf_views_script.sql">Drupal_rdf_views_script.sql</ulink> file, which contains the RDF Views scripts for Drupal, you need to configure Drupal to have blog, feeds, polls, aggregator: <orderedlist spacing="compact"><listitem>Access the drupal home page at <ulink url="http://host:port/drupal">http://host:port/drupal</ulink> <figure><graphic fileref="OdsIntegrationDrupal/dp1.png" /></figure> </listitem>
<listitem>Follow the steps shown: <orderedlist spacing="compact"><listitem>Create the first account: Click the link &quot;Create the first account&quot; and fill in the form fields.
 Finally click the &quot;Create new account&quot; button.
<figure><graphic fileref="OdsIntegrationDrupal/dp2.png" /></figure> </listitem>
<listitem>As result your account will be created.
<figure><graphic fileref="OdsIntegrationDrupal/dp3.png" /></figure> </listitem>
<listitem>Go to Administer-&gt;Site building-&gt;Modules and check the check-box for the following modules: Aggregator,Blog, Blog API, Book, Forum, Poll <figure><graphic fileref="OdsIntegrationDrupal/dp4.png" /></figure> </listitem>
<listitem>Click the &quot;Save configuration&quot; button.
</listitem>
</orderedlist></listitem>
</orderedlist></listitem>
<listitem>Having configured Drupal to have blog, feeds, polls, aggregator, etc..
 you can execute now from ISQL the RDF Views script: <programlisting>isql localhost:1116 dba dba Drupal_rdf_views_script.sql
</programlisting><itemizedlist mark="bullet" spacing="compact"><listitem>You can find the Drupal RDF Views scripts also  <ulink url="VirtRDFViewDrupal">here</ulink>.</listitem>
</itemizedlist></listitem>
</orderedlist><bridgehead class="http://www.w3.org/1999/xhtml:h3">Configuration</bridgehead>
<orderedlist spacing="compact"><listitem>In case you want to change the dba password, you need to locate the file below in your FS and change the <emphasis>$db_url</emphasis> value: <programlisting>vad\vsp\drupal\sites\default\settings.php
</programlisting></listitem>
<listitem>Once you have already created your administrator and configured the modules needed the RDF Views script to be executed correctly, log in and from the Welcome page click the &quot;create content&quot; link from the &quot;Start posting content&quot; section.
<figure><graphic fileref="OdsIntegrationDrupal/dp5.png" /></figure> </listitem>
<listitem>As result will be shown the Content page page: <figure><graphic fileref="OdsIntegrationDrupal/dp6.png" /></figure> </listitem>
<listitem>Click &quot;Blog entry&quot;.
</listitem>
<listitem>In the shown form enter your data and click &quot;Submit&quot; <figure><graphic fileref="OdsIntegrationDrupal/dp7.png" /></figure> </listitem>
<listitem>As result your blog will be created: <figure><graphic fileref="OdsIntegrationDrupal/dp8.png" /></figure> </listitem>
<listitem>Go to &quot;Create content&quot;-&gt;Poll </listitem>
<listitem>Enter in the shown form your new Poll question and choices of answers and click the &quot;Submit&quot; button.
<figure><graphic fileref="OdsIntegrationDrupal/dp9.png" /></figure> </listitem>
<listitem>As result your Poll will be created <figure><graphic fileref="OdsIntegrationDrupal/dp10.png" /></figure> </listitem>
<listitem>Go to Administer-&gt;Content management -&gt; News aggregator and click the button &quot;Add Feed&quot;.
<figure><graphic fileref="OdsIntegrationDrupal/dp11.png" /></figure> </listitem>
<listitem>Enter in the shown form: <orderedlist spacing="compact"><listitem>for Title: Kingsley&#39;s Blog</listitem>
<listitem>for URL: http://www.openlinksw.com/blog/~kidehen/gems/rss.xml</listitem>
<listitem>Click the button &quot;Submit&quot;.
<figure><graphic fileref="OdsIntegrationDrupal/dp12.png" /></figure> </listitem>
</orderedlist></listitem>
<listitem>As result the feed will be added: <figure><graphic fileref="OdsIntegrationDrupal/dp13.png" /></figure> </listitem>
<listitem>You can view your Feeds sources going to News aggregator-&gt;Sources: <figure><graphic fileref="OdsIntegrationDrupal/dp14.png" /></figure> </listitem>
<listitem>Go to Administer-&gt;Content management -&gt; Forums <figure><graphic fileref="OdsIntegrationDrupal/dp15.png" /></figure> </listitem>
<listitem>Click the &quot;Add container&quot; button.
</listitem>
<listitem>In the shown form: <orderedlist spacing="compact"><listitem>Enter for Container name: Food </listitem>
<listitem>Enter for Description: all about food </listitem>
<listitem>Click the &quot;Submit&quot; button.
<figure><graphic fileref="OdsIntegrationDrupal/dp16.png" /></figure> </listitem>
</orderedlist></listitem>
<listitem>As result your new forum will be created: <figure><graphic fileref="OdsIntegrationDrupal/dp17.png" /></figure> </listitem>
<listitem>Click the &quot;Add forum&quot; button.
</listitem>
<listitem>In the shown form: <orderedlist spacing="compact"><listitem>Enter for Forum name: Pizza </listitem>
<listitem>Enter for Description: Italian pizza </listitem>
<listitem>Choose for Parent: Food </listitem>
<listitem>Click the &quot;Submit&quot; button.
<figure><graphic fileref="OdsIntegrationDrupal/dp18.png" /></figure> </listitem>
</orderedlist></listitem>
<listitem>As result your new forum will be created: <figure><graphic fileref="OdsIntegrationDrupal/dp19.png" /></figure> </listitem>
<listitem>Go to Create content-&gt;Forum topic </listitem>
<listitem>In the shown form: <orderedlist spacing="compact"><listitem>Enter for Subject: My favorite menu </listitem>
<listitem>For Forums select: Pizza </listitem>
<listitem>Enter for Body: Italian pizza is my favorite menu.
</listitem>
<listitem>Click the &quot;Submit&quot; button.
<figure><graphic fileref="OdsIntegrationDrupal/dp20.png" /></figure> </listitem>
</orderedlist></listitem>
<listitem>As result your new forum topic will be created: <figure><graphic fileref="OdsIntegrationDrupal/dp21.png" /></figure></listitem>
</orderedlist><bridgehead class="http://www.w3.org/1999/xhtml:h3">URI Schemes</bridgehead>
 <programlisting>http://&lt;your-instance-cname&gt;/drupal/user/&lt;ods-user-id&gt;
</programlisting><para> </para>
<bridgehead class="http://www.w3.org/1999/xhtml:h2">Download</bridgehead>
<itemizedlist mark="bullet" spacing="compact"><listitem>You can download the Drupal VAD package from <ulink url="http://download.openlinksw.com/packages/5.0/virtuoso/drupal_fs.vad">here</ulink>.</listitem>
</itemizedlist><bridgehead class="http://www.w3.org/1999/xhtml:h2">References</bridgehead>
<itemizedlist mark="bullet" spacing="compact"><listitem><ulink url="http://drupal.org/about">Drupal</ulink></listitem>
</itemizedlist><bridgehead class="http://www.w3.org/1999/xhtml:h3">See Also</bridgehead>
<itemizedlist mark="bullet" spacing="compact"><listitem><ulink url="DrupalSIOCRef">Drupal SIOC Reference</ulink></listitem>
</itemizedlist><para><ulink url="CategoryRDF">CategoryRDF</ulink> <ulink url="CategoryVirtuoso">CategoryVirtuoso</ulink> <ulink url="CategoryDrupal">CategoryDrupal</ulink> <ulink url="CategorySIOC">CategorySIOC</ulink> <ulink url="CategoryODS">CategoryODS</ulink> <ulink url="CategoryWebSite">CategoryWebSite</ulink> </para>
</section></docbook>