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);

Configuration

  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


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

Download

References

See Also

CategoryBlog CategoryOpenSource CategoryVirtuoso