<html><head></head><body><span class="viv-signature"></span>On Thursday 16 March 2023 10:53:03 AM (-05:00), James Abernathy wrote:<br><br><blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex"><div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Mar 16, 2023 at 10:38 AM Bill Meek <<a href="mailto:keemllib@gmail.com">keemllib@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="padding-left:1ex;border-left-color:rgb(204, 204, 204);border-left-style:solid;border-left-width:1px;margin-left:0.8ex;margin-bottom:0px;margin-right:0px;margin-top:0px;"><div><span></span><br><br>On
Thursday 16 March 2023 10:14:55 AM (-05:00), James Abernathy
wrote:<br><br><blockquote style="padding-left:1ex;border-left-color:rgb(0, 0, 255);border-left-style:solid;border-left-width:2px;margin-left:0px;margin-bottom:0.8ex;margin-right:0px;margin-top:0px;"><div dir="ltr"><div dir="ltr">I think I had
the process correct. But I have a question about mythconverg
passwords.<div><br></div><div>Does the restore process change the
/etc/mythtv/config.xml password or does it change the database to the
password created on the new backend?</div><div><br></div><div>What I did
was install Ubuntu 22.10 desktop on the RPI4 with the same hostname as on
the old failed mythtv-backend, then added the mythbuntu repository for
fixes/33. Next I installed mariadb-server and then mythtv. Once that
was completed I ran mythtv-setup and added my user 'jim' to the mythtv
group and then I rebooted.</div><div><br></div><div>At this point I copied
over all the old recordings and other files, then did:</div><div><pre style="font-family:monospace, Courier;color:black;background-color:rgb(249, 249, 249);border-left-width:1px;border-bottom-width:1px;border-right-width:1px;border-top-width:1px;border-left-style:solid;border-bottom-style:solid;border-right-style:solid;border-top-style:solid;border-left-color:rgb(221, 221, 221);border-bottom-color:rgb(221, 221, 221);border-right-color:rgb(221, 221, 221);border-top-color:rgb(221, 221, 221);padding-left:1em;padding-bottom:1em;padding-right:1em;padding-top:1em;white-space:pre-wrap;line-height:1.3em;font-size:14px;"><a href="http://mythconverg_restore.pl">mythconverg_restore.pl</a>
--drop_database --create_database --filename
mythconverg-?????.sql.gz</pre><br></div><div>I ran mythtv-setup and
everything looked good and then I ran mythfrontend and it
worked.</div><div><br></div><div>However, I had written down the
mythconverg password on the old system before doing this and the new
/etc/mythtv/config.xml passwords are different. I can only assume <a href="http://mythconverg_restore.pl">mythconverg_restore.pl</a>
fixes all of this??</div><div><br></div><div>Jim
A</div></div></div></blockquote><div><br></div> <a href="http://mythconverg_restore.pl">mythconverg_restore.pl</a>
restores the mythconverg DB. Passwords etc. are stored in the mysql
DB.<div><br><blockquote style="padding-left:1ex;border-left-color:rgb(0, 0, 255);border-left-style:solid;border-left-width:2px;margin-left:0px;margin-bottom:0.8ex;margin-right:0px;margin-top:0px;"><div dir="ltr"><div dir="ltr"><div></div></div></div></blockquote><span>l-- <br>Bill</span></div></div>_______________________________________________<br><br></blockquote><div><br></div><div>So that may explain why I'm having issues now. I rebooted and now mythtv-setup and mythfrontend will not connect to the database. How do I make this work? I really don't care what the database password is. When I build from source I use mythtv for both user and password. I removed the comment from /etc/mysql/conf.d/mythtv.cnf bind statement and that's all except rebooting</div><div><br></div><div>Jim A</div></div></div></blockquote><div><br></div><div>I always use the commands here to adjust as required: https://github.com/MythTV/mythtv/blob/master/mythtv/database/mc.sql</div><div><br></div><div>Done as the SQL root user. Depends on the distribution, but: sudo mysql mysql works for me.</div><br><blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex"><div dir="ltr"><div class="gmail_quote"><div></div></div></div></blockquote><span class="viv-signature-below">-- <br>Bill</span></body></html>