Then one of the following is likely true (in no particular order):
1. You have the environment variable MW_INSTALL_PATH set in your shell, which is causing the wrong LocalSettings.php to be loaded due to being set to an incorrect path. 2. You are passing --wiki mediawiki to the script somehow (the wiki param lets you specify the db and table prefix to operate on) 3. Your LocalSettings is part of a wikifarm setup and your wiki detection is broken when run from cli 4. You’re defining $wgConf which is overriding your settings with wrong values
Can you check up on all of those? If all else fails, try passing --wiki wikidb into the update script to force it to use the right db.
-- Ryan Schmidt Sent from my iPhone
On Sep 21, 2018, at 7:28 AM, 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