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 <[email protected]> > 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 <[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 _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
