From: S P. <ski...@ea...> - 2006-03-17 08:28:06
|
I installed XAMPP Lite (Apache 2.2.0, PHP 5.1.1 with apache2handler, MySQL 5.0.18) on <horrors> Windows XP SP2, and installed MediaWiki 1.5.7. The only glitch was selecting the "Experimental MySQL 4.1/5.0 UTF-8" option led to "Specified key was too long; max key length is 1000 bytes". I had to drop the wikidb and choose "Backwards-compatible UTF-8", as explained in http://mail.wikipedia.org/pipermail/mediawiki-l/2005-August/006195.html Then I installed latest SemanticMediaWiki from CVS following the INSTALL guide. That sort of worked! Recreating the San Diego page made it appear with the Relations and Attributes infoboxes. But every attribute and relation was unsupported, and I get no results from any Special:SearchTriple search. The INSTALL says "The extension has to create a new table *once* for storing semantic data. Grant these privileges to the wiki database user and repeat the operation." but 1. Doesn't say what privileges to grant (I think CREATE only)? 2. Doesn't say what table(s) it is trying to create (I think in the default wikidb database in MySQL, they are smw_relations, smw_attributes, and smw_specialprops, and I don't have these). 3. Doesn't say where the error is logged. I have three "wikiuser" users, with different Host values: %, localhost, and localhost.localdomain. Which of the three does the create at http://localhost/mediawiki/index.php?title=San_Diego&action=edit ? I tried granting all privileges to all three and kept previewing and saving my page, and didn't get the tables. I then tried changing LocalSettings.php's $wgDBuser to root and still didn't get the tables. I restarted MySQL and Apache and re-previewed my San Diego page, and still nothing. Thanks in advance for any suggestions, I'm going to learn about PHP and MediaWiki error logging. -- =S |
From: Markus <ma...@ai...> - 2006-03-17 11:24:14
|
On Friday 17 March 2006 09:23, S Page wrote: > I installed XAMPP Lite (Apache 2.2.0, PHP 5.1.1 with apache2handler, > MySQL 5.0.18) on <horrors> Windows XP SP2, and installed MediaWiki 1.5.7. > > The only glitch was selecting the "Experimental MySQL 4.1/5.0 UTF-8" > option led to "Specified key was too long; max key length is 1000 > bytes". I had to drop the wikidb and choose "Backwards-compatible > UTF-8", as explained in > http://mail.wikipedia.org/pipermail/mediawiki-l/2005-August/006195.html We did not try this yet with SMW. Careful. > > Then I installed latest SemanticMediaWiki from CVS following the INSTALL > guide. That sort of worked! Recreating the San Diego page made it > appear with the Relations and Attributes infoboxes. But every attribute > and relation was unsupported, and I get no results from any > Special:SearchTriple search. > > The INSTALL says "The extension has to create a new table *once* for > storing semantic data. Grant these privileges to the wiki database user > and repeat the operation."=20 Sorry if this is still in the current text. 0.3 works differently. Go to=20 Special:SMWAdmin as an admin user and do as you are told there (first=20 section, although it says "upgrading" is also for install). > but=20 > 1. Doesn't say what privileges to grant (I think CREATE only)? Yes. For the upgrade you also need delete. > 2. Doesn't say what table(s) it is trying to create (I think in the > default wikidb database in MySQL, they are smw_relations, > smw_attributes, and smw_specialprops, and I don't have these). Yes. > 3. Doesn't say where the error is logged. The error did not actually occur. SMW does not attempt to write anything if= =20 the tables are not there. The privileges are only needed for the operation = of=20 Special:SMWAdmin. > > I have three "wikiuser" users, with different Host values: %, localhost, > and localhost.localdomain. Which of the three does the create at > http://localhost/mediawiki/index.php?title=3DSan_Diego&action=3Dedit ? The DB user is the one given in your MW LocalSettings.php. It is unrelated = to=20 the wikiuser.=20 > I tried granting all privileges to all three and kept previewing and > saving my page, and didn't get the tables. I then tried changing > LocalSettings.php's $wgDBuser to root and still didn't get the tables. Yes. We really have to document this! That is why 0.3 is not released yet ;= =2D) > > I restarted MySQL and Apache and re-previewed my San Diego page, and > still nothing. Sure. The Special will do the trick. Sorry for the inconvenience. Regards, Markus > > Thanks in advance for any suggestions, I'm going to learn about PHP and > MediaWiki error logging. > > -- > =3DS > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting langua= ge > that extends applications into web and mobile media. Attend the live > webcast and join the prime developer group breaking into this new coding > territory! > http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat= =3D121642 > _______________________________________________ > Semediawiki-devel mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-devel =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 |