[mythtv-users] 0.28 upgrade issue frontend connection

[Douglas Peale]

On 07/17/2016 08:37 PM, Mark Perkins wrote:
>> 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
>>
> 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.
There is a copy of the backend log from earlier today here: http://pastebin.com/X1z4jRn1
> 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"?
No, it always showed 192.168.63.3
> In mythtv-setup / general what values do you have set for Local Backend IPv4 address and Master Backend IPv4 address?
192.168.63.3 for both
> 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?

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.


I just changed the two addresses in backend setup to 127.0.0.1, and parts of mythweb started working.

Only listings and recorded programs are reporitng an error now.

Recorded Programs gives:


    Fatal Error

!!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]!!

Listings gives:


    Fatal Error

!!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]!!


Changing the other two files and re-booting did not change the above result.

$ ifconfig
enp4s0    Link encap:Ethernet  HWaddr 00:23:54:91:05:f3 
          UP BROADCAST MULTICAST  MTU:1500  Metric:1
          RX packets:0 errors:0 dropped:0 overruns:0 frame:0
          TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:0 (0.0 B)  TX bytes:0 (0.0 B)
          Interrupt:17

enp5s0    Link encap:Ethernet  HWaddr 00:23:54:91:05:f4 
          inet addr:192.168.63.3  Bcast:192.168.63.255  Mask:255.255.255.0
          inet6 addr: fe80::7e55:f88:cc42:921d/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:892 errors:0 dropped:0 overruns:0 frame:0
          TX packets:938 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:444914 (444.9 KB)  TX bytes:105755 (105.7 KB)
          Interrupt:18

lo        Link encap:Local Loopback 
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:65536  Metric:1
          RX packets:3754 errors:0 dropped:0 overruns:0 frame:0
          TX packets:3754 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1
          RX bytes:1271463 (1.2 MB)  TX bytes:1271463 (1.2 MB)

I need to quit for the night. I need to go to work tomorrow.

Thanks for the first hint of progress in a week.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160717/fbe0cf54/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160717/fbe0cf54/attachment.sig>