History:Installing MB Slave and Search Server on a New Xubuntu Machine: Difference between revisions

From MusicBrainz Wiki
Jump to navigationJump to search
No edit summary
No edit summary
Line 1: Line 1:
+++Install software not available from apt
==Install software not available from apt
Install Xubunu 12.10 from CD
Install Xubunu 12.10 from CD
Download and unzip mbslave
Download and unzip mbslave
Download an unzip psycopg 2-2.4.6
Download an unzip psycopg 2-2.4.6


=== Download Musicbrainz Datadumps
== Download Musicbrainz Datadumps
cp /home/paul/Downloads/mbdump*.bz2 /home/paul/Downloads/lalinsky-mbslave*
cp /home/paul/Downloads/mbdump*.bz2 /home/paul/Downloads/lalinsky-mbslave*


=== Install Postgres
==Install Postgres
<pre>
<pre>
sudo apt-get install postgresql-9.1 postgresql-server-dev-9.1 postgresql-contrib-9.1
sudo apt-get install postgresql-9.1 postgresql-server-dev-9.1 postgresql-contrib-9.1
Line 13: Line 13:
</pre>
</pre>


=== Configue psycogs2
==Configue psycogs2
<pre>
<pre>
sudo apt-get install python-dev
sudo apt-get install python-dev
Line 20: Line 20:
</pre>
</pre>


===Configure mbslave
==Configure mbslave
<pre>
<pre>
cd /home/paul/Downloads/lalinsky-mbslave*
cd /home/paul/Downloads/lalinsky-mbslave*
Line 27: Line 27:
</pre>
</pre>


== Setup Musicbrainz Database
==Setup Musicbrainz Database
<pre>
<pre>
sudo su - postgres
sudo su - postgres
Line 52: Line 52:


./mbslave-remap-schema.py <sql/CreateSimpleViews.sql | ./mbslave-psql.py
./mbslave-remap-schema.py <sql/CreateSimpleViews.sql | ./mbslave-psql.py
</pre>
Cntl-D
Cntl-D
</pre>


== Build Search Server
==Build Search Server
<pre>
<pre>
sudo apt-get install subversion
sudo apt-get install subversion

Revision as of 09:47, 18 March 2013

==Install software not available from apt Install Xubunu 12.10 from CD Download and unzip mbslave Download an unzip psycopg 2-2.4.6

== Download Musicbrainz Datadumps cp /home/paul/Downloads/mbdump*.bz2 /home/paul/Downloads/lalinsky-mbslave*

==Install Postgres

sudo apt-get install postgresql-9.1 postgresql-server-dev-9.1 postgresql-contrib-9.1
export PATH=$PATH:/usr/lib/postgresql/9.1/bin

==Configue psycogs2

sudo apt-get install python-dev
cd /home/paul/Downloads/psycopg2-2.4.6
python setup.py install

==Configure mbslave

cd /home/paul/Downloads/lalinsky-mbslave*
cp mbslave.conf.default mbslave.conf
uncomment password line and set to musicbrainz

==Setup Musicbrainz Database

sudo su - postgres
createuser musicbrainz
createdb -l C -E UTF-8 -T template0 -O musicbrainz musicbrainz
createlang plpgsql musicbrainz
plsql musicbrainz
ALTER ROLE musicbrainz WITH PASSWORD 'musicbrainz'
Cntl-D
echo 'CREATE SCHEMA musicbrainz;' | ./mbslave-psql.py -S
echo 'CREATE SCHEMA statistics;' | ./mbslave-psql.py -S
echo 'CREATE SCHEMA cover_art_archive;' | ./mbslave-psql.py -S
./mbslave-remap-schema.py <sql/CreateTables.sql | sed 's/CUBE/TEXT/' | ./mbslave-psql.py
./mbslave-remap-schema.py <sql/statistics/CreateTables.sql | ./mbslave-psql.py
./mbslave-remap-schema.py <sql/caa/CreateTables.sql | ./mbslave-psql.py
./mbslave-import.py mbdump.tar.bz2 mbdump-derived.tar.bz2 mbdump-cdstubs.tar.bz2 mbdump-cover-art-archive.tar.bz2
./mbslave-remap-schema.py <sql/CreatePrimaryKeys.sql | ./mbslave-psql.py
./mbslave-remap-schema.py <sql/statistics/CreatePrimaryKeys.sql | ./mbslave-psql.py
./mbslave-remap-schema.py <sql/caa/CreatePrimaryKeys.sql | ./mbslave-psql.py

./mbslave-remap-schema.py <sql/CreateIndexes.sql | grep -vE '(collate|page_index|tracklist_index)' | ./mbslave-psql.py
./mbslave-remap-schema.py <sql/statistics/CreateIndexes.sql | ./mbslave-psql.py
./mbslave-remap-schema.py <sql/caa/CreateIndexes.sql | ./mbslave-psql.py

./mbslave-remap-schema.py <sql/CreateSimpleViews.sql | ./mbslave-psql.py
Cntl-D

==Build Search Server

sudo apt-get install subversion
sudo apt-get install openjdk-7-jdk maven2 tomcat7 
cd
mkdir code
mkdir musicbrainz
cd code/musicbrainz
svn co http://svn.musicbrainz.org/mmd-schema/trunk mmd-schema
svn co http://svn.musicbrainz.org/search_server/trunk search_server
cd mmd-schema/brainz-mmd2-jaxb
mvn install
cd /home/paul/code/musicbrainz/search_server/servlet/src/main/webapp/WEB-INF
vi web.xml chnage to <param-value>/home/paul/indexdata</param-value>

==Build Indexes

cd /home/paul/code/musicbrainz/search_server/index/target
java  -jar index-2.0-SNAPSHOT-jar-with-dependencies.jar --indexes-dir /home/paul/indexdata -d musicbrainz -u musicbrainz -p musicbrainz