Reply To: No backend database support for type: = sqlite3

#6611
barnseyboy
Participant

ive just tried to reconfigure with –enable-sqlite and i got the following

checking sqlite.h presence... no
checking for sqlite.h... no
configure: error: sqlite.h not found... Must have sqlite headers installed

i then installed libsqlite0 and re-ran configure. all reported back ok (found sqlite.h etc)

i then make copy the binary to /usr/sbin/ and run /etc/init.d/mt-daapd -start

log reports same error

2006-09-26 11:19:24 (00004000): Starting rendezvous daemon
2006-09-26 11:19:24 (00004000): Starting signal handler
2006-09-26 11:19:24 (00004002): Signal handler started
2006-09-26 11:19:25 (00004000): Error opening db: No backend database support for type: = sqlite
2006-09-26 11:19:25 (00004000): Stopping signal handler
2006-09-26 11:19:25 (00004002): Got shutdown signal. Notifying daap server.

this is the first time i have tried to run using sqlite (previously using songs.gdb) do i need to do anything to ‘initialise the database file’ ? ive specified the db path (and it exists, but obviously no sqlite file is being created in there yet)

and im presuming that gdb is no longer supports as when i compile without the flags i get this error

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

i also tried running mt-daapd -force-reload which put the following in the log file

2006-09-26 11:35:06 (00004000): Can't get db version. New database?
2006-09-26 11:35:06 (00004000): Initializing database
2006-09-26 11:35:06 (00004000): Error: enum_begin failed (error 1): ?
2006-09-26 11:35:06 (00004000): Error: enum_begin failed (error 1): ?
2006-09-26 11:35:06 (00004000): Full reload...
2006-09-26 11:35:06 (00004000): Starting mp3 scan
2006-09-26 11:35:06 (00004000): Error inserting file Track 01.mp3 in database
2006-09-26 11:35:06: Aborting