-----Original message-----
From: Jay Harbeston <jharbestonus@gmail.com>
Sent: Tuesday 6th June 2023 17:32
To: Discussion about MythTV <mythtv-users@mythtv.org>
Subject: Re: [mythtv-users] Transcode script that keeps show in Recordings
On Jun 6, 2023, at 12:22 PM, James Abernathy <jfabernathy@gmail.com> wrote:
Database changed
MariaDB [mythconverg]> SHOW VARIABLES LIKE "secure_file_priv";
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| secure_file_priv | |
+------------------+-------+
1 row in set (0.001 sec)
Looks empty to me.
I was afraid of that. My attempts to find a solution in mysql failed to find a solution. So much security so little time! :-)
Jay
This has worked for me in mysql, I presume it would also work for MariaDB:
grant file on *.* to 'mythtv'@'localhost';
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
Regards,
Dave.
From: Jay Harbeston <jharbestonus@gmail.com>
Sent: Tuesday 6th June 2023 17:32
To: Discussion about MythTV <mythtv-users@mythtv.org>
Subject: Re: [mythtv-users] Transcode script that keeps show in Recordings
On Jun 6, 2023, at 12:22 PM, James Abernathy <jfabernathy@gmail.com> wrote:
Database changed
MariaDB [mythconverg]> SHOW VARIABLES LIKE "secure_file_priv";
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| secure_file_priv | |
+------------------+-------+
1 row in set (0.001 sec)
Looks empty to me.
I was afraid of that. My attempts to find a solution in mysql failed to find a solution. So much security so little time! :-)
Jay
This has worked for me in mysql, I presume it would also work for MariaDB:
grant file on *.* to 'mythtv'@'localhost';
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
Regards,
Dave.