<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><br><div><br><blockquote type="cite"><div>On Jun 5, 2023, at 9:35 PM, James Abernathy <jfabernathy@gmail.com> wrote:</div><br class="Apple-interchange-newline"><div><meta charset="UTF-8"><div dir="ltr" style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><br class="Apple-interchange-newline"><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Jun 5, 2023 at 6:38 PM Jay Harbeston <<a href="mailto:jharbestonus@gmail.com">jharbestonus@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding-left: 1ex;"><div><br><div><br><blockquote type="cite"><div>On Jun 5, 2023, at 4:23 PM, James Abernathy <<a href="mailto:jfabernathy@gmail.com" target="_blank">jfabernathy@gmail.com</a>> wrote:</div><br><div><div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Jun 5, 2023 at 3:58 PM Jay Harbeston <<a href="mailto:jharbestonus@gmail.com" target="_blank">jharbestonus@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding-left: 1ex;"><br><br>> On Jun 5, 2023, at 3:08 PM, James Abernathy <<a href="mailto:jfabernathy@gmail.com" target="_blank">jfabernathy@gmail.com</a>> wrote:<br>><span class="Apple-converted-space"> </span><br>><span class="Apple-converted-space"> </span><br>> sudo mysql -u root -p [return]<br>> then I'm asked for my sudo password. Sometimes I get another password request and I enter the same sudo password.<br>><span class="Apple-converted-space"> </span><br>> Not sure how I replace the --login-path=local with mysql -u root -p.<span class="Apple-converted-space"> </span><br>><span class="Apple-converted-space"> </span><br>> I tried just putting in mysql -u root -p but that didn't work. When I tried putting in<span class="Apple-converted-space"> </span><br>> mysql -u root -p 1234<br>> assuming 1234 was my sudo password. They failed filling up the ffcut.log with mysql --help stuff,<br><br>If the mythtv user is set up to login using the standard auth, you may not need the -u and -p arguments as it relies on the login already authenticating the mythtv user. You would want to just remove that info and run the ffcut as the mythtv user.<br><br>Jay<br><br></blockquote><div><br></div><div>I removed all the -u root -p stuff and still fails. in the fftotal.log the last line is</div><div> <span style="font-family: monospace;">/tmp/myth6544/filelist.txt: No such file or directory</span></div><span style="font-family: monospace;"><br></span></div><div class="gmail_quote"><span style="font-family: monospace;">The ffcut.log shows</span></div><div class="gmail_quote"><span style="font-family: monospace;"><br></span></div><div class="gmail_quote"><span style="font-family: monospace;"><span>Mon Jun 5 04:14:34 PM EDT 2023<span class="Apple-converted-space"> </span></span><br>mythdir=/srv/mythtv/recordings chanid=10501 starttimeutc=20230604223000 <br>query = select basename from recorded where chanid = 10501 and starttime = '20230604223000';<span class="Apple-converted-space"> </span><br>Basename = <br>process the file for infile: /srv/mythtv/recordings/: 10501 20230604223000<span class="Apple-converted-space"> </span><br><br>query1 = select data , type from recordedmarkup where chanid = '10501' and starttime = '202306<span class="Apple-converted-space"> </span><br>04223000' and ( type = 34 or type = 32 ) into outfile '/tmp/myth6544/queryres' FIELDS TERM<span class="Apple-converted-space"> </span><br>INATED BY '\t' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';<span class="Apple-converted-space"> </span><br>/tmp/myth6544/queryres contents for framerate/framecount: <br>------------------------------<span class="Apple-converted-space"> </span><br>------------------------------<span class="Apple-converted-space"> </span><br>framerate = /srv/mythtv/recordings<span class="Apple-converted-space"> </span><br>maxframes = 10501<span class="Apple-converted-space"> </span><br>select mark , type from recordedmarkup where chanid = '10501' and starttime = '20230604223000' and (<span class="Apple-converted-space"> </span><br>type = 0 or type = 1 ) order by mark asc into outfile '/tmp/myth6544/queryres' FIELDS TERMINATED BY<span class="Apple-converted-space"> </span><br>'\t' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';<span class="Apple-converted-space"> </span><br>/tmp/myth6544/queryres contents for cutlist:<span class="Apple-converted-space"> </span><br>------------------------------<span class="Apple-converted-space"> </span><br>------------------------------<span class="Apple-converted-space"> </span><br>There are /srv/mythtv/recordings records for infile<span class="Apple-converted-space"> </span><br>counter=3<span class="Apple-converted-space"> </span><br>counter=3<span class="Apple-converted-space"> </span><br>mark = /srv/mythtv/recordings ; type = 10501<span class="Apple-converted-space"> </span><br>counter=1<span class="Apple-converted-space"> </span><br>mark = 20230604223000 ; type = <br></span></div></div></div></blockquote><div><br></div><div>There’s something wrong in the line above, the type should not be blank. Look at the record involved using phpmyadmin.. there may be a problem with that cut.</div><div><br></div><br><blockquote type="cite"><div><div dir="ltr"><div class="gmail_quote"><span style="font-family: monospace;">ffmpeg -f concat -safe 0 -i /tmp/myth6544/filelist.txt -c copy /tmp/myth6544/tmpfile.ts<span class="Apple-converted-space"> </span><br>Conversion did not occur correctly<br></span></div></div></div></blockquote></div></div></blockquote><div><br></div><div>I have 3 recordings on this test system and I used mythfrontend to correct the cutlist after commercial flagging was completed. I 2 with the same basic errors you saw with the type = [blank] on the last mark statement. Not sure on what to look for in the database, but I have phpmyadmin up and running on mythconverg.</div><div><br></div><div>I did try to do a lossless copy using mythtranscode with --honorcutlist and it fails with a fair number of bad file descriptors. Not sure what that is all about. The recordings look perfect in mythfronted when you watch them. No visual errors. All this is the latest Master that I updated to today.</div><div><br></div><div>Jim A</div><div><br></div></div></div><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;">____</span></div></blockquote><br></div><div><br></div><div>I am looking at it now. Looks like mysql cmd line output has changed on me since I last used this shell script. Of note, make sure you also have ffmpeg installed as well as that is what is used to cut/copy the segments as well as ‘glue’ them back together.</div><div><br></div><div>Jay</div><div><br></div><br></body></html>