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
On Fri, Sep 21, 2018 at 9:36 AM Ryan Schmidt <skizzerz(a)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(a)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/