NSLU2 playlist setup for Win iTunes

[johnnymac]

I am endeavoring to fully understand the *new* playlist implementation.
I am running itunes on a Windows machine (for playlist management) and hae my songs on a hard drive attached to a NSLU2, I play the songs via the windows iTunes or a Roku soundbridge.

I was happily using the static playlists in the stable version of mt-daapd but decided to move to the cvs-20050620 build. Not unexpectedly, my static playlists disappeared. Since then, I have been unable to implment new playlists.

I realize there are two ways, convert my itunes playlists to .m3u files using a .m3u converter such as this http://chimpen.com/itunes2m3u/convert.php and then copy the .m3u files into my songs directory /share/hdd/data/public/mp3. This is workable but would require updating the .m3u file each time I changed a playlist.

The second method, and the one I would like to pursue, is to allow mt-daapd to pull my playlists info from my iTunes playlists file.

There are several questions I have. In my (Windows) iTunes folder, I have two database files, one is iTunes Music Library which is a XML file, the second is iTunes 4 Music Library which is an iTunes Music Database File (.itl). I believe that the .itl file is the file from which mt-daapd pulls the playlist information.

I copied the .itl database file into my NSLU2 directory and then changed the mt-daapd.conf to reflect the location. (The default syntax in mt-daapd.conf is /opt/etc/mt-daapd/mt-daapd.playlist which appears to be a holdover from the older type playlists). The playlists appear but there are no songs in the playlist, I assume this is a relative path issue. Can anyone point me in direction to correct this.

Finally, is there a way to force a re-scan from the command line? I realize the web interface can accomplish this function.
Thanks
John

The following posts have data on playlists:
http://www.mt-daapd.org/index.php?option=com_simpleboard&Itemid=40&func=view&id=1271&catid=2&limit=6%20&limitstart=6
[url]http://www.mt-daapd.org/index.php?option=com_simpleboard&Itemid=40&func=view&id=1312&catid=3
[/url]
http://www.mt-daapd.org/index.php?option=com_simpleboard&Itemid=40&func=view&id=1211&catid=2

Post edited by: johnnymac, at: 2005/07/02 19:52

[rpedde]

Actually, it is the .xml file it wants.

The playlist directive in the .conf is now unused, so it doesn’t really matter what it points to.

You’ll probably want to run mt-daapd -d9 to see where it’s trying to find the music files when it parses the xml file and move the file around to make it find the music files.

— Ron

[johnnymac]

Ron,
I initiated the mt-daapd daemon by using:
/opt/etc/init.d/S60mt-daapd -d9

However, the return was: Starting with debug level 1

Do I need to configure the debug flags as part of the compile / installation process?

Secondly, you are right. I had added the .xml playlist information into my NSLU2 /share/hdd/data/public/mp3 file. This had the effect of producing the same playlists that had been set up in Win iTunes, however, the playlists are empty. I believe the problem has to do with the relative path. Any Win users had any success they want to share?

Post edited by: johnnymac, at: 2005/07/05 17:57

[rpedde]

You’ll have to edit the /opt/init.d/S60mt-daapd and add the -d9 to the line that runs mt-daapd.

The -d9 option that you are passing to S60mt-daapd doesn’t get handed off to mt-daapd, so it gets ignored. With latest nightlies, though, you can add the “debuglevel” parameter to the config file, if that helps.

— Ron

[johnnymac]

Ron
Thanks, got it. I will let you know what i find.
John

[johnnymac]

Well, I am still befuddled.

The .xml playlist file was copied from my windows directory:
C:Documents and SettingsJohnMy DocumentsMy MusiciTunes
to my NSLU2 mp3 directory.
/share/hdd/data/public/mp3/

mt-daapd was then started with the -d9 debug flag.

The logfile indicates that the mt-daapd finds the mp3’s:
2005-07-05 20:58:55: Executing: BEGIN TRANSACTION
2005-07-05 20:58:55: Rows: 0
2005-07-05 20:58:55: Scanning for MP3s in /share/hdd/data/public/mp3
2005-07-05 20:58:55: Found /share/hdd/data/public/mp3/40 Greatest Drinking Songs

