Installation

From SONIVIS:Wiki

Jump to: navigation, search

This is a guide for installing and configuring SONIVIS:Tool.

This is for the new all-in-one bundle (out 27 May 2008) - for the old, non-bundled version please see Old Installation

Contents

Software installation

Database

If you have a MediaWiki installation and the access data for its MySQL database, you can skip this step. If not:

  1. Download and install a MySQL database server (like MySQL 5.0 or XAMPP).
    • Here you find an installation guideline for MySQL 5.0.45 Win32.
  2. PLEASE enable InnoDB engine BEFORE importing the database in order to gain more performance at analysis time. Do so by editing my.cnf (in Windows it should be in mysql\bin directory - in Linux it should be somewhere in /etc/ (or just type locate my.cnf ;-)) and replace
    skip-innodb
    with
    #skip-innodb
  3. Create a database [DBName] (e.g. called "enwikiversity")
    [YourDatabaseServerDirectory]/mysql/bin>mysql -u root -p --execute="create database [DBName]"
  4. For people without access to a MediaWiki database server, we have prepared some exemplary databases for your first steps with SONIVIS:Tool. Import one of these databases (e.g. use a prepared german or english Wikiversity database incl. Stored Procedures) or a database from Wikimedia's dump service):
    • Start the installed database server.
    • Unpack the generated / downloaded MediaWiki database SQL file (e.g. wikiversity.sql).
    • Run cmd (Windows) or start a terminal (Linux/MacOS X) and type:
      [YourDatabaseServerDirectory]/mysql/bin>mysql -u root -p [DBName] < [SQLFile]

SONIVIS-Tool installation

  1. Download and unpack with 7zip.
  2. Start the tool with SONIVISTool (Linux) or startup.bat (Windows), respectively. If you encounter any problems starting SONIVIS:Tool on Linux, please adjust the variables in startSONIVISTool (a bash script) according to your setup and try starting with this script.

Stored Procedures

In SONIVIS:Tool you can use precomputed database tables for your analyses. For example, there is a precalculated table with links of every revision. That raises performance significantly because the tool does not have to search for links in the revisions' text.
For German and English Wikiversity, we have already precalculated all tables — you may download the result here: German or English.

Creating Stored Procedures

If you want to load data from your own MediaWiki database server, you first have to run our stored procedures on your database server. Download the stored procedures here. After downloading and unpacking the SQL scripts, you have to execute them on the server. In order to do this, run cmd (Windows) or start a terminal (Linux/MacOS X) and type:

[YourDatabaseServerDirectory]/mysql/bin>mysql -u root -p
Enter password: (after installation no password is set)
...
mysql> use [DBName];
mysql> source [ScriptPath]/1create_pagelinks.sql;
mysql> source [ScriptPath]/2create_templatelinks.sql;
mysql> source [ScriptPath]/3create_revlength.sql;
mysql> source [ScriptPath]/6create_revdiff.sql;
mysql> source [ScriptPath]/8create_edges.sql;
mysql> CALL 1create_pagelinks;
mysql> CALL 2create_templatelinks;
mysql> CALL 3create_revlength;
mysql> CALL 6create_revdiff;
mysql> CALL 8create_edges;
mysql> exit;
[YourDatabaseServerDirectory]/mysql/bin>vi NamespaceUpdates.sql

Edit the NamespaceUpdates.sql file and add or uncomment namespaces according to your project.

[YourDatabaseServerDirectory]/mysql/bin>mysql -u root -p [DBName] < NamespaceUpdates.sql

Error Handling

If you encounter any errors please follow these guides:

Personal tools