Error opening database file

[Anonymous]

Help!

Ok, first, the background:
mt-daapd/Firefly Version: Firefly Media Server (svn-1586)
Server OS: Vista
Server Hardware: PC
Client Device: Roku M500
iTunes 8.0 for Windows
Connection: Wireless Router, Dlink 2XR

I had everything working smoothly a month ago. Then like a fool, I downloaded and installed a newer version of Bonjour (lesson learned: if it’s not broke, don’t fix it!). I am now running the most current Bonjour version found on the Apple site (1.0.6). When Roku suddenly couldn’t find the database, I updated my Firefly Media Server thinking that it would work with the new version of Bonjour. And now, nothing works. 🙁

Firefly installs fine and scans my iTunes library perfectly on the first pass. But a few minutes later, it rescans, and I get the following log:
2009-04-08 22:12:07 (8505fd15): Starting with debuglevel 0
2009-04-08 22:12:07 (8505fd15): Starting rendezvous daemon
2009-04-08 22:12:07 (8505fd15): Initializing database
2009-04-08 22:12:18 (8505fd15): Starting web server from C:Program FilesFirefly Media Serveradmin-root on port 9999
2009-04-08 22:12:18 (8505fd15): Registering rendezvous names
2009-04-08 22:12:18 (8505fd15): Serving 3585 songs. Startup complete in 11 seconds
2009-04-08 22:12:18 (8505fd15): Rescanning database
2009-04-08 22:12:25 (8505fd15): Query: INSERT INTO updated VALUES (67)
2009-04-08 22:12:25 (8505fd15): Error: unable to open database file
2009-04-08 22:12:25: Aborting

On top of this, even when Firefly was running after the initial install & scan, my Roku couldn’t see it.

My Roku is accessing my router without issue and can play internet radio just fine.

What am I doing wrong? Please help.

Thanks,
Eric

[EVILRipper]

Your roku probably can’t find your firefly because it isn’t running.
With any bump or hiccup, firefly kills itself.

Sometimes the database file just gets corrupted. It happens.
How to fix it? Quite simple — Stop firefly. Delete the database. Start firefly.
It will then build a new database from scratch.

Hope this helps.

[Anonymous]

Hi Ripper,

Thanks for the feedback. Unfortunately, it doesn’t work. When there’s no database, it scans my songs and initializes a new database just fine. But after that, it can’t open the existing database upon rescan. The messages look like this:

2009-04-09 00:31:29 (03940439): Starting with debuglevel 0
2009-04-09 00:31:30 (03940439): Starting rendezvous daemon
2009-04-09 00:31:30 (03940439): Error: enum_begin failed (error 1): Misc SQL Error: no such table: config
2009-04-09 00:31:30 (03940439): Can’t get db version. New database?
2009-04-09 00:31:30 (03940439): Initializing database
2009-04-09 00:31:30 (03940439): Error: enum_begin failed (error 1): ?
2009-04-09 00:31:30 (03940439): Error: enum_begin failed (error 1): ?
2009-04-09 00:31:30 (03940439): Full reload…
2009-04-09 00:31:30 (03940439): Starting mp3 scan
2009-04-09 00:33:28 (03940439): Starting playlist scan
2009-04-09 00:33:41 (03940439): err adding playlist Music
2009-04-09 00:33:43 (03940439): Scanned 3585 songs in 133 seconds
2009-04-09 00:33:43 (03940439): Starting web server from C:Program FilesFirefly Media Serveradmin-root on port 9999
2009-04-09 00:33:43 (03940439): Registering rendezvous names
2009-04-09 00:33:45 (03940439): Serving 3585 songs. Startup complete in 135 seconds
2009-04-09 00:43:47 (03940439): Rescanning database
2009-04-09 00:44:58 (03940439): Query: INSERT INTO updated VALUES (676)
2009-04-09 00:44:58 (03940439): Error: unable to open database file
2009-04-09 00:44:58: Aborting

Thanks for your help,
Eric

[Author]

Posts