| Andrew Cooke | Contents | Latest | RSS | Twitter | Previous | Next

C[omp]ute

Welcome to my blog, which was once a mailing list of the same name and is still generated by mail. Please reply via the "comment" links.

Always interested in offers/projects/new ideas. Eclectic experience in fields like: numerical computing; Python web; Java enterprise; functional languages; GPGPU; SQL databases; etc. Based in Santiago, Chile; telecommute worldwide. CV; email.

Personal Projects

Lepl parser for Python.

Colorless Green.

Photography around Santiago.

SVG experiment.

Professional Portfolio

Calibration of seismometers.

Data access via web services.

Cache rewrite.

Extending OpenSSH.

Last 100 entries

The Quest for Randomness; Chat Wars; Real-life Financial Co Without ACID Database...; Flexible Muscle-Based Locomotion for Bipedal Creatures; SQL Performance Explained; The Little Manual of API Design; Multiple Word Sizes; CRC - Next Steps; FizzBuzz; Update on CRCs; Decent Links / Discussion Community; Automated Reasoning About LLVM Optimizations and Undefined Behavior; A Painless Guide To CRC Error Detection Algorithms; Tests in Julia; Dave Eggers: what's so funny about peace, love and Starship?; Cello - High Level C Programming; autoreconf needs tar; Will Self Goes To Heathrow; Top 5 BioInformatics Papers; Vasovagal Response; Good Food in Vina; Chilean Drug Criminals Use Subsitution Cipher; Adrenaline; Stiglitz on the Impact of Technology; Why Not; How I Am 5; Lenovo X240 OpenSuse 13.1; NSA and GCHQ - Psychological Trolls; Finite Fields in Julia (Defining Your Own Number Type); Julian Assange; Starting Qemu on OpenSuse; Noisy GAs/TMs; Venezuela; Reinstalling GRUB with EFI; Instructions For Disabling KDE Indexing; Evolving Speakers; Changing Salt Size in Simple Crypt 3.0.0; Logarithmic Map (Moved); More Info; Words Found in Voynich Manuscript; An Inventory Of 3D Space-Filling Curves; Foxes Using Magnetic Fields To Hunt; 5 Rounds RC5 No Rotation; JP Morgan and Madoff; Ori - Secure, Distributed File System; Physical Unclonable Functions (PUFs); Prejudice on Reddit; Recursion OK; Optimizing Julia Code; Cash Handouts in Brazil; Couple Nice Music Videos; It Also Works!; Adaptive Plaintext; It Works!; RC5 Without Rotation (2); 8 Years...; Attack Against Encrypted Linux Disks; Pushing Back On NSA At IETF; Summary of Experimental Ethics; Very Good Talk On Security, Snowden; Locusts are Grasshoppers!; Vagrant (OpenSuse and IDEs); Interesting Take On Mandela's Context; Haskell Cabal O(n^2) / O(n) Fix; How I Am 4; Chilean Charity Supporting Women; Doing SSH right; Festival of Urban Intervention; Neat Idea - Wormholes Provide Entanglement; And a Link....; Simple Encryption for Python 2.7; OpenSuse 13.1 Is Better!; Little Gain...; More Details on Technofull Damage; Palmrest Cracked Too....; Tecnofull (Lenovo Support) Is Fucking Useless; The Neuroscientist Who Discovered He Was a Psychopath; Interpolating Polynomials; Bottlehead Crack as Pre-amp; Ooops K702!; Bottlehead Crack, AKG K701; Breaking RC5 Without Rotation; Great post thank you; Big Balls of Mud; Phabricator - Tools for working together; Amazing Julia RC5 Code Parameterized By Word Size; Chi-Square Can Be Two-Sided; Why Do Brits Accept Surveillance?; Statistics Done Wrong; Mesas Trape from Bravo; European Report on Crypto Primitives and Protocols; Interesting Omissions; Oryx And Crake (Margaret Atwood); Music and Theory; My Arduino Programs; Elliptic Curve Crypto; Re: Licensing Interpreted Code; Licensing Interpreted Code; ASUS 1015E-DS03 OpenSuse 12.3 SSD; translating lettuce feature files into stub steps files; Re: translating lettuce feature files into stub steps files

© 2006-2013 Andrew Cooke (site) / post authors (content).

Installing MusicBrainz Database

From: andrew cooke <andrew@...>

Date: Fri, 11 Mar 2011 08:20:58 -0300

I just installed the MusicBrainz database.  It was a little more complex than
I expected, so here are my notes on what to do.


