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