Help Pls! Can’t get music added to database

[jw2k_fr]

So having got Firefly working on my previous install I borked the thing and decided to change distros to Debian. I have installed svn1463 and all looks good except for having some ‘choons’ to serve up to my Roku.

I have a PPC version of Debian Sarge running on a Kurobox (linkstation) and am getting the following lines in my logfile:

2007-01-14 22:56:45 (00004000): Initializing database
2007-01-14 22:56:45 (00004000): Full reload…
2007-01-14 22:56:45 (00004000): Starting mp3 scan
2007-01-14 22:56:45 (00004000): Query: create index idx_path on songs(path,idx)
2007-01-14 22:56:45 (00004000): Error: index idx_path already exists
2007-01-14 22:56:45: Aborting
2007-01-14 22:56:45 (00004000): Rendezvous socket closed (daap server crashed?)
2007-01-14 22:56:45: Aborting

I have checked the permissions on my songs.db:

KURO-BOX:/var/cache/mt-daapd# ls -l songs.db
-rw-r–r– 1 nobody nogroup 14336 Jan 14 23:13 songs.db

KURO-BOX:/var# ls -l cache
total 28
..
drwxr-xr-x 2 nobody root 4096 Jan 14 23:13 mt-daapd

I have also checked the directory in which I am storing music and both that dir and the files have access by nobody.

Firefly is running as nobody but I can’t see where I have the wrong permissions. Can anyone help please?

Thanks
James

[rpedde]

@jw2k_fr wrote:

Firefly is running as nobody but I can’t see where I have the wrong permissions. Can anyone help please?

Try deleting the songs.db in your database path. Somehow, it seems to have broken itself — like maybe it was terminated badly while it was building an index or something.

— Ron

[jw2k_fr]

So it gets stranger and stranger…

Have deleted songs.db and it recreated the database (thanks for the suggestion Ron).

Upon viewing the logfile I see lines such as:

2007-01-16 22:44:01 (00004000): Found /media/usb1/Aimee Mann/Lost in Space
2007-01-16 22:44:01 (00004000): Found Lost in Space.. recursing
2007-01-16 22:44:01 (00004000): Found /media/usb1/Aimee Mann/Lost in Space/01.
2007-01-16 22:44:01 (00004000): Found /media/usb1/Aimee Mann/Lost in Space/02.
2007-01-16 22:44:01 (00004000): Found /media/usb1/Aimee Mann/Lost in Space/03.
2007-01-16 22:44:01 (00004000): Found /media/usb1/Aimee Mann/Lost in Space/04.

and after a pile more songs:

2007-01-16 22:44:02 (00004000): mDNS_Execute
2007-01-16 22:44:02 (00004000): SendQueries: Put Question KURO-BOX.local. (Ad
2007-01-16 22:44:02 (00004000): SendQueries: Sending 1 Question 0 Answers 1 U
2007-01-16 22:44:02 (00004000): select(7, 0.098632)
2007-01-16 22:44:02 (00004000): SocketDataReady got a packet from 192.168.0.100
2007-01-16 22:44:02 (00004000): Received Query from 192.168.0.100 :5353 to 224
2007-01-16 22:44:02 (00004000): select(7, 0.098632)

And then a little further on:

2007-01-16 22:44:02 (00004000): Ending song scan
2007-01-16 22:44:02 (00004000): Executing: commit transaction
2007-01-16 22:44:02 (00004000): Rows: 0
2007-01-16 22:44:02 (00004000): Executing: pragma synchronous=normal
2007-01-16 22:44:02 (00004000): Rows: 0
2007-01-16

Upon which it finds a few more songs (I may have asked it to scan again) and then it repeats the above.

However, upon checking the admin status webpage, it lists zero songs. My Roku also lists it as having zero songs available.

What’s the verdict doctor?

[rpedde]

@jw2k_fr wrote:

2007-01-16 22:44:01 (00004000): Found /media/usb1/Aimee Mann/Lost in Space
2007-01-16 22:44:01 (00004000): Found Lost in Space.. recursing
2007-01-16 22:44:01 (00004000): Found /media/usb1/Aimee Mann/Lost in Space/01.
2007-01-16 22:44:01 (00004000): Found /media/usb1/Aimee Mann/Lost in Space/02.
2007-01-16 22:44:01 (00004000): Found /media/usb1/Aimee Mann/Lost in Space/03.
2007-01-16 22:44:01 (00004000): Found /media/usb1/Aimee Mann/Lost in Space/04.

Do those really have no extensions? If so, that would be a problem. It decides something is a media file by the extension. .mp3, etc.

Also, just double-check that those files are indeed world readable. And what file system is it formatted as?

[jw2k_fr]

🙂 No, they’re not truncated that’s just the way the lines are truncated from my terminal session. The files are in folders owned by nobody and nogroup

The files themselves also are owned by nobody and nogroup and I have run chmod -R a+rwx * from the root of my media tree. Still doesn’t want to list the files.

It is possible that I’ve something weird going on with usbmount, but it doesn’t catalogue anything in the other media directory I have which is not on an external USB drive. The log entries from the init of the database have slightly strange wording which might indicate an error (a dollar sign indicates a truncated line from terminal session):

2007-01-17 08:41:45 (00004000): Executing: select value from config where term=$2007-01-17 08:41:45 (00004000): Results: 0
2007-01-17 08:41:45 (00004000): Initializing database
2007-01-17 08:41:45 (00004000): Executing: select count(*) FROM songs
2007-01-17 08:41:45 (00004000): Executing: select value from config where term=$2007-01-17 08:41:45 (00004000): Full reload…
2007-01-17 08:41:45 (00004000): Executing: drop index idx_path
2007-01-17 08:41:45 (00004000): Rows: 0
2007-01-17 08:41:45 (00004000): Executing: drop index idx_songid
2007-01-17 08:41:45 (00004000): Rows: 0
2007-01-17 08:41:45 (00004000): Executing: drop index idx_playlistid
2007-01-17 08:41:45 (00004000): Rows: 0
22007-01-17 08:41:45 (00004000): Executing: drop index idx_playlistid
2007-01-17 08:41:45 (00004000): Rows: 0
2007-01-17 08:41:45 (00004000): Executing: drop table songs
2007-01-17 08:41:45 (00004000): Rows: 0
2007-01-17 08:41:45 (00004000): Executing: delete from playlists where not type$2007-01-17 08:41:45 (00004000): Rows: 0
2007-01-17 08:41:45 (00004000): Executing: drop table playlistitems
2007-01-17 08:41:45 (00004000): Rows: 0
2007-01-17 08:41:45 (00004000): Executing: drop table config
2007-01-17 08:41:45 (00004000): Rows: 0
2007-01-17 08:41:45 (00004000): Executing: vacuum
2007-01-17 08:41:45 (00004000): Rows: 0
2007-01-17 08:41:45 (00004000): Executing: 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,
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,
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)
bits_per_sample INTEGER DEFAULT 0,
album_artist VARCHAR(1024)
);
create table playlistitems (
id INTEGER PRIMARY KEY NOT NULL,
playlistid INTEGER NOT NULL,
songid INTEGER NOT NULL
);
create table config (
term VARCHAR(255) NOT NULL,
subterm VARCHAR(255) DEFAULT NULL,
value VARCHAR(1024) NOT NULL
);
insert into config values (‘version’,”,’13’);

