<html><head></head><body><span class="viv-signature"></span>On Thursday 16 March 2023 11:32:33 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 11:20 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>On Thursday 16 March 2023 10:53:03 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"><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="margin-left:0.8ex;margin-bottom:0px;margin-right:0px;margin-top:0px;border-left-color:rgb(204, 204, 204);border-left-style:solid;border-left-width:1px;padding-left:1ex;"><div><span></span><br><br>On
Thursday 16 March 2023 10:14:55 AM (-05:00), James Abernathy
wrote:<br><br><blockquote style="margin-left:0px;margin-bottom:0.8ex;margin-right:0px;margin-top:0px;border-left-color:rgb(0, 0, 255);border-left-style:solid;border-left-width:2px;padding-left:1ex;"><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-size:14px;line-height:1.3em;white-space:pre-wrap;padding-left:1em;padding-bottom:1em;padding-right:1em;padding-top:1em;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);border-left-style:solid;border-bottom-style:solid;border-right-style:solid;border-top-style:solid;border-left-width:1px;border-bottom-width:1px;border-right-width:1px;border-top-width:1px;background-color:rgb(249, 249, 249);color:black;font-family:monospace, Courier;"><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="margin-left:0px;margin-bottom:0.8ex;margin-right:0px;margin-top:0px;border-left-color:rgb(0, 0, 255);border-left-style:solid;border-left-width:2px;padding-left:1ex;"><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: <a href="https://github.com/MythTV/mythtv/blob/master/mythtv/database/mc.sql">https://github.com/MythTV/mythtv/blob/master/mythtv/database/mc.sql</a></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="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 class="gmail_quote"><div></div></div></div></blockquote><span>-- <br>Bill</span></div></blockquote><div><br></div><div>I just tried that and all commands worked fine in mariadb mysql but no success. /etc/mythtv/config.xml password is set to 'mythtv', so I was hoping this would fix it.</div><div> This is what I see in the log:</div><div>Mar 16 11:25:51 den-pc mythbackend[2290]: mythbackend[2290]: N thread_unknown mythdirs.cpp:204 (InitializeMythDirs) Using configuration directory = /home/mythtv/.mythtv<br>Mar 16 11:25:51 den-pc mythbackend[2290]: mythbackend[2290]: I CoreContext mythcorecontext.cpp:261 (Init) Assumed character encoding: en_US.UTF-8<br>Mar 16 11:25:51 den-pc mythbackend[2290]: mythbackend[2290]: I LogForward loggingserver.cpp:219 (SyslogLogger) Added syslogging<br>Mar 16 11:25:51 den-pc mythbackend[2290]: mythbackend[2290]: I CoreContext mythcontext.cpp:584 (LoadDatabaseSettings) Empty LocalHostName. This is typical.<br>Mar 16 11:25:51 den-pc mythbackend[2290]: mythbackend[2290]: I CoreContext mythcontext.cpp:635 (LoadDatabaseSettings) Using a profile name of: 'den-pc' (Usually the same as this host's name.)<br>Mar 16 11:25:51 den-pc mythbackend[2290]: mythbackend[2290]: I CoreContext mythcontext.cpp:872 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 0, status dbAwake, Delay: 2000<br>Mar 16 11:25:52 den-pc mythbackend[2290]: mythbackend[2290]: I CoreContext mythcontext.cpp:872 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 1, status dbAwake, Delay: 2000<br>Mar 16 11:26:24 den-pc mythbackend[2290]: mythbackend[2290]: I CoreContext mythcontext.cpp:872 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 2, status dbAwake, Delay: 2000<br>Mar 16 11:26:29 den-pc mythbackend[2290]: mythbackend[2290]: I CoreContext mythcontext.cpp:872 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 3, status dbAwake, Delay: 2000<br>Mar 16 11:26:34 den-pc mythbackend[2290]: mythbackend[2290]: I CoreContext mythcontext.cpp:872 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 4, status dbAwake, Delay: 2000<br>Mar 16 11:26:39 den-pc mythbackend[2290]: mythbackend[2290]: I CoreContext mythcontext.cpp:872 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 5, status dbAwake, Delay: 2000<br>Mar 16 11:26:44 den-pc mythbackend[2290]: mythbackend[2290]: I CoreContext mythcontext.cpp:872 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 6, status dbAwake, Delay: 2000<br>Mar 16 11:26:49 den-pc mythbackend[2290]: mythbackend[2290]: I CoreContext mythcontext.cpp:872 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 7, status dbAwake, Delay: 2000<br>Mar 16 11:26:54 den-pc mythbackend[2290]: mythbackend[2290]: I CoreContext mythcontext.cpp:872 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 8, status dbAwake, Delay: 2000<br>Mar 16 11:26:59 den-pc mythbackend[2290]: mythbackend[2290]: I CoreContext mythcontext.cpp:872 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 9, status dbAwake, Delay: 2000<br>Mar 16 11:27:04 den-pc mythbackend[2290]: mythbackend[2290]: I CoreContext mythcontext.cpp:872 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 10, status dbAwake, Delay: 2000<br>Mar 16 11:27:09 den-pc mythbackend[2290]: mythbackend[2290]: I CoreContext mythcontext.cpp:1000 (TestDBconnection) Start up failure. host localhost, status dbAwakeFail<br>Mar 16 11:27:10 den-pc mythbackend[2290]: Cannot login to database<br>Mar 16 11:27:10 den-pc mythbackend[2290]: Would you like to configure the database connection now? [no]<br>Mar 16 11:27:10 den-pc mythbackend[2290]: [console is not interactive, using default 'no']<br>Mar 16 11:27:10 den-pc mythbackend[2290]: mythbackend[2290]: C CoreContext mythbackend.cpp:134 (main) Failed to init MythContext.<br>Mar 16 11:27:11 den-pc mythbackend[2290]: mythbackend[2290]: I CoreContext mythcontext.cpp:1684 (~MythContext) Exiting<br>Mar 16 11:27:11 den-pc systemd[1]: mythtv-backend.service: Main process exited, code=exited, status=130/n/a<br>Mar 16 11:27:11 den-pc systemd[1]: mythtv-backend.service: Failed with result 'exit-code'.<br></div></div></div>
</blockquote><span class="viv-signature-below"><div><span class="viv-signature-below"><br></span></div><div>Take MythTV out of the picture and get this to work:</div><div><br></div><div> mysql --user=mythtv --password=mythtv --host=localhost mythconverg</div><div><br></div><div>Adjust the above with the correct password and host. I assume: systemctl status mysql.service</div><div>shows that the DB is running.</div><br>-- <br>Bill</span></body></html>