FireFly Media Server › Firefly Media Server Forums › Firefly Media Server › Nightlies Feedback › svn-1751 SQL error
- This topic has 1 reply, 1 voice, and was last updated 16 years, 4 months ago by
spartas.
-
AuthorPosts
-
06/05/2007 at 6:01 PM #1364
spartas
ParticipantI finally was able to get mt-daap installed on my Ubuntu dappper 64-bit server box, but I’ve hit a few snags with the db.
Here are the flags I compiled with at first:
--enable-sqlite3
--enable-avahi
--with-libid3tag=/usr/lib
--prefix=/usr
mt-daap started up fine, and I was able to see the music share on my iTunes powerbook okay. However, I have been encountering these errors:
2007-05-06 12:57:54 (f849b1ee): Thread 0: Done parsing GET/POST args!
2007-05-06 12:57:54 (f849b1ee): Thread 0: Original URI: /databases/1/items
2007-05-06 12:57:54 (f849b1ee): Thread 0: Translated URI: /databases/1/items
2007-05-06 12:57:54 (f849b1ee): Thread 0: Preparing to find handler
2007-05-06 12:57:54 (f849b1ee): Checking /databases/1/items against handler for /
2007-05-06 12:57:54 (f849b1ee): Thread 0: URI Match!
2007-05-06 12:57:54 (f849b1ee): Thread 0: Time is 1178474274 seconds after epoch
2007-05-06 12:57:54 (f849b1ee): Thread 0: Setting time header
2007-05-06 12:57:54 (f849b1ee): Added *Date=Sun, 6 May 2007 17:57:54 GMT*
2007-05-06 12:57:54 (f849b1ee): Added *Connection=keep-alive*
2007-05-06 12:57:54 (f849b1ee): Added *Server=mt-daapd/svn-1571*
2007-05-06 12:57:54 (f849b1ee): Added *Content-Type=text/html*
2007-05-06 12:57:54 (f849b1ee): Added *Content-Language=en_us*
2007-05-06 12:57:54 (f849b1ee): Thread 0: Using non-default handler
2007-05-06 12:57:54 (f849b1ee): in main_auth
2007-05-06 12:57:54 (f849b1ee): Checking url /databases/1/items
2007-05-06 12:57:54 (f849b1ee): Checking url /databases/1/items
2007-05-06 12:57:54 (f849b1ee): Dispatching auth for /databases/1/items to plugin
2007-05-06 12:57:54 (f849b1ee): Checking url /databases/1/items
2007-05-06 12:57:54 (f849b1ee): Checking url /databases/1/items
2007-05-06 12:57:54 (f849b1ee): Dispatching /databases/1/items to daap/svn-1571
2007-05-06 12:57:54 (f849b1ee): Checking if pw required for /databases/1/items as user
2007-05-06 12:57:54 (f849b1ee): Nope
2007-05-06 12:57:54 (f849b1ee): in main_handler
2007-05-06 12:57:54 (f849b1ee): Checking url /databases/1/items
2007-05-06 12:57:54 (f849b1ee): Checking url /databases/1/items
2007-05-06 12:57:54 (f849b1ee): Dispatching /databases/1/items to plugin
2007-05-06 12:57:54 (f849b1ee): Checking url /databases/1/items
2007-05-06 12:57:54 (f849b1ee): Checking url /databases/1/items
2007-05-06 12:57:54 (f849b1ee): Dispatching /databases/1/items to daap/svn-1571
2007-05-06 12:57:54 (f849b1ee): Getting uri...
2007-05-06 12:57:54 (f849b1ee): Mallocing privinfo...
2007-05-06 12:57:54 (f849b1ee): Added *Accept-Ranges=bytes*
2007-05-06 12:57:54 (f849b1ee): Added *DAAP-Server=firefly/svn-1571*
2007-05-06 12:57:54 (f849b1ee): Updating Content-Type from text/html to application/x-dmap-tagged
2007-05-06 12:57:54 (f849b1ee): Added *Cache-Control=no-cache*
2007-05-06 12:57:54 (f849b1ee): Added *Expires=-1*
2007-05-06 12:57:54 (f849b1ee): Tokenizing url
2007-05-06 12:57:54 (f849b1ee): Found 17 elements
2007-05-06 12:57:54 (f849b1ee): Checking reponse 0
2007-05-06 12:57:54 (f849b1ee): Checking reponse 1
2007-05-06 12:57:54 (f849b1ee): Checking reponse 2
2007-05-06 12:57:54 (f849b1ee): Checking reponse 3
2007-05-06 12:57:54 (f849b1ee): Checking reponse 4
2007-05-06 12:57:54 (f849b1ee): Checking reponse 5
2007-05-06 12:57:54 (f849b1ee): Checking reponse 6
2007-05-06 12:57:54 (f849b1ee): Found it! Index: 6
2007-05-06 12:57:54 (f849b1ee): Unknown meta code: daap.songalbumartist
2007-05-06 12:57:54 (f849b1ee): Unknown meta code: daap.songcategory
2007-05-06 12:57:54 (f849b1ee): Unknown meta code: daap.songextradata
2007-05-06 12:57:54 (f849b1ee): Unknown meta code: daap.songcontentdescription
2007-05-06 12:57:54 (f849b1ee): Unknown meta code: daap.songlongcontentdescription
2007-05-06 12:57:54 (f849b1ee): Unknown meta code: daap.songkeywords
2007-05-06 12:57:54 (f849b1ee): Unknown meta code: com.apple.itunes.is-podcast
2007-05-06 12:57:54 (f849b1ee): Unknown meta code: com.apple.itunes.mediakind
2007-05-06 12:57:54 (f849b1ee): Unknown meta code: com.apple.itunes.series-name
2007-05-06 12:57:54 (f849b1ee): Unknown meta code: com.apple.itunes.network-name
2007-05-06 12:57:54 (f849b1ee): Unknown meta code: com.apple.itunes.episode-num-str
2007-05-06 12:57:54 (f849b1ee): Unknown meta code: com.apple.itunes.episode-sort
2007-05-06 12:57:54 (f849b1ee): Unknown meta code: com.apple.itunes.season-num
2007-05-06 12:57:54 (f849b1ee): Unknown meta code: daap.songgapless
2007-05-06 12:57:54 (f849b1ee): Unknown meta code: com.apple.itunes.gapless-enc-del
2007-05-06 12:57:54 (f849b1ee): Unknown meta code: com.apple.itunes.gapless-heur
2007-05-06 12:57:54 (f849b1ee): Unknown meta code: com.apple.itunes.gapless-enc-dr
2007-05-06 12:57:54 (f849b1ee): Unknown meta code: com.apple.itunes.gapless-dur
2007-05-06 12:57:54 (f849b1ee): Unknown meta code: com.apple.itunes.gapless-resy
2007-05-06 12:57:54 (f849b1ee): meta codes: 193514046488527
2007-05-06 12:57:54 (f849b1ee): No query/filter
2007-05-06 12:57:54 (f849b1ee): Executing: select count(songs.id) from songs
2007-05-06 12:57:54 (f849b1ee): Error: enum_fetch failed (error 1): Misc SQL Error: library routine called out of sequence
2007-05-06 12:57:54 (f849b1ee): Enumerating size
The mt-daapd server quits after this, and the share disappears from iTunes.
In an attempt to bypass these SQL errors, I tried to recompile using the –with-sqlite flag instead, I get the following:
2007-05-06 12:40:51 (06b4e486): Client running
2007-05-06 12:40:51 (06b4e486): Creting service group
2007-05-06 12:40:51 (06b4e486): No entries yet... skipping service create
2007-05-06 12:40:51 (06b4e486): Starting avahi polling thread
2007-05-06 12:40:51 (06b4e486): Starting signal handler
2007-05-06 12:40:51 (06b4e486): Opening database
2007-05-06 12:40:51 (06b4e486): Error opening db: No backend database support for type: sqlite
I should have both sqlite and sqlite3 installed, so I’m uncertain on what the issue is here.
Between each compile, I was sure to remove everything from within /var/cache/mt-daap to ensure I was working with a fresh db each time.
06/05/2007 at 6:31 PM #10555spartas
ParticipantOkay, scratch that second part; I had sqlite verison 2 installed, but not the development headers. I aplogize for that.
-
AuthorPosts
- The forum ‘Nightlies Feedback’ is closed to new topics and replies.