Thanks for repsonse cnit. See below. The account already had Create temporary tables.
On Jan 7, 2008 6:12 AM, cnit <[EMAIL PROTECTED]> wrote: > > I have upgraded SMW 0.7 to 1.0 on three systems. One instance worked > > without incident. Two instances have issues. There are two distinct > > issues described below: > > > Issue #1 > > Each time I upgraded, changed the $wgDbuser and $wgDBpassword to root > > account in LocalSettings.php before clicking the Initialize button on > > the Admin functions special page. Each time, the table upgrade > > completed without error. However, on two of three systems, switching > > back to the unprivileged $wgDbuser and $wgDBpassword in > > LocalSettings.php started throwing SQL errors when accessing page with > > SMW <ask> query as follows: > > > Database error > > 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 "". MySQL returned error > > "1142: ALTER command denied to user 'wikiuser'@'localhost' for table > > 'cats1' > MW installation procedure specifies to set the following rights: > create, select, insert, update, delete, lock tables > > SMW 0.7 also requires alter > > SMW 1.0 also requires drop, create temporarily tables, index > rights. > Logged into mysql and added privs, verified new settings and flushed: mysql> grant alter, drop, index on <wikidatabasename>.* to 'wikiuser'@'localhost'; mysql> show grants for 'wikiuser'@'localhost'; mysql> flush privileges; Corrected issue. > > Issue #2 > > On third system only, attempting to run the SMW_refreshData.php -pv > > results in follow error: > > > DB connection error: Access denied for user 'root`'@'localhost' (using > > password: YES) (localhost) > > > The odd thing is, this username/password combination worked $wgDbuser > > and $wgDBpassword in LocalSettings.php but don't work from the > > AdminSettings.php? > In AdminSettings.php these variables have different names: > $wgDBadminuser, $wgDBadminpassword > Dmitriy > > Resolved: this was case of tired eyes -- missed the spurious ` character in string. -- -- Dan Thomas ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Semediawiki-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
