|
|
(7 intermediate revisions by 2 users not shown) |
Line 1: |
Line 1: |
− | The state wiki require some maintenance and an urgent upgrade. This page documents what needs to be done, and what should be done. There is a thread on dev (Wiki maintenance) where the decisions are made.
| |
− |
| |
− | At the moment we have the following work list:
| |
− |
| |
− | * Change LocalSettings.php to close for "create user" '''DONE'''
| |
− | * Update UA- code for google-analyics '''DONE'''
| |
− | * open for "create page" again '''DONE'''
| |
− | * Check "nofollow" setting, to be sure it's on (True) '''DONE, added $wgNoFollowDomainExceptions and $wgNoFollowNsExceptions'''
| |
− | * remove accounts older than a year WITHOUT any contributions '''DONE, removed 32527 accounts'''
| |
− | * remove all accounts from the time of the spam period '''DONE, removed 65743 accounts'''
| |
− | * testwiki.openoffice.org in DNS/ooo-wiki '''DONE, .htaccess is in place (wikitest/wikitest)
| |
− |
| |
− | * testwiki, oooSkin is not working, Alexandro is looking at it
| |
− | * testwiki, find new extensions for:
| |
− | ** extension FCKeditor is no longer supported and does not work (I am looking for a replacement)
| |
− | ** extension GoogleCoop does not work, and does not exist on mediawiki (thanks to Clayton I got a hint where to find it)
| |
− | ** extension LabeledSectionTransclusion does not offer a compat mode (needed due to DPL2 usage)
| |
− | ** extension MultiUpload no longer supported (there are no obvious replacement, I have to dig deeper)
| |
− | ** extension OOoIDLtags does not work (our own development, I need to change some core calls...wish I was a PHP specialist)
| |
− | ** extension PasswordReset no longer supported and does not work (not really needed so I will just remove it)
| |
− | ** extension StringFunctions no longer supported and are partly integrated in parserFunctions (We have to test that what we use is available)
| |
− | ** extension ToggleDisplay no longer supported, should be core functionality (we have to test that what we use is available)
| |
− |
| |
− | * Convert all pages to UTF8 (mysql),
| |
− | ** most pages are defined as latin1, but some have UTF8 content, this will not work after an update.
| |
− | :: The fix for this is to pass the tables manually through the conversion process using "binary" as an intermediary from Latin1 to UTF-8. Note though that this only "needs" to be done on tables that are incorrectly types as Latin1 but actually contain UTF-8 data. Not all tables in the OOoWiki dB have this issue.
| |
| UPDATE table_name SET col_name = CONVERT(CONVERT(CONVERT(col_name USING latin1) USING binary) USING utf8); | | UPDATE table_name SET col_name = CONVERT(CONVERT(CONVERT(col_name USING latin1) USING binary) USING utf8); |
− | :: Another way to do this (and possibly a more effective solution since it can be done during the MWiki upgrade) is: | + | :: |
| + | Another way to do this (and possibly a more effective solution since it can be done during the MWiki upgrade) is: |
| mysqldump -h DB_HOST -u DB_USER -p DB_PASSWORD --opt --quote-names --skip-set-charset --default-character-set=latin1 DB_NAME > DB_NAME-dump.sql | | mysqldump -h DB_HOST -u DB_USER -p DB_PASSWORD --opt --quote-names --skip-set-charset --default-character-set=latin1 DB_NAME > DB_NAME-dump.sql |
| mysql -h DB_HOST -u DB_USER -p DB_PASSWORD --default-character-set=utf8 DB_NAME < DB_NAME-dump.sql | | mysql -h DB_HOST -u DB_USER -p DB_PASSWORD --default-character-set=utf8 DB_NAME < DB_NAME-dump.sql |
| :: (source: http://blog.hno3.org/2010/04/22/fixing-double-encoded-utf-8-data-in-mysql/ ) | | :: (source: http://blog.hno3.org/2010/04/22/fixing-double-encoded-utf-8-data-in-mysql/ ) |
− |
| |
− | * Discuss on whether to add anti-spam measures for the currenct MW version.
| |
− | ** Search for extension to prevent spammers create user
| |
− | * open for create user
| |
− | ** this task caused concern, so it will be discussed again
| |
− | ** Decide on anti-spam measures for current MW version, install and set them, ''then'' open for create user.
| |
− | * Clean database, for "deleted" pages, unused files.
| |
− | * repair "broken redirect", "double redirect", "non categorized pages"
| |
− |
| |
− | * have people testing test
| |
− | * Copy production db, and upgrade it
| |
− | * copy test to production.
| |
− | * Assemble all files and inform community/infra about further action
| |
− |
| |
− | no goes:
| |
− | * there are objections against using openoffice SVN
| |
− | ** no intermediary changes will be recorded and snapshot steps for testing most be done with zip files (or not at all)
| |
Another way to do this (and possibly a more effective solution since it can be done during the MWiki upgrade) is: