Version at: 07/04/2013, 13:41 vs. version at: 07/04/2013, 13:45
11NOTE: This is about installing the PHP version (i.e. current version) of Tatoeba.
22
33# Downloads
44
55## Required tools
66
77* Apache
88* PHP
99* MySQL
1010* SVN Client
1111
1212For those who are on Windows:
1313
1414* [XAMPP](http://www.apachefriends.org/en/xampp-windows.html) will do the trick for Apache/PHP/MySQL.
1515* [TortoiseSVN](http://tortoisesvn.net/downloads.html) for the SVN client
1616
1717## Source code
1818
1919The source code is hosted on a platform called Assembla:
2020[https://www.assembla.com/code/tatoeba2/subversion/nodes](https://www.assembla.com/code/tatoeba2/subversion/nodes)
2121
2222Repository URL:
2323[https://subversion.assembla.com/svn/tatoeba2/](https://subversion.assembla.com/svn/tatoeba2/)
2424
2525URL you'll want to checkout:
2626[https://subversion.assembla.com/svn/tatoeba2/trunk/](https://subversion.assembla.com/svn/tatoeba2/trunk/)
2727
2828
2929# Configuration
3030
3131## Virtual host
3232
3333You may set up a virtual host. I personally use http://tatoeba.dev/ as my local URL.
3434
3535**TODO** More details on how to do that.
3636
3737
3838## mod_rewrite
3939
4040You need to have mod_rewrite enabled, it's necessary for CakePHP.
4141
4242**TODO** More details on how to do that.
4343
4444
4545## app/core/config.php
4646
4747In the file app/core/config.php, put into comments the part about XCache.
4848
49`/*
50Cache::config('default', array(
49 /*
50 Cache::config('default', array(
5151    'engine' => 'Xcache', //[required]
5252    'duration'=> 3600, //[optional]
5353    'probability'=> 100, //[optional]
5454    'prefix' => Inflector::slug(APP_DIR) . '_', //[optional] prefix every cache file with this string
5555    'user' => 'user', //user from xcache.admin.user settings
56 'password' => 'password', //plaintext password (xcache.admin.pass)
57));
58 Cache::config('_cake_core_', array(
56 'password' => 'password', //plaintext password (xcache.admin.pass)
57 ));
58 Cache::config('_cake_core_', array(
5959    'engine' => 'Xcache', //[required]
6060    'duration'=> 3600, //[optional]
6161    'probability'=> 100, //[optional]
6262    'prefix' => Inflector::slug(APP_DIR) . '_', //[optional] prefix every cache file with this string
6363    'user' => 'user', //user from xcache.admin.user settings
64 'password' => 'password', //plaintext password (xcache.admin.pass)
65));
66*/`
64 'password' => 'password', //plaintext password (xcache.admin.pass)
65 ));
66 */
6767
6868And uncomment the line to use the "File" cache engine:
6969
7070`Cache::config('default', array('engine' => 'File'));`
7171
7272
7373
7474## app/core/database.php
7575
7676In the file app/core/database.php, set your login, password and database in the $default array.
7777
7878`
7979var $default = array(
8080    'driver' => 'mysql',
8181    'persistent' => false,
8282    'host' => 'localhost',
8383    'login' => 'root',
8484    'password' => 'somepassword',
8585    'database' => 'tatoeba',
8686    'prefix' => '',
8787    'encoding' => 'utf8'
8888);
8989`
9090
9191## app/models/sentence.php
9292
9393Tatoeba uses some other external tools that you won't necessarily need. These tools are:
9494
9595* the search engine (Sphinx)
9696* the tools for romanization
9797
9898If you're not going to work on the search or on the romanization and don't want to install these tools, you will have to uncomment a few things in the Sentence model (app/models/sentence.php).
9999
100100line 274: uncomment "return array(1)"
101101`public function getSeveralRandomIds($lang = 'und', $numberOfIdWanted = 10)
102102{
103103 // Uncomment the line below if you don't have sphinx installed.
104104 return array(1);`
105105
106106line 847: uncomment "return false"
107107`public function generateMetas(&$sentenceArray)
108108{
109109 // Uncomment the line below you don't have the Chinese
110110 // romanization tools installed.
111111 return false;`
112112    
113113    
114114# Database
115115
116116Now you need to create the database, and import the necessary things.
117117
118118First, create the database. Make sure the name you use here is the name you've set in app/core/database.php. I'll name it tateoba.
119119`CREATE DATABASE tatoeba`
120120`USE tatoeba`
121121
122122Then execute the following scripts.
123123
1241241. This will create all the tables (they will be empty).
125125`\. docs/database/database_20130406.sql`
126126
1271272. These will create a minimal user base (one user in each group), and the associated access rights for each user.
128128`\. docs/database/import/groups.sql
129129\. docs/database/import/users.sql
130130\. docs/database/import/acos.sql
131131\. docs/database/import/aros.sql
132132\. docs/database/import/aros_acos.sql`
133133
1341343. This will import the list of countries. It's used in profile.
135135`\. docs/database/import/countries.sql`
136136
137137**TODO** Would probably be nice to have some data for sentences, comments, wall messages as well. Although they can be created manually once logged in.
138138
139139
140140# Logging in
141141
142142Now you should be able to go to your local Tatoeba URL (http://tatoeba.dev/ in my case), and be able to log in.
143143
144144The default usernames are:
145145
146146* admin
147147* corpus_maintainer
148148* advanced_contributor
149149* contributor
150150* inactive
151151* spammer
152152
153153The default password for each user is '123456'.
diff view generated by jsdifflib

Version at: 07/04/2013, 13:41

NOTE: This is about installing the PHP version (i.e. current version) of Tatoeba.

# Downloads

## Required tools

* Apache
* PHP
* MySQL
* SVN Client

For those who are on Windows:

* [XAMPP](http://www.apachefriends.org/en/xampp-windows.html) will do the trick for Apache/PHP/MySQL.
* [TortoiseSVN](http://tortoisesvn.net/downloads.html) for the SVN client

## Source code

The source code is hosted on a platform called Assembla:
[https://www.assembla.com/code/tatoeba2/subversion/nodes](https://www.assembla.com/code/tatoeba2/subversion/nodes)

Repository URL:
[https://subversion.assembla.com/svn/tatoeba2/](https://subversion.assembla.com/svn/tatoeba2/)

URL you'll want to checkout:
[https://subversion.assembla.com/svn/tatoeba2/trunk/](https://subversion.assembla.com/svn/tatoeba2/trunk/)


# Configuration

## Virtual host

You may set up a virtual host. I personally use http://tatoeba.dev/ as my local URL.

**TODO** More details on how to do that.


## mod_rewrite

You need to have mod_rewrite enabled, it's necessary for CakePHP.

**TODO** More details on how to do that.


## app/core/config.php

In the file app/core/config.php, put into comments the part about XCache.

`/*
Cache::config('default', array(
	'engine' => 'Xcache', //[required]
	'duration'=> 3600, //[optional]
	'probability'=> 100, //[optional]
	'prefix' => Inflector::slug(APP_DIR) . '_', //[optional] prefix every cache file with this string
	'user' => 'user', //user from xcache.admin.user settings
   'password' => 'password', //plaintext password (xcache.admin.pass)
));
 Cache::config('_cake_core_', array(
	'engine' => 'Xcache', //[required]
	'duration'=> 3600, //[optional]
	'probability'=> 100, //[optional]
	'prefix' => Inflector::slug(APP_DIR) . '_', //[optional] prefix every cache file with this string
	'user' => 'user', //user from xcache.admin.user settings
   'password' => 'password', //plaintext password (xcache.admin.pass)
));
*/`

And uncomment the line to use the "File" cache engine:

`Cache::config('default', array('engine' => 'File'));`



## app/core/database.php

In the file app/core/database.php, set your login, password and database in the $default array.

`
var $default = array(
	'driver' => 'mysql',
	'persistent' => false,
	'host' => 'localhost',
	'login' => 'root',
	'password' => 'somepassword',
	'database' => 'tatoeba',
	'prefix' => '',
	'encoding' => 'utf8'
);
`

## app/models/sentence.php

Tatoeba uses some other external tools that you won't necessarily need. These tools are:

* the search engine (Sphinx)
* the tools for romanization

If you're not going to work on the search or on the romanization and don't want to install these tools, you will have to uncomment a few things in the Sentence model (app/models/sentence.php).

line 274: uncomment "return array(1)"
`public function getSeveralRandomIds($lang = 'und',  $numberOfIdWanted = 10)
{
    // Uncomment the line below if you don't have sphinx installed.
    return array(1);`

line 847: uncomment "return false"
`public function generateMetas(&$sentenceArray) 
{
    // Uncomment the line below you don't have the Chinese
    // romanization tools installed.
    return false;`
	
	
# Database

Now you need to create the database, and import the necessary things.

First, create the database. Make sure the name you use here is the name you've set in app/core/database.php. I'll name it tateoba.
`CREATE DATABASE tatoeba`
`USE tatoeba`

Then execute the following scripts.

1. This will create all the tables (they will be empty).
`\. docs/database/database_20130406.sql`

2. These will create a minimal user base (one user in each group), and the associated access rights for each user.
`\. docs/database/import/groups.sql
\. docs/database/import/users.sql
\. docs/database/import/acos.sql
\. docs/database/import/aros.sql
\. docs/database/import/aros_acos.sql`

3. This will import the list of countries. It's used in profile.
`\. docs/database/import/countries.sql`

**TODO** Would probably be nice to have some data for sentences, comments, wall messages as well. Although they can be created manually once logged in.


# Logging in

Now you should be able to go to your local Tatoeba URL (http://tatoeba.dev/ in my case), and be able to log in.

The default usernames are: 

* admin
* corpus_maintainer
* advanced_contributor
* contributor
* inactive
* spammer

The default password for each user is '123456'.

version at: 07/04/2013, 13:45

NOTE: This is about installing the PHP version (i.e. current version) of Tatoeba.

# Downloads

## Required tools

* Apache
* PHP
* MySQL
* SVN Client

For those who are on Windows:

* [XAMPP](http://www.apachefriends.org/en/xampp-windows.html) will do the trick for Apache/PHP/MySQL.
* [TortoiseSVN](http://tortoisesvn.net/downloads.html) for the SVN client

## Source code

The source code is hosted on a platform called Assembla:
[https://www.assembla.com/code/tatoeba2/subversion/nodes](https://www.assembla.com/code/tatoeba2/subversion/nodes)

Repository URL:
[https://subversion.assembla.com/svn/tatoeba2/](https://subversion.assembla.com/svn/tatoeba2/)

URL you'll want to checkout:
[https://subversion.assembla.com/svn/tatoeba2/trunk/](https://subversion.assembla.com/svn/tatoeba2/trunk/)


# Configuration

## Virtual host

You may set up a virtual host. I personally use http://tatoeba.dev/ as my local URL.

**TODO** More details on how to do that.


## mod_rewrite

You need to have mod_rewrite enabled, it's necessary for CakePHP.

**TODO** More details on how to do that.


## app/core/config.php

In the file app/core/config.php, put into comments the part about XCache.

    /*
    Cache::config('default', array(
	'engine' => 'Xcache', //[required]
	'duration'=> 3600, //[optional]
	'probability'=> 100, //[optional]
	'prefix' => Inflector::slug(APP_DIR) . '_', //[optional] prefix every cache file with this string
	'user' => 'user', //user from xcache.admin.user settings
        'password' => 'password', //plaintext password (xcache.admin.pass)
    ));
    Cache::config('_cake_core_', array(
	'engine' => 'Xcache', //[required]
	'duration'=> 3600, //[optional]
	'probability'=> 100, //[optional]
	'prefix' => Inflector::slug(APP_DIR) . '_', //[optional] prefix every cache file with this string
	'user' => 'user', //user from xcache.admin.user settings
        'password' => 'password', //plaintext password (xcache.admin.pass)
    ));
    */

And uncomment the line to use the "File" cache engine:

`Cache::config('default', array('engine' => 'File'));`



## app/core/database.php

In the file app/core/database.php, set your login, password and database in the $default array.

`
var $default = array(
	'driver' => 'mysql',
	'persistent' => false,
	'host' => 'localhost',
	'login' => 'root',
	'password' => 'somepassword',
	'database' => 'tatoeba',
	'prefix' => '',
	'encoding' => 'utf8'
);
`

## app/models/sentence.php

Tatoeba uses some other external tools that you won't necessarily need. These tools are:

* the search engine (Sphinx)
* the tools for romanization

If you're not going to work on the search or on the romanization and don't want to install these tools, you will have to uncomment a few things in the Sentence model (app/models/sentence.php).

line 274: uncomment "return array(1)"
`public function getSeveralRandomIds($lang = 'und',  $numberOfIdWanted = 10)
{
    // Uncomment the line below if you don't have sphinx installed.
    return array(1);`

line 847: uncomment "return false"
`public function generateMetas(&$sentenceArray) 
{
    // Uncomment the line below you don't have the Chinese
    // romanization tools installed.
    return false;`
	
	
# Database

Now you need to create the database, and import the necessary things.

First, create the database. Make sure the name you use here is the name you've set in app/core/database.php. I'll name it tateoba.
`CREATE DATABASE tatoeba`
`USE tatoeba`

Then execute the following scripts.

1. This will create all the tables (they will be empty).
`\. docs/database/database_20130406.sql`

2. These will create a minimal user base (one user in each group), and the associated access rights for each user.
`\. docs/database/import/groups.sql
\. docs/database/import/users.sql
\. docs/database/import/acos.sql
\. docs/database/import/aros.sql
\. docs/database/import/aros_acos.sql`

3. This will import the list of countries. It's used in profile.
`\. docs/database/import/countries.sql`

**TODO** Would probably be nice to have some data for sentences, comments, wall messages as well. Although they can be created manually once logged in.


# Logging in

Now you should be able to go to your local Tatoeba URL (http://tatoeba.dev/ in my case), and be able to log in.

The default usernames are: 

* admin
* corpus_maintainer
* advanced_contributor
* contributor
* inactive
* spammer

The default password for each user is '123456'.

Note

The lines in green are the lines that have been added in the new version. The lines in red are those that have been removed.

Actions