<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 4:23 PM, James Abernathy <jfabernathy@gmail.com> wrote:</div><br class="Apple-interchange-newline"><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">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 style="">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>
<br></span></div></div>
_______________________________________________<br>mythtv-users mailing list<br>mythtv-users@mythtv.org<br>http://lists.mythtv.org/mailman/listinfo/mythtv-users<br>http://wiki.mythtv.org/Mailing_List_etiquette<br>MythTV Forums: https://forum.mythtv.org<br></div></blockquote></div><br></body></html>