[mythtv-users] DVD/Blu-Ray set-up

[Daryl McDonald]

>
> The hostname of 'mythtv' looks a bit suspicious.  Do you have a
> frontend PC with the hostname 'mythtv'?  You appear to be doing the
> commands from a PC with the hostname 'trieli', so if the frontend is
> on the same PC, I would have expected you to need to change the
> settings for hostname 'trieli'.
>
OK I redid it:
 On Thu, Jun 6, 2019 at 12:48 PM Stephen Worthington <
stephen_agent at jsw.gen.nz> wrote:
On Thu, 6 Jun 2019 12:35:50 -0400, you wrote:


>> You are right, there seems to be a bug there.  I just tried it in v30.
>> Mine is still set to /dev/sr0, as it has been for many versions of
>> MythTV, but when I try to set it to that now using the GUI, it does
>> not work.  I can not see any sr0 under the /dev folder, and when I
>> type in /dev/sr0 and use the up arrow to go directly to the OK button,
>> it reverts to /.  You should probably file a bug report about this.
>>
>> So you may need to use SQL commands to set it, for now.  In my
>> database, there are two settings that use /dev/sr0:
>>
>> MariaDB [mythconverg]> select * from settings where data like '%sr0%';
>> +------------------------+----------+----------+
>> | value                  | data     | hostname |
>> +------------------------+----------+----------+
>> | MythArchiveDVDLocation | /dev/sr0 | mypvr    |
>> | DVDDeviceLocation      | /dev/sr0 | mypvr    |
>> +------------------------+----------+----------+
>> 2 rows in set (0.00 sec)
>>
>> Your settings will have different hostnames.  They are per frontend
>> settings, so there can be different values for each frontend hostname.
>> If you want to use SQL, this should work:
>>
>> Find the settings you want to change and the correct hostname:
>>
>> sudo mysql
>> use mythconverg;
>> select * from settings where value='MythArchiveDVDLocation' or
>> value='DVDDeviceLocation';
>> quit
>>
>> Then in the following, substitute the hostname you found for <your
>> hostname> (twice):
>>
>> sudo mysql
>> use mythconverg;
>> update settings set data='/dev/sr0' where
>> value='MythArchiveDVDLocation' and hostname='<your hostname>';
>> update settings set data='/dev/sr0' where value='DVDDeviceLocation'
>> and hostname='<your hostname>';
>> # Check that the updates worked.
>> select * from settings where data like '/dev/sr%';
>> quit
>>
>I think this went well:
>mysql> use mythconverg;
>Reading table information for completion of table and column names
>You can turn off this feature to get a quicker startup with -A
>
>Database changed
>mysql> update settings set data='/dev/sr0' where
>    -> value='MythArchiveDVDLocation' and hostname='mythtv';
>Query OK, 0 rows affected (0.00 sec)
>Rows matched: 1  Changed: 0  Warnings: 0
>
>mysql> update settings set data='/dev/sr0' where value='DVDDeviceLocation'
>    -> and hostname='mythtv';
>Query OK, 1 row affected (0.00 sec)
>Rows matched: 1  Changed: 1  Warnings: 0
>
>mysql> select * from settings where data like '/dev/sr%';
>+------------------------+----------+----------+
>| value                  | data     | hostname |
>+------------------------+----------+----------+
>| MythArchiveDVDLocation | /dev/sr0 | mythtv   |
>| DVDDeviceLocation      | /dev/sr0 | mythtv   |
>| DVDDeviceLocation      | /dev/sr0 | trieli   |
>| BluRayMountpoint       | /dev/sr0 | trieli   |
>| CDDevice               | /dev/sr0 | trieli   |
>+------------------------+----------+----------+
>5 rows in set (0.00 sec)
>
>mysql> quit
>Bye
>daryl at trieli:/dev$
but still "failed to open device"

>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20190606/d93d8ac9/attachment.html>