Page MenuHomePhabricator

wikiuser cannot write to labswiki from mw* servers
Closed, DuplicatePublic

Description

hello

i just discovered wikiuser cannot write to labswiki from mw* servers, only labsweb*. That means stewards are unable to change user rights at that wiki (since that's done via meta, ie. mw* server), as well as massmessage sent from other wikis failing. See this as an example of a stacktrace:

Error 1142: INSERT command denied to user 'wikiuser'@'10.64.16.61' for table 'comment' (10.64.0.98)
Function: CommentStore::createComment
Query: INSERT INTO `comment` (comment_hash,comment_text,comment_data) VALUES (1902169376,'/* Tech News: 2021-06 */ new section',NULL)
	
from /srv/mediawiki/php-1.36.0-wmf.27/includes/libs/rdbms/database/Database.php(1702)
#0 /srv/mediawiki/php-1.36.0-wmf.27/includes/libs/rdbms/database/Database.php(1686): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /srv/mediawiki/php-1.36.0-wmf.27/includes/libs/rdbms/database/Database.php(1661): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /srv/mediawiki/php-1.36.0-wmf.27/includes/libs/rdbms/database/Database.php(1230): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /srv/mediawiki/php-1.36.0-wmf.27/includes/libs/rdbms/database/Database.php(2346): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /srv/mediawiki/php-1.36.0-wmf.27/includes/libs/rdbms/database/Database.php(2326): Wikimedia\Rdbms\Database->doInsert(string, array, string)
#5 /srv/mediawiki/php-1.36.0-wmf.27/includes/CommentStore.php(479): Wikimedia\Rdbms\Database->insert(string, array, string)
#6 /srv/mediawiki/php-1.36.0-wmf.27/includes/CommentStore.php(501): CommentStore->createComment(Wikimedia\Rdbms\DatabaseMysqli, CommentStoreComment, NULL)
#7 /srv/mediawiki/php-1.36.0-wmf.27/includes/CommentStore.php(599): CommentStore->insertInternal(Wikimedia\Rdbms\DatabaseMysqli, string, CommentStoreComment, NULL)
#8 /srv/mediawiki/php-1.36.0-wmf.27/includes/Revision/RevisionStore.php(634): CommentStore->insertWithTempTable(Wikimedia\Rdbms\DatabaseMysqli, string, CommentStoreComment)
#9 /srv/mediawiki/php-1.36.0-wmf.27/includes/Revision/RevisionStore.php(495): MediaWiki\Revision\RevisionStore->insertRevisionRowOn(Wikimedia\Rdbms\DatabaseMysqli, MediaWiki\Revision\MutableRevisionRecord, Title, integer)
#10 /srv/mediawiki/php-1.36.0-wmf.27/includes/Revision/RevisionStore.php(433): MediaWiki\Revision\RevisionStore->insertRevisionInternal(MediaWiki\Revision\MutableRevisionRecord, Wikimedia\Rdbms\DatabaseMysqli, User, CommentStoreComment, Title, integer, integer)
#11 /srv/mediawiki/php-1.36.0-wmf.27/includes/libs/rdbms/database/Database.php(4499): MediaWiki\Revision\RevisionStore->MediaWiki\Revision\{closure}(Wikimedia\Rdbms\DatabaseMysqli, string)
#12 /srv/mediawiki/php-1.36.0-wmf.27/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->doAtomicSection(string, Closure)
#13 /srv/mediawiki/php-1.36.0-wmf.27/includes/libs/rdbms/database/DBConnRef.php(641): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#14 /srv/mediawiki/php-1.36.0-wmf.27/includes/Revision/RevisionStore.php(435): Wikimedia\Rdbms\DBConnRef->doAtomicSection(string, Closure)
#15 /srv/mediawiki/php-1.36.0-wmf.27/includes/Storage/PageUpdater.php(1080): MediaWiki\Revision\RevisionStore->insertRevisionOn(MediaWiki\Revision\MutableRevisionRecord, Wikimedia\Rdbms\DBConnRef)
#16 /srv/mediawiki/php-1.36.0-wmf.27/includes/Storage/PageUpdater.php(801): MediaWiki\Storage\PageUpdater->doModify(CommentStoreComment, User, integer)
#17 /srv/mediawiki/php-1.36.0-wmf.27/includes/page/WikiPage.php(2042): MediaWiki\Storage\PageUpdater->saveRevision(CommentStoreComment, integer)
#18 /srv/mediawiki/php-1.36.0-wmf.27/includes/page/WikiPage.php(1894): WikiPage->doUserEditContent(WikitextContent, User, CommentStoreComment, integer, boolean, array, integer)
#19 /srv/mediawiki/php-1.36.0-wmf.27/includes/EditPage.php(2352): WikiPage->doEditContent(WikitextContent, string, integer, boolean, User, string, array, integer)
#20 /srv/mediawiki/php-1.36.0-wmf.27/includes/EditPage.php(1687): EditPage->internalAttemptSave(array, boolean)
#21 /srv/mediawiki/php-1.36.0-wmf.27/includes/api/ApiEditPage.php(454): EditPage->attemptSave(array)
#22 /srv/mediawiki/php-1.36.0-wmf.27/includes/api/ApiMain.php(1612): ApiEditPage->execute()
#23 /srv/mediawiki/php-1.36.0-wmf.27/includes/api/ApiMain.php(561): ApiMain->executeAction()
#24 /srv/mediawiki/php-1.36.0-wmf.27/extensions/MassMessage/includes/Job/MassMessageJob.php(403): ApiMain->execute()
#25 /srv/mediawiki/php-1.36.0-wmf.27/extensions/MassMessage/includes/Job/MassMessageJob.php(260): MediaWiki\MassMessage\Job\MassMessageJob->makeAPIRequest(array)
#26 [internal function]: MediaWiki\MassMessage\Job\MassMessageJob->editPage(string)
#27 /srv/mediawiki/php-1.36.0-wmf.27/extensions/MassMessage/includes/Job/MassMessageJob.php(240): call_user_func(array, string)
#28 /srv/mediawiki/php-1.36.0-wmf.27/extensions/MassMessage/includes/Job/MassMessageJob.php(69): MediaWiki\MassMessage\Job\MassMessageJob->sendMessage()
#29 /srv/mediawiki/php-1.36.0-wmf.27/extensions/EventBus/includes/JobExecutor.php(79): MediaWiki\MassMessage\Job\MassMessageJob->run()
#30 /srv/mediawiki/rpc/RunSingleJob.php(76): MediaWiki\Extension\EventBus\JobExecutor->execute(array)
#31 {main}
	
host: mw1296
servergroup: jobrunner

Is that intentional? If not, can this grant be added? Thanks!