I did try to get this server thing going on centos but I got to the point where I would be better off getting MusicBrainz Server Virtual Machine that was already created.

All I'm looking at doing is setting up an Musicbrainz server that is offline (not conected to the net) and just the database in it.

Will the current database dump work with the MusicBrainz Server Virtual Machine image provided?

Thankyou :)

I have been trying to setup the server using the provided VM. When I tried to access the server after starting it getting the following exception.

Caught exception in MusicBrainz::Server::Controller::Root->index "mismatched tag 'BODY'"

Any help is really appreciated. I have included part of the stack trace below.

Thanks,
Regards,
Sumith

Stack Trace

Package    Line    File
MusicBrainz::Server::Data::Blog    26    lib/MusicBrainz/Server/Data/Blog.pm
   23:         return undef unless $xml && $xml->is_success;
   24:
   25:         $entry_parser = XML::RSS::Parser::Lite->new;
   26:         $entry_parser->parse($xml->content);
   27:         $cache->set($key => $entry_parser);
   28:     }
   29:

MusicBrainz::Server::Controller::Root    44    lib/MusicBrainz/Server/Controller/Root.pm
   41: sub index : Path Args(0)
   42: {
   43:     my ($self, $c) = @_;
   44:     $c->stash(
   45:         blog => $c->model('Blog')->get_latest_entries,
   46:         template => 'main/index.tt'
   47:     );

MusicBrainz::Server    322    lib/MusicBrainz/Server.pm
  319:             chomp $warning;
  320:             $c->log->warn($c->req->method . " " . $c->req->uri . " caused a warning: " . $warning);
  321:         };
  322:         $c->next::method(@_);
  323:     };
  324: }
  325:

MusicBrainz::Server    322    lib/MusicBrainz/Server.pm
  319:             chomp $warning;
  320:             $c->log->warn($c->req->method . " " . $c->req->uri . " caused a warning: " . $warning);
  321:         };
  322:         $c->next::method(@_);
  323:     };
  324: }
  325:

MusicBrainz::Server    322    lib/MusicBrainz/Server.pm
  319:             chomp $warning;
  320:             $c->log->warn($c->req->method . " " . $c->req->uri . " caused a warning: " . $warning);
  321:         };
  322:         $c->next::method(@_);
  323:     };
  324: }
  325:

MusicBrainz::Server    291    lib/MusicBrainz/Server.pm
  288:         alarm(0);

Yesterday I started submiting a few CDs I have at home, when I found that one of the options under the media type is to label releases as HDCD, and I have a couple of questions/suggestions before doing things in the wrong way.

Personally, I do not own an HDCD player, so the method I use to find those in my CD collection is by ripping all them to WAV with EAC and then scan them with CUETools which, among other things, detects when HDCD encoding was used.

A quick example:

[CUETools log; Date: 30/04/2013 11:19:23; Version: 2.1.4]
HDCD: peak extend: none, transient filter: some, gain: none
[...]   

The log shows more info, but the relevant part is this line at the beginning, which only appears when an HDCD is detected along with the enhacements employed. Quite useful since some (a lot of?) HDCDs do not actually have any info on the inserts, back cover, etc at all pointing to be one of them, including the example above (Acidman - and world, TOCT-25866).

So my question is, would a CUETools log like that be considered good enough proof to submit edits to the database? and if it wasn't, what would be the proper way to add HDCDs?

Sorry if these questions have been answer before, but the search didn't throw any relevant result.

Regards.

I'm pretty new to MB so forgive me if this post is in the wrong place or if there's a resource I have missed. I'm looking to do lookups directly against the Postgres db. I want to hit the DB direct mainly for speed but also because it'll be much easier to add a Postgres DB rather than a VM or the full MB web service.

The first query I'm trying to do is: with a given recording UUID (ie recording.gid is known), I want to get the name of the recording, the album (ie release group) and artist info. I think the below is an appropriate query to achieve this but I'm a little wary about the sub-queries and am also wondering if it's the best way to get the Artist Name (see below).

// Query to 
SELECT DISTINCT ON (relg.id)
    rec.gid AS Recording_UUID, 
    trn.name AS Recording_Name,
    rec.length AS length_MS, rec.comment,
    relg.gid AS Album_UUID,
    reln.name AS Album,
    array(
        SELECT name 
        FROM release_group_primary_type rgpt
        WHERE rgpt.id = relg.type
        ORDER BY name ASC
    ) album_primary_types,
    array(
        SELECT name 
        FROM release_group_secondary_type rgst
        JOIN release_group_secondary_type_join rgstj
        ON rgstj.secondary_type = rgst.id
        WHERE rgstj.release_group = relg.id
        ORDER BY name ASC
    ) album_secondary_types,
    array (
        SELECT artn.name
        FROM artist_name artn
            JOIN artist_credit artc ON artn.id = artc.name
            JOIN artist_credit_name artcn ON artc.id = artcn.artist_credit
        WHERE artc.id = rec.artist_credit
        ORDER BY artcn.position ASC 
    ) Artist_Names,
    array (
        SELECT art.gid
        FROM artist art
            JOIN artist_credit_name artcn ON art.id = artcn.artist
            JOIN artist_credit artc ON artcn.artist_credit = artc.id
        WHERE artc.id = rec.artist_credit
        ORDER BY artcn.position ASC 
    ) Artist_UUIDs
