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


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.

C-ORM: docs, API.

Last 100 entries

Small Success With Go!; Re: Quick message - This link is broken; Adding Reverb To The Echo Chamber; Sox Audio Tools; Would This Have Been OK?; Honesty only important economically before institutions develop; Stegangraphy via PS4; OpenCL Mess; More Book Recommendations; Good Explanation of Difference Between Majority + Minority; Musical Chairs - Who's The Privileged White Guy; I can see straight men watching this conversation and laffing; When it's Actually a Source of Indignation and Disgust; Meta Thread Defending POC Causes POC To Close Account; Indigenous People Of Chile; Curry Recipe; Interesting Link On Marginality; A Nuclear Launch Ordered, 1962; More Book Recs (Better Person); It's Nuanced, And I Tried, So Back Off; Marx; The Negative Of Positive; Jenny Holzer Rocks; Huge Article on Cultural Evolution and More; "Ignoring language theory"; Negative Finger Counting; Week 12; Communication Via Telecomm Bids; Finding Suspects Via Relatives' DNA From Non-Crime Databases; Statistics and Information Theory; Ice OK in USA; On The Other Hand; (Current Understanding Of) Chilean Taxes / Contributions; M John Harrison; Playing Games on a Cloud GPU; China Gamifies Real Life; Can't Help Thinking It's Thoughtcrime; Mefi Quotes; Spray Painting Bike Frame; Weeks 10 + 11; Change: No Longer Possible To Merge Metadata; Books on Old Age; Health Tree Maps; MRA - Men's Rights Activists; Writing Good C++14; Risk Assessment - Fukushima; The Future of Advertising and Surveillance; Travelling With Betaferon; I think I know what I dislike so much about Metafilter; Weeks 8 + 9; More; Pastamore - Bad Italian in Vitacura; History Books; Iraq + The (UK) Governing Elite; Answering Some Hard Questions; Pinochet: The Dictator's Shadow; An Outsider's Guide To Julia Packages; Nobody gives a shit; Lepton Decay Irregularity; An Easier Way; Julia's BinDeps (aka How To Install Cairo); Good Example Of Good Police Work (And Anonymity Being Hard); Best Santiago Burgers; Also; Michael Emmerich (Vibrator Translator) Interview (Japanese Books); Clarice Lispector (Brazillian Writer); Books On Evolution; Looks like Ara (Modular Phone) is dead; Index - Translations From Chile; More Emotion in Chilean Wines; Week 7; Aeon Magazine (Science-ish); QM, Deutsch, Constructor Theory; Interesting Talk Transcripts; Interesting Suggestion Of Election Fraud; "Hard" Books; Articles or Papers on depolarizing the US; Textbook for "QM as complex probabilities"; SFO Get Libor Trader (14 years); Why Are There Still So Many Jobs?; Navier Stokes Incomplete; More on Benford; FBI Claimed Vandalism; Architectural Tessellation; Also: Go, Blake's 7; Delusions of Gender (book); Crypto AG DID work with NSA / GCHQ; UNUMS (Universal Number Format); MOOCs (Massive Open Online Courses); Interesting Looking Game; Euler's Theorem for Polynomials; Weeks 3-6; Reddit Comment; Differential Cryptanalysis For Dummies; Japanese Graphic Design; Books To Be Re-Read; And Today I Learned Bugs Need Clear Examples; Factoring a 67 bit prime in your head; Islamic Geometric Art; Useful Julia Backtraces from Tasks; Nothing, however, is lost with less discomfort than that which, when lost, cannot be missed

© 2006-2015 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:


 * 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
< # /etc/init.d/postgresql
> # /etc/init.d/postgresql2
< # /(usr/)sbin/rcpostgresql
> # /(usr/)sbin/rcpostgresql2
< # Provides:       postgresql
> # Provides:       postgresql2
< PG_SYSCONFIG=/etc/sysconfig/postgresql
> PG_SYSCONFIG=/etc/sysconfig/postgresql2
< eval DATADIR=${POSTGRES_DATADIR:-~postgres/data}
> eval DATADIR=${POSTGRES_DATADIR:-~postgres/data2}
< PIDFILE=$DATADIR/postmaster.pid
> PIDFILE=$DATADIR/postmaster2.pid
<           "$INITDB --locale=$LANG --auth=\"ident\" $DATADIR &> initlog" ||
>           "$INITDB --locale=$LANG --encoding=UNICODE --auth=\"ident\"
   $DATADIR &> initlog" ||
<               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

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


Comment on this post