2007-01-17 08:41:45 (00004000): Rows: 1
2007-01-17 08:41:45 (00004000): Executing: create table playlists (
id INTEGER PRIMARY KEY NOT NULL,
title VARCHAR(255) NOT NULL,
type INTEGER NOT NULL,
title VARCHAR(255) NOT NULL,
type INTEGER NOT NULL,
items INTEGER NOT NULL,
query VARCHAR(1024),
db_timestamp INTEGER NOT NULL,
path VARCHAR(4096),
idx INTEGER NOT NULL
);
insert into playlists values (1,’Library’,1,0,’1′,0,”,0);

2007-01-17 08:41:45 (00004000): Query: create table playlists (
id INTEGER PRIMARY KEY NOT NULL,
title VARCHAR(255) NOT NULL,
type INTEGER NOT NULL,
items INTEGER NOT NULL,
query VARCHAR(1024),
db_timestamp INTEGER NOT NULL,
path VARCHAR(4096),
idx INTEGER NOT NULL
);
idx INTEGER NOT NULL
);
insert into playlists values (1,’Library’,1,0,’1′,0,”,0);

2007-01-17 08:41:45 (00004000): Error: table playlists already exists
2007-01-17 08:41:45 (00004000): Starting mp3 scan
2007-01-17 08:41:45 (00004000): Starting scan_init
2007-01-17 08:41:45 (00004000): Starting db scan
2007-01-17 08:41:45 (00004000): Executing: pragma synchronous = off
2007-01-17 08:41:45 (00004000): Rows: 0
2007-01-17 08:41:45 (00004000): Executing: begin transaction
2007-01-17 08:41:45 (00004000): Rows: 0
2007-01-17 08:41:45 (00004000): Scanning for MP3s in /mnt/music
2007-01-17 08:41:45 (00004000): Found /mnt/music/AC-DC
2007-01-17 08:41:45 (00004000): Found AC-DC.. recursing
2007-01-17 08:41:45 (00004000): Found /mnt/music/AC-DC/Live
2007-01-17 08:41:45 (00004000): Found Live.. recursing
2007-01-17 08:41:45 (00004000): Found /mnt/music/AC-DC/Live/01. Thunderstruck.f$2007-01-17 08:41:45 (00004000): Found /mnt/music/AC-DC/Live/02. Shoot To Thrill$

And thus continues the scan of flac files found in both media directories (i have flac as a file format to transcode)

Any further ideas?
Thx

[rpedde]

@jw2k_fr wrote:

And thus continues the scan of flac files found in both media directories (i have flac as a file format to transcode)

Do you have .flac in your “extensions” list?

[jw2k_fr]

Heh
Oops
Heh
errrm

Well actually no.
I thought it needed to be in the transcode section and not in the extensions line

How very simple

Many thanks for your assistance. I now just have to work out why automount won’t use my desired directory and I am sorted.

James

[rpedde]

@jw2k_fr wrote:

Well actually no.

lol. it’s always the easiest stuff that trips you up. Good luck.

— Ron

[Author]

Posts