<div dir="ltr"><br><br><div class="gmail_quote"><div dir="ltr">On Tue, Nov 13, 2018 at 3:49 AM Jim Abernathy <<a href="mailto:jfabernathy@gmail.com">jfabernathy@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
On 11/12/18 9:33 PM, Stephen Worthington wrote:<br>
> On Mon, 12 Nov 2018 12:58:23 -0500, you wrote:<br>
><br>
>>> On Nov 12, 2018, at 12:50 PM, James Abernathy <<a href="mailto:jfabernathy@gmail.com" target="_blank">jfabernathy@gmail.com</a>> wrote:<br>
>>><br>
>>><br>
>>>> On Nov 12, 2018, at 12:32 PM, Stephen Worthington <<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>> wrote:<br>
>>>><br>
>>>> On Mon, 12 Nov 2018 10:48:22 -0500 (EST), you wrote:<br>
>>>><br>
>>>>>>>> I?m thinking about how to diagnose tuner problems and this info would be helpful.<br>
>>>>> You won't see this in MythWeb, but you can see it in the front end by going to the suspect program and pressing Info twice I believe,<br>
>>>> Yes, it is stored in the "inputname" field in the recorded table. It<br>
>>>> is a relatively recent addition - only available from 0.27? onwards.<br>
>>> Thanks, guys. Found it on the Frontend. This will help in my tuner debug.<br>
>> I meant to ask now that I’ve seen the display that I+I gives you. I see the filename, but not the directory. I have 2 hard drives mounted and both mount points are in my default storage directory setting. This ping-pongs the files to spread the recording load. I know I can find it once I have the filename but it would be nice to know which directory to start on.<br>
>><br>
>> Any changes on that being added?<br>
> No. That would be counter to MythTV's philosophy of storage groups.<br>
> MythTV will find a recording by looking in all the storage groups. You<br>
> can move recordings around as much as you like and they will still be<br>
> found.<br>
><br>
> If you want to quickly find a particular recording, you can do what I<br>
> do, which is to use the mlocate database. Install the mlocate package<br>
> (I think it is installed by default in Ubuntu). That will install an<br>
> "mlocate" command (aliased to "locate") and an "mlocate" job in<br>
> cron.daily that runs the "mlocate.updatedb" command (also aliased to<br>
> "updatedb"). So then you can use the file name from the I+I command,<br>
> or a database query like this:<br>
><br>
> MariaDB [mythconverg]> select<br>
> chanid,starttime,endtime,title,subtitle,basename from recorded where<br>
> title like '%at her m%' order by starttime;<br>
> +--------+---------------------+---------------------+--------------------------+------------------+-------------------------+<br>
> | chanid | starttime | endtime | title | subtitle | basename |<br>
> +--------+---------------------+---------------------+--------------------------+------------------+-------------------------+<br>
> | 10017 | 2018-01-07 07:29:00 | 2018-01-07 08:34:00 | At Her Majesty's Service | England | 10017_20180107072900.ts |<br>
> | 10017 | 2018-01-14 07:29:00 | 2018-01-14 08:34:00 | At Her Majesty's Service | Scotland | 10017_20180114072900.ts |<br>
> | 10017 | 2018-01-21 07:29:00 | 2018-01-21 08:34:00 | At Her Majesty's Service | Northern Ireland | 10017_20180121072900.ts |<br>
> | 10017 | 2018-01-28 07:29:00 | 2018-01-28 08:34:00 | At Her Majesty's Service | Wales | 10017_20180128072900.ts |<br>
> +--------+---------------------+---------------------+--------------------------+------------------+-------------------------+<br>
> 4 rows in set (0.05 sec)<br>
><br>
> and use the basename to find the file:<br>
><br>
> root@mypvr:~# locate 10017_20180128072900.ts<br>
> /home/stephen/.mythtv/cache/remotecache/10017_20180128072900.ts.png<br>
> /home/stephen/.mythtv/cache/themecache/MythCenter-wide-JSW.1920.1080/-home-stephen-.mythtv-cache-remotecache-10017_20180128072900.ts.png--480x360.png<br>
> /home/stephen/.mythtv/cache/themecache/MythCenter-wide-JSW.1920.1080/-mnt-rec4-recordings-10017_20180128072900.ts.png--480x360.png<br>
> /mnt/rec4/recordings/10017_20180128072900.ts<br>
> /mnt/rec4/recordings/10017_20180128072900.ts.png<br>
><br>
> If it is a new recording, done after the daily updatedb run, you can<br>
> run updatedb manually, and wait for it to complete, then do the locate<br>
> command.<br>
><br>
> You could also write a script that just looks for the basename in all<br>
> your recording directories. Since you have only two, it would not<br>
> need to be a complicated script. And if you want that script to have<br>
> the ability to look up the database, I have a script to do that. It<br>
> looks up your config.xml file to get the correct login to the database<br>
> and then runs the "mysql" command. It needs the "xmlstarlet" package.<br>
><br>
> <a href="http://www.jsw.gen.nz/mythtv/do_mythconverg.sh" rel="noreferrer" target="_blank">http://www.jsw.gen.nz/mythtv/do_mythconverg.sh</a><br>
><br>
> You can add that to your script and use the -e option on the mysql<br>
> command to run an SQL command and get back the results for your script<br>
> to use. Then you could get the script to lookup the database and find<br>
> the recording directories, then look in each one for the basenames it<br>
> found from a search query on the recorded table.<br>
<br>
This is very useful. locate is already install on my Ubuntu 18.04 system <br>
and the mlocate daily job already exist. Since I've pushed out the <br>
running on anacron daily jobs to 5:30 am, then all my recordings can be <br>
found this way the next morning. Thanks,<br>
<br>
Jim A<br>
<br>
<br><br></blockquote><div>Sorry for the late post but clicking on the small image from the recording on the left in MythWeb bring up an info sheet that lists the tuner used.</div><div><br></div><div>For example:</div><table id="gmail-x-info" width="100%" border="0" cellspacing="0" cellpadding="0" style="padding:0px;width:45em;margin:10px 0px 10px 10px;background-color:rgb(16,26,41);color:rgb(224,224,255);border:1px solid rgb(144,144,176);font-size:12px"><tbody><tr class="gmail-x-extras"><th style="vertical-align:top;font-weight:normal;text-align:right;padding:0.25em;white-space:nowrap;border-top:1px solid rgb(32,41,51)">Input Name:</th><td style="padding:0.25em;border-top:1px solid rgb(32,41,51)">3: MPEG2TS</td></tr></tbody></table><div><br></div><div>Allen </div></div></div>