Reply To: Firefly failed to start

#8371
zelet
Participant

mac:~ john$ sqlite /Users/john/Library/Application Support/Firefly/songs.db
-bash: sqlite: command not found

mac:~ john$ locate sqlite
~bunch of locations of libraries here
/usr/bin/sqlite3
~more libraries and stuff
/usr/lib/sqlite3

Should I change the DB to sqlite3?

mac:~ john$ sqlite3 /Users/john/Library/Application Support/Firefly/songs.db
SQLite version 3.1.3
Enter “.help” for instructions
sqlite>

Thanks for your help! 🙂

Changed it to sqlite3 and got this:
2007-01-10 16:03:57 (a000eca8): Firefly Version svn-1463: Starting with debuglevel 2
2007-01-10 16:03:57 (a000eca8): Starting rendezvous daemon
2007-01-10 16:03:57 (a000eca8): Starting signal handler
2007-01-10 16:03:57 (01807000): Signal handler started
2007-01-10 16:03:57 (a000eca8): Error opening db: No backend database support for type: sqlite3
2007-01-10 16:03:57 (a000eca8): Stopping signal handler
2007-01-10 16:03:57 (01807000): Got shutdown signal. Notifying daap server.

Another Update:

I installed sqlite (version 2) and it worked for a bit. It found my songs. Through the web interface I added my iTunes library instead of just my song list. When I went to browse the share in iTunes (it was visible) it loaded the songs then the server crashed. This is the error log:
2007-01-10 16:09:27 (a000eca8): Firefly Version svn-1463: Starting with debuglevel 2
2007-01-10 16:09:27 (a000eca8): Starting rendezvous daemon
2007-01-10 16:09:27 (a000eca8): Starting signal handler
2007-01-10 16:09:27 (01807000): Signal handler started
2007-01-10 16:09:27 (a000eca8): Initializing database
2007-01-10 16:09:29 (a000eca8): Starting web server from /Users/john/Library/PreferencePanes/Firefly.prefPane/Contents/Resources/Firefly Helper.app/Contents/Resources/Server/admin-root on port 0
2007-01-10 16:09:29 (a000eca8): Registering rendezvous names
2007-01-10 16:09:31 (a000eca8): Serving 1585 songs. Startup complete in 4 seconds
2007-01-10 16:09:31 (a000eca8): Rescanning database
2007-01-10 16:09:34 (01809600): Unknown meta code: daap.songalbumartist
2007-01-10 16:09:34 (01809600): Unknown meta code: daap.songcategory
2007-01-10 16:09:34 (01809600): Unknown meta code: daap.songcontentdescription
2007-01-10 16:09:34 (01809600): Unknown meta code: daap.songlongcontentdescription
2007-01-10 16:09:34 (01809600): Unknown meta code: daap.songkeywords
2007-01-10 16:09:34 (01809600): Unknown meta code: com.apple.itunes.is-podcast
2007-01-10 16:09:34 (01809600): Unknown meta code: com.apple.itunes.mediakind
2007-01-10 16:09:34 (01809600): Unknown meta code: com.apple.itunes.series-name
2007-01-10 16:09:34 (01809600): Unknown meta code: com.apple.itunes.network-name
2007-01-10 16:09:34 (01809600): Unknown meta code: com.apple.itunes.episode-num-str
2007-01-10 16:09:34 (01809600): Unknown meta code: com.apple.itunes.episode-sort
2007-01-10 16:09:34 (01809600): Unknown meta code: com.apple.itunes.season-num
2007-01-10 16:09:34 (01809600): Unknown meta code: daap.songgapless
2007-01-10 16:09:34 (01809600): Unknown meta code: com.apple.itunes.gapless-enc-del
2007-01-10 16:09:34 (01809600): Unknown meta code: com.apple.itunes.gapless-heur
2007-01-10 16:09:34 (01809600): Unknown meta code: com.apple.itunes.gapless-enc-dr
2007-01-10 16:09:34 (01809600): Unknown meta code: com.apple.itunes.gapless-dur
2007-01-10 16:09:34 (01809600): Unknown meta code: com.apple.itunes.gapless-resy
2007-01-10 16:09:34 (01809600): Unknown meta code: com.apple.itunes.is-podcast-playlist
2007-01-10 16:09:34 (01809600): Unknown meta code: com.apple.itunes.special-playlist
2007-01-10 16:09:35 (a000eca8): Rendezvous socket closed (daap server crashed?) Aborting.
2007-01-10 16:09:35: Aborting

Now after that crash when I try to restart the server it does quickly and gives me this log:
2007-01-10 16:11:37 (a000eca8): Firefly Version svn-1463: Starting with debuglevel 2
2007-01-10 16:11:37 (a000eca8): Starting rendezvous daemon
2007-01-10 16:11:37 (a000eca8): Starting signal handler
2007-01-10 16:11:37 (01807000): Signal handler started
2007-01-10 16:11:37 (a000eca8): Initializing database
2007-01-10 16:11:38 (a000eca8): Starting web server from /Users/john/Library/PreferencePanes/Firefly.prefPane/Contents/Resources/Firefly Helper.app/Contents/Resources/Server/admin-root on port 0
2007-01-10 16:11:38 (a000eca8): Registering rendezvous names
2007-01-10 16:11:40 (a000eca8): Serving 1585 songs. Startup complete in 3 seconds
2007-01-10 16:11:40 (a000eca8): Rescanning database
2007-01-10 16:11:44 (a000eca8): Rendezvous socket closed (daap server crashed?) Aborting.
2007-01-10 16:11:44: Aborting

and this:

mac:~ john$ sqlite /Users/john/Library/Application Support/Firefly/songs.db
SQL error: near “Support”: syntax error

So I’m assuming somehow the DB got corrupted when it crashed and I have to recreate it?