{"id":687,"date":"2014-11-02T06:56:50","date_gmt":"2014-11-02T06:56:50","guid":{"rendered":"http:\/\/zensonic.dk\/?p=687"},"modified":"2017-04-09T10:02:27","modified_gmt":"2017-04-09T10:02:27","slug":"about-fixing-bluesound-playlists-after-cifs-migration","status":"publish","type":"post","link":"https:\/\/zensonic.dk\/?p=687","title":{"rendered":"About fixing Bluesound playlists after CIFS migration"},"content":{"rendered":"

I recently wiped TomatoUSB and installed OpenWRT Barrier Breaker on my Linksys E3000 based router. In that process I also migrated our FLAC collection from my x86 based server edison\u00c2\u00a0 to the OpenWRT router. Life was good….. until my wife complained that the her Bluesound playlists had stopped working.<\/p>\n

Luckily I have root access to my Bluesound and can fix stuff like this. Heres the issue and the fix.<\/p>\n

After the switch to OpenWRT the world look like this as seen from the Bluesound:<\/p>\n

[code]
\nroot@Stue \/tmp\/var\/data$ df
\nFilesystem\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 1K-blocks\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 Used Available Use% Mounted on
\n\/dev\/root\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 903080\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 342168\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 515040\u00c2\u00a0 40% \/
\ntmpfs\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 127488\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 48\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 127440\u00c2\u00a0\u00c2\u00a0 0% \/tmp
\ntmpfs\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 127488\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 36\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 127452\u00c2\u00a0\u00c2\u00a0 0% \/dev
\n\/dev\/mmcblk0p3\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 2778768\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 86668\u00c2\u00a0\u00c2\u00a0 2550944\u00c2\u00a0\u00c2\u00a0 3% \/tmp\/var\/data
\nshm\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 127488\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 127488\u00c2\u00a0\u00c2\u00a0 0% \/dev\/shm
\n\/\/192.168.1.254\/flac 153703308\u00c2\u00a0 74379356\u00c2\u00a0 79323952\u00c2\u00a0 48% \/tmp\/var\/mnt\/OPENWRT-flac
\n[\/code]<\/p>\n

But a peek inside the playlist.db on the Bluesound shows the following<\/p>\n

[code]
\n‘StoredPlaylist::files’ => ‘\/var\/mnt\/EDISON-flac\/Arvo Part – Alina\/01-Spiegel im Spiegel (Version fur Violine und Klavier).flac
\n\/var\/mnt\/EDISON-flac\/Arvo Part – Alina\/02-Fur Alina (fur Klavier).flac
\n\/var\/mnt\/EDISON-flac\/Arvo Part – Alina\/03-Spiegel im Spiegel (Version fur Violoncello und Klavier).flac
\n\/var\/mnt\/EDISON-flac\/Arvo Part – Alina\/04-Fur Alina (fur Klavier).flac
\n\/var\/mnt\/EDISON-flac\/Arvo Part – Alina\/05-Spiegel im Spiegel (Version fur Violine und Klavier).flac
\n\/var\/mnt\/EDISON-flac\/Arvo Part – Alina\/03-Spiegel im Spiegel (Version fur Violoncello und Klavier).flac’
\n[\/code]<\/p>\n

Notice how the name of the CIFS server is part of the playlist entry. After figuring out the format of the playlist.db, it was trivially easy to write a little perl program to convert them. I did have to take care of some latin1 to utf8 as well, but that was also easy. For anyone who cares:<\/p>\n

[code]
\n#!\/usr\/bin\/perl -w
\n#
\n# convert_playlist.pl – version 1.0 gamma. Project hours: 1
\n#
\n# —————————————————————————-
\n# “THE WISHLIST LICENSE” (Revision 42):
\n# <zensonic@zensonic.dk> wrote this file.\u00c2\u00a0 As long as you retain this notice you
\n# can do whatever you want with this stuff.
\n#
\n# If you feel it saved your world a gift from http:\/\/amzn.com\/w\/2Y27QA7V5FUGU<\/a>
\n# is highly appriciated
\n# —————————————————————————-
\n#
\n# Copyright 2014.11.01 by Thomas S. Iversen (zensonic@zensonic.dk)<\/p>\n

use strict;
\nuse Storable qw(nstore retrieve);<\/p>\n

die “$0 <path_to_playlist> <regexp_match> <regexp_replace>” if(!($#ARGV+1 == 3));
\nmy $filename = $ARGV[0];
\nmy $regexp_match = $ARGV[1];
\nmy $regexp_replace = $ARGV[2];
\nmy $storable;<\/p>\n

die “$filename does not exist\\n” if(! -f $filename);
\n$storable = retrieve($filename);
\nforeach my $playlist (@$storable) {
\nmy $name=$playlist->{‘StoredPlaylist::name’};
\nprint “Converting playlist ‘$name’\\n”;
\n$playlist->{‘StoredPlaylist::files’}=~s\/$regexp_match\/$regexp_replace\/g;<\/p>\n

# capital danish
\n$playlist->{‘StoredPlaylist::files’}=~s\/\\xc5\/\\xc3\\x85\/g;
\n$playlist->{‘StoredPlaylist::files’}=~s\/\\xc6\/\\xc3\\x86\/g;
\n$playlist->{‘StoredPlaylist::files’}=~s\/\\xd8\/\\xc3\\x98\/g;<\/p>\n

# lower danish
\n$playlist->{‘StoredPlaylist::files’}=~s\/\\xe5\/\\xc3\\xA5\/g;
\n$playlist->{‘StoredPlaylist::files’}=~s\/\\xe6\/\\xc3\\xA6\/g;
\n$playlist->{‘StoredPlaylist::files’}=~s\/\\xf8\/\\xc3\\xB8\/g;<\/p>\n

# lower swedish
\n$playlist->{‘StoredPlaylist::files’}=~s\/\\xe4\/\\xc3\\xA4\/g;
\n$playlist->{‘StoredPlaylist::files’}=~s\/\\xf6\/\\xc3\\xB6\/g;<\/p>\n

# capital swedish
\n$playlist->{‘StoredPlaylist::files’}=~s\/\\xc4\/\\xc3\\x84\/g;
\n$playlist->{‘StoredPlaylist::files’}=~s\/\\xd6\/\\xc3\\x96\/g;
\n}<\/p>\n

my $filename_new=$filename . “.new”;
\nprint “Saving playlist as $filename_new\\n”;
\nnstore($storable, $filename_new);
\n[\/code]<\/p>\n

Which I then ran as<\/p>\n

[code]
\nroot@Stue \/tmp\/var\/data$ .\/convert_playlist.pl stored_playlists.db EDISON OPENWRT
\nConverting playlist ‘Svensk jul’
\nConverting playlist ‘Hvid januar’
\nConverting playlist ‘Lektier’
\nConverting playlist ‘Moderne salmer’
\nConverting playlist ‘Total afslapning’
\nConverting playlist ‘P\u00ef\u00bf\u00bdske’
\nSaving playlist as stored_playlists.db.new
\n[\/code]<\/p>\n

And then the last part<\/p>\n

[code]
\nmv playlist as stored_playlists.db.new playlist as stored_playlists.db
\nreboot
\n[\/code]<\/p>\n

And restart the Bluesound app on the phone (it caches). Happy wife \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"

I recently wiped TomatoUSB and installed OpenWRT Barrier Breaker on my Linksys E3000 based router. In that process I also migrated our FLAC collection from my x86 based server edison\u00c2\u00a0 to the OpenWRT router. Life was good….. until my wife complained that the her Bluesound playlists had stopped working. Luckily I have root access to […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,4,32,33],"tags":[],"class_list":["post-687","post","type-post","status-publish","format-standard","hentry","category-fun-projects","category-hardware","category-sound","category-upgrade"],"_links":{"self":[{"href":"https:\/\/zensonic.dk\/index.php?rest_route=\/wp\/v2\/posts\/687"}],"collection":[{"href":"https:\/\/zensonic.dk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zensonic.dk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zensonic.dk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/zensonic.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=687"}],"version-history":[{"count":0,"href":"https:\/\/zensonic.dk\/index.php?rest_route=\/wp\/v2\/posts\/687\/revisions"}],"wp:attachment":[{"href":"https:\/\/zensonic.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=687"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zensonic.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=687"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zensonic.dk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}