After much scanning the playlists are pulled from the the .xml Win iTunes database, the songs are referenced by the the itunes track number (this is my “Alternative” playlist entry).
2005-07-05 21:03:04: Creating playlist for Alternative
2005-07-05 21:03:04: Executing: select * from playlists where path=’/share/hdd/data/public/mp3/iTunes Music Library.xml’ and idx=12083
2005-07-05 21:03:04: Executing: select count(*) from playlists where upper(title)=upper(‘Alternative’)
2005-07-05 21:03:04: Executing: insert into playlists (title,type,items,query,db_timestamp,path,idx) values (‘Alternative’,3,0,NULL,1120611784,’/share/hdd/data/public/mp3/iTunes Music Library.xml’,12083)
2005-07-05 21:03:04: Rows: 1
2005-07-05 21:03:04: Executing: select id from playlists where title=’Alternative’
2005-07-05 21:03:04: Adding itunes track #843

The playlists are then added to the database:
2005-07-05 21:03:06: Executing: SELECT * FROM playlists
2005-07-05 21:03:06: Updating playlist counts for Library
2005-07-05 21:03:06: Executing: UPDATE playlists SET items=(SELECT COUNT(*) FROM songs WHERE 1) WHERE id=1
2005-07-05 21:03:07: Rows: 1
2005-07-05 21:03:07: Updating playlist counts for Alternative
2005-07-05 21:03:07: Executing: UPDATE playlists SET items=(SELECT COUNT(*) FROM playlistitems WHERE id=2) WHERE id=2

So, I have playlists, but no files within them. mt-daapd obviously finds the songs and uses the itunes reference number for each. It then finds the playlists, and the associated itunes song/reference number.

My problems (that the playlists are empty) would seem to be the relative location of the file or referencing the location of the song. Any Win iTunes users crack this nut yet?

Post edited by: johnnymac, at: 2005/07/06 01:46

[rpedde]

When it’s first walking through the songs in the itunes xml file (before it adds the playlists), it should try to update metadata for all the songs. It will say something like:

Found iTunes track #857

then a:

select * from songs where path=’/some/path/name’.

Find a song and compare the path it’s looking for with the path of the actual file. See what the correspondence is.

[johnnymac]

