Then methinks maintenance/update.php in MW 1.31.0 isn't honoring $wgDBname. From LocalSettings.php:
$wgDBname = "wikidb";
Jeffrey T. Darlington General Protection Fault https://www.gpf-comics.com/
On Thu, Jun 14, 2018 at 4:04 PM Brian Wolff bawolff@gmail.com wrote:
Umm, your error message states that mediawiki thinks the database name is "mediawiki" not "wikidb".
-- Brian
On Thu, Jun 14, 2018 at 7:47 PM, Jeff Darlington jeff.darlington@gmail.com wrote:
As previously stated, the admin user has full privileges to the wiki DB:
show grants for 'wikiadmin'@'localhost';
GRANT ALL PRIVILEGES ON `wikidb`.* TO 'wikiadmin'@'localhost'
The database is on the same box as the Web server, so localhost ought to work. Also as previously stated, none of these attributes have changed
on
this box since MW 1.30.0, which is currently running without incident.
Jeffrey T. Darlington General Protection Fault https://www.gpf-comics.com/
On Thu, Jun 14, 2018 at 3:36 PM Brian Wolff bawolff@gmail.com wrote:
The error should be different if it was due to the column already
existing
Are you sure that wikiadmin has full permissions (Check to make sure that the permissions are for the right db, as well as for the right host).
-- Brian
On Thu, Jun 14, 2018 at 5:43 PM, Jeff Darlington jeff.darlington@gmail.com wrote:
I could have sworn I had those to variables added when I tried running
it a
second time, but I guess I didn't. Here's the updated output:
============= MediaWiki 1.31.0 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 ...[ff08e486f9ef856d82769935]
[no
req] Wikimedia\Rdbms\DBQueryError from line 1457 of
/var/www/gpf/mediawiki-1.31.0/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.0/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.0/includes/libs/rdbms/database/Database.php(1427):
Wikimedia\Rdbms\Database->makeQueryException(string, integer, string, string) #1
/var/www/gpf/mediawiki-1.31.0/includes/libs/rdbms/database/Database.php(1200):
Wikimedia\Rdbms\Database->reportQueryError(string, integer, string,
string,
boolean) #2
/var/www/gpf/mediawiki-1.31.0/includes/libs/rdbms/database/Database.php(4194):
Wikimedia\Rdbms\Database->query(string, string) #3
/var/www/gpf/mediawiki-1.31.0/includes/libs/rdbms/database/Database.php(4129):
Wikimedia\Rdbms\Database->sourceStream(unknown type, NULL, NULL,
string,
NULL) #4
/var/www/gpf/mediawiki-1.31.0/includes/installer/DatabaseUpdater.php(683):
Wikimedia\Rdbms\Database->sourceFile(string) #5
/var/www/gpf/mediawiki-1.31.0/includes/installer/DatabaseUpdater.php(751):
DatabaseUpdater->applyPatch(string, boolean, string) #6
/var/www/gpf/mediawiki-1.31.0/includes/installer/DatabaseUpdater.php(482):
DatabaseUpdater->addField(string, string, string) #7
/var/www/gpf/mediawiki-1.31.0/includes/installer/DatabaseUpdater.php(446):
DatabaseUpdater->runUpdates(array, boolean) #8 /var/www/gpf/mediawiki-1.31.0/maintenance/update.php(200): DatabaseUpdater->doUpdates(array) #9 /var/www/gpf/mediawiki-1.31.0/maintenance/doMaintenance.php(94): UpdateMediaWiki->execute() #10 /var/www/gpf/mediawiki-1.31.0/maintenance/update.php(245): require_once(string)
#11 {main}
The "ALTER command denied to user 'wikiadmin'@'localhost' for table 'ipblocks'" error shouldn't be a permissions issue; "wikiadmin" has
full
permissions to the DB.
However, as stated in my second message, column ipb_id already exists
on
ipblocks as of my MW 1.30.0 install. It could be barfing on the ALTER
ADD
because the column already exists.
Jeffrey T. Darlington General Protection Fault https://www.gpf-comics.com/
On Thu, Jun 14, 2018 at 1:35 PM Ryan Schmidt skizzerz@gmail.com
wrote:
The update is failing for some reason. If you re-run the update.php
script
with those two settings in LocalSettings.php, it will give you the
exact
error message for what failed. With that info, we should be able to
figure
out what is going on and therefore what steps need to be taken to
make
the
upgrade successful.
Reply back with the error message from update.php once you have it.
On Jun 14, 2018, at 9:23 AM, Jeff Darlington <
jeff.darlington@gmail.com>
wrote:
My current setup, under which MW is running swimmingly:
Fedora 27 Apache 2.4.33 MariaDB 10.2.14 MediaWiki 1.30.0
I am attempting to upgrade to MW 1.31.0. I unzipped the tarball
into
a
fresh directory, copied over my LocalSettings.php file, and changed
the
symlink that I use with Apache to point to the new location. I
then
attempted to run maintenance/update.php and it cryptically ended
with
a
whimper:
==================== MediaWiki 1.31.0 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 ...Set
$wgShowExceptionDetails =
true; and $wgShowDBErrorBacktrace = true; at the bottom of LocalSettings.php to show detailed debugging information. ====================
I added the suggested flags to LocalSettings and got the following
in
my
browser:
====================
[WyJ-joCjti3zg1lzHPXHqQAAAAM] /wiki/Main_Page
Wikimedia\Rdbms\DBQueryError
from line 1457 of
/var/www/gpf/mediawiki-1.31.0/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: SELECT
user_id,user_name,user_real_name,user_email,user_touched,user_token,user_email_authenticated,user_email_token,user_email_token_expires,user_registration,user_editcount
FROM `mediawiki`.`user` WHERE user_id = '1' LIMIT 1 Function: User::loadFromDatabase Error: 1142 SELECT command denied to user 'wikiuser'@'localhost'
for
table
'user' (localhost)
Backtrace:
#0
/var/www/gpf/mediawiki-1.31.0/includes/libs/rdbms/database/Database.php(1427):
Wikimedia\Rdbms\Database->makeQueryException(string, integer,
string,
string) #1
/var/www/gpf/mediawiki-1.31.0/includes/libs/rdbms/database/Database.php(1200):
Wikimedia\Rdbms\Database->reportQueryError(string, integer, string,
string,
boolean) #2
/var/www/gpf/mediawiki-1.31.0/includes/libs/rdbms/database/Database.php(1653):
Wikimedia\Rdbms\Database->query(string, string) #3
/var/www/gpf/mediawiki-1.31.0/includes/libs/rdbms/database/Database.php(1730):
Wikimedia\Rdbms\Database->select(array, array, array, string,
array,
array)
#4 /var/www/gpf/mediawiki-1.31.0/includes/user/User.php(1407): Wikimedia\Rdbms\Database->selectRow(array, array, array, string,
array,
array) #5 /var/www/gpf/mediawiki-1.31.0/includes/user/User.php(537): User->loadFromDatabase(integer) #6
/var/www/gpf/mediawiki-1.31.0/includes/libs/objectcache/WANObjectCache.php(1240):
User->{closure}(boolean, integer, array, NULL) #7
/var/www/gpf/mediawiki-1.31.0/includes/libs/objectcache/WANObjectCache.php(1110):
WANObjectCache->doGetWithSetCallback(string, integer, Closure,
array)
#8 /var/www/gpf/mediawiki-1.31.0/includes/user/User.php(561): WANObjectCache->getWithSetCallback(string, integer, Closure, array) #9 /var/www/gpf/mediawiki-1.31.0/includes/user/User.php(482): User->loadFromCache() #10 /var/www/gpf/mediawiki-1.31.0/includes/user/User.php(420): User->loadFromId(integer) #11
/var/www/gpf/mediawiki-1.31.0/includes/session/UserInfo.php(88):
User->load() #12
/var/www/gpf/mediawiki-1.31.0/includes/session/CookieSessionProvider.php(119):
MediaWiki\Session\UserInfo::newFromId(string) #13
/var/www/gpf/mediawiki-1.31.0/includes/session/SessionManager.php(488):
MediaWiki\Session\CookieSessionProvider->provideSessionInfo(WebRequest)
#14
/var/www/gpf/mediawiki-1.31.0/includes/session/SessionManager.php(191):
MediaWiki\Session\SessionManager->getSessionInfoForRequest(WebRequest)
#15 /var/www/gpf/mediawiki-1.31.0/includes/WebRequest.php(736): MediaWiki\Session\SessionManager->getSessionForRequest(WebRequest) #16
/var/www/gpf/mediawiki-1.31.0/includes/session/SessionManager.php(130):
WebRequest->getSession() #17 /var/www/gpf/mediawiki-1.31.0/includes/Setup.php(847): MediaWiki\Session\SessionManager::getGlobalSession() #18 /var/www/gpf/mediawiki-1.31.0/includes/WebStart.php(88): require_once(string) #19 /var/www/gpf/mediawiki-1.31.0/index.php(39): require(string) #20 {main}
==================== Needless to say, I'm pretty confused here. Nothing has changed to
my
configuration (and probably to the wiki's contents) since I
successfully
upgraded to 1.30.0. If I switch my symlink back to point to my MW
1.30.0
install, the site loads just fine. So it appears the updater is
bombing
when it tries to add the field "ipb_id" to table "ipblocks".
What confuses me is the "SELECT command denied to user 'wikiuser'@
'localhost'"
error. My wiki has two MariaDB users: "wikuser" (the standard
user
set
in
$wgDBuser) and an admin user set with $wgDBadminuser. Neither user
account
has changed, either in the DB or in LocalSettings.
It *almost* looks like the updater is trying to use the standard
user
to
do
admin functions, but even that doesn't make much sense. "wikiuser"
has
SELECT access to all tables in the DB, while the admin user has all permissions to the entire DB. So I don't see why that specific
error
would
crop up; even "wikiuser" should be able to perform a simple SELECT.
Fortunately, I can switch back to MW 1.30.0 pretty easily, but I
thought
I
ought to report the problem.
ADDENDUM: I just noticed the following in the 1.31 release notes:
==================== Important pre-upgrade notes for 1.31
- If you're using MySQL, SQLite, or MSSQL, are not using
update.php
to
apply schema changes, and cannot have downtime to run migrateArchiveText.php and apply patch-drop-ar_text.sql manually,
you'll
have to apply a default value to the ar_text and ar_flags
columns of
the
archive table or make those columns nullable before upgrading to
MediaWiki
1.31. maintenance/archives/patch-nullable-ar_text.sql shows how
to
do
this
for MySQL.
==================== Based on this, I think there's something screwy with update.php. I
*am*
using update.php to apply schema changes, but I'm guessing it's not
working
correctly. I have *not* tried this manual fix (and would prefer
not
to
unless absolutely necessary).
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
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
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