You are here: Home » Reply

Reply To: Sqlite3 on NSLU2 with debian etch

#16143

Anonymous
http://nightlies.fireflymediaserver.org/mt-daapd_0.9-svn-1586_etch_arm.deb

Ron has uploaded it to there. I can now get mine past that error, but i get another error

2008-02-09 14:05:50 (00004000): Firefly Version svn-1586: Starting with debuglevel 2
2008-02-09 14:05:50 (00004000): Warning: Could not load plugins
2008-02-09 14:05:50 (00004000): Starting rendezvous daemon
2008-02-09 14:05:50 (00004000): Starting signal handler
2008-02-09 14:05:50 (00004000): Local Hostname SLUG.local already in use; will try SLUG-2.local instead
2008-02-09 14:05:50 (00004000): Old database version: 12, expecting 13
2008-02-09 14:05:50 (00004000): Upgrading db: 12 --> 13
2008-02-09 14:05:53 (00004000): Query: create temp table tempsongs as select * from songs;
drop table songs;
CREATE TABLE songs (
id INTEGER PRIMARY KEY NOT NULL,
path VARCHAR(4096) NOT NULL,
fname VARCHAR(255) NOT NULL,
title VARCHAR(1024) DEFAULT NULL,
artist VARCHAR(1024) DEFAULT NULL,
album VARCHAR(1024) DEFAULT NULL,
genre VARCHAR(255) DEFAULT NULL,
comment VARCHAR(4096) DEFAULT NULL,
type VARCHAR(255) DEFAULT NULL,
composer VARCHAR(1024) DEFAULT NULL,
orchestra VARCHAR(1024) DEFAULT NULL,
conductor VARCHAR(1024) DEFAULT NULL,
grouping VARCHAR(1024) DEFAULT NULL,
url VARCHAR(1024) DEFAULT NULL,
bitrate INTEGER DEFAULT 0,
samplerate INTEGER DEFAULT 0,
song_length INTEGER DEFAULT 0,
file_size INTEGER DEFAULT 0,
year INTEGER DEFAULT 0,
track INTEGER DEFAULT 0,
total_tracks INTEGER DEFAULT 0,
disc INTEGER DEFAULT 0,
total_discs INTEGER DEFAULT 0,
bpm INTEGER DEFAULT 0,
compilation INTEGER DEFAULT 0,
rating INTEGER DEFAULT 0,
play_count INTEGER DEFAULT 0,
data_kind INTEGER DEFAULT 0,
item_kind INTEGER DEFAULT 0,
description INTEGER DEFAULT 0,
time_added INTEGER DEFAULT 0,
time_modified INTEGER DEFAULT 0,
time_played INTEGER DEFAULT 0,
db_timestamp INTEGER DEFAULT 0,
disabled INTEGER DEFAULT 0,
sample_count INTEGER DEFAULT 0,
force_update INTEGER DEFAULT 0,
codectype VARCHAR(5) DEFAULT NULL,
idx INTEGER NOT NULL,
has_video INTEGER DEFAULT 0,
contentrating INTEGER DEFAULT 0,
bits_per_sample INTEGER DEFAULT 0,
album_artist VARCHAR(1024)
);
begin transaction;
insert into songs select *,0,'' from tempsongs;
commit transaction;
drop table tempsongs;
update config set value=13 where term='version';

2008-02-09 14:05:53 (00004000): Error: unable to open database file
2008-02-09 14:05:53 (00004000): Error upgrading db: Misc SQL Error: unable to open database file
2008-02-09 14:05:53 (00004000): Error opening db: Misc SQL Error: unable to open database file

File stuff

SLUG:/var/cache# ls -l
total 28
drwxr-xr-x 3 root root 4096 Feb 9 12:49 apt
drwxrwxr-x 3 root lp 4096 Jan 12 06:26 cups
drwxr-xr-x 2 root root 4096 Feb 7 00:29 debconf
drwxr-xr-x 2 root root 4096 Feb 9 06:26 locate
drwxr-sr-x 16 man root 4096 Feb 9 06:26 man
drwxrwxr-x 2 nobody root 4096 Feb 9 12:52 mt-daapd
drwxr-xr-x 3 root root 4096 Feb 9 14:12 samba

SLUG:/var/cache/mt-daapd# ls -l
total 1924
-rw-r--r-- 1 mt-daapd nogroup 1965056 Feb 9 12:52 songs3.db

Permissions would seem right (im running it via /etc/init.d/mt-daapd)

Any suggestions?

Sam