FreeBSD svn-1586 error: "Error opening db:

[dovad]

I’ve been trying to get svn-1586 to run on FreeBSD 7.1-64 and am getting the following errors in my log:

2009-03-06 11:03:38 (93677f4e): Firefly Version svn-1586: Starting with debuglevel 2
2009-03-06 11:03:38 (93677f4e): Warning: Could not load plugins
2009-03-06 11:03:38 (93677f4e): Starting rendezvous daemon
2009-03-06 11:03:38 (93677f4e): Starting signal handler
2009-03-06 11:03:38 (93677f4e): db_sqlite3_open: Misc SQL Error: unable to open database file (/var/cache/mt-daapd/songs3.db)
2009-03-06 11:03:38 (93677f4e): Error opening db: Misc SQL Error: unable to open database file

I’m a UNIX Newbe and would appreciate help.

Thanks…
Dave

[Anonymous]

The SQL errors are most likely because of a permission problem. The user that runs firefly probably doesn’t have write rights in /var/cache/mt-daapd
The warning about the plugins is most likely because they are not installed in the right location.

Why are you using svn-1586 and not the version in the ports tree ( svn-1696 ) ?

[dovad]

You were right about permissions being the sql issue, and now that database is working, THANKS!

I am running svn-1586 because it is more stable than svn-1696. I’ve been running a Linkstation for about 18 months with svn-1586. I could not get it to run reliably with svn-1696 and Ron Pedde suggested that I fall back to svn-1586 and since then that Linkstation has been the most super reliable box of any kind that I have ever had.

On another note, mt-daapd is still not able to read the plugins. I checked many times that they are in the specified directory and they are where expected. In the “/usr/local/share/mt-daapd/plugins” directory are the following files:

-rwxr-xr-x 1 root daapd 139190 Mar 6 17:12 libout-daap.a
-rwxr-xr-x 1 root daapd 97030 Mar 6 17:12 libout-daap.so.0.0
-rwxr-xr-x 1 root daapd 68392 Mar 6 17:12 librsp.a
-rwxr-xr-x 1 root daapd 48379 Mar 6 17:12 librsp.so.0.0
-rwxr-xr-x 1 root daapd 20940 Mar 6 17:12 libssc-script.a
-rwxr-xr-x 1 root daapd 19991 Mar 6 17:12 libssc-script.so.0.0
-rwxr-xr-x 1 root daapd 922 Mar 6 17:12 out-daap.la
-rwxr-xr-x 1 root daapd 892 Mar 6 17:12 rsp.la
-rwxr-xr-x 1 root daapd 934 Mar 6 17:12 ssc-script.la

The only thing that I can think of is that perhaps some plugins may be missing? Does that make sense? I also changed some of the permissions adding “execute” to a few that didn’t have that level of permission in the event that was the issue.

Log output:

2009-03-06 19:28:07 (93677f4e): Firefly Version svn-1586: Starting with debuglevel 2
2009-03-06 19:28:07 (93677f4e): Warning: Could not load plugins
2009-03-06 19:28:07 (93677f4e): Starting rendezvous daemon
2009-03-06 19:28:07 (93677f4e): Starting signal handler
2009-03-06 19:28:07 (93677f4e): Initializing database
2009-03-06 19:28:08 (93677f4e): Starting web server from /usr/local/share/mt-daapd/admin-root on port 3689
2009-03-06 19:28:08 (93677f4e): Registering rendezvous names
2009-03-06 19:28:08 (93677f4e): Serving 6204 songs. Startup complete in 1 seconds

Also, the server is running and I can display the web page but it does not show up in iTunes. This server has had Netatalk and Howl installed for some time well before the mt-daapd project and does successfully advertise afp shares to our Mac’s. Is there some kind of conflict that can possibly be occurring?

[stretch]

@dovad wrote:

Also, the server is running and I can display the web page but it does not show up in iTunes. This server has had Netatalk and Howl installed for some time well before the mt-daapd project and does successfully advertise afp shares to our Mac’s. Is there some kind of conflict that can possibly be occurring?

Possibly. Who compiled Firefly?

Howl support needs to be enabled when compiled
@http://wiki.fireflymediaserver.org/Configure_Options wrote:

–enable-howl

Use howl (0.9.6 or greater) as an mdns provider. –enable-howl automatically disables the built-in mdns provider. Again, DO NOT USE –disable-mdns, or you will disable howl as well.

When using the –enable-howl option, you may need to use the “–with-howl-includes” and “–with-howl-libs” options to point to the directories holding the howl include files and the howl libraries.

[dovad]

I compiled Firefly. I tried both of the following:

./configure –enable-sqlite3 –with-id3tag=/usr/local

and

./configure –enable-sqlite3 –with-id3tag=/usr/local –with-gdbm-includes=/usr/local/include –prefix=/usr/local CFLAGS=”-O2 -fno-strict-aliasing -pipe” CPPFLAGS=” -I/usr/local/include”

When I added “–enable-howl” to either of the above to compile Firefly I got errors and the compile was not successful. Before I started this project to add Firefly to this server I had already setup Netatalk and Howl to advertise the “afp” shares so Howl was already installed.

Firefly is still giving me the following errors when loading indicating that it is not loading the plugins even though the plugins are exactly where they are specified in the Firefly configuration:

2009-03-07 00:15:07 (93677f4e): Firefly Version svn-1586: Starting with debuglevel 2
2009-03-07 00:15:07 (93677f4e): Warning: Could not load plugins
2009-03-07 00:15:07 (93677f4e): Starting rendezvous daemon
2009-03-07 00:15:07 (93677f4e): Starting signal handler
2009-03-07 00:15:07 (93677f4e): Initializing database
2009-03-07 00:15:07 (93677f4e): Starting web server from /usr/local/share/mt-daapd/admin-root on port 3689
2009-03-07 00:15:07 (93677f4e): Registering rendezvous names
2009-03-07 00:15:07 (93677f4e): Serving 6205 songs. Startup complete in 0 seconds
2009-03-07 00:15:07 (93677f4e): Rescanning database
2009-03-07 00:15:10 (93677f4e): Starting playlist scan

I am also getting the following message in the web interface under configuration:

Options missing from config.xml
The options below are in your mt-daapd.conf and Firefly uses them,
but this web page can’t handle them until they are added to config.xml

general:db_dir
plugins:debuglevel
plugins:process_itunes

[dovad]

Just to add something to the above post and like I mentioned before, I already had setup Netatalk and Howl a couple of weeks prior to giving Firefly a go. In my rc.conf file I have the following enabled:

mdnsresponder_enable=”YES”
mdnsresponder_flags=”-f /usr/local/etc/mDNSResponder.conf”

Is there a possibility that this is interfering with Firefly’s efforts to display it’s presence across my network via it’s built-in mDNSResponder and if so how can I fix this issue.

I still cannot figure out why my plugins wont load and any ideas would be appreciated.

Thanks…
Dave

[Anonymous]

@dovad wrote:

Just to add something to the above post and like I mentioned before, I already had setup Netatalk and Howl a couple of weeks prior to giving Firefly a go. In my rc.conf file I have the following enabled:

mdnsresponder_enable=”YES”
mdnsresponder_flags=”-f /usr/local/etc/mDNSResponder.conf”

Is there a possibility that this is interfering with Firefly’s efforts to display it’s presence across my network via it’s built-in mDNSResponder and if so how can I fix this issue.

I still cannot figure out why my plugins wont load and any ideas would be appreciated.

Thanks…
Dave

cd /usr/ports/audio/firefly
make install clean

No need for external mDNSresponder
various iTunes and Roku devices connect to my firefly server running in freebsd 8.0-stable jail

[Author]

Posts