FROM recording rec
    JOIN track trk ON rec.id = trk.recording
    JOIN track_name trn ON rec.name = trn.id
    JOIN tracklist trl ON trk.tracklist = trl.id
    JOIN medium med ON trl.id = med.tracklist
    JOIN release rel ON med.release = rel.id
    JOIN release_group relg ON rel.release_group = relg.id
    JOIN release_name reln ON relg.name = reln.id
WHERE 
    rec.gid = '1e402422-64cf-4be7-9f95-d6398585bf48' 
    OR rec.gid = '25794d9c-216c-42a1-a5db-18d391a6d142'
    OR rec.gid = '1b42b6fa-2c22-472d-901e-095b7100e9fc'
    OR rec.gid = '61e5c7b9-3317-4b9a-b4e2-8db3cc1c92b9'

// Sample recording UUIDs: Happiest Days of Our Lives; Welcome to the Machine; Intervention; Thrift Shop.

// Above executes in 25-40ms on my laptop so I'm pretty happy with the speed.

Regarding the artist names, with the above query, the artist names are returned as a single string with each artist then having a unique UUID/gid/id in the artist table. Is that the best way to get them or should I construct them individually by joining from the main artist table -> artist_name and then building the full string myself (in non-SQL code afterwards)?

If I am doing things right and I want to associate each artist in the returned artist name with their UUID/gid, what are the separators? From what I can tell, the artist_name table uses separators: &, feat., and vs.  - are there others? Is there a canonical list somewhere?

Similarly, is there a full list of suffixes (I see ", The" and ", A" but wonder if there are others).

Any ideas?

The foo_audioscrobbler component allows field remapping for last.fm submissions. Since lastfm handles featured artists differently than musicbrainz, it's helpful to use this feature (found at Prefs/Tools/Audioscrobbler).

Here are the entries you should use to handle the issue: http://pastebin.com/BgrPNc70

This will cause foobar to prefer the album artist over the track artist, and will move the "feat." part of the track artist field to the track title.

As an example, the properly tagged song as defined by Musicbrainz

Rihanna feat. Jay-Z - "Umbrella"

becomes

Rihanna - "Umbrella feat. Jay-Z"

For most of us, this isn't the way we want our ID3 tags but it's the way that they have to look on lastfm. This should help to clean up scrobbles. If you have any suggestions for other issues that could be handled with this feature, please let me know and I'll update the post.

I would like to know... Do DVD's contain meta info? Much like how Audio CD's contain metadata. I'm currently ripping my audio collection and tagging them using musicbrainz... however i'm stumped when it comes to my movies...

does anything like this exist!?

Thank you.

Having come across various CDs that were problematic to extract ISRCs from reliably, I've put together a crude tool to assist.

It's incredibly simple: it scans the CD (starting at sector 0 and continuing until it hits a read error), extracts the q subchannel, and depending on the command line options, reports the decoded contents to the console.

To use:

isrcscan.exe [options] [drive]

where options is some combination of:

-r   dump raw q subchannel contents
-p   dump parsed contents
-t   output timing information
-c   output catalog number
-i   output isrc
-e   log q subchannel errors (e.g. crc errors)

e.g.

> isrcscan.exe -t -c -i k:

The tool is currently Win64 only, but it should be pretty easy to stitch on other backends.  I'll get round to packaging up the source sometime soon if anyone's interested.  I'm not planning on doing much further development work, as it looks like libdiscid will gain such functionality soon, but would be very intested to hear about bugs.

Finally, a URL would be useful:

http://www.cjkey.org.uk/isrcscan/isrcscan.exe

Regards,

Christopher Key

I'm building a ASP.NET site that I want to populate with recent releases from various artists.  I've only got access to SQL Server and ASP.NET shared hosting so getting the weekly drops won't work for me (i think!)

What's my best option to get the new additions to the database every week or so?  Does the XML feed allow querying using date added as a filter?  This way I could get a baseline bulk load, then on a weekly basis run a query against the XML feed (or something similar) to get the last week's new records.

Is this possible? 

Thanks in advance,
Nic

Just wondering if I need a key to use phpBrainz?

I've installed the class files, and can use the examples, but they give me info like:

phpBrainz_Track Object ( [id:phpBrainz_Track:private] => d615590b-1546-441d-9703-b3cf88487cbd [artist:phpBrainz_Track:private] => phpBrainz_Artist Object ( [id:phpBrainz_Artist:private] => 6fe07aa5-fec0-4eca-a456-f29bff451b04 [name:phpBrainz_Artist:private] => Weezer [sortName:phpBrainz_Artist:private] => Weezer [beginDate:phpBrainz_Artist:private] => [endDate:phpBrainz_Artist:private] => [type:phpBrainz_Artist:private] => [disambiguation:phpBrainz_Artist:private]

How do I see what's in all the private properties?

I need to get the year and genre of songs.

Thanks for your time and help.

I have a couple of quick questions on the rate limiting operations on ws2.
I have my own instance of MusicBrainz running on my server, and would like to tweak it’s operation for a project.

Firstly, are there any terms/conditions regarding changing the rate limiting ON YOUR OWN SERVER, not musicbrainz.org?
Secondly, I found the "ratelimit-server" pearl file that looks like it determines how the rate limiting works, but I can make neither head nor tails of it. Is there any documentation on it?

Thanks in advance for the advice,

Regards,

Caboose

The comment on the removal edits is: "I don't want to have any information about me here. Thanks Xavier Baumaxa."
Should we vote against such edits?

Is there any prepared text explaining that the author does not need to worry about his copyright etc?

What if someone asks to remove his personal information like the date of birth or the real name?

Could someone please check my submissions so that they don't go to waste...

My musicbrainz username is 'jjabba'.

Thanks