VOS.OdsIntegraionDrupal

  • Topic
  • Discussion
    • VOS.OdsIntegraionDrupal(Last) -- Owiki? , 2018-04-19 06:29:02 Edit
    [TXT]
    [PLAIN]
    [DOCBOOK]
    owiki 2018-04-19 06:29:02

    What is Drupal?

    Drupal is a popular open-source content-management system (CMS) written in PHP. The steps below allow you to run it in Virtuoso.

    Install VAD

    1. 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: 

      ...
[Plugins]
# for ex. here the location of the plugins is the plugin folder
LoadPath = ./plugin
...
Load6    = Hosting,hosting_php.so
...

    2. Setup "Local Virtuoso" DSN (note the empty space in the name!) in order to access any of the application URLs.
      • For windows users, please perform the following steps:
        1. Go to Start-> Settings-> Control Panel ->Administrative Tools -> Data Sources (ODBC)
        2. Go to tab "User DSN" and click "Add"
        3. Select the " OpenLink Virtuoso(version)" driver and click "Finish"
        4. Enter for "Name": Local Virtuoso
        5. Enter "Description": My Local Virtuoso
        6. Enter for the field "Server" your Virtuoso host value and ISQL port, for ex: localhost:1116
        7. Click "Next"
        8. Enter for "Login ID" for ex. dba
        9. Enter for "Password" the user password, for ex. for dba by default it is dba.
        10. Click "Next"
        11. Click "Finish".
    3. From ISQL execute: 

      SQL> DB.DBA.VAD_INSTALL('tmp/drupal_fs.vad',0);

    RDF View Scripts

    1. After you have installed the Drupal drupal_fs.vad package, before running the Drupal_rdf_views_script.sql file, which contains the RDF Views scripts for Drupal, you need to configure Drupal to have blog, feeds, polls, aggregator:
      1. Access the drupal home page at http://host:port/drupal
      2. Follow the steps shown:
        1. Create the first account: Click the link "Create the first account" and fill in the form fields. Finally click the "Create new account" button.
        2. As result your account will be created.
        3. Go to Administer->Site building->Modules and check the check-box for the following modules: Aggregator,Blog, Blog API, Book, Forum, Poll
        4. Click the "Save configuration" button.
    2. Having configured Drupal to have blog, feeds, polls, aggregator, etc.. you can execute now from ISQL the RDF Views script: 

      isql localhost:1116 dba dba Drupal_rdf_views_script.sql

      • You can find the Drupal RDF Views scripts also here.

    Configuration

    1. In case you want to change the dba password, you need to locate the file below in your FS and change the $db_url value: 

      vad\vsp\drupal\sites\default\settings.php

    2. 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 "create content" link from the "Start posting content" section.
    3. As result will be shown the Content page page:
    4. Click "Blog entry".
    5. In the shown form enter your data and click "Submit"
    6. As result your blog will be created:
    7. Go to "Create content"->Poll
    8. Enter in the shown form your new Poll question and choices of answers and click the "Submit" button.
    9. As result your Poll will be created
    10. Go to Administer->Content management -> News aggregator and click the button "Add Feed".
    11. Enter in the shown form:
      1. for Title: Kingsley's Blog
      2. for URL: http://www.openlinksw.com/blog/~kidehen/gems/rss.xml
      3. Click the button "Submit".
    12. As result the feed will be added:
    13. You can view your Feeds sources going to News aggregator->Sources:
    14. Go to Administer->Content management -> Forums
    15. Click the "Add container" button.
    16. In the shown form:
      1. Enter for Container name: Food
      2. Enter for Description: all about food
      3. Click the "Submit" button.
    17. As result your new forum will be created:
    18. Click the "Add forum" button.
    19. In the shown form:
      1. Enter for Forum name: Pizza
      2. Enter for Description: Italian pizza
      3. Choose for Parent: Food
      4. Click the "Submit" button.
    20. As result your new forum will be created:
    21. Go to Create content->Forum topic
    22. In the shown form:
      1. Enter for Subject: My favorite menu
      2. For Forums select: Pizza
      3. Enter for Body: Italian pizza is my favorite menu.
      4. Click the "Submit" button.
    23. As result your new forum topic will be created:

    URI Schemas

    What is WordPress?

    WordPress is a popular open-source blog engine written in PHP. The guide below shows how to run it in Virtuoso.

    Install VAD

    1. 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: 

      ...
[Plugins]
# for ex. here the location of the plugins is the plugin folder
LoadPath = ./plugin
...
Load6    = Hosting,hosting_php.so
...

    2. Setup "Local Virtuoso" DSN (note the empty space in the name!) in order to access any of the application URLs.
      • For windows users, please perform the following steps:
        1. Go to Start-> Settings-> Control Panel ->Administrative Tools -> Data Sources (ODBC)
        2. Go to tab "User DSN" and click "Add"
        3. Select the " OpenLink Virtuoso(version)" driver and click "Finish"
        4. Enter for "Name": Local Virtuoso
        5. Enter "Description": My Local Virtuoso
        6. Enter for the field "Server" your Virtuoso host value and ISQL port, for ex: localhost:1116
        7. Click "Next"
        8. Enter for "Login ID" for ex. dba
        9. Enter for "Password" the user password, for ex. for dba by default it is dba.
        10. Click "Next"
        11. Click "Finish".
    3. From ISQL execute: 

      SQL> DB.DBA.VAD_INSTALL('tmp/wordpress_fs.vad',0);

    RDF View Scripts

    1. After you have installed the WordPress wordpress_fs.vad package, using ISQL execute the WordPress_rdf_views_script.sql file, which contains the RDF Views scripts for WordPress: 

      isql localhost:1116 dba dba WordPress_rdf_views_script.sql

      • You can find the WordPress RDF Views scripts also here.

    Configuration

    1. In case you want to change the dba password, you need to locate the file below in your FS and change the $wgDBpassword value: 

      vad\vsp\wordpress\wp-config.php

    2. After you have successfully installed the WordPress wordpress_fs.vad package and have run the RDF Views WordPress_rdf_views_script.sql, access the WordPress home page: http://host:port/wordpress

    URI Schemes


    http://<your-instance-cname>/drupal/user/<ods-user-id>

    Download

    1. You can download from here the RPM for Drupal.
    2. Put the downloaded file preferably into an empty folder and in order to build the drupal_fs.vad package, please perform: 

      rpm2cpio <the name of the rpm file> | cpio -idmv

    3. As result the drupal_fs.vad package will be build and ready to be installed.

    References

    See Also

    CategoryRDF CategoryVirtuoso CategoryDrupal