On Wednesday 04 April 2007 16:28, Dmitri Pissarenko wrote: > Hello! > > I have a MediaWiki 1.9.2 (language is Russian) and want to install > Semantic MediaWiki 0.6. > > When I go to the page "Special:SMWAdmin" and press the "Initialise > tables" button, I get the following error message: > > "Error in function SMW::MakeSemanticTables. MySQL returned: '1044: > Access denied for user 'wikiuser'@'localhost' to database 'wikidb' > (localhost)'". > > However, the user "wikiuser" has all permissions on the database "wikidb". > > How can I fix this error?
If you are sure that the user has this permissions formally (but note that MW may remove some permissions during installation!), then this seems to be a problem in your MySQL setup. MySQL may have different permissions for the same user with different "@..." postfixes, and it also sometimes has version problems with its own permission management tables. We once had a similar problem where even the MySQL admin user and root were not able to do certain DB operations, even though they aparently had all permissions. What we did in this rather hard case was something like this (on a Debian server): 1. stop mysql 2. run /usr/sbin/mysqld directly from the command line (the startscript would run /usr/bin/mysqld_safe) this skips some checks for permissions 3. start mysql-client and try 'grant all privileges on *.* to 'root'@'localhost';' (adapt this line to fit the database/user settings of your case) 4. If this fails, repeat steps, but run "/usr/sbin/mysqld --skip-grant-tables" in step 2. 5. with mysql-client run: 'FLUSH privileges;' and then again the command from step 3. 6. If this fails, try running the various commands mysql_fix_* that are provided with mysql, and try steps 1 to 5 from time to time. Your case might be simpler or just completely different. What you can try to analyse the issue also is to run SMW-commands on the mysql client directly. In 0.6, the relevant SQL statements are still in file SMW_Storage.php, within the method smwfMakeSemanticTables(). Good luck! Markus > > TIA > > Dmitri Pissarenko > > ------------------------------------------------------------------------- > 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 -- 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
pgpoA4IDpLVdv.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
