Difference between revisions of "Moving the SF wiki"

Revision as of 13:37, 28 October 2014

copy existing backup:

then:

install mediawiki
- download mediawiki:
  
  wget http://releases.wikimedia.org/mediawiki/1.23/mediawiki-1.23.0.tar.gz
- tar xvzf mediawiki-*.tar.gz
- copy to /var/www/html/ and rename, perhaps
- install supporting applications:
  
  sudo apt-get install php-apc php5-intl imagemagick phpmyadmin vsftpd
  
  when installing one has to create passwords for mysql (2014..)
- start install process by calling http://http://146.155.17.19:21080/mediawiki-1.22.7/mw-config/index.php
=> Guide under: http://www.mediawiki.org/wiki/Manual:Running_MediaWiki_on_Ubuntu

=> Note, if there is a already a MediaWiki installation, one needs to use a different DB, see:
copy the images to the image folder
apply the sql dump file to mediawiki db using the "import" option
run: php maintenance/update.php
perhaps reset the passwords using a script SQL (http://kb.siteground.com/how_to_reset_my_mediawiki_admin_password/)

UPDATE user SET user_password = MD5( CONCAT( user_id, ‘-’, MD5( ‘NEWPASS‘ ) ) ) WHERE user_id =1

(the ID is the user id) or use

php changePassword.php --user=example --password=newpassword

change this user rights to be a sysop:

first find the users ID:

select user_id from user where user_name = 'Whatever';

If the user id is found (admin has usually '1') do:

INSERT INTO user_groups (ug_user, ug_group) VALUES ('1', 'bureaucrat');

 INSERT INTO user_groups (ug_user, ug_group) VALUES ('1', 'sysop')

create another account for editing (e.g. stefanS)
close the wiki - so no one else can sign up
perhaps fix file upload rights: e.g. with sudo chown -R www-data: /var/www/html/wiki

@@ Line 30: / Line 30: @@
 * create another account for editing (e.g. stefanS)
 * close the wiki - so no one else can sign up
+* perhaps fix file upload rights: e.g. with <code>sudo chown -R www-data: /var/www/html/wiki</code>