User:Ursdestiny/installing Wikipedia on Server 2003

I am posting a tutorial for installing Wikipedia on Server 2003 using wamp and mediwiki for lan access.

I hope its useful.

==

'''
Wikipedia Installation ==''' == ==

1.	Install Wamp (Windows-apache-MySql-PHP) server

2.	Create a DB user on MySql

a.	Go to PHPMyAdmin b.	Click privileges c.	Add a new user i.	Username: wikiuser ii. Host: Localhost iii. Password: xxxxxx iv. Generate password: click the generate button v.	Global privileges: All unchecked d.	Click Go   e.	On confirmation page click edit the user to for the section “Database-Specific privileges” f.	Set Dropdown to “ Use text field” g.	Enter “wikidb” and click Go   h.	Check all and click Go

Install Mediawiki
1.	Unpack the mediawiki to a new folder (wiki) created in the www in the Wamp folder

2.	Type: http://localhost/wiki in your browser and you reach “setup the wiki first” page

3.	Follow the link and you will get a “Site Config.” page

a.	Wiki Name: Wikipedia b.	Password: xxxxxx c.	Database Host: localhost d.	Database Name: wikidb e.	DB username: wikiuser f.	DB password: same password used when creating MySql user

4.	Leave the rest default and click install mediawiki.

5.	Go to- wamp root\www\wiki\config\ and copy LocalSettings.php to wamp root\www\wiki\

== Download and Install dumps of Wikipedia ==

1.	Download the latest Wikipedia dumps from Wikimedia website

2.	Extract the file

3.	Download XML2SQL

4.	 Run XML2SQL giving the extracted file with following options:

a.	Output format – mysqlimport b.	Option Full revision

5.	Go to MySql console and type source filename.sql for both pages and text files

6.	For importing revision table run the following sql command:

a.	Alter table Revision Drop Column rev_len, drop column rev_parent_id; b.	Source revision.sql; c.	Alter table revision Add column rev_len INT (10) UNSIGNED DEFAULT NULL AFTER rev_deleted, Add column rev_parent_id INT (10) UNSIGNED DEFAULT NULL AFTER rev_len;

7.	In cmd type: (path)\Php.exe (path-maintenance folder of wiki)\ rebuild.php

== Tweaking Wiki ==

1.	Get the following file cite.php and Parser Function.php

2.	Add the two lines to LocalSettings.php

Require_once (“$IP/extensions/parserfunctions/ParserFunction.php”); Require_once (“$IP/extensions/cite/cite.php”); The setup is now complete but the search is slow.

Installing Sphinx
1.	Extract to a Folder

2.	Rename the “sphinx.conf.in” to “sphinx.conf”

3.	Set the following code in the file

source src_wiki_main

{

type = mysql

sql_host = localhost

sql_user = wikiuser

sql_pass = xxxxxx

sql_db = wikidb

sql_query_pre = SET NAMES utf8

sql_query = SELECT page_id, page_title, page_namespace, old_id, old_text FROM page, revision, text WHERE rev_id=page_latest AND old_id=rev_text_id sql_attr_uint = page_namespace

sql_attr_uint = old_id

sql_query_info = SELECT page_title, page_namespace FROM page WHERE page_id=$id

}

source src_wiki_incremental : src_wiki_main

{

sql_query = SELECT page_id, page_title, page_namespace, old_id, old_text FROM page, revision, text WHERE rev_id=page_latest AND old_id=rev_text_id AND page_touched>=DATE_FORMAT(CURDATE, '%Y%m%d070000')

}

index wikipedia

{

source = src_wiki_main

path = C:\Sphinx\data\wikipedia

docinfo = extern

morphology = stem_en

min_word_len = 1

charset_type = utf-8

charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F

}

index wiki_incremental : wikipedia

{

path = C:\Sphinx\data\wikipediastemmed

source = src_wiki_incremental

}

indexer

{

mem_limit = 64M

}

searchd

{

#address = 127.0.0.1

port = 3312

log = C:\Sphinx\data\log\searchd.log

query_log = C:\Sphinx\data\log\query.log

read_timeout = 5

max_children = 30

pid_file = C:\Sphinx\data\log\searchd.pid

max_matches = 1000

}

4.	Go to Command prompt and set sphinx as the working directory

5.	Run the command: bin/indexer –-config sphinx.conf

6.	Wait

7.	After indexing has completed Run the command: bin/searchd –install –-config sphinx.conf