| 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.

C-ORM: docs, API.

Last 100 entries

Weird Componentized Virus; Interesting Argentinian Author - Antonio Di Benedetto; Useful Thread on MetaPhysics; RAND on fighting online anarchy (2001); Now Is Cat Soft LLC's Chance To Save Up To 32% On Mail; NSA Hacked; Call Center Services for Cat Soft LLC; Very Good LRB Article on Brexit; Nussbaum on Anger; Credit Card Processing for Cat Soft LLC; Discover new movies on demand in our online cinema; Tasting; Credit Card Processing for Cat Soft LLC; Apple + Kiwi Jam; Hit Me; Increase Efficiency with GPS Vehicle Tracking for Cat Soft LLC; Sudoku - CSP + Chaos; Recycling Electronics In Santiago; Vector Displays in OpenGL; Call Center Services for Cat Soft LLC; And Anti-Aliased; OpenGL - Render via Intermediate Texture; And Garmin Connect; Using Garmin Forerunner 230 With Linux; Payroll Service Quotes for Cat Soft LLC; (Beating Dead Horse) StackOverflow; Current State of Justice in China; Now Is Cat Soft LLC's Chance To Save Up To 32% On Mail; Axiom of Determinacy; Ewww; Fee Chaos Book; Course on Differential Geometry; Increase Efficiency with GPS Vehicle Tracking for Cat Soft LLC; Okay, but...; Sparse Matrices, Deep Learning; Sounds Bad; Applebaum Rape; Tomato Chutney v4; Have to add...; Culturally Liberal and Nothing More; Weird Finite / Infinite Result; Your diamond is a beaten up mess; Maths Books; Good Bike Route from Providencia / Las Condes to Panul\; Iain Pears (Author of Complex Plots); Plum Jam; Excellent; More Recently; For a moment I forgot StackOverflow sucked; A Few Weeks On...; Chilean Book Recommendations; How To Write Shared Libraries; Jenny Erpenbeck (Author); Dijkstra, Coins, Tables; Python libraries error on OpenSuse; Deserving Trump; And Smugness; McCloskey Economics Trilogy; cmocka - Mocks for C; Concept Creep (Americans); Futhark - OpenCL Language; Moved / Gone; Fan and USB issues; Burgers in Santiago; The Origin of Icosahedral Symmetry in Viruses; autoenum on PyPI; Jars Explains; Tomato Chutney v3; REST; US Elections and Gender: 24 Point Swing; PPPoE on OpenSuse Leap 42.1; SuperMicro X10SDV-TLN4F/F with Opensuse Leap 42.1; Big Data AI Could Be Very Bad Indeed....; Cornering; Postcapitalism (Paul Mason); Black Science Fiction; Git is not a CDN; Mining of Massive Data Sets; Rachel Kaadzi Ghansah; How great republics meet their end; Raspberry, Strawberry and Banana Jam; Interesting Dead Areas of Math; Later Taste; For Sale; Death By Bean; It's Good!; Tomato Chutney v2; Time ATAC MX 2 Pedals - First Impressions; Online Chilean Crafts; Intellectual Variety; Taste + Texture; Time Invariance and Gauge Symmetry; Jodorowsky; Tomato Chutney; Analysis of Support for Trump; Indian SF; TP-Link TL-WR841N DNS TCP Bug; TP-Link TL-WR841N as Wireless Bridge; Sending Email On Time; Maybe run a command; Sterile Neutrinos

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

   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