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 <[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
