As I stated several months ago, the updater isn't honoring $wgDBname, which I have explicitly set in LocalSettings.php to "wikidb":
$wgDBname = "wikidb"; -- Jeffrey T. Darlington General Protection Fault https://www.gpf-comics.com/ On Fri, Sep 21, 2018 at 9:36 AM Ryan Schmidt <[email protected]> wrote: > You have permissions on the “wikidb” database but the upgrader is trying > to alter a table in the “mediawiki” database. Double check your db settings > in LocalSettings.php > > -- > Ryan Schmidt > Sent from my iPhone > > > On Sep 21, 2018, at 6:09 AM, Jeff Darlington <[email protected]> > wrote: > > > > For the record, this problem that I reported back in June still does not > > seem to be resolved with MediaWiki 1.31.1. I am still unable to upgrade > to > > the 1.31.x branch because the updater script says my wiki admin user > > doesn't have the necessary privileges to ALTER table ipblocks. The > > database user account has full privileges to the entire MediaWiki > database, > > so I have no idea why this error is occurring. Fortunately, I'm able to > > update to MediaWiki 1.30.1 without a problem, but I'd much rather be on > the > > latest and greatest code base. > > > > My MediaWiki installation is pretty much vanilla except for a single > custom > > extension that I have eliminated as a possible suspect. Something has > > definitely changed between 1.30.x and 1.31.x, possibly in the updater, > that > > isn't working. > > > > I'm at a complete loss here. Any help would be greatly appreciated. > > > > MediaWiki updater output with debugging and tracing turned on: > > ===================== > > MediaWiki 1.31.1 Updater > > > > Your composer.lock file is up to date with current dependencies! > > Going to run database updates for wikidb > > Depending on the size of your database this may take a while! > > Abort with control-c in the next five seconds (skip this countdown with > > --quick) ... 0 > > Turning off Content Handler DB fields for this part of upgrade. > > Adding ipb_id field to table ipblocks ...[6f8054f6cf05b696bf3c9981] [no > > req] Wikimedia\Rdbms\DBQueryError from line 1457 of > > /var/www/gpf/mediawiki-1.31.1/includes/libs/rdbms/database/Database.php: > A > > database query error has occurred. Did you forget to run your > application's > > database schema updater after upgrading? > > Query: ALTER TABLE `mediawiki`.`ipblocks` > > ADD ipb_auto tinyint NOT NULL default '0', > > ADD ipb_id int NOT NULL auto_increment, > > ADD PRIMARY KEY (ipb_id) > > > > Function: Wikimedia\Rdbms\Database::sourceFile( > > /var/www/gpf/mediawiki-1.31.1/maintenance/archives/patch-ipblocks.sql ) > > Error: 1142 ALTER command denied to user 'wikiadmin'@'localhost' for > table > > 'ipblocks' (localhost) > > > > Backtrace: > > #0 > > > /var/www/gpf/mediawiki-1.31.1/includes/libs/rdbms/database/Database.php(1427): > > Wikimedia\Rdbms\Database->makeQueryException(string, integer, string, > > string) > > #1 > > > /var/www/gpf/mediawiki-1.31.1/includes/libs/rdbms/database/Database.php(1200): > > Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, > string, > > boolean) > > #2 > > > /var/www/gpf/mediawiki-1.31.1/includes/libs/rdbms/database/Database.php(4194): > > Wikimedia\Rdbms\Database->query(string, string) > > #3 > > > /var/www/gpf/mediawiki-1.31.1/includes/libs/rdbms/database/Database.php(4129): > > Wikimedia\Rdbms\Database->sourceStream(unknown type, NULL, NULL, string, > > NULL) > > #4 > > > /var/www/gpf/mediawiki-1.31.1/includes/installer/DatabaseUpdater.php(683): > > Wikimedia\Rdbms\Database->sourceFile(string) > > #5 > > > /var/www/gpf/mediawiki-1.31.1/includes/installer/DatabaseUpdater.php(751): > > DatabaseUpdater->applyPatch(string, boolean, string) > > #6 > > > /var/www/gpf/mediawiki-1.31.1/includes/installer/DatabaseUpdater.php(482): > > DatabaseUpdater->addField(string, string, string) > > #7 > > > /var/www/gpf/mediawiki-1.31.1/includes/installer/DatabaseUpdater.php(446): > > DatabaseUpdater->runUpdates(array, boolean) > > #8 /var/www/gpf/mediawiki-1.31.1/maintenance/update.php(200): > > DatabaseUpdater->doUpdates(array) > > #9 /var/www/gpf/mediawiki-1.31.1/maintenance/doMaintenance.php(94): > > UpdateMediaWiki->execute() > > #10 /var/www/gpf/mediawiki-1.31.1/maintenance/update.php(245): > > require_once(string) > > #11 {main} > > ===================== > > > > MariaDB user privileges check: > > ===================== > >> show grants for 'wikiadmin'@'localhost'; > > GRANT ALL PRIVILEGES ON `wikidb`.* TO 'wikiadmin'@'localhost' > > ===================== > > > > -- > > > > Jeffrey T. Darlington > > General Protection Fault > > https://www.gpf-comics.com/ > > _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
