<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><br>
</p>
<div class="moz-cite-prefix">On 10/31/18 12:27 AM, Mark Perkins
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:SLXP216MB012874D8AEAEA973D47AECE1B7CD0@SLXP216MB0128.KORP216.PROD.OUTLOOK.COM">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<div dir="auto">
<div dir="auto"><br>
</div>
<div dir="auto"><br>
</div>
<div id="aqm-original" style="color: black;"><!-- body start -->
<div style="word-wrap: break-word; -webkit-nbsp-mode: space;
line-break: after-white-space;" class="aqm-original-body">
<div style="color: black;">
<p style="color: black; font-size: 10pt; font-family:
sans-serif; margin: 8pt 0;">
On 31 October 2018 1:43:49 pm James Abernathy
<a class="moz-txt-link-rfc2396E" href="mailto:jfabernathy@gmail.com"><jfabernathy@gmail.com></a> wrote:</p>
<blockquote type="cite" class="gmail_quote" style="margin:
0 0 0 0.75ex; border-left: 1px solid #808080;
padding-left: 0.75ex;">
I’m now having problems with mythtv-setup not connecting
to the database. I’m following the instructions I
documented in the following blog:
<div class=""><br class="">
</div>
<div class=""><a
href="https://mythtvinstall.blogspot.com/2018/10/creating-mythtv-v29-frontendbackend-on.html"
class="" moz-do-not-send="true">https://mythtvinstall.blogspot.com/2018/10/creating-mythtv-v29-frontendbackend-on.html</a></div>
<div class=""><br class="">
</div>
<div class="">The first time I did this, no problems. I
complete started over again to verify things. Since I
link /etc/mythtv/config.xml to
$HOME/.mythtv/config.xml before I run mythtv-setup, I
never had to look at the database password.</div>
<div class=""><br class="">
</div>
<div class="">I ran mythtv-setup after setting up XMLTV
json per the wiki as I’ve done before and documented.
I had no problems connecting then, but after I
finished, I ran mythfilldatabase and it also bombed
due to not connecting with the database. I tried
mythtv-setup again and this time it couldn’t connect.</div>
<div class=""><br class="">
</div>
<div class="">It’s like I follow the same instructions,
but it randomly fails.</div>
<div class=""><br class="">
</div>
<div class="">when I run mythfilldatabase now I see
this:</div>
<div class=""><br class="">
</div>
<div class="">
<div style="margin: 0px; font-stretch: normal;
font-size: 11px; line-height: normal; font-family:
Menlo; background-color: rgb(253, 253, 253);"
class="">
<span style="font-variant-ligatures:
no-common-ligatures" class="">2018-10-30
22:57:55.639274 I Start up testing connections.
DB 192.168.0.251, BE , attempt 0, status dbAwake</span></div>
<div style="margin: 0px; font-stretch: normal;
font-size: 11px; line-height: normal; font-family:
Menlo; background-color: rgb(253, 253, 253);"
class="">
<span style="font-variant-ligatures:
no-common-ligatures" class="">2018-10-30
22:57:56.641275 I Start up testing connections.
DB 192.168.0.251, BE , attempt 1, status dbAwake</span></div>
<div style="margin: 0px; font-stretch: normal;
font-size: 11px; line-height: normal; font-family:
Menlo; background-color: rgb(253, 253, 253);"
class="">
<span style="font-variant-ligatures:
no-common-ligatures" class="">2018-10-30
22:58:01.650478 I Start up testing connections.
DB 192.168.0.251, BE , attempt 2, status dbAwake</span></div>
<div style="margin: 0px; font-stretch: normal;
font-size: 11px; line-height: normal; font-family:
Menlo; background-color: rgb(253, 253, 253);"
class="">
<span style="font-variant-ligatures:
no-common-ligatures" class="">2018-10-30
22:58:06.659712 I Start up testing connections.
DB 192.168.0.251, BE , attempt 3, status dbAwake</span></div>
<div style="margin: 0px; font-stretch: normal;
font-size: 11px; line-height: normal; font-family:
Menlo; background-color: rgb(253, 253, 253);"
class="">
<span style="font-variant-ligatures:
no-common-ligatures" class="">2018-10-30
22:58:11.668891 I Start up testing connections.
DB 192.168.0.251, BE , attempt 4, status dbAwake</span></div>
</div>
<div class=""><br class="">
</div>
<div class="">Jim A</div>
<div class=""><br class="">
<div class="">
<div style="color: rgb(0, 0, 0); letter-spacing:
normal; orphans: auto; text-align: start;
text-indent: 0px; text-transform: none;
white-space: normal; widows: auto; word-spacing:
0px; -webkit-text-stroke-width: 0px; word-wrap:
break-word; -webkit-nbsp-mode: space;
-webkit-line-break: after-white-space;" class="">
<br class="">
<br class="">
</div>
</div>
<br class="">
</div>
<div>_______________________________________________</div>
<div>mythtv-users mailing list</div>
<div><a class="aqm-autolink aqm-autowrap"
href="mailto:mythtv-users%40mythtv.org"
moz-do-not-send="true">mythtv-users@mythtv.org</a></div>
<div><a class="aqm-autolink aqm-autowrap"
href="http://lists.mythtv.org/mailman/listinfo/mythtv-users"
moz-do-not-send="true">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a></div>
<div><a class="aqm-autolink aqm-autowrap"
href="http://wiki.mythtv.org/Mailing_List_etiquette"
moz-do-not-send="true">http://wiki.mythtv.org/Mailing_List_etiquette</a></div>
<div>MythTV Forums: <a class="aqm-autolink
aqm-autowrap" href="https://forum.mythtv.org"
moz-do-not-send="true">
https://forum.mythtv.org</a></div>
<div><br>
</div>
</blockquote>
</div>
</div>
<!-- body end --></div>
<div dir="auto">I can't speak for Xubuntu, but vanilla install
of mysql / mariadb sometimes only bind to localhost as it is
default more secure. Have you checked for bind-address? Or:</div>
<div dir="auto">netstat -peanut | grep 3306</div>
</div>
<br>
</blockquote>
<p>Okay, problem solved, but it brings up questions about what
should be changed when configuring the backend the first time.
What I do and document is changing General-> Primary IP to
192.168.0.250, which is the IP address of the backend and
LOCALHOST. I'm guessing that change now made it important to
change the #bind-address=:: to bind-address=::</p>
<p>With that solved I ran the FE and it worked but had no guide
data. So I ran mythtv-setup which stopped the BE then I exited
and it asked about running mythfilldatabase. That failed due to
me running mythtv-setup and thereby mythfilldatabase as 'jim'. I
had configured XMLTV as 'mythtv'.</p>
<p>So I ran mythfilldatabase as 'mythtv'. problem solved.</p>
<p>This brings up what should be done to make this work all the
time.</p>
<p>1. Either leave General -> Primary IP as 127.0.0.1 or always
do the bind-address=:: fix</p>
<p>2. When doing mythtv-setup as "jim" don't run mythfilldatabase as
part of exiting. Then sudo su mythtv and then run mythfilldatabase</p>
<p>3. Or do I run the XMLTV setup stuff as "jim" and then link all
the .xmltv stuff in /home/mythtv/.xmltv back to /home/jim/.xmltv</p>
<p>Thoughts?</p>
<p>Jim A<br>
<br>
</p>
<p><br>
</p>
</body>
</html>