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

Daryl McDonald darylangela at gmail.com
Thu Jun 6 16:59:24 UTC 2019


On Thu, Jun 6, 2019 at 12:57 PM Daryl McDonald <darylangela at gmail.com>
wrote:

>
>
>
>>
>> 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"
>

 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   |
| MythArchiveDVDLocation | /dev/sr0 | trieli   |
| CDDevice               | /dev/sr0 | trieli   |
+------------------------+----------+----------+
6 rows in set (0.01 sec)

Are lines 1&2 taking presidence over lines 3&5?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20190606/74d873c3/attachment.html>


More information about the mythtv-users mailing list