<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 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:1px solid 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:1px solid 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>
> <br>
> <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>
> <br>
> Not sure how I replace the --login-path=local with mysql -u root -p. <br>
> <br>
> I tried just putting in mysql -u root -p but that didn't work. When I tried putting in <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><br>mythdir=/srv/mythtv/recordings chanid=10501 starttimeutc=20230604223000 <br>query = select basename from recorded where chanid = 10501 and starttime = '20230604223000';
<br>Basename = <br>process the file for infile: /srv/mythtv/recordings/: 10501 20230604223000
<br>
<br>query1 = select data , type from recordedmarkup where chanid = '10501' and starttime = '202306
<br>04223000' and ( type = 34 or type = 32 ) into outfile '/tmp/myth6544/queryres' FIELDS TERM
<br>INATED BY '\t' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
<br>/tmp/myth6544/queryres contents for framerate/framecount: <br>------------------------------
<br>------------------------------
<br>framerate = /srv/mythtv/recordings
<br>maxframes = 10501
<br>select mark , type from recordedmarkup where chanid = '10501' and starttime = '20230604223000' and (
<br> type = 0 or type = 1 ) order by mark asc into outfile '/tmp/myth6544/queryres' FIELDS TERMINATED BY
<br> '\t' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
<br>/tmp/myth6544/queryres contents for cutlist:
<br>------------------------------
<br>------------------------------
<br> There are /srv/mythtv/recordings records for infile
<br>counter=3
<br>counter=3
<br>mark = /srv/mythtv/recordings ; type = 10501
<br>counter=1
<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
<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>