ODS Integration of WordPress?

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 "Name": Local Virtuoso
      5. Enter "Description": My Local Virtuoso
      6. For "Server", enter your Virtuoso's hostname and ISQL port, e.g., localhost:1116
      7. Click "Next"
      8. Enter a username for "Login ID", e.g., dba
      9. Enter the user's "Password". For dba, the default password is dba
      10. Click "Next"
      11. Click "Finish".
  3. From ISQL execute:

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


  1. After you have successfully installed the WordPress wordpress_fs.vad package, access the WordPress home page: http://host:port/WordPress in order to continue the installation process
  2. Proceed with the installation offered by the UI
  3. When finished run the rdf view script WordPress_rdf_views_script.sql, .

RDF View Script

  1. After you have installed the WordPress wordpress_fs.vad package and from the WordPress UI the configuration is finished, from 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 also find the WordPress RDF Views scripts here.

URI Schemes




See Also

CategoryBlog CategoryOpenSource CategoryVirtuoso