[mythtv-users] 0.28 upgrade issue frontend connection

[Mark Perkins]

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

Ok. There is definitely something going on with the local IPv4 address but I have no idea what or where to start with it. See the following snippets from your log:

> Jul 17 10:09:03 Compromise mythbackend: mythbackend[1425]: C CoreContext serverpool.cpp:269 (SelectDefaultListen) ServerPool: Host is configured to listen on 192.168.63.3, but address is not used on any local network interfaces.
> ...
> Jul 17 10:09:07 Compromise mythbackend: mythbackend[1425]: I CoreContext housekeeper.cpp:706 (Start) Starting HouseKeeper.
> Jul 17 10:09:07 Compromise mythbackend: mythbackend[1425]: I CoreContext serverpool.cpp:407 (listen) Listening on TCP 127.0.0.1:6544
> Jul 17 10:09:07 Compromise mythbackend: mythbackend[1425]: I CoreContext serverpool.cpp:407 (listen) Listening on TCP [::1]:6544
> Jul 17 10:09:07 Compromise mythbackend: mythbackend[1425]: I CoreContext serverpool.cpp:407 (listen) Listening on TCP 127.0.0.1:6554
> Jul 17 10:09:07 Compromise mythbackend: mythbackend[1425]: I CoreContext serverpool.cpp:407 (listen) Listening on TCP [::1]:6554
> Jul 17 10:09:07 Compromise mythbackend: mythbackend[1425]: I CoreContext serverpool.cpp:407 (listen) Listening on TCP 127.0.0.1:6549
> Jul 17 10:09:07 Compromise mythbackend: mythbackend[1425]: I CoreContext serverpool.cpp:407 (listen) Listening on TCP [::1]:6549
> Jul 17 10:09:09 Compromise mythbackend: mythbackend[1425]: I CoreContext main_helpers.cpp:687 (run_backend) Main::Registering HttpStatus Extension
> Jul 17 10:09:09 Compromise mythbackend: mythbackend[1425]: W CoreContext mainserver.cpp:286 (MainServer) MainServer: Unable to find IPv4 address to bind
> Jul 17 10:09:09 Compromise mythbackend: mythbackend[1425]: I CoreContext serverpool.cpp:407 (listen) Listening on TCP 127.0.0.1:6543
> Jul 17 10:09:09 Compromise mythbackend: mythbackend[1425]: I CoreContext serverpool.cpp:407 (listen) Listening on TCP [::1]:6543

Not really an answer but at least with sticking with 127.0.0.1 we should be able to work around it.

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

Ok this is good progress. From looking at this https://code.mythtv.org/trac/ticket/12713 you may be running MySQL version 5.7 which had some incompatibilities with MythTV. It looks like your version of MythTV 0.28 is current as of about 12th April 2016.  There were some fixes pushed to 0.28 around 24th April 2016 to address. Can you pull an updated package? If not, try adding the following line to the bottom of your /etc/mysql/mysql.conf.d/mythtv.cnf file:

sql_mode=NO_ENGINE_SUBSTITUTION

Reboot and try again.