<!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>
<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> Mike Perkins <mikep@randomtraveller.org.uk></span><br /><span><strong>Sent:</strong> Thursday 8th June 2023 12:52</span><br /><span><strong>To:</strong> mythtv-users@mythtv.org</span><br /><span><strong>Subject:</strong> Re: [mythtv-users] Transcode script that keeps show in Recordings</span><br /><br /></span>
<div>
<pre style="white-space: pre-wrap; word-wrap: break-word;">On 08/06/2023 12:45, James Abernathy wrote:<br />> On Wed, Jun 7, 2023 at 7:21 PM Jay Harbeston <jharbestonus@gmail.com> wrote:<br />> <br />>><br />>><br />>> On Jun 7, 2023, at 7:13 PM, James <jam@tigger.ws> wrote:<br />>><br />>><br />>><br />>> On 8 Jun 2023, at 7:08 am, Jay Harbeston <jharbestonus@gmail.com> wrote:<br />>><br />>><br />>><br />>> I have created a python version of ffcut.sh and am currently making sure I<br />>> have most of the kinks out of it.<br />>><br />>> I'm thinking tomorrow I should be able to post the python version the same<br />>> way as I did the shell version.<br />>><br />>> With the python version I did not have to create the text files as<br />>> intermediary holding arrays for data that needed to be used.<br />>><br />>> It will require python version 3+.<br />>><br />>> jamesWhen I created it originally, mythtranscode would not handle mp4<br />>> streams that we were getting from the HDHRs when silicon dust did the 4 or<br />>> so month experiment of being a content provider from the cloud. The ffmpeg<br />>> version ffcut.sh and soon the ffcut.py version will be able to handle both<br />>> mp4 and mpeg 2 transport streams.<br />>><br />>><br />> I'd be interested in looking at the python script also.<br />> <br />> BTW, I did get ffcut working for me to a point. I have to may the mysql<br />> commands look like this if password was 1234<br />> sudo mysql -u root -p1234<br />> <br />> That works from the console, but not sure what will happen in a UserJob<br />> when it encounters a sudo?<br />> <br />As I recall you can put something in the sudoers file for specific jobs and/or specific users, such <br />that you wouldn't require a password for that combination. If that wasn't so, half of unix wouldn't run.<br /><br />-- <br /><br />Mike Perkins<br /><br /><br />_______________________________________________<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</pre>
</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;">Mike,<br /></span></p>
<p style="padding: 0; margin: 0; "><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;"><br /></span></p>
<p style="padding: 0; margin: 0; "><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;">I modified Jay's script so that it uses the /etc/mythtv/config.xml file to get the user credentials:</span></p>
<p style="padding: 0; margin: 0; "><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;"><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; color: #aaab25;"><span style="font-variant-ligatures: no-common-ligatures; color: #000000;">confxml</span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">=</span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"/etc/mythtv/config.xml"</strong></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; color: #aaab25;"><span style="font-variant-ligatures: no-common-ligatures; color: #000000;">hostname</span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">=`</span><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>grep</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"<Host"</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #ca3323;"><strong>$confxml</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">|</span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>sed</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #db27da;"><strong> -e</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"s;</.*>;;"</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">|</span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>sed</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #db27da;"><strong> -e</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"s;<.*>;;"</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">|</span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>sed</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #db27da;"><strong> -e</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"s/ *//g"</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">`</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; color: #aaab25;"><span style="font-variant-ligatures: no-common-ligatures; color: #000000;">username</span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">=`</span><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>grep</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"UserName"</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #ca3323;"><strong>$confxml</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">|</span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>sed</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #db27da;"><strong> -e</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"s;</.*>;;"</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">|</span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>sed</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #db27da;"><strong> -e</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"s;<.*>;;"</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">|</span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>sed</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #db27da;"><strong> -e</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"s/ *//g"</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">`</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; color: #aaab25;"><span style="font-variant-ligatures: no-common-ligatures; color: #000000;">passwd</span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">=`</span><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>grep</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"Password"</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #ca3323;"><strong>$confxml</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">|</span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>sed</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #db27da;"><strong> -e</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"s;</.*>;;"</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">|</span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>sed</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #db27da;"><strong> -e</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"s;<.*>;;"</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">|</span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>sed</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #db27da;"><strong> -e</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"s/ *//g"</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">`</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; color: #aaab25;"><span style="font-variant-ligatures: no-common-ligatures; color: #000000;">dbname</span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">=`</span><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>grep</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"DatabaseName"</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #ca3323;"><strong>$confxml</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">|</span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>sed</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #db27da;"><strong> -e</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"s;</.*>;;"</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">|</span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>sed</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #db27da;"><strong> -e</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"s;<.*>;;"</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">|</span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>sed</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #db27da;"><strong> -e</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"s/ *//g"</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">`</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; min-height: 13px;"><br /></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; color: #aaab25;"><span style="font-variant-ligatures: no-common-ligatures; color: #000000;">usercreds</span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">=</span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"-h$hostname -u$username -p$passwd $dbname"</strong></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; color: #aaab25;"><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>echo</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"User Credentials = "</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #ca3323;"><strong>$usercreds</strong></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; min-height: 13px;"><br /></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; min-height: 13px;"><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;"><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; min-height: 13px;"><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;">Then I modified the sql query lines to use this info, such that the first query is:<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; color: #aaab25;"><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>echo</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"mythdir=$mythdir chanid=$chanid starttimeutc=$starttimeutc "</strong></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; color: #aaab25;"><span style="font-variant-ligatures: no-common-ligatures; color: #000000;">query0</span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">=</span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"select basename from recorded where chanid = $chanid and starttime = '$starttimeutc';"</strong></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; min-height: 13px;"><br /></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; color: #aaab25;"><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>echo</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"query = $query0"</strong></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; min-height: 13px;"><br /></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;">basename</span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">=`</span><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>echo</strong></span><span style="font-variant-ligatures: no-common-ligatures;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #aaab25;"><strong>"$query0;"</strong></span><span style="font-variant-ligatures: no-common-ligatures;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">|</span><span style="font-variant-ligatures: no-common-ligatures;"> mysql</span><span style="font-variant-ligatures: no-common-ligatures; color: #db27da;"><strong> -N</strong></span><span style="font-variant-ligatures: no-common-ligatures;"> </span><span style="font-variant-ligatures: no-common-ligatures; color: #ca3323;"><strong>$usercreds</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #39c026;">`</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; min-height: 13px;"><br /></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; color: #aaab25;"><span style="font-variant-ligatures: no-common-ligatures; color: #5620f4;"><strong>echo</strong></span><span style="font-variant-ligatures: no-common-ligatures; color: #000000;"> </span><span style="font-variant-ligatures: no-common-ligatures;"><strong>"Basename = $basename"</strong></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; min-height: 13px;"><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;"><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; min-height: 13px;"><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;">By modifying it in this way, I do not need to use sudo, so long as I enable file privileges for the mysql user, as per an earlier email from me.</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; min-height: 13px;"><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;"><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; min-height: 13px;"><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;">Obviously, I should really stop echoing the $usercreds variable :-) </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; min-height: 13px;"><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;"><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; min-height: 13px;"><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;">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; min-height: 13px;"><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;">Dave</span></p>
<p style="padding: 0; margin: 0; "><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;"><br /></span></p>
<blockquote style="border-left-width: 2px; border-left-style: solid; border-left-color: #325fba; padding-left: 5px; margin: 1em 5px 0px;">
<div>
<pre style="white-space: pre-wrap; word-wrap: break-word;"><br /></pre>
</div>
</blockquote>
</body>
</html>