Nobody else has reported having a similar issue, and using the default $wgDBname is pretty rare. I would suggest it is highly likely something wrong with your config and not something wrong with mediawiki: E.g. (but not limitted to): * derriving your db name from the host header or some other part of the request not present from the command line * using some sort of complex symlink system for mw files where the command line ends up reading a different LocalSettings.php than the web would
-- Brian
On Friday, September 21, 2018, Jeff Darlington jeff.darlington@gmail.com wrote:
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 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/
MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l