[mythtv] Trouble playing back recordings from remote frontend

Kevin Kuphal kuphal at dls.net
Thu Oct 4 01:26:51 UTC 2007


On 10/3/07, Joe Doucette <doucej at gmail.com> wrote:
>
> Hi folks,
>
> I'm running into a bit of an odd problem with SVN myth. I find I can't
> play back any recordings from on my remote frontend. The preview videos in
> the media library all play fine, but fail when I actually try to watch them.
> I'm also able to watch live tv fine. I'm running the frontend on yellow dog
> linux on a ps3. The relevant error message is "GetRecordBasename found no
> entry", hinting towards some sort of db problem.
>
> Asking google yields a suggestion that perhaps perl-crypt-ssleay isn't
> installed. In fact, it wasn't installed. I added that in (and recompiled
> myth for good measure) to no avail. I seem to be able to talk to the backend
> okay because live and preview works fine, so this one's kinda puzzling.
>
> A few log messages with -v database enabled on the frontend:
>
> 2007-10-03 18:59:17.690 MSqlQuery: SELECT data FROM settings WHERE value =
> 'GuiH
> eight' AND hostname IS NULL;
> 2007-10-03 18:59:17.939 MSqlQuery: SELECT data FROM settings WHERE value =
> 'Reco
> rdOverTime' AND hostname = 'talkie.kryten.yi.org' ;
> 2007-10-03 18:59:17.940 MSqlQuery: SELECT data FROM settings WHERE value =
> 'Reco
> rdOverTime' AND hostname IS NULL;
> 2007-10-03 18:59:17.968 TV: Attempting to change from None to
> WatchingPreRecorde
> d
> 2007-10-03 18:59:18.066 MSqlQuery: SELECT basename FROM recorded WHERE
> chanid =
> '1039' AND       starttime = '2007-10-03T17:30:00';
> 2007-10-03 18:59:18.067 GetRecordBasename found no entry
> 2007-10-03 18:59:18.069 MSqlQuery: SELECT DISTINCT dirname FROM
> storagegroup WHE
> RE groupname = 'Default'
> 2007-10-03 18:59:18.090 MSqlQuery: SELECT name, skipahead FROM playgroup
> WHERE (
> name = 'Default' OR name = 'Default')       AND skipahead <> 0 ORDER BY
> name = '
> Default';
> 2007-10-03 18:59:18.091 MSqlQuery: SELECT name, skipback FROM playgroup
> WHERE (n
> ame = 'Default' OR name = 'Default')       AND skipback <> 0 ORDER BY name
> = 'De
> fault';
> 2007-10-03 18:59:18.092 MSqlQuery: SELECT name, jump FROM playgroup WHERE
> (name
> = 'Default' OR name = 'Default')       AND jump <> 0 ORDER BY name =
> 'Default';
> 2007-10-03 18:59: 18.093 MSqlQuery: SELECT name, timestretch FROM
> playgroup WHERE
>  (name = 'Default' OR name = 'Default')       AND timestretch <> 0 ORDER
> BY name
>  = 'Default';
> 2007-10-03 18:59:24.575 RingBuf(/mnt/store/): Invalid file (fd -1) when
> opening
> '/mnt/store/'.
> 2007-10-03 18:59:24.681 MSqlQuery: SELECT recgroup, password FROM
> recgrouppasswo
> rd WHERE password is not null AND password <> '' ;
> 2007-10-03 18:59:24.742 MSqlQuery: SELECT recordid, type, maxepisodes,
> avg_delay
> , next_record, last_record, last_delete FROM record;
> 2007-10-03 18:59:25.759 RingBuf(/mnt/store/): Invalid file (fd -1) when
> opening
> '/mnt/store/'.
> 2007-10-03 18:59:24.681 MSqlQuery: SELECT recgroup, password FROM
> recgrouppasswo
> rd WHERE password is not null AND password <> '' ;
> 2007-10-03 18:59:24.742 MSqlQuery: SELECT recordid, type, maxepisodes,
> avg_delay
> , next_record, last_record, last_delete FROM record;
> 2007-10-03 18:59:25.759 RingBuf(/mnt/store/): Invalid file (fd -1) when
> opening
> '/mnt/store/'.
> 2007-10-03 18:59:25.759 PlaybackBox Error: Could not open file for preview
> video
> .
> 2007-10-03 18:59:25.821 MSqlQuery: SELECT icon FROM channel WHERE chanid =
> '1039
> ' ;
>
> ...
>
> Any thoughts/suggestions would be greatly appreciated..


What happens if you manually execute the SQL against the DB from either the
command-line or something like phpmyadmin?

SELECT basename FROM recorded WHERE chanid = '1039' AND       starttime =
'2007-10-03T17:30:00';

Kevin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-dev/attachments/20071003/ad775abd/attachment.htm 


More information about the mythtv-dev mailing list