<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html>
<head>
<meta name="Generator" content="Kopano WebApp v-5.0.0.223+1986.1">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>RE: [mythtv-users] Transcode script that keeps show in Recordings</title>
</head>
<body>
<p style="padding: 0; margin: 0; min-height: 11pt; font-family: arial,helvetica,sans-serif; font-size: 11pt;"><br /></p>
<p style="padding: 0; margin: 0; min-height: 11pt; font-family: arial,helvetica,sans-serif; font-size: 11pt;"><br /></p>
<blockquote style="border-left-width: 2px; border-left-style: solid; border-left-color: #325fba; padding-left: 5px; margin: 0px 5px 1em;"><span style="font-family: tahoma,arial,helvetica,sans-serif; font-size: 10pt;">-----Original message-----<br /><span><strong>From:</strong> Jay Harbeston <jharbestonus@gmail.com></span><br /><span><strong>Sent:</strong> Tuesday 6th June 2023 17:32</span><br /><span><strong>To:</strong> Discussion about MythTV <mythtv-users@mythtv.org></span><br /><span><strong>Subject:</strong> Re: [mythtv-users] Transcode script that keeps show in Recordings</span><br /><br /></span><br />
<div><br />
<blockquote>
<div>On Jun 6, 2023, at 12:22 PM, James Abernathy <jfabernathy@gmail.com> wrote:</div>
<br class="Apple-interchange-newline" />
<div>
<div dir="ltr">
<div dir="ltr"><br /></div>
<div class="gmail_quote"><span style="font-family: monospace;"><span style="font-weight: bold;">Database changed</span><span> </span><br />MariaDB [mythconverg]> SHOW VARIABLES LIKE "secure_file_priv"; <br />+------------------+-------+ <br />| Variable_name | Value | <br />+------------------+-------+ <br />| secure_file_priv | | <br />+------------------+-------+ <br /><span style="font-weight: bold;">1 row in set (0.001 sec)</span><br /><span> </span><br /></span></div>
<div class="gmail_quote">Looks empty to me.</div>
</div>
</div>
</blockquote>
<br /></div>
<div><br /></div>
<div>I was afraid of that. My attempts to find a solution in mysql failed to find a solution. So much security so little time! :-)</div>
<div><br /></div>
<div>Jay</div>
</blockquote>
<p style="padding: 0; margin: 0; "><br /></p>
<p style="padding: 0; margin: 0; "><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;">This has worked for me in mysql, I presume it would also work for MariaDB:<br /><br /></span></p>
<p style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures;">grant file on *.* to 'mythtv'@'localhost';</span></p>
<p style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures;"><br /></span></p>
<p style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures;">The problem then was that the output file was owned by the mysql user, so I had to add the mysql group to the user that I was using to run ffcut.sh</span></p>
<p style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures;"><br /></span></p>
<p style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures;">Regards,</span></p>
<p style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures;">Dave.</span></p>
</body>
</html>