<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jun 6, 2019 at 12:57 PM Daryl McDonald <<a href="mailto:darylangela@gmail.com">darylangela@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><br><br>
The hostname of 'mythtv' looks a bit suspicious. Do you have a<br>
frontend PC with the hostname 'mythtv'? You appear to be doing the<br>
commands from a PC with the hostname 'trieli', so if the frontend is<br>
on the same PC, I would have expected you to need to change the<br>
settings for hostname 'trieli'.<br></blockquote><div>OK I redid it:</div><div> On Thu, Jun 6, 2019 at 12:48 PM Stephen Worthington <<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>> wrote:</div>On Thu, 6 Jun 2019 12:35:50 -0400, you wrote:<br><br><br>>> You are right, there seems to be a bug there. I just tried it in v30.<br>>> Mine is still set to /dev/sr0, as it has been for many versions of<br>>> MythTV, but when I try to set it to that now using the GUI, it does<br>>> not work. I can not see any sr0 under the /dev folder, and when I<br>>> type in /dev/sr0 and use the up arrow to go directly to the OK button,<br>>> it reverts to /. You should probably file a bug report about this.<br>>><br>>> So you may need to use SQL commands to set it, for now. In my<br>>> database, there are two settings that use /dev/sr0:<br>>><br>>> MariaDB [mythconverg]> select * from settings where data like '%sr0%';<br>>> +------------------------+----------+----------+<br>>> | value | data | hostname |<br>>> +------------------------+----------+----------+<br>>> | MythArchiveDVDLocation | /dev/sr0 | mypvr |<br>>> | DVDDeviceLocation | /dev/sr0 | mypvr |<br>>> +------------------------+----------+----------+<br>>> 2 rows in set (0.00 sec)<br>>><br>>> Your settings will have different hostnames. They are per frontend<br>>> settings, so there can be different values for each frontend hostname.<br>>> If you want to use SQL, this should work:<br>>><br>>> Find the settings you want to change and the correct hostname:<br>>><br>>> sudo mysql<br>>> use mythconverg;<br>>> select * from settings where value='MythArchiveDVDLocation' or<br>>> value='DVDDeviceLocation';<br>>> quit<br>>><br>>> Then in the following, substitute the hostname you found for <your<br>>> hostname> (twice):<br>>><br>>> sudo mysql<br>>> use mythconverg;<br>>> update settings set data='/dev/sr0' where<br>>> value='MythArchiveDVDLocation' and hostname='<your hostname>';<br>>> update settings set data='/dev/sr0' where value='DVDDeviceLocation'<br>>> and hostname='<your hostname>';<br>>> # Check that the updates worked.<br>>> select * from settings where data like '/dev/sr%';<br>>> quit<br>>><br>>I think this went well:<br>>mysql> use mythconverg;<br>>Reading table information for completion of table and column names<br>>You can turn off this feature to get a quicker startup with -A<br>><br>>Database changed<br>>mysql> update settings set data='/dev/sr0' where<br>> -> value='MythArchiveDVDLocation' and hostname='mythtv';<br>>Query OK, 0 rows affected (0.00 sec)<br>>Rows matched: 1 Changed: 0 Warnings: 0<br>><br>>mysql> update settings set data='/dev/sr0' where value='DVDDeviceLocation'<br>> -> and hostname='mythtv';<br>>Query OK, 1 row affected (0.00 sec)<br>>Rows matched: 1 Changed: 1 Warnings: 0<br>><br>>mysql> select * from settings where data like '/dev/sr%';<br>>+------------------------+----------+----------+<br>>| value | data | hostname |<br>>+------------------------+----------+----------+<br>>| MythArchiveDVDLocation | /dev/sr0 | mythtv |<br>>| DVDDeviceLocation | /dev/sr0 | mythtv |<br>>| DVDDeviceLocation | /dev/sr0 | trieli |<br>>| BluRayMountpoint | /dev/sr0 | trieli |<br>>| CDDevice | /dev/sr0 | trieli |<br>>+------------------------+----------+----------+<br>>5 rows in set (0.00 sec)<br>><br>>mysql> quit<br>>Bye<br>>daryl@trieli:/dev$</div><div class="gmail_quote">but still "failed to open device"<br></div></div></blockquote><div><br></div><div> mysql> select * from settings where data like '/dev/sr%';</div>+------------------------+----------+----------+<br>| value | data | hostname |<br>+------------------------+----------+----------+<br>| MythArchiveDVDLocation | /dev/sr0 | mythtv |<br>| DVDDeviceLocation | /dev/sr0 | mythtv |<br>| DVDDeviceLocation | /dev/sr0 | trieli |<br>| BluRayMountpoint | /dev/sr0 | trieli |<br>| MythArchiveDVDLocation | /dev/sr0 | trieli |<br>| CDDevice | /dev/sr0 | trieli |<br>+------------------------+----------+----------+<br>6 rows in set (0.01 sec)<br></div><div class="gmail_quote"><br></div><div class="gmail_quote">Are lines 1&2 taking presidence over lines 3&5?</div></div>