<div dir="ltr">All is well now, slightly unconventionally, a previous iteration of Ubuntu on this dual boot OS drive restored and renamed just fine. json setup went well too. Thanks to all contributors. Daryl</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Sep 26, 2023 at 11:14 AM Mike Perkins <<a href="mailto:mikep@randomtraveller.org.uk">mikep@randomtraveller.org.uk</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">On 26/09/2023 13:43, Daryl McDonald wrote:<br>
> On Sat, Sep 23, 2023 at 12:45 PM Stephen Worthington <<br>
> <a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>> wrote:<br>
> <br>
>> On Sat, 23 Sep 2023 12:42:13 -0400, you wrote:<br>
>><br>
>>> On Sat, Sep 23, 2023 at 12:24?PM Stephen Worthington <<br>
>>> <a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>> wrote:<br>
>>><br>
>>>> On Sat, 23 Sep 2023 11:17:45 -0400, you wrote:<br>
>>>><br>
>>>>> On Sat, Sep 23, 2023 at 11:04?AM Hika van den Hoven <<a href="mailto:hikavdh@gmail.com" target="_blank">hikavdh@gmail.com</a><br>
>>><br>
>>>>> wrote:<br>
>>>>><br>
>>>>>> Hoi Daryl,<br>
>>>>>><br>
>>>>>> Saturday, September 23, 2023, 3:22:59 PM, you wrote:<br>
>>>>>><br>
>>>>>>> Experimentally, I tried using a RPi4 as a master BE with EIT<br>
>>>>>>> program data, on 24/7 to get the best data possible. That didn't<br>
>>>>>>> work so well so, as the subject indicates, I want my previous setup<br>
>>>>>>> back. I renewed my SD subscription and started with the "XMLTV -<br>
>>>>>>> MythTV Official" wiki. I did the xmltv install, but get nothing<br>
>> when<br>
>>>>>>> I run "mythtv-setup" as mythtv. If I turn the RPi off I can't<br>
>>>>>>> connect to the database. Do I need to restore a database to the<br>
>>>>>>> Lenovo in order to proceed with the wiki?<br>
>>>>>>> TIA Daryl<br>
>>>>>><br>
>>>>>> Am I right to assume your database is on the rpi?<br>
>>>>>><br>
>>>>> Yes, it is currently the Master BE<br>
>>>>><br>
>>>>>> The database does not have to be on the machine running the<br>
>>>>>> master backend, but it MUST be up and running to use mythtv.<br>
>>>>>> So, if the db is on the rpi and you want to take the rpi out of<br>
>>>>>> commission, you will have to move the database and change the<br>
>> settings<br>
>>>>>> on all back and frontends accordingly.<br>
>>>>>><br>
>>>>><br>
>>>>> The RPi is called "trieli" and the Lenovo is called "daryl".<br>
>>>>> I've created a new database backup from the RPi (host name trieli) so<br>
>> I'll<br>
>>>>> need to change Lenove's hostname from daryl to trieli to be able to:<br>
>> drop,<br>
>>>>> create, and restore this new db?<br>
>>>>><br>
>>>>> Or can I move the database from the master (RPi) to the slave (Lenovo)<br>
>> and<br>
>>>>> then configure the Lenovo to be the master?<br>
>>>>><br>
>>>>> TIA Daryl<br>
>>>><br>
>>>> The <a href="http://mythconverg_restore.pl" rel="noreferrer" target="_blank">mythconverg_restore.pl</a> program has an option to change the<br>
>>>> hostname in the database - use the --help option to see it. So you<br>
>>>> can restore a database on a machine with a different hostname, then<br>
>>>> use that command to change the hostname in the database to match the<br>
>>>> machine's hostname.<br>
>>>><br>
>>> So, to make sure I understand this. restoring the RPi's database backup<br>
>>> onto the Lenovo, WILL restore and leave me with a mis-match of hostnames:<br>
>>> database to machine (Lenovo) which can be corrected / matched by using the<br>
>>> command in the <a href="http://mythconverg_restore.pl" rel="noreferrer" target="_blank">mythconverg_restore.pl</a> --help. Then off to the XMLTV wiki?<br>
>>> Thanks again! Daryl<br>
>><br>
>> Yes.<br>
> With both backends running the db drop, create, and restore went ahead<br>
> fine, then when the RPi is shutdown the Lenovo can't connect to the<br>
> database. With only the Lenovo running the restore (etal) fails because it<br>
> can"t connect to the database. Is there a way to move the database from the<br>
> RPi to the Lenovo? The wiki at "<br>
> <a href="https://www.mythtv.org/wiki/Backend_migration" rel="noreferrer" target="_blank">https://www.mythtv.org/wiki/Backend_migration</a>" seems not to apply because<br>
> this would be retiring a master and promoting a slave to master,rather than<br>
> bringing a database from an unrelated system.<br>
> <br>
> Maybe just this bit below? : (storage directories are setup on both boxes<br>
> and recordings are prioritized to occur on the Lenovo)<br>
> <br>
> mysql -umythtv -p mythconverg -e "UPDATE recorded SET hostname =<br>
> 'new_daryl' WHERE hostname = 'old_trieli';"<br>
> <br>
The only way the Lenovo backend restore could be failing to find the database is if the database <br>
credentials still point to the RPi (or are wrong, eg have a typo).<br>
<br>
The restore script uses a config file called backuprc which should be either in ~/.mythtv or <br>
/etc/mythtv.<br>
<br>
Have a look at those and make sure that they point to the Lenovo and give the correct password.<br>
<br>
It occurs to me that, if the hostname is wrong, you could still be restoring to the RPi! Once you <br>
have backed up the RPi database, turn off the RPI and leave it off. Having two masters on the same <br>
network can only lead to conflict.<br>
<br>
-- <br>
<br>
Mike Perkins<br>
<br>
<br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
</blockquote></div>