Re: [Semediawiki-user] SMW on a virtual appliance

[Markus <ma...@ai...>]

On Saturday 23 September 2006 09:47, Asle Pedersen wrote:
> Hi,
> Did anyone on the list try out Semantic Mediawiki using a Mediawiki virtu=
al
> appliance? I am trying out the rPath Mediawiki appliance using the VMWare
> player. I started installing Semantic Mediawiki and things went fine as f=
ar
> 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=
2:
> 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@%27localhost%27> which sorted thin=
gs
> out and SMW installed properly.

In fact, this error is not specific to virtual appliances. It occurs with m=
any=20
of the normal MediaWiki installations as well. The problem is that SMW has =
to=20
add some tables to the DB and there is no standard way for extensions to do=
=20
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=
=20
them.

Regards,

Markus


=2D-=20
Markus Kr=F6tzsch
Institute AIFB, University of Karlsruhe, D-76128 Karlsruhe
ma...@ai...        phone +49 (0)721 608 7362
www.aifb.uni-karlsruhe.de/WBS/     fax +49 (0)721 693  717