FAQ  •  Register  •  Login

Find out what I watch/access derby DB [SOLVED]

<<

AlecTBM

Serviio newbie

Posts: 6

Joined: Sun Jun 19, 2011 5:17 pm

Post Sun Mar 10, 2013 7:42 pm

Find out what I watch/access derby DB [SOLVED]

Hey
I have an custom buildt tv episode system that use Serviio as DLNA server.
I want to register when I start watching a item via Serviio, and register that item in my own system as watched.
How to find out when I watch a item was no problem (sending the the debug log to the syslog port, and then make a script that listen to port 415 and parse the data)
My problem is too find out what I am watching.
Ex. I watch an episode, and I get in the log that I am watching MEDIA_ITEM 100, not the filename of the file.
I was thinking to connect to the derby database, but I have noe idea how to do it automatic. Any tips?
Running Debian Testing without GUI.

Thanks for any help.

PS.
Perhaps you guys have an better way of doing this, but I found sniffing the log to be the easiest.
Last edited by AlecTBM on Sun Mar 10, 2013 8:09 pm, edited 1 time in total.
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17215

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Sun Mar 10, 2013 7:48 pm

Re: Find out what I watch/access derby DB

you can connect to derby using their sql client and look up the file name from media_item table (by id, e.g. 100 in your case)
<<

AlecTBM

Serviio newbie

Posts: 6

Joined: Sun Jun 19, 2011 5:17 pm

Post Sun Mar 10, 2013 8:09 pm

Re: Find out what I watch/access derby DB

Thank you.
Just cracked it. Always fun to use the wrong software. Some hours down the drain because of that.

Return to Serviio Support & Help

Who is online

Users browsing this forum: Google [Bot] and 28 guests

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by ST Software for PTF.