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