<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 07/17/2016 08:37 PM, Mark Perkins
wrote:<br>
</div>
<blockquote
cite="mid:SG2PR03MB190318BF14517A486F766D5FB7360@SG2PR03MB1903.apcprd03.prod.outlook.com"
type="cite">
<blockquote type="cite">
<pre wrap="">Neither option caused mythweb to work.
With db server at 127.0.0.1:
$ sudo netstat -peanut | grep 6543
[sudo] password for dpeale:
tcp 0 0 127.0.0.1:6543 0.0.0.0:* LISTEN 124 22761
1433/mythbackend
tcp6 0 0 ::1:6543 :::* LISTEN 124 22762
1433/mythbackend
with dbserver at 192.168.63.3:
$ sudo netstat -peanut | grep 6543
[sudo] password for dpeale:
tcp 0 0 127.0.0.1:6543 0.0.0.0:* LISTEN 124 23751
1414/mythbackend
tcp6 0 0 ::1:6543 :::* LISTEN 124 23752
1414/mythbackend
</pre>
</blockquote>
<pre wrap="">Interesting. Your backend is not listening on the 192.168.63.3 IP address. I wonder if there is some other network issue at play. The startup section of the mythbackend log file might reveal more.</pre>
</blockquote>
There is a copy of the backend log from earlier today here: <a
class="moz-txt-link-freetext" href="http://pastebin.com/X1z4jRn1"><a class="moz-txt-link-freetext" href="http://pastebin.com/X1z4jRn1">http://pastebin.com/X1z4jRn1</a></a>
<blockquote
cite="mid:SG2PR03MB190318BF14517A486F766D5FB7360@SG2PR03MB1903.apcprd03.prod.outlook.com"
type="cite">
<pre wrap="">
Did the error message in mythweb change to follow the 127.0.0.1 address when setenv db_server "127.0.0.1", and 192.168.63.3 when setenv db_server "192.168.63.3"?</pre>
</blockquote>
No, it always showed 192.168.63.3<br>
<blockquote
cite="mid:SG2PR03MB190318BF14517A486F766D5FB7360@SG2PR03MB1903.apcprd03.prod.outlook.com"
type="cite">
<pre wrap="">
In mythtv-setup / general what values do you have set for Local Backend IPv4 address and Master Backend IPv4 address?
</pre>
</blockquote>
192.168.63.3 for both<br>
<blockquote
cite="mid:SG2PR03MB190318BF14517A486F766D5FB7360@SG2PR03MB1903.apcprd03.prod.outlook.com"
type="cite">
<pre wrap="">I'm rapidly running out of ideas. At this point I would try setting both Local Backend IPv4 address and Master Backend IPv4 address to 127.0.0.1 in mythtv-setup / general. I would set setenv db_server "127.0.0.1" in mythweb.conf and confirm that the error message given when trying to access the webpage changes to point to 127.0.0.1 not 192.168.63.3. I would also change config.xml to point to 127.0.0.1.
Did you restart apache2 after updating the conf file each time?
What does ifconfig show?
</pre>
</blockquote>
<p>I re-started the computer each time. Not to sure how to restart
just one service, and not entirely sure I'd trust that to work.</p>
<p><br>
</p>
<p>I just changed the two addresses in backend setup to 127.0.0.1,
and parts of mythweb started working.</p>
<p>Only listings and recorded programs are reporitng an error now.</p>
<p>Recorded Programs gives:</p>
<h2>Fatal Error</h2>
<p class="err"> !!NoTrans: SQL Error: Expression #3 of SELECT list
is not in GROUP BY clause and contains nonaggregated column
'mythconverg.program.endtime' which is not functionally dependent
on columns in GROUP BY clause; this is incompatible with
sql_mode=only_full_group_by [#1055]!!</p>
Listings gives:<br>
<h2>Fatal Error</h2>
<p class="err"> !!NoTrans: SQL Error: Expression #3 of SELECT list
is not in GROUP BY clause and contains nonaggregated column
'mythconverg.program.endtime' which is not functionally dependent
on columns in GROUP BY clause; this is incompatible with
sql_mode=only_full_group_by [#1055]!!</p>
<p class="err"><br>
</p>
<p class="err">Changing the other two files and re-booting did not
change the above result.</p>
<p class="err">$ ifconfig<br>
enp4s0 Link encap:Ethernet HWaddr 00:23:54:91:05:f3 <br>
UP BROADCAST MULTICAST MTU:1500 Metric:1<br>
RX packets:0 errors:0 dropped:0 overruns:0 frame:0<br>
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0<br>
collisions:0 txqueuelen:1000 <br>
RX bytes:0 (0.0 B) TX bytes:0 (0.0 B)<br>
Interrupt:17 <br>
<br>
enp5s0 Link encap:Ethernet HWaddr 00:23:54:91:05:f4 <br>
inet addr:192.168.63.3 Bcast:192.168.63.255
Mask:255.255.255.0<br>
inet6 addr: fe80::7e55:f88:cc42:921d/64 Scope:Link<br>
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1<br>
RX packets:892 errors:0 dropped:0 overruns:0 frame:0<br>
TX packets:938 errors:0 dropped:0 overruns:0 carrier:0<br>
collisions:0 txqueuelen:1000 <br>
RX bytes:444914 (444.9 KB) TX bytes:105755 (105.7 KB)<br>
Interrupt:18 <br>
<br>
lo Link encap:Local Loopback <br>
inet addr:127.0.0.1 Mask:255.0.0.0<br>
inet6 addr: ::1/128 Scope:Host<br>
UP LOOPBACK RUNNING MTU:65536 Metric:1<br>
RX packets:3754 errors:0 dropped:0 overruns:0 frame:0<br>
TX packets:3754 errors:0 dropped:0 overruns:0 carrier:0<br>
collisions:0 txqueuelen:1 <br>
RX bytes:1271463 (1.2 MB) TX bytes:1271463 (1.2 MB)<br>
</p>
<p class="err">I need to quit for the night. I need to go to work
tomorrow.</p>
<p class="err">Thanks for the first hint of progress in a week.<br>
</p>
</body>
</html>