Ron
Below is my mt-daapd logfile for a directory of two songs,one of which was added to a playlist named “testplaylist”. The itunes xml file has been copied from windows directory into the NSLU2 itunes path. The “itunes base path” is listed as (file://localhost//Nlsu2/disk%201/My%20Music/iTunes/) because it is relative to where the xml document originally resided.

The other issue I see is the location for the playlist songs. The actual location is \Nlsu2DISK 1My MusiciTunes however the path is listed as /share/hdd/data/public/My Music/iTunes/iTunes Music Library.xml. I would not think this is a problem because mt-daapd is able to find the songs using this path.

So, in the end, mt-daapd displays the song correctly, displays the playlists correctly, but does not propagate the specified songs into the playlists (playlists have no entries). Any ideas? I love mt-daapd and am wondering if I am the only win user with this problem.

2005-07-10 10:28:23: select(6, 1.235351)
2005-07-10 10:28:24: select(6, 0.007812)
2005-07-10 10:28:24: select(6, 0.102539)
2005-07-10 10:28:24: select(6, 0.101562)
2005-07-10 10:28:24: select(6, 255.895507)
2005-07-10 10:32:24: Starting rendezvous daemon
2005-07-10 10:32:24: Starting signal handler
2005-07-10 10:32:24: Signal handler started
2005-07-10 10:32:24: Opening database
2005-07-10 10:32:24: select(6, 0.000976)
2005-07-10 10:32:24: select(6, 0.213867)
2005-07-10 10:32:24: Results: 0
2005-07-10 10:32:24: Initializing database
2005-07-10 10:32:24: Executing: CREATE INDEX idx_path ON songs(path)
2005-07-10 10:32:24: Query: CREATE INDEX idx_path ON songs(path)
2005-07-10 10:32:24: Error: no such table: songs
2005-07-10 10:32:24: Executing: select value from config where term=’version’
2005-07-10 10:32:24: Query: select value from config where term=’version’
2005-07-10 10:32:24: Error: no such table: config
2005-07-10 10:32:24: Upgrading database from version 0 to version 1
2005-07-10 10:32:24: Executing: CREATE TABLE songs (
id INTEGER PRIMARY KEY NOT NULL,
path VARCHAR(4096) UNIQUE NOT NULL,
fname VARCHAR(255) NOT NULL,
title VARCHAR(1024) DEFAULT NULL,
artist VARCHAR(1024) DEFAULT NULL,
album VARCHAR(1024) DEFAULT NULL,
genre VARCHAR(255) DEFAULT NULL,
comment VARCHAR(4096) DEFAULT NULL,
type VARCHAR(255) DEFAULT NULL,
composer VARCHAR(1024) DEFAULT NULL,
orchestra VARCHAR(1024) DEFAULT NULL,
conductor VARCHAR(1024) DEFAULT NULL,
grouping VARCHAR(1024) DEFAULT NULL,
url VARCHAR(1024) DEFAULT NULL,
bitrate INTEGER DEFAULT 0,
samplerate INTEGER DEFAULT 0,
song_length INTEGER DEFAULT 0,
file_size INTEGER DEFAULT 0,
year INTEGER DEFAULT 0,
track INTEGER DEFAULT 0,
total_tracks INTEGER DEFAULT 0,
disc INTEGER DEFAULT 0,
total_discs INTEGER DEFAULT 0,
bpm INTEGER DEFAULT 0,
compilation INTEGER DEFAULT 0,
rating INTEGER DEFAULT 0,
play_count INTEGER DEFAULT 0,
data_kind INTEGER DEFAULT 0,
item_kind INTEGER DEFAULT 0,
description INTEGER DEFAULT 0,
time_added INTEGER DEFAULT 0,
time_modified INTEGER DEFAULT 0,
time_played INTEGER DEFAULT 0,
db_timestamp INTEGER DEFAULT 0,
disabled INTEGER DEFAULT 0,
sample_count INTEGER DEFAULT 0,
force_update INTEGER DEFAULT 0
);
CREATE INDEX idx_path ON songs(path);
CREATE TABLE config (
term VARCHAR(255) NOT NULL,
subterm VARCHAR(255) DEFAULT NULL,
value VARCHAR(1024) NOT NULL
);
CREATE TABLE playlists (
id INTEGER PRIMARY KEY NOT NULL,
title VARCHAR(255) NOT NULL,
smart INTEGER NOT NULL,
items INTEGER NOT NULL,
query VARCHAR(1024)
);
CREATE TABLE playlistitems (
id INTEGER NOT NULL,
songid INTEGER NOT NULL
);
INSERT INTO config VALUES (‘version’,”,’1′);
INSERT INTO playlists VALUES (1,’Library’,1,0,’1′);

2005-07-10 10:32:24: select(6, 0.099609)
2005-07-10 10:32:24: select(6, 0.097656)
2005-07-10 10:32:24: Rows: 2
2005-07-10 10:32:24: Upgrading database from version 1 to version 2
2005-07-10 10:32:24: Executing: REPLACE INTO config VALUES(‘rescan’,NULL,1);
UPDATE config SET value=2 WHERE term=’version’;

2005-07-10 10:32:24: Rows: 2
2005-07-10 10:32:24: Upgrading database from version 2 to version 3
2005-07-10 10:32:24: Executing: drop index idx_path;
create temp table tempsongs as select * from songs;
drop table songs;
CREATE TABLE songs (
id INTEGER PRIMARY KEY NOT NULL,
path VARCHAR(4096) UNIQUE NOT NULL,
fname VARCHAR(255) NOT NULL,
title VARCHAR(1024) DEFAULT NULL,
artist VARCHAR(1024) DEFAULT NULL,
album VARCHAR(1024) DEFAULT NULL,
genre VARCHAR(255) DEFAULT NULL,
comment VARCHAR(4096) DEFAULT NULL,
type VARCHAR(255) DEFAULT NULL,
composer VARCHAR(1024) DEFAULT NULL,
orchestra VARCHAR(1024) DEFAULT NULL,
conductor VARCHAR(1024) DEFAULT NULL,
grouping VARCHAR(1024) DEFAULT NULL,
url VARCHAR(1024) DEFAULT NULL,
bitrate INTEGER DEFAULT 0,
samplerate INTEGER DEFAULT 0,
song_length INTEGER DEFAULT 0,
file_size INTEGER DEFAULT 0,
year INTEGER DEFAULT 0,
track INTEGER DEFAULT 0,
total_tracks INTEGER DEFAULT 0,
disc INTEGER DEFAULT 0,
total_discs INTEGER DEFAULT 0,
bpm INTEGER DEFAULT 0,
compilation INTEGER DEFAULT 0,
rating INTEGER DEFAULT 0,
play_count INTEGER DEFAULT 0,
data_kind INTEGER DEFAULT 0,
item_kind INTEGER DEFAULT 0,
description INTEGER DEFAULT 0,
time_added INTEGER DEFAULT 0,
time_modified INTEGER DEFAULT 0,
time_played INTEGER DEFAULT 0,
db_timestamp INTEGER DEFAULT 0,
disabled INTEGER DEFAULT 0,
sample_count INTEGER DEFAULT 0,
force_update INTEGER DEFAULT 0,
codectype VARCHAR(5) DEFAULT NULL
);
begin transaction;
insert into songs select *,NULL from tempsongs;
commit transaction;
update songs set type=lower(type);
update songs set type=’m4a’ where type=’aac’ or type=’mp4′;
update songs set type=’flac’ where type=’fla’;
update songs set description=’AAC audio file’ where type=’m4a’;
update songs set description=’MPEG audio file’ where type=’mp3′;
update songs set description=’WAV audio file’ where type=’wav’;
update songs set description=’Playlist URL’ where type=’pls’;
update songs set description=’Ogg Vorbis audio file’ where type=’ogg’;
update songs set description=’FLAC audio file’ where type=’flac’;
update songs set codectype=’mp4a’ where type=’m4a’ or type=’m4p’;
update songs set codectype=’mpeg’ where type=’mp3′;
update songs set codectype=’ogg’ where type=’ogg’;
update songs set codectype=’flac’ where type=’flac’;
update songs set force_update=1 where type=’m4a’;
create index idx_path on songs(path);
drop table tempsongs;
update config set value=3 where term=’version’;

2005-07-10 10:32:24: select(6, 0.000976)
2005-07-10 10:32:24: select(6, 0.140625)
2005-07-10 10:32:24: select(6, 0.100585)
2005-07-10 10:32:24: select(6, 0.099609)
2005-07-10 10:32:24: Rows: 1
2005-07-10 10:32:24: Upgrading database from version 3 to version 4
2005-07-10 10:32:24: Executing: create temp table tempplaylists as select * from playlists;
drop table playlists;
CREATE TABLE playlists (
id INTEGER PRIMARY KEY NOT NULL,
title VARCHAR(255) NOT NULL,
type INTEGER NOT NULL,
items INTEGER NOT NULL,
query VARCHAR(1024),
db_timestamp INTEGER NOT NULL,
path VARCHAR(4096)
);
insert into playlists select *,0,NULL from tempplaylists;
drop table tempplaylists;
update config set value=4 where term=’version’;

2005-07-10 10:32:25: select(6, 0.001953)
2005-07-10 10:32:25: select(6, 0.138671)
2005-07-10 10:32:25: Rows: 2
2005-07-10 10:32:25: Upgrading database from version 4 to version 5
2005-07-10 10:32:25: Executing: create temp table tempplaylists as select * from playlists;
drop table playlists;
CREATE TABLE playlists (
id INTEGER PRIMARY KEY NOT NULL,
title VARCHAR(255) NOT NULL,
type INTEGER NOT NULL,
items INTEGER NOT NULL,
query VARCHAR(1024),
db_timestamp INTEGER NOT NULL,
path VARCHAR(4096),
idx INTEGER NOT NULL
);
insert into playlists select *,0 from tempplaylists;
drop table tempplaylists;
update config set value=5 where term=’version’;

2005-07-10 10:32:25: select(6, 0.093750)
2005-07-10 10:32:25: select(6, 0.091796)
2005-07-10 10:32:25: Rows: 2
2005-07-10 10:32:25: Upgrading database from version 5 to version 6
2005-07-10 10:32:25: Executing: drop index idx_path;
create temp table tempsongs as select * from songs;
drop table songs;
CREATE TABLE songs (
id INTEGER PRIMARY KEY NOT NULL,
path VARCHAR(4096) UNIQUE NOT NULL,
fname VARCHAR(255) NOT NULL,
title VARCHAR(1024) DEFAULT NULL,
artist VARCHAR(1024) DEFAULT NULL,
album VARCHAR(1024) DEFAULT NULL,
genre VARCHAR(255) DEFAULT NULL,
comment VARCHAR(4096) DEFAULT NULL,
type VARCHAR(255) DEFAULT NULL,
composer VARCHAR(1024) DEFAULT NULL,
orchestra VARCHAR(1024) DEFAULT NULL,
conductor VARCHAR(1024) DEFAULT NULL,
grouping VARCHAR(1024) DEFAULT NULL,
url VARCHAR(1024) DEFAULT NULL,
bitrate INTEGER DEFAULT 0,
samplerate INTEGER DEFAULT 0,
song_length INTEGER DEFAULT 0,
file_size INTEGER DEFAULT 0,
year INTEGER DEFAULT 0,
track INTEGER DEFAULT 0,
total_tracks INTEGER DEFAULT 0,
disc INTEGER DEFAULT 0,
total_discs INTEGER DEFAULT 0,
bpm INTEGER DEFAULT 0,
compilation INTEGER DEFAULT 0,
rating INTEGER DEFAULT 0,
play_count INTEGER DEFAULT 0,
data_kind INTEGER DEFAULT 0,
item_kind INTEGER DEFAULT 0,
description INTEGER DEFAULT 0,
time_added INTEGER DEFAULT 0,
time_modified INTEGER DEFAULT 0,
time_played INTEGER DEFAULT 0,
db_timestamp INTEGER DEFAULT 0,
disabled INTEGER DEFAULT 0,
sample_count INTEGER DEFAULT 0,
force_update INTEGER DEFAULT 0,
codectype VARCHAR(5) DEFAULT NULL,
idx INTEGER NOT NULL
);
begin transaction;
insert into songs select *,0 from tempsongs;
commit transaction;
create index idx_path on songs(path);
drop table tempsongs;
update config set value=6 where term=’version’;

2005-07-10 10:32:25: select(6, 0.132812)
2005-07-10 10:32:25: Rows: 1
2005-07-10 10:32:25: Executing: SELECT value FROM config WHERE term=’rescan’
2005-07-10 10:32:25: Executing: SELECT COUNT(*) FROM songs
2005-07-10 10:32:25: Full reload…
2005-07-10 10:32:25: Executing: DROP INDEX idx_path
2005-07-10 10:32:25: Rows: 0
2005-07-10 10:32:25: Executing: DELETE FROM songs
2005-07-10 10:32:25: Rows: 0
2005-07-10 10:32:25: Starting mp3 scan
2005-07-10 10:32:25: Executing: PRAGMA synchronous = OFF
2005-07-10 10:32:25: Rows: 0
2005-07-10 10:32:25: Executing: BEGIN TRANSACTION
2005-07-10 10:32:25: Rows: 0
2005-07-10 10:32:25: Scanning for MP3s in /share/hdd/data/public/My Music/iTunes
2005-07-10 10:32:25: Found /share/hdd/data/public/My Music/iTunes/iTunes Music Library.xml
2005-07-10 10:32:25: Adding /share/hdd/data/public/My Music/iTunes/iTunes Music Library.xml for deferred processing.
2005-07-10 10:32:25: Found /share/hdd/data/public/My Music/iTunes/iTunes Library.itl
2005-07-10 10:32:25: Found /share/hdd/data/public/My Music/iTunes/The Killers
2005-07-10 10:32:25: Found dir The Killers… recursing
2005-07-10 10:32:25: Found /share/hdd/data/public/My Music/iTunes/The Killers/Hot Fuss
2005-07-10 10:32:25: Found dir Hot Fuss… recursing
2005-07-10 10:32:25: Found /share/hdd/data/public/My Music/iTunes/The Killers/Hot Fuss/01 – Jenny Was A Friend Of Mine.mp3
2005-07-10 10:32:25: Executing: SELECT * FROM songs WHERE path=’/share/hdd/data/public/My Music/iTunes/The Killers/Hot Fuss/01 – Jenny Was A Friend Of Mine.mp3′ and idx=0
2005-07-10 10:32:25: Found music file: 01 – Jenny Was A Friend Of Mine.mp3
2005-07-10 10:32:25: Codec type: mpeg
2005-07-10 10:32:25: Title: Jenny Was a Friend of Mine
2005-07-10 10:32:25: Artist: The Killers
2005-07-10 10:32:25: Album: Hot Fuss
2005-07-10 10:32:25: Track 1 of 0
2005-07-10 10:32:25: Genre: Indie Rock
2005-07-10 10:32:25: Year: 2004
2005-07-10 10:32:25: Got id3 tag successfully
2005-07-10 10:32:25: Found ID3 header
2005-07-10 10:32:25: Header length: 1822
2005-07-10 10:32:25: Reading in new block at 1832
2005-07-10 10:32:25: valid header at 0
2005-07-10 10:32:25: select(6, 0.098632)
2005-07-10 10:32:25: select(6, 0.097656)
2005-07-10 10:32:25: MPEG Version: 1
2005-07-10 10:32:25: Layer: 3
2005-07-10 10:32:25: Sample Rate: 44100
2005-07-10 10:32:25: Bit Rate: 128
2005-07-10 10:32:25: Found Xing header
2005-07-10 10:32:25: Xing Flags: 0F
2005-07-10 10:32:25: Song Length: 244192
2005-07-10 10:32:25: Date Added: 1109679049
2005-07-10 10:32:25: Codec: mpeg
2005-07-10 10:32:25: Executing: INSERT INTO songs VALUES (NULL,’/share/hdd/data/public/My Music/iTunes/The Killers/Hot Fuss/01 – Jenny Was A Friend Of Mine.mp3′,’01 – Jenny Was A Friend Of Mine.mp3′,’Jenny Was a Friend of Mine’,’The Killers’,’Hot Fuss’,’Indie Rock’,’ÜberStandard – UberNet.org’,’mp3′,”,”,”,”,”,128,44100,244192,7170048,2004,1,0,0,0,0,0,0,0,0,2,’MPEG audio file’,1109679049,1109679049,0,1121005945,0,0,0,’mpeg’,0)
2005-07-10 10:32:25: Rows: 1
2005-07-10 10:32:25: Found /share/hdd/data/public/My Music/iTunes/The Killers/Hot Fuss/02 – Mr Brightside.mp3
2005-07-10 10:32:25: Executing: SELECT * FROM songs WHERE path=’/share/hdd/data/public/My Music/iTunes/The Killers/Hot Fuss/02 – Mr Brightside.mp3′ and idx=0
2005-07-10 10:32:25: Found music file: 02 – Mr Brightside.mp3
2005-07-10 10:32:25: Codec type: mpeg
2005-07-10 10:32:25: Title: Mr. Brightside
2005-07-10 10:32:25: Artist: The Killers
2005-07-10 10:32:25: Album: Hot Fuss
2005-07-10 10:32:25: Track 2 of 0
2005-07-10 10:32:25: Genre: Indie Rock
2005-07-10 10:32:25: Year: 2004
2005-07-10 10:32:25: Got id3 tag successfully
2005-07-10 10:32:25: Found ID3 header
2005-07-10 10:32:25: Header length: 1900
2005-07-10 10:32:25: Reading in new block at 1910
2005-07-10 10:32:25: valid header at 0
2005-07-10 10:32:25: MPEG Version: 1
2005-07-10 10:32:25: Layer: 3
2005-07-10 10:32:25: Sample Rate: 44100
2005-07-10 10:32:25: Bit Rate: 128
2005-07-10 10:32:25: Found Xing header
2005-07-10 10:32:25: Xing Flags: 0F
2005-07-10 10:32:25: Song Length: 223033
2005-07-10 10:32:25: Date Added: 1109679052
2005-07-10 10:32:25: Codec: mpeg
2005-07-10 10:32:25: Executing: INSERT INTO songs VALUES (NULL,’/share/hdd/data/public/My Music/iTunes/The Killers/Hot Fuss/02 – Mr Brightside.mp3′,’02 – Mr Brightside.mp3′,’Mr. Brightside’,’The Killers’,’Hot Fuss’,’Indie Rock’,’ÜberStandard – UberNet.org’,’mp3′,”,”,”,”,”,128,44100,223033,5419008,2004,2,0,0,0,0,0,0,0,0,2,’MPEG audio file’,1109679052,1109679052,0,1121005945,0,0,0,’mpeg’,0)
2005-07-10 10:32:25: Rows: 1
2005-07-10 10:32:25: Executing: commit transaction
2005-07-10 10:32:25: Rows: 0
2005-07-10 10:32:25: Executing: create index idx_path on songs(path)
2005-07-10 10:32:25: Rows: 0
2005-07-10 10:32:25: Executing: delete from config where term=’rescan’
2005-07-10 10:32:25: Rows: 1
2005-07-10 10:32:25: Executing: begin transaction
2005-07-10 10:32:25: Rows: 0
2005-07-10 10:32:25: iTunes Version: 4.9
2005-07-10 10:32:25: iTunes base path: file://localhost//Nlsu2/disk%201/My%20Music/iTunes/
2005-07-10 10:32:25: Scanning tracks
2005-07-10 10:32:25: Scanning iTunes id #35
2005-07-10 10:32:25: Executing: SELECT * FROM songs WHERE path=’/share/hdd/data/public/My Music/iTunes/iTunes Music’ and idx=0
2005-07-10 10:32:25: Scanning iTunes id #36
2005-07-10 10:32:25: Executing: SELECT * FROM songs WHERE path=’/share/hdd/data/public/My Music/iTunes/iTunes Music’ and idx=0
2005-07-10 10:32:25: select(6, 0.000976)
2005-07-10 10:32:25: Scanning playlists
2005-07-10 10:32:25: Adding itunes track #35
2005-07-10 10:32:25: Adding itunes track #36
2005-07-10 10:32:25: Adding itunes track #36
2005-07-10 10:32:25: Adding itunes track #35
2005-07-10 10:32:25: Creating playlist for testplaylist
2005-07-10 10:32:25: select(6, 0.890625)
2005-07-10 10:32:25: Executing: select * from playlists where path=’/share/hdd/data/public/My Music/iTunes/iTunes Music Library.xml’ and idx=65
2005-07-10 10:32:25: Executing: select count(*) from playlists where upper(title)=upper(‘testplaylist’)
2005-07-10 10:32:25: Executing: insert into playlists (title,type,items,query,db_timestamp,path,idx) values (‘testplaylist’,3,0,NULL,1121005945,’/share/hdd/data/public/My Music/iTunes/iTunes Music Library.xml’,65)
2005-07-10 10:32:25: Rows: 1
2005-07-10 10:32:25: Executing: select id from playlists where title=’testplaylist’
2005-07-10 10:32:25: Adding itunes track #35
2005-07-10 10:32:25: Executing: end transaction
2005-07-10 10:32:25: Rows: 0
2005-07-10 10:32:25: Executing: pragma synchronous=normal
2005-07-10 10:32:25: Rows: 0
2005-07-10 10:32:25: Executing: SELECT * FROM playlists
2005-07-10 10:32:25: Updating playlist counts for Library
2005-07-10 10:32:25: Executing: UPDATE playlists SET items=(SELECT COUNT(*) FROM songs WHERE 1) WHERE id=1
2005-07-10 10:32:25: Rows: 1
2005-07-10 10:32:25: Updating playlist counts for testplaylist
2005-07-10 10:32:25: Executing: UPDATE playlists SET items=(SELECT COUNT(*) FROM playlistitems WHERE id=2) WHERE id=2
2005-07-10 10:32:25: Rows: 1
2005-07-10 10:32:25: Starting web server from /opt/share/mt-daapd/admin-root on port 3689
2005-07-10 10:32:25: Preparing to listen on port 3689
2005-07-10 10:32:25: Starting server thread
2005-07-10 10:32:25: Registering rendezvous names
2005-07-10 10:32:25: Processing rendezvous message
2005-07-10 10:32:25: Registering Networked Files._daap._tcp (3689)
2005-07-10 10:32:25: Registered service 0, name ‘Networked Files’, type ‘_daap._tcp’, domain ‘local.’, port 3689
2005-07-10 10:32:25: mDNSPlatformTimeNow went backwards by 6 ticks; setting correction factor to 6
2005-07-10 10:32:25: select(6, 0.255859)
2005-07-10 10:32:25: Processing rendezvous message
2005-07-10 10:32:25: Registering Networked Files._http._tcp (3689)
2005-07-10 10:32:25: Registered service 1, name ‘Networked Files’, type ‘_http._tcp’, domain ‘local.’, port 3689
2005-07-10 10:32:25: select(6, 0.247070)
2005-07-10 10:32:25: Executing: SELECT COUNT(*) FROM songs
2005-07-10 10:32:25: Scanned 2 songs in 1 seconds
2005-07-10 10:32:25: select(6, 0.106445)
2005-07-10 10:32:25: select(6, 0.105468)
2005-07-10 10:32:26: select(6, 0.141601)
2005-07-10 10:32:26: select(6, 0.102539)
2005-07-10 10:32:26: mDNSPlatformTimeNow went backwards by 1 ticks; setting correction factor to 7
2005-07-10 10:32:26: select(6, 0.105468)
2005-07-10 10:32:26: select(6, 0.148437)
2005-07-10 10:32:26: select(6, 0.107421)
2005-07-10 10:32:26: select(6, 0.105468)
2005-07-10 10:32:26: select(6, 0.107421)
2005-07-10 10:32:26: select(6, 0.106445)
2005-07-10 10:32:26: select(6, 0.039062)
2005-07-10 10:32:26: Callback: Name Registered
2005-07-10 10:32:26: Callback: Name Registered
2005-07-10 10:32:26: select(6, 0.104492)
2005-07-10 10:32:26: select(6, 0.102539)
2005-07-10 10:32:26: select(6, 0.897460)
2005-07-10 10:32:27: select(6, 0.106445)
2005-07-10 10:32:27: select(6, 0.105468)
2005-07-10 10:32:27: select(6, 0.750000)
2005-07-10 10:32:28: select(6, 0.107421)
2005-07-10 10:32:28: select(6, 0.106445)
2005-07-10 10:32:28: select(6, 1.045898)
2005-07-10 10:32:29: select(6, 0.106445)
2005-07-10 10:32:29: select(6, 0.104492)
2005-07-10 10:32:29: select(6, 2.749023)
2005-07-10 10:32:32: select(6, 0.025390)
2005-07-10 10:32:32: select(6, 0.105468)
2005-07-10 10:32:32: select(6, 0.103515)
2005-07-10 10:32:32: select(6, 5.036132)
2005-07-10 10:32:37: select(6, 0.044921)
2005-07-10 10:32:37: select(6, 0.106445)
2005-07-10 10:32:37: select(6, 0.104492)
2005-07-10 10:32:37: select(6, 15.898437)
2005-07-10 10:32:53: select(6, 0.152343)
2005-07-10 10:32:53: select(6, 0.104492)
2005-07-10 10:32:53: select(6, 0.103515)
2005-07-10 10:32:53: select(6, 31.897460)
2005-07-10 10:33:25: select(6, 0.306640)
2005-07-10 10:33:25: select(6, 0.106445)
2005-07-10 10:33:25: select(6, 0.104492)
2005-07-10 10:33:25: select(6, 63.897460)
2005-07-10 10:34:29: select(6, 0.617187)
2005-07-10 10:34:29: select(6, 0.104492)
2005-07-10 10:34:29: select(6, 0.103515)
2005-07-10 10:34:29: select(6, 127.897460)

Post edited by: johnnymac, at: 2005/07/10 14:57

[johnnymac]

The nightly (mt-daapd_cvs-20050713-1_armeb.ipk) fixed this issue. mt-daapd rules! I now have all of my tunes and playlists!

[rpedde]

Good to hear.

Cheers.

— Ron

[Author]

Posts