Change Details

As part of {T59336}, OAuth data (`oauth_registered_consumer` table, `oauth_accepted_consumer` table and OAuth records in the log table) needs to be moved to the Meta database. The data consist of about 250 consumers, 16000 acceptances (authorizations) and 500 OAuth log records. == Test migration * run `mwscript extensions/OAuth/maintenance/importCentralWikiLogs.php --wiki=aawiki --old=mediawikiwiki` (no need to test migration of OAuth tables - they don't exist on Meta now so it's low risk) == Real migration * set `$wgMWOAuthReadOnly = true` for all wikis * run `mwscript sql.php --wiki=metawiki --write extensions/OAuth/backend/schema/mysql/OAuth.sql` * run `mwscript extensions/OAuth/maintenance/migrateCentralWiki.php --wiki=metawiki --old=mediawikiwiki --new=metawiki --table=oauth_registered_consumer` * run `mwscript extensions/OAuth/maintenance/migrateCentralWiki.php --wiki=metawiki --old=mediawikiwiki --new=metawiki --table=oauth_accepted_consumer` * set `$wgMWOAuthCentralWiki = 'metawiki'` for all wikis * set `$wgMWOAuthReadOnly = false` for all wikis * run `mwscript extensions/OAuth/maintenance/importCentralWikiLogs.php --wiki=metawiki --old=mediawikiwiki` == Testing * test authorizing/deauthorizing an existing consumer * register a new consumer, test userinfo API via [[ http://pythonhosted.org/mwoauth/ | mwoauth ]]

As part of {T59336}, OAuth data (`oauth_registered_consumer` table, `oauth_accepted_consumer` table and OAuth records in the log table) needs to be moved to the Meta database. The data consist of about 250 consumers, 16000 acceptances (authorizations) and 500 OAuth log records. == Test migration * run `mwscript extensions/OAuth/maintenance/importCentralWikiLogs.php --wiki=aawiki --old=mediawikiwiki` (no need to test migration of OAuth tables - they don't exist on Meta now so it's low risk) == Real migration * set `$wgMWOAuthReadOnly = true` for all wikis * run `mwscript sql.php --wiki=metawiki --write extensions/OAuth/backend/schema/mysql/OAuth.sql` * run `mwscript extensions/OAuth/maintenance/migrateCentralWiki.php --wiki=metawiki --old=mediawikiwiki --new=metawiki --table=oauth_registered_consumer` * run `mwscript extensions/OAuth/maintenance/migrateCentralWiki.php --wiki=metawiki --old=mediawikiwiki --new=metawiki --table=oauth_accepted_consumer` * set `$wgMWOAuthCentralWiki = 'metawiki'` for all wikis * set `$wgMWOAuthReadOnly = false` for all wikis * run `mwscript extensions/OAuth/maintenance/importCentralWikiLogs.php --wiki=metawiki --old=mediawikiwiki` == Testing * authorize [[ https://tools.wmflabs.org/oauth-hello-world/ | Hello World app ]] before migration, verify it's still authorized afterwards * test deauthorizing/reauthorizing it * register a new consumer, test userinfo API via [[ http://pythonhosted.org/mwoauth/ | mwoauth ]]

As part of {T59336}, OAuth data (`oauth_registered_consumer` table, `oauth_accepted_consumer` table and OAuth records in the log table) needs to be moved to the Meta database. The data consist of about 250 consumers, 16000 acceptances (authorizations) and 500 OAuth log records. == Test migration * run `mwscript extensions/OAuth/maintenance/importCentralWikiLogs.php --wiki=aawiki --old=mediawikiwiki` (no need to test migration of OAuth tables - they don't exist on Meta now so it's low risk) == Real migration * set `$wgMWOAuthReadOnly = true` for all wikis * run `mwscript sql.php --wiki=metawiki --write extensions/OAuth/backend/schema/mysql/OAuth.sql` * run `mwscript extensions/OAuth/maintenance/migrateCentralWiki.php --wiki=metawiki --old=mediawikiwiki --new=metawiki --table=oauth_registered_consumer` * run `mwscript extensions/OAuth/maintenance/migrateCentralWiki.php --wiki=metawiki --old=mediawikiwiki --new=metawiki --table=oauth_accepted_consumer` * set `$wgMWOAuthCentralWiki = 'metawiki'` for all wikis * set `$wgMWOAuthReadOnly = false` for all wikis * run `mwscript extensions/OAuth/maintenance/importCentralWikiLogs.php --wiki=metawiki --old=mediawikiwiki` == Testing * test authorizing/deauthorizing an existing consumerauthorize [[ https://tools.wmflabs.org/oauth-hello-world/ | Hello World app ]] before migration, verify it's still authorized afterwards * test deauthorizing/reauthorizing it * register a new consumer, test userinfo API via [[ http://pythonhosted.org/mwoauth/ | mwoauth ]]