Wiki Upgrade: Difference between revisions

From Noisebridge
Jump to navigation Jump to search
(added database hacking ideas)
No edit summary
Line 36: Line 36:


We need to upgrade a really old version of mediawiki and will likely need to futz with the database. Lets use one of the OpenStack Semantic MediaWiki images for testing and refitting the database: https://wikitech.wikimedia.org/wiki/Portal:Cloud_VPS
We need to upgrade a really old version of mediawiki and will likely need to futz with the database. Lets use one of the OpenStack Semantic MediaWiki images for testing and refitting the database: https://wikitech.wikimedia.org/wiki/Portal:Cloud_VPS
=== Password Rollover ===
We need to delete the password column and expire everyone's password. The old mediawiki only stores md5 hashed passwords with no salts, so we'll have to delete the whole thing
<source>
user_password_expires[edit]
MediaWiki version: ≥ 1.23
Date when user's password expires; null for no expiration date. Can also be set manually by calling User->expirePassword().
</source>

Revision as of 15:03, 20 December 2017

Eternal Wiki Upgrade Quest

This is the beginning of the wiki upgrade page....



Requirements

  1. https by letsencrypt
  2. debian 9
  3. no snowflakes, all our (known) devops culture at nb is ansible
  4. salt the passwords correctly


Chosen Technologies

  1. Ansible
  2. Debian 9
  3. Caddy
  4. Letsencrypt / Certbot


Ansible Roles

Noisebridge already has an ansible infrastructure repo, please join the Noisebridge github group and hack this: https://github.com/noisebridge/ansible/


  1. Certbot - https://github.com/geerlingguy/ansible-role-certbot
  2. Semantic Mediawiki - Mediawiki maintains some: https://phabricator.wikimedia.org/diffusion/1881/
    1. It may be useful to look at this one: https://github.com/yongxinL/ansible-mediawiki


Database Hacking

We need to upgrade a really old version of mediawiki and will likely need to futz with the database. Lets use one of the OpenStack Semantic MediaWiki images for testing and refitting the database: https://wikitech.wikimedia.org/wiki/Portal:Cloud_VPS


Password Rollover

We need to delete the password column and expire everyone's password. The old mediawiki only stores md5 hashed passwords with no salts, so we'll have to delete the whole thing

<source> user_password_expires[edit] MediaWiki version: ≥ 1.23 Date when user's password expires; null for no expiration date. Can also be set manually by calling User->expirePassword(). </source>