svn-1751 SQL error

[spartas]

I 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.

[spartas]

Okay, scratch that second part; I had sqlite verison 2 installed, but not the development headers. I aplogize for that.

[Author]

Posts