You are here: Home »

t0m

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 28 total)
  • Author
    Posts
  • in reply to: AudioScrobbler / last.fm support #5227
    t0m
    Participant

    I’ve modified the rockscrobbler perl script by noleti so you actually only need one script.

    this script supports compilations. You can download it from:

    http://rapidshare.com/files/31760952/firescrobbler.zip

    this is a sqlite3 version – for sqlite2 add use DBD::SQLite2;

    I’ve been testing this script for two weeks now (cronjob running every 5 minutes) – its working fine for me.
    /t0m

    in reply to: AudioScrobbler / last.fm support #5226
    t0m
    Participant

    @djurnove wrote:

    A few questions about the script:

    1. My songs db is “songs.gdb”, not “songs3.db”. As long as I change the path in the script, will this matter? Are they two different db formats?

    songs3.db is sqlite3 format
    songs.db is sqlite2 format
    songs.gdb is another textbased(?) format.

    the script was/is for sqlite databases only – sorry.

    in reply to: ogg transcoding problem #5457
    t0m
    Participant

    .ogg and .flac trasncoding is working fine in svn-1281 running on debian.

    t0m
    Participant

    seems the output need to be sorted by date, otherwise last.fm will complain:

    Spam protection triggered: You submitted a track dated earlier than your last submission.

    so we need to change the line:


    $SQLITE $DATABASE 'SELECT artist,album,title,track,song_length,time_played FROM songs where time_played > '$LASTRUN' ORDER BY time_played ASC;' | awk -F '|' '{ printf "%st%st%st%st%dtLt%sn",$1,$2,$3,$4,$5/600,$6 }' >> $OUTLOG

    /t0m

    in reply to: "Songs Served" and play_count not updated correctl #5299
    t0m
    Participant

    I’ve noticed, there is still a diff. of exactly 10bytes:

    in svn-1274

    2006-06-29 18:41:22: Thread 7: Length of file (remaining) is 4390463
    […]
    2006-06-29 18:45:55: Finished streaming file to remote: 4390453 bytes

    in svn-1249

    2006-06-28 13:51:08: Thread 11: Length of file (remaining) is 2917002
    2006-06-28 13:51:08: Added *Content-Length=2917002*
    […]
    2006-06-28 13:54:10: Finished streaming file to remote: 2916992 byte

    /t0m

    in reply to: "Songs Served" and play_count not updated correctl #5298
    t0m
    Participant

    @rpedde wrote:

    Nice catch. Should be fixed in r1269.

    well… still problem when album art in the mp3-tag

    in reply to: "Songs Served" and play_count not updated correctl #5296
    t0m
    Participant

    If there is a “art_filename” file present, the play_count / time_played is NOT update, because of a byte missmatch content-lenght <-> bytes streamed.

    /t0m

    in reply to: "Songs Served" and play_count not updated correctl #5295
    t0m
    Participant

    I’ve tested some more – seems a problem with folder art.

    with folder art

    2006-06-28 13:51:08: Thread 11: Length of file (remaining) is 2917002
    2006-06-28 13:51:08: Updating Content-Type from application/x-dmap-tagged to audio/mp3
    2006-06-28 13:51:08: Added *Content-Length=2917002*
    […]
    2006-06-28 13:51:08: Image appears to be 11881 bytes
    2006-06-28 13:51:08: Current tag size is 345 bytes
    2006-06-28 13:51:09: Done copying IMG 11895
    [..]
    2006-06-28 13:54:10: Finished streaming file to remote: 2916992 byte

    without folder art:

    2006-06-28 13:58:10: Thread 17: Length of file (remaining) is 831524
    2006-06-28 13:58:10: Updating Content-Type from application/x-dmap-tagged to audio/mp3
    2006-06-28 13:58:10: Added *Content-Length=831524*
    […]
    2006-06-28 13:58:55: Finished streaming file to remote: 831524 bytes
    2006-06-28 13:58:55: Executing: update songs set play_count=play_count + 1, time_played=1151495935 where id=12257

    in reply to: "Songs Served" and play_count not updated correctl #5292
    t0m
    Participant

    I’m not sure, but isn’t it –enable-sqlite OR –enable-sqlite3 ?
    BR,
    Carsten.

    hmm… ./configure without optiosn gives:


    Must use either --enable-sqlite or --enable-sqlite3

    wil try with –enable-sqlite3 only…

    /t0m

    OK. just configured with –enable-sqlite3 only and compiled mt-daap new..
    No Change – play_count etc. still not updated 🙁

    /t0m

    in reply to: debugging transcoding – build 1249 #5308
    t0m
    Participant

    on linux?
    you could use logger statements in the script:


    NAME
    logger - a shell command interface to the syslog(3) system log module

    SYNOPSIS
    logger [-isd] [-f file] [-p pri] [-t tag] [-u socket] [message ...]

    DESCRIPTION
    Logger makes entries in the system log. It provides a shell command interface to the syslog(3) system log
    module.

    Options:

    -i Log the process id of the logger process with each line.

    -s Log the message to standard error, as well as the system log.

    -f file Log the specified file.

    -p pri Enter the message with the specified priority. The priority may be specified numerically or as a
    ``facility.level'' pair. For example, ``-p local3.info'' logs the message(s) as informational level
    in the local3 facility. The default is ``user.notice.''

    -t tag Mark every line in the log with the specified tag.

    -u sock Write to socket as specified with socket instead of builtin syslog routines.

    -d Use a datagram instead of a stream connection to this socket.

    -- End the argument list. This is to allow the message to start with a hyphen (-).

    message Write the message to log; if not specified, and the -f flag is not provided, standard input is
    logged.

    The logger utility exits 0 on success, and >0 if an error occurs.

    /t0m

    in reply to: "Songs Served" and play_count not updated correctl #5290
    t0m
    Participant

    starting mt-daapd with -D database -d 9 gives:


    13:56:22: Starting with debuglevel 9
    13:56:22: Starting rendezvous daemon
    13:56:22: Starting signal handler
    13:56:23: Opening database
    13:56:23: Executing: select value from config where term='version'
    13:56:23: Results: 0
    13:56:23: Initializing database
    13:56:23: Executing: select count(*) FROM songs
    13:56:23: Executing: select value from config where term='rescan'
    13:56:23: Executing: vacuum
    13:56:32: Rows: 2
    13:56:32: Starting web server from /usr/local/share/mt-daapd/admin-root on port 3689
    13:56:32: Registering rendezvous names
    13:56:32: Executing: select count(*) FROM songs
    13:56:32: Scanned 13095 songs in 10 seconds
    13:56:53: Executing: select count(*) FROM songs
    13:56:53: Executing: select count(*) FROM playlists
    13:56:53: No query/filter
    13:56:53: Executing: select * from songs
    13:56:53: Enumerating size
    13:56:55: Executing: select * from songs
    13:56:55: Got size: 1760614
    13:59:01: Executing: select * from songs where id=686
    13:59:01: Session 2: Streaming file '03 - Interlude1.mp3' to 127.0.0.1 (offset 0)
    13:59:30: Executing: select * from songs where id=692
    13:59:30: Session 3: Streaming file '09 - Interlude2.mp3' to 127.0.0.1 (offset 0)
    14:00:00: Executing: select * from songs where id=695
    14:00:00: Session 4: Streaming file '12 - Interlude3.mp3' to 127.0.0.1 (offset 0)
    14:00:09: Executing: select * from songs where id=684
    14:00:09: Session 5: Streaming file '01 - Intro.mp3' to 127.0.0.1 (offset 0)
    14:01:16: Executing: select * from songs where id=693
    14:01:16: Session 6: Streaming file '10 - Love labous on.mp3' to 127.0.0.1 (offset 0)
    14:05:13: Executing: select * from songs where id=702
    14:05:13: Session 7: Streaming file '19 - Mother Dawn.mp3' to 127.0.0.1 (offset 0)
    14:10:26: Executing: select * from songs where id=690

    no update statements…..

    in reply to: "Songs Served" and play_count not updated correctl #5289
    t0m
    Participant

    I’ve compiled mt-daapd with


    ./configure --enable-sqlite3 --enable-sqlite --enable-debug --enable-mdns --enable-oggvorbis --enable-flac

    I switched to sqlite3 and streamed about 12 mp3s completely using the daap-java applet.

    play_count and time_played for all files still 0.


    # sqlite3 /usr/local/var/cache/mt-daapd/songs3.db
    SQLite version 3.3.5
    Enter ".help" for instructions
    sqlite> SELECT count(*) FROM songs where time_played != 0;
    0
    sqlite> SELECT count(*) FROM songs where time_played = 0;
    13095
    sqlite> SELECT count(*) FROM songs where play_count != 0;
    0
    sqlite> SELECT count(*) FROM songs where play_count = 0;
    13095
    sqlite>
    in reply to: "Songs Served" and play_count not updated correctl #5288
    t0m
    Participant

    regarding the Status page, I’ve got 13095 songs in my db.

    After streaming some mp3 songs to my SB I’ve got:

    Songs Served 13

    the counters in the database are not updated:


    # sqlite songs.db 'SELECT title FROM songs where play_count =0;' |wc -l
    13095
    # sqlite songs.db 'SELECT title FROM songs where time_played =0;' |wc -l
    13095
    #

    # sqlite songs.db 'SELECT title FROM songs where play_count !=0;' |wc -l
    0
    # sqlite songs.db 'SELECT title FROM songs where play_count >0;' |wc -l
    0
    # sqlite songs.db 'SELECT title FROM songs where time_played !=0;' |wc -l
    0
    # sqlite songs.db 'SELECT title FROM songs where time_played >0;' |wc -l
    0
    #

    I haven’t checked transcoded content, yet.

    /t0m

    in reply to: AudioScrobbler / last.fm support #5216
    t0m
    Participant

    @rpedde wrote:

    yes, but I was going to put that in a separate plug-in.

    thanks for the fast reply…. looking forward to the plugin….

    /t0m

    in reply to: play_count update point #4051
    t0m
    Participant

    @rpedde wrote:

    I could use the audioscrobbler rules, and make it when 50% of the song was played, but I like this way, so I’ll keep it that way. 🙂

    Is Audioscrobbler / last.fm support still on the roadmap?
    Any idea when you are going to implement it?

    /t0m

Viewing 15 posts - 1 through 15 (of 28 total)