Unable to open database error

[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

[sonichouse]

Your conffig has runas=nobody.

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

[Anonymous]

Changed runas to root and I am now serving music!

Thank you so much for your swift and accurate response.

Martin

[sonichouse]

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

[Author]

Posts