User Tools

Site Tools


archive_wiki_service

This is an old revision of the document!


Tardis has a a MediaWiki hosting facility.

Speak to seth for information.

MediaWiki User Accounts

Adding accounts

Thom can create new accounts.

Some notes for future reference

From… http://people.planetpostgresql.org/greg/index.php?/archives/74-Reset-a-user-password-on-MediaWiki.html. See also http://meta.wikimedia.org/wiki/Help:User_rights. Log into www.reaper as root, then:

  www:~# mysql -h db.reaper -u tardiswiki -p
  Enter password: 
  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 4057 to server version: 4.0.24
  Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
  mysql> insert into tw_user (user_name,user_real_name) values ('TestUser','Test User');
  Query OK, 1 row affected (0.03 sec)
  mysql> UPDATE tw_user SET user_password = md5( concat('25-',md5('somepassword'))) WHERE user_name='TestUser';

Where we really want the concat() call to be something like

  concat((SELECT user_id FROM tw_user WHERE user_name='TestUser'),'-',md5('somepassword'))

… Need to fix this and script this for a tardis-add-wikiuser script that users can run themselves to add their user or update password. Prod people for the tardiswiki password.

archive_wiki_service.1165166054.txt.gz · Last modified: (external edit)