As I stated several months ago, the updater isn't honoring $wgDBname, which
I have explicitly set in LocalSettings.php to "wikidb":
--
Jeffrey T. Darlington
General Protection Fault
https://www.gpf-comics.com/
On Fri, Sep 21, 2018 at 9:36 AM Ryan Schmidt
skizzerz@gmail.com 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
jeff.darlington@gmail.com
> 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/
>
>