First, it requires an unusual combination of collation and encoding (actually,
not so strange, but different from the default install on OpenSuse).  Since I
already use Postgres, and these are set per *installation* (not per database),
I needed a parallel install of Postgres.

That meant creating a new data directory (data2) in /var/lib/pgsql and then
configuring new configuration and init scripts:

 * Copy /etc/sysconfig/postgresql to /etc/sysconfig/postgresql2 and change the
   contents to have:

   POSTGRES_DATADIR="~postgres/data2"
   POSTGRES_OPTIONS="-p 5433"
   POSTGRES_LANG="C"

 * Change /etc/init.d/postgresql to remove only /tmp/.s.PGSQL.5432 and not
   /tmp/.s.PGSQL.* (IMPORTANT!)

 * Copy /etc/init.d/postgresql to /etc/init.d/postgresql2 and
   change to match the diff below
> diff /etc/init.d/postgresql /etc/init.d/postgresql2
8c8
< # /etc/init.d/postgresql
---
> # /etc/init.d/postgresql2
10c10
< # /(usr/)sbin/rcpostgresql
---
> # /(usr/)sbin/rcpostgresql2
31c31
< # Provides:       postgresql
---
> # Provides:       postgresql2
40c40
< PG_SYSCONFIG=/etc/sysconfig/postgresql
---
> PG_SYSCONFIG=/etc/sysconfig/postgresql2
53c53
< eval DATADIR=${POSTGRES_DATADIR:-~postgres/data}
---
> eval DATADIR=${POSTGRES_DATADIR:-~postgres/data2}
57c57
< PIDFILE=$DATADIR/postmaster.pid
---
> PIDFILE=$DATADIR/postmaster2.pid
115c115
<           "$INITDB --locale=$LANG --auth=\"ident\" $DATADIR &> initlog" ||
---
>           "$INITDB --locale=$LANG --encoding=UNICODE --auth=\"ident\"
   $DATADIR &> initlog" ||
126c126
<               rm -f /tmp/.s.PGSQL.5432 $PIDFILE
---
>               rm -f /tmp/.s.PGSQL.5433 $PIDFILE

 * Link the new init file from /usr/sbin/rcpostgresql2 (see the link there for
   the original)

With those changes (and chkconfig -a) the new postgres instance will run,
listening on port 5433.  Note that when you use this database, you always need
to add "-p 5433" to commands.  So, for example, to list databases:

  psql -l -p 5433


Next, configure that database and install the data.  This largely follows the
MusicBrainz site instructions, once you figure them out.

Since I only wanted the database, but wanted it complete, I decided to use the
server install scripts (the site has an alternative install process that
doesn't use the install scripts, but which looked a little unreliable -
mentioned things like not setting foreign keys...).

To do this, download both the latest data and the code from
http://svn.musicbrainz.org/mb_server/branches/RELEASE_20090524-BRANCH

Next, look at the INSTALL file you downloaded and make sure all requirements
are installed.  I don't like CPAN, but the Strings::ShellQuote module is not
listed in Yast, so I needed to use CPAN to install that.

I decided that the Postgres databases would be mbrainz and mbrainz_raw, and
that I would configure the initial database creation as postgres, then use the
database as myself (andrew).  So I configured pg_hba.conf with:

 local   mbrainz     mbrainz                           ident map=mb_map
 local   mbrainz_raw mbrainz                           ident map=mb_map

(note that these lines must be before "local all all") and pg_ident.conf with:

 mb_map        andrew             mbrainz

and then start postgres (or restart if it was running before these changes).

Finally, configure cgi-bin/DBDefs.pm.  I had entries:

        READWRITE => {
            database    => "mbrainz",
            username    => "mbrainz",
            password    => "",
            host        => "",
            port        => "5433",
        },

        SYSTEM  => {
            database    => "template1",
            username    => "postgres",
            password    => "",
            host        => "",
            port        => "5433",
        },

       RAWDATA => {
            database    => "mbrainz_raw",
            username    => "mbrainz",
            password    => "",
            host        => "",
            port        => "5433",
       },

In particular, note the 5433 port numbers.


With all the configuration done, install worked smoothly.

As postgres:

 ./admin/InitDb.pl --createdb --empty-database

As myself:

 ./admin/InitDb.pl --import ../20110309-000002/mbdump*.tar.bz2


It's worth mentioning that you do need all the data.  I tried to load
everything but one file, which I thought I would not need, and got an error
(one that googling associated with an incorrect source code version, which was
misleading).

Andrew

Comment on this post