Re: Media Export problem

[Michael Lathion <m lathion gmail com>]

Hi,

You'll find enclosed the output of the command about foobar, after restarting rygel the problem is always persistent, I also tried to reinstall rygel 0.14.1 from source instead of 0.14.0 but still the same. Except that now I can see the "Files and Folder" branch if I click on the rygel server. Also from the install of 0.14.1 I'm not sure that my /etc/rygel.conf file is read because I've changed the playbin "title" properties but the default name appear in other devices ?? 

... I just made some other test and I confirm the /etc/rygel.conf file is not readed because before installing 14.1 the server was working on wmp12 or media:connect on iphone but now the media server is empty because there are no files on the default folders. 
I have try to put the rygel.conf to my home folder but still the same, what can cause this issue ??

Also I've try to change the dc: to upnp: before build 0.14.1 but the problem with 8-player is always there, you will find enclosed the exact error log in .png picture

Indeed the problem with the icon is resolved after installing from sources with a nice new icon :)
Thanks for your help
Michael

2012/5/5 Jens Georg <mail jensge org>

On Sa, 2012-05-05 at 09:13 +0200, Jens Georg wrote:
> On Fr, 2012-05-04 at 23:40 +0200, Michael Lathion wrote:
>
> > On foobar I see the device in servers list but I can't open it and in
>
> I'll have a look at foobar. No idea what should be causing this.

Works here with the upnp component version 0.99.39 from 2012-04-21.

Did you restart rygel since updating from 0.6 to 0.14? If not, could you
do so? If it still doesn't work, can you attach the output of echo
".schema" | sqlite3 $HOME/.cache/rygel/media-export.db ?

Could be that something went wrong when updating the database.

CREATE TABLE closure (ancestor TEXT, descendant TEXT, depth INTEGER);
CREATE TABLE meta_data (size INTEGER NOT NULL, mime_type TEXT NOT NULL, duration INTEGER, width INTEGER, height INTEGER, class TEXT NOT NULL, author TEXT, album TEXT, date TEXT, bitrate INTEGER, sample_freq INTEGER, bits_per_sample INTEGER, channels INTEGER, track INTEGER, color_depth INTEGER, object_fk TEXT UNIQUE CONSTRAINT object_fk_id REFERENCES Object(upnp_id) ON DELETE CASCADE, dlna_profile TEXT, genre TEXT);
CREATE TABLE object (parent TEXT CONSTRAINT parent_fk_id REFERENCES Object(upnp_id), upnp_id TEXT PRIMARY KEY, type_fk INTEGER CONSTRAINT type_fk_id REFERENCES Object_Type(id), title TEXT NOT NULL, timestamp INTEGER NOT NULL, uri TEXT, flags TEXT);
CREATE TABLE schema_info (version TEXT NOT NULL);
CREATE INDEX idx_meta_data_fk on meta_data(object_fk);
CREATE INDEX idx_parent on Object(parent);
CREATE TRIGGER trgr_delete_closure AFTER DELETE ON Object FOR EACH ROW BEGIN DELETE FROM Closure WHERE descendant = OLD.upnp_id;END;
CREATE TRIGGER trgr_delete_metadata BEFORE DELETE ON Object FOR EACH ROW BEGIN DELETE FROM meta_data WHERE meta_data.object_fk = OLD.upnp_id; END;
CREATE TRIGGER trgr_delete_uris BEFORE DELETE ON Object FOR EACH ROW BEGIN DELETE FROM Uri WHERE Uri.object_fk = OLD.upnp_id;END;
CREATE TRIGGER trgr_update_closure AFTER INSERT ON Object FOR EACH ROW BEGIN SELECT RAISE(IGNORE) WHERE (SELECT COUNT(*) FROM Closure WHERE ancestor = NEW.upnp_id AND descendant = NEW.upnp_id AND depth = 0) != 0;INSERT INTO Closure (ancestor, descendant, depth) VALUES (NEW.upnp_id, NEW.upnp_id, 0); INSERT INTO Closure (ancestor, descendant, depth) SELECT ancestor, NEW.upnp_id, depth + 1 FROM Closure WHERE descendant = NEW.parent;END;

Attachment: 8-player.PNG
Description: PNG image