FreeBSD svn-1586 error: "Error opening db:

FireFly Media Server Firefly Media Server Forums Firefly Media Server Setup Issues FreeBSD svn-1586 error: "Error opening db:

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #2759
    dovad
    Participant

    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

    #18051
    Anonymous
    Inactive

    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 ) ?

    #18052
    dovad
    Participant

    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?

    #18053
    stretch
    Participant

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

    #18054
    dovad
    Participant

    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

    #18055
    dovad
    Participant

    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

    #18056
    Anonymous
    Inactive

    @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

Viewing 7 posts - 1 through 7 (of 7 total)
  • The forum ‘Setup Issues’ is closed to new topics and replies.