Posts Tagged ‘mysql’

SemanticMediaWiki installation : SPARQL integration, OpenId

January 20, 2011 Comments off

MediaWiki [1] is a popular wiki system written in PHP. SemanticMediaWiki [2] is an extension to this that allows collaborate database backed site with RDF and Sparql capability. Semantic Bundle [3] extends this by adding some more extensions including semantic forms, drilldown, parallel queries, extra types and fields, result formats, and an interesting one “Halo” [4] (from Project Halo[5]) – this brings some fairly sophisticated query, form and visualisation capability.

The reason I’m looking into this is because its quite similar to Drupal7 – php, RDFa, sparql are all part of the deal and both promise to get you up and running pretty quickly with a semantic website, data mashups and syndication. But the crucial difference is that SemanticMediaWiki by nature is a collaborative thing where the structure and admin are shared among users, whereas Drupal7 has a central admin model where governance and a-priori typing are the order of the day (see [6] for early Drupal consideration in comparison to the likes of SemanticMediaWiki).

OpenID, despite its faults, allows single sign on – you can use your Google ID (and others) to sign into sites without having to create yet another username and password and divulge personal details yet again. Its useful even if it needs to change, so I thought I’d see how easy it is to set up for PHP. Sucker for punishment.

So here is the outline

  1. install mysql
  2. install phpMyAdmin if you like
  3. setup a database for mediawiki
  4. create a user with all privileges for the wiki, grant privileges, initialise database
  5. install mediawiki
  6. initialise the wiki database
  7. install SemanticMediaWiki
  8. install php5_gmp, php_curl
  9. install openID – install php_openid,  use pear.
    1. sudo pear install MDB2mysql
    2. sudo pear install OpenID
  10. add Semantic Bundle extensions.
  11. check out wibit*/exhibit [7] to visualise and create forms for RDF data

An alternative might be to install Halo, but I found that trying to use the latest version and the latest SemanticBundle was troublesome, and install documentation and packages seem not to match with documentation. Probably best to install on its own, and by the looks of it, its a good package.


*Now part of the SemanticResultFormats so that you can use the Exhibit result printer. You can use it with JSON/JSONP feeds from you local wiki, or from other SemanticMediaWiki instances if you get the other instance to create the necessary URL to plug into it. (You’ll need a CORS filter or some such on the remote side if you want to use remote JSON).








Categories: semantic Tags: , , , , ,

MySQL server connection drop

September 7, 2010 Comments off

After 8 hours MySQL server side drops idle connections. I don’t want to just allow recovery and have to run a ping every few hours, want driver to handle it. What is this, 1970 still ?

So :

  • try add autoReconnect=true to url
  • try setting wait_timeout and others on server –
  • try c3po instead of dbcp, if using dbcp


Categories: technology Tags: , ,