You are here: Home » Topic » Unable to open database error

Unable to open database error

This topic contains 3 replies, has 2 voices, and was last updated by  sonichouse 9 years, 10 months ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #2046

    Anonymous

    Hi,
    I had the 0.2 stable version working on Linkstation HG. Due to a few other problems (self inflicted no doubt) a reflash was required. Decided to go for a nightly install of Firefly.

    Have ploughed through a few issues, but am now hitting a brick wall with an “unable to open database” error – There shouldn’t be one to open as it hasn’t done the initial scan yet, no?

    Anyway, this is the output from debug 9:

    OpenLink 0.73b – PPC – HD-HGLAN
    http://www.linkstationwiki.net

    bash-2.05a# /usr/local/sbin/mt-daapd -d9 -f -m -c /etc/mt-daapd/mt-daapd.conf
    Loading config file /etc/mt-daapd/mt-daapd.conf
    Opening file:///etc/mt-daapd/mt-daapd.conf?ascii=1
    Checking handler for file
    opening /etc/mt-daapd/mt-daapd.conf
    Config file open
    Got general/web_root, convert to general/web_root (/mnt/usr/local/share/mt-daapd
    /admin-root)
    Found existing section
    Got general/port, convert to general/port (3689)
    Found existing section
    Got general/admin_pw, convert to general/admin_pw (mt-daapd)
    Found existing section
    Got general/db_type, convert to general/db_type (sqlite3)
    Found existing section
    Got general/db_parms, convert to general/db_parms (/fireflylib)
    Found existing section
    Got general/mp3_dir, convert to general/mp3_dir (/mnt/share/MP3 Music/Music)
    Found existing section
    Found 1 tokens in /mnt/share/MP3 Music/Music
    Token 1: /mnt/share/MP3 Music/Music
    Got general/servername, convert to general/servername (Firefly)
    Found existing section
    Got general/runas, convert to general/runas (nobody)
    Found existing section
    Got general/extensions, convert to general/extensions (.mp3,.m4a,.m4p)
    Found existing section
    Expanding precomments to 2048
    Expanding precomments to 4096
    Got general/rescan_interval, convert to general/rescan_interval (0)
    Found existing section
    Got general/scan_type, convert to general/scan_type (0)
    Found existing section
    Got plugins/plugin_dir, convert to plugins/plugin_dir (/usr/local/lib/mt-daapd/p
    lugins)
    Found existing section
    Got plugins/process_playlists, convert to plugins/process_playlists (0)
    Found existing section
    Got plugins/process_itunes, convert to plugins/process_itunes (0)
    Found existing section
    Got plugins/process_m3u, convert to plugins/process_m3u (0)
    Found existing section
    Checking existence of /mnt/usr/local/share/mt-daapd/admin-root
    Checking existence of /mnt/usr/local/share/mt-daapd/admin-root
    Checking existence of /fireflylib
    Checking existence of /fireflylib
    Checking existence of /usr/local/lib/mt-daapd/plugins
    Checking existence of /usr/local/lib/mt-daapd/plugins
    Loading new config file.
    Firefly Version svn-1696: Starting with debuglevel 9
    Attempting to load plugin /mnt/usr/local/lib/mt-daapd/plugins/out-daap.so
    Loaded plugin /mnt/usr/local/lib/mt-daapd/plugins/out-daap.so (daap/svn-1696)
    New transcode codec list:
    Attempting to load plugin /mnt/usr/local/lib/mt-daapd/plugins/rsp.so
    Loaded plugin /mnt/usr/local/lib/mt-daapd/plugins/rsp.so (rsp/svn-1696)
    New transcode codec list:
    Attempting to load plugin /mnt/usr/local/lib/mt-daapd/plugins/ssc-script.so
    No ssc program specified for script transcoder.
    Error loading plugin /mnt/usr/local/lib/mt-daapd/plugins/ssc-script.so: plugin d
    eclined to load
    Plugin loaded: rsp/svn-1696
    Plugin loaded: daap/svn-1696
    Starting signal handler
    Opening database
    db_sqlite3_open: Misc SQL Error: unable to open database file (/fireflylib/songs
    3.db)
    Results: 1
    Error opening db: Misc SQL Error: unable to open database file
    bash-2.05a#
    bash-2.05a#

    Any pointers would be gratefully recieved.

    Many thanks

    Martin

    #15280

    sonichouse
    Participant

    Your conffig has runas=nobody.

    Check that you have given the correct access permissions to the database directory.

    #15281

    Anonymous

    Changed runas to root and I am now serving music!

    Thank you so much for your swift and accurate response.

    Martin

    #15282

    sonichouse
    Participant

    @Festa1971 wrote:

    Changed runas to root and I am now serving music!

    Thank you so much for your swift and accurate response.

    Martin

    No problem 😆

    You could probably do a chmod 766 on the directory and still run as nobody.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.