On Saturday 23 September 2006 09:47, Asle Pedersen wrote:
> Did anyone on the list try out Semantic Mediawiki using a Mediawiki virtu=
> appliance? I am trying out the rPath Mediawiki appliance using the VMWare
> player. I started installing Semantic Mediawiki and things went fine as f=
> as to the step where the SMW is supposed to be configured using the
> Special:SMWAdmin page. The following error occured:
> A database query syntax error has occurred. This may indicate a bug in the
> software. The last attempted database query was:
> (SQL query hidden)
> from within function "SMW::MakeSemanticTables". MySQL returned error "114=
> CREATE command denied to user 'wikiuser'@'localhost' for table
> 'smw_relations' (localhost) ".
> I handled this by issuing GRANT ALL PRIVILEGES ON wikidb.* to
> 'wikiuser'@'localhost' <%27wikiuser%27@...> which sorted thin=
> out and SMW installed properly.
In fact, this error is not specific to virtual appliances. It occurs with m=
of the normal MediaWiki installations as well. The problem is that SMW has =
add some tables to the DB and there is no standard way for extensions to do=
this in MediaWiki. During normal usage, extension code is of course not=20
supposed to add tables to the DB, so it is OK that those priveliges are=20
disabled by default. Maybe we can add a maintenance script for cleanly=20
installing SMW in the future.
> What I would really like to see, which I think would also widespread the
> use of SMW is an SMW virtual appliance. At least a HOWTO page on howto
> install SMW on a Mediawiki virtual appliance would be very handy.
I am not sure whether there is a difference between virutal and normal=20
operation. If you have helpful tips to share about this issue, then=20
http://ontoworld.org/wiki/Help:Virtual_appliance could be the place to put=
Institute AIFB, University of Karlsruhe, D-76128 Karlsruhe
mak@... phone +49 (0)721 608 7362
http://www.aifb.uni-karlsruhe.de/WBS/ fax +49 (0)721 693 717