On Saturday 23 September 2006 09:47, Asle Pedersen wrote: > Hi, > Did anyone on the list try out Semantic Mediawiki using a Mediawiki virtual > appliance? I am trying out the rPath Mediawiki appliance using the VMWare > player. I started installing Semantic Mediawiki and things went fine as far > 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 "1142: > 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' <[EMAIL PROTECTED]> which sorted things > out and SMW installed properly.
In fact, this error is not specific to virtual appliances. It occurs with many of the normal MediaWiki installations as well. The problem is that SMW has to 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 supposed to add tables to the DB, so it is OK that those priveliges are disabled by default. Maybe we can add a maintenance script for cleanly 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 operation. If you have helpful tips to share about this issue, then http://ontoworld.org/wiki/Help:Virtual_appliance could be the place to put them. Regards, Markus -- Markus Krötzsch Institute AIFB, University of Karlsruhe, D-76128 Karlsruhe [EMAIL PROTECTED] phone +49 (0)721 608 7362 www.aifb.uni-karlsruhe.de/WBS/ fax +49 (0)721 693 717
pgpPLKj756B2g.pgp
Description: PGP signature
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________ Semediawiki-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/semediawiki-user
