NSLU2 playlist setup for Win iTunes

This topic contains 9 replies, has 1 voice, and was last updated by  rpedde 11 years, 8 months ago.

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • #75

    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

    #3473

    rpedde
    Member

    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

    #3474

    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

    #3475

    rpedde
    Member

    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

    #3476

    johnnymac

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

    #3477

    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

    #3478

    rpedde
    Member

    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.

    #3479

    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

    #3480

    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!

    #3481

    rpedde
    Member

    Good to hear.

    Cheers.

    — Ron

Viewing 10 posts - 1 through 10 (of 10 total)
  • You must be logged in to reply to this topic.
Register here