[mythtv-users] DVD/Blu-Ray set-up
Daryl McDonald
darylangela at gmail.com
Thu Jun 6 16:57:12 UTC 2019
>
> 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>
More information about the mythtv-users
mailing list