Difference between revisions of "Talk:Configuring MythTV for the HDHomeRun Prime"

From MythTV Official Wiki
Jump to: navigation, search
(Example MySQL statements to add the third tuner: new section)
(Remove discussion related to old 0.24 issue)
 
Line 1: Line 1:
What is the process to edit the tuner number, to get the 3rd tuner configured?
 
  
When adding the tuner by IP in the GUI, the tuner numbers are limited to 0 and 1.  Do I need to edit the DB, and if so, which attribute?
 
:: Looks like all you have to do is edit the tuner number directly... https://github.com/MythTV/mythtv/commit/7c2c24933
 
 
Apparently that change is not in the mythbackend version in the Ubuntu repository, because the only options I have are 0 and 1.  So, I was looking for some more details on the manual override process.
 
 
:: Add the Mythbuntu PPA and update to current .24-fixes so that you will have an up to date version-- you *definitely* don't want to be using the version you have with the HDHomeRun Prime.  If you can't edit the tuner numbers, you will have recording failures due to missing other critical fixes.
 
 
Thanks for the help.  I was using Ubuntu server, so I added the Mythbuntu PPA and moved to the newer version.    It allows me to add the 3rd tuner, and will hopefully also address the recording failures I have been seeing since upgrading.  I'm sure you saved me some headaches..  Thanks!
 
 
== Example MySQL statements to add the third tuner ==
 
 
Here's how I added the third tuner to 0.24 fixes after adding the first 2 by device ID in mythtv-setup. I'm assuming the device ID's for all Primes start with '13.' The display name for my Prime is hdhr3.
 
 
1) Find the cardid for the second tuner.
 
<pre>
 
mysql> select cardid, videodevice from capturecard where videodevice like '13%' order by cardid;
 
+--------+-------------+
 
| cardid | videodevice |
 
+--------+-------------+
 
|    42 | 13xxxxxx-0  |
 
|    44 | 13xxxxxx-1  |
 
+--------+-------------+
 
</pre>
 
 
Note the cardid for the second tuner.
 
 
2) Copy the capturecard row for the second tuner to a temporary table.
 
<pre>
 
mysql> create table foo as select * from capturecard where cardid = 44;
 
</pre>
 
3) Update the new row. My first two tuners used even numbers, so I used the next even number for the third tuner.
 
<pre>
 
mysql> update foo set cardid = 46, videodevice = 13xxxxxx-2;
 
</pre>
 
4) Add the new row to the capturecard table.
 
<pre>
 
mysql> insert into capturecard select * from foo;
 
mysql> drop table foo;
 
</pre>
 
5) At this point, we've defined the capture card, but it doesn't have a video source associated with it.
 
You could chicken out and use mythtv-setup, or continue with MySQL...
 
<pre>
 
mysql> create table foo select * from cardinput where cardid = 44;
 
mysql> update foo set cardinputid = NULL, cardid = 46, displayname = 'hdhr3-2';
 
mysql> insert into cardinput select * from foo;
 
mysql> drop table foo;
 
</pre>
 
Fini!
 

Latest revision as of 14:05, 13 March 2016