<div dir="ltr">Thanks for the tip, but I don't think this is my issue. I am able to connect to the database just fine from both the backend and frontend hosts using the "mysql" command line method. I did put in the "bind-address=0.0.0.0" line in the [mysqld] section of the /etc/my.cnf.d/mariadb-server.cnf file and restarted mariadb, but made no difference; mythbackend still starts as a slave. None of the other files in my.cnf.d have any reference o bind-address. I do not have a mythtv.cnf file anywhere.<div><br></div><div>--Greg</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr">On Sun, May 27, 2018 at 8:44 AM James Abernathy <<a href="mailto:jfabernathy@gmail.com" target="_blank">jfabernathy@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word;line-break:after-white-space"><br><div>
<div style="color:rgb(0,0,0);letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word">Jim Abernathy<br><a href="mailto:jfabernathy@gmail.com" target="_blank">jfabernathy@gmail.com</a><br><br><br></div>
</div>
<div><br><blockquote type="cite"><div>On May 25, 2018, at 1:33 PM, Greg Woods <<a href="mailto:greg@gregandeva.net" target="_blank">greg@gregandeva.net</a>> wrote:</div><br class="m_1847316114353091114m_-1606892366255604759Apple-interchange-newline"><div><div dir="ltr">This issue has occurred on both a desktop frontend and a frontend running on the BE system itself. When I fire up mythfrontend after the upgrade, I get the display showing that it is trying to connect to the backend, which eventually fails, as to any retries. As far as I can see, connections to the DB are good; "netstat --tcp" shows several connections from the frontend systems to the Mariadb server, and I can also connect manually and poke around and it all looks good as far as I can tell. I think the schema has already been upgraded, since I tried to connect from a frontend still on 0.28 and got the screen saying that the schema was not what was expected.<div><br></div><div>Is there something I can do to troubleshoot this? I've done lots of Myth upgrades before (I started on 0.16) and haven't seen this particular symptom.</div><div><br></div><div>I am running on Fedora 26, the full version number of the Myth packages is </div><div><div>29.1-17.19.20180510.g0849e99596.fc26.x86_64. I have also completely disabled the firewall on both the desktop and the BE system so that I can rule out firewall issues. In the setup, the DB host was set to the IP address of the BE. I tried using the hostname, but that made no difference (no surprise there since the DB connections look OK).</div></div><div><br></div><div>Here's the tail of the FE log:</div><div><br></div><div><br></div><div><div>2018-05-25 11:27:07.185346 I Start up testing connections. DB <a href="http://mongoliad.gregandeva.net/" target="_blank">mongoliad.gregandeva.net</a>, BE , attempt 2, status beAwake</div><div>2018-05-25 11:27:12.202041 I Start up testing connections. DB <a href="http://mongoliad.gregandeva.net/" target="_blank">mongoliad.gregandeva.net</a>, BE , attempt 3, status beAwake</div><div>2018-05-25 11:27:17.216581 I Start up testing connections. DB <a href="http://mongoliad.gregandeva.net/" target="_blank">mongoliad.gregandeva.net</a>, BE , attempt 4, status beAwake</div><div>2018-05-25 11:27:22.229820 I Start up testing connections. DB <a href="http://mongoliad.gregandeva.net/" target="_blank">mongoliad.gregandeva.net</a>, BE , attempt 5, status beAwake</div><div>2018-05-25 11:27:27.244218 I Start up testing connections. DB <a href="http://mongoliad.gregandeva.net/" target="_blank">mongoliad.gregandeva.net</a>, BE , attempt 6, status beAwake</div><div>2018-05-25 11:27:32.263358 I Start up testing connections. DB <a href="http://mongoliad.gregandeva.net/" target="_blank">mongoliad.gregandeva.net</a>, BE , attempt 7, status beAwake</div><div>2018-05-25 11:27:37.284150 I Start up testing connections. DB <a href="http://mongoliad.gregandeva.net/" target="_blank">mongoliad.gregandeva.net</a>, BE , attempt 8, status beAwake</div><div>2018-05-25 11:27:42.297133 I Start up testing connections. DB <a href="http://mongoliad.gregandeva.net/" target="_blank">mongoliad.gregandeva.net</a>, BE , attempt 9, status beAwake</div><div>2018-05-25 11:27:47.310539 I Start up testing connections. DB <a href="http://mongoliad.gregandeva.net/" target="_blank">mongoliad.gregandeva.net</a>, BE , attempt 10, status beAwake</div><div>2018-05-25 11:27:52.325031 I Start up failure. host <a href="http://mongoliad.gregandeva.net/" target="_blank">mongoliad.gregandeva.net</a>, status beAwakeFail</div></div><div><br></div><div>Here is the tail of the BE log:</div><div><br></div><div><div>2018-05-25 11:26:26.886773 E [23866/24604] MythSocketThread(-1) mythsocket.cpp:827 (ReadStringListReal) - MythSocket(20d8010:214): </div><div>ReadStringList: Error, timed out after 30000 ms.</div><div>2018-05-25 11:26:26.886896 W [23866/24604] MythSocketThread(-1) mainserver.cpp:7704 (connectionClosed) - MainServer: Unknown socket</div><div> closing MythSocket(0x20d8010)</div><div>2018-05-25 11:26:26.887006 E [23866/23866] CoreContext mythsocket.cpp:369 (SendReceiveStringList) - MythSocket(20d8010:-1): No resp</div><div>onse.</div><div>2018-05-25 11:26:26.887021 E [23866/23866] CoreContext mainserver.cpp:8040 (reconnectTimeout) - MainServer: Failed to open master s</div><div>erver socket, timeout</div><div>2018-05-25 11:26:26.887896 I [23866/24609] MythSocketThread(215) mainserver.cpp:7693 (connectionClosed) - Control sock(20df930) dis</div><div>connected</div><div>2018-05-25 11:26:26.887960 I [23866/24608] MythSocketThread(214) mainserver.cpp:7693 (connectionClosed) - Control sock(20dcf20) dis</div><div>connected</div><div>2018-05-25 11:26:26.888101 I [23866/24610] MythSocketThread(217) mainserver.cpp:7693 (connectionClosed) - Control sock(20e07c0) disconnected</div><div>2018-05-25 11:26:26.888328 C [23866/23906] ProcessRequest mainserver.cpp:1614 (HandleVersion) - MainServer: MainServer::HandleVersion - Client speaks protocol version 88 but we speak 91!</div><div>2018-05-25 11:26:26.888548 I [23866/24611] MythSocketThread(219) mainserver.cpp:7693 (connectionClosed) - Control sock(20e16e0) disconnected</div><div>2018-05-25 11:26:27.862295 N [23866/23866] CoreContext mainserver.cpp:7991 (reconnectTimeout) - MainServer: Connecting to master server: <a href="http://192.168.1.33:6543/" target="_blank">192.168.1.33:6543</a></div><div>2018-05-25 11:26:27.862820 N [23866/23866] CoreContext mainserver.cpp:8002 (reconnectTimeout) - MainServer: Connected successfully</div><div>2018-05-25 11:26:57.886824 E [23866/24612] MythSocketThread(-1) mythsocket.cpp:827 (ReadStringListReal) - MythSocket(20ddb90:217): ReadStringList: Error, timed out after 30000 ms.</div><div>2018-05-25 11:26:57.886943 W [23866/24612] MythSocketThread(-1) mainserver.cpp:7704 (connectionClosed) - MainServer: Unknown socket closing MythSocket(0x20ddb90)</div><div>2018-05-25 11:26:57.887052 E [23866/23866] CoreContext mythsocket.cpp:369 (SendReceiveStringList) - MythSocket(20ddb90:-1): No response.</div><div>2018-05-25 11:26:57.887067 E [23866/23866] CoreContext mainserver.cpp:8040 (reconnectTimeout) - MainServer: Failed to open master server socket, timeout</div><div>2018-05-25 11:26:57.888022 I [23866/24618] MythSocketThread(217) mainserver.cpp:7693 (connectionClosed) - Control sock(20db0a0) disconnected</div><div>2018-05-25 11:26:57.888107 I [23866/24619] MythSocketThread(219) mainserver.cpp:7693 (connectionClosed) - Control sock(20e38b0) disconnected</div><div>2018-05-25 11:26:57.888199 I [23866/24620] MythSocketThread(222) mainserver.cpp:7693 (connectionClosed) - Control sock(20e46b0) disconnected</div><div>2018-05-25 11:26:57.888606 C [23866/23906] ProcessRequest mainserver.cpp:1614 (HandleVersion) - MainServer: MainServer::HandleVersion - Client speaks protocol version 88 but we speak 91!</div><div>2018-05-25 11:26:57.888904 I [23866/24621] MythSocketThread(224) mainserver.cpp:7693 (connectionClosed) - Control sock(20e54e0) disconnected</div><div>2018-05-25 11:26:58.862398 N [23866/23866] CoreContext mainserver.cpp:7991 (reconnectTimeout) - MainServer: Connecting to master server: <a href="http://192.168.1.33:6543/" target="_blank">192.168.1.33:6543</a></div><div>2018-05-25 11:26:58.862925 N [23866/23866] CoreContext mainserver.cpp:8002 (reconnectTimeout) - MainServer: Connected successfully</div><div>2018-05-25 11:27:28.886960 E [23866/24622] MythSocketThread(-1) mythsocket.cpp:827 (ReadStringListReal) - MythSocket(20dfed0:222): ReadStringList: Error, timed out after 30000 ms.</div><div>2018-05-25 11:27:28.887081 W [23866/24622] MythSocketThread(-1) mainserver.cpp:7704 (connectionClosed) - MainServer: Unknown socket closing MythSocket(0x20dfed0)</div></div><div><div>2018-05-25 11:27:28.887191 E [23866/23866] CoreContext mythsocket.cpp:369 (SendReceiveStringList) - MythSocket(20dfed0:-1): No response.</div><div>2018-05-25 11:27:28.887206 E [23866/23866] CoreContext mainserver.cpp:8040 (reconnectTimeout) - MainServer: Failed to open master server socket, timeout</div><div>2018-05-25 11:27:28.888300 I [23866/24626] MythSocketThread(222) mainserver.cpp:7693 (connectionClosed) - Control sock(20e0b70) disconnected</div><div>2018-05-25 11:27:28.888365 I [23866/24627] MythSocketThread(224) mainserver.cpp:7693 (connectionClosed) - Control sock(20e7640) disconnected</div><div>2018-05-25 11:27:28.888411 I [23866/24628] MythSocketThread(227) mainserver.cpp:7693 (connectionClosed) - Control sock(20e8430) disconnected</div><div>2018-05-25 11:27:28.888785 C [23866/24548] ProcessRequest mainserver.cpp:1614 (HandleVersion) - MainServer: MainServer::HandleVersion - Client speaks protocol version 88 but we speak 91!</div><div>2018-05-25 11:27:28.889044 I [23866/24629] MythSocketThread(229) mainserver.cpp:7693 (connectionClosed) - Control sock(20ec470) disconnected</div><div>2018-05-25 11:27:29.862612 N [23866/23866] CoreContext mainserver.cpp:7991 (reconnectTimeout) - MainServer: Connecting to master server: <a href="http://192.168.1.33:6543/" target="_blank">192.168.1.33:6543</a></div><div>2018-05-25 11:27:29.863119 N [23866/23866] CoreContext mainserver.cpp:8002 (reconnectTimeout) - MainServer: Connected successfully</div><div>2018-05-25 11:27:59.886704 E [23866/24630] MythSocketThread(-1) mythsocket.cpp:827 (ReadStringListReal) - MythSocket(20e7990:229): ReadStringList: Error, timed out after 30000 ms.</div><div>2018-05-25 11:27:59.886825 W [23866/24630] MythSocketThread(-1) mainserver.cpp:7704 (connectionClosed) - MainServer: Unknown socket closing MythSocket(0x20e7990)</div><div>2018-05-25 11:27:59.886934 E [23866/23866] CoreContext mythsocket.cpp:369 (SendReceiveStringList) - MythSocket(20e7990:-1): No response.</div><div>2018-05-25 11:27:59.886950 E [23866/23866] CoreContext mainserver.cpp:8040 (reconnectTimeout) - MainServer: Failed to open master server socket, timeout</div><div>2018-05-25 11:27:59.887970 I [23866/24636] MythSocketThread(229) mainserver.cpp:7693 (connectionClosed) - Control sock(20e6380) disconnected</div><div>2018-05-25 11:27:59.888039 I [23866/24637] MythSocketThread(230) mainserver.cpp:7693 (connectionClosed) - Control sock(20f1e50) disconnected</div><div>2018-05-25 11:27:59.888089 I [23866/24638] MythSocketThread(232) mainserver.cpp:7693 (connectionClosed) - Control sock(20f2d50) disconnected</div><div>2018-05-25 11:27:59.888326 I [23866/24639] MythSocketThread(229) mainserver.cpp:7693 (connectionClosed) - Control sock(210cac0) disconnected</div><div>2018-05-25 11:28:00.862318 N [23866/23866] CoreContext mainserver.cpp:7991 (reconnectTimeout) - MainServer: Connecting to master server: <a href="http://192.168.1.33:6543/" target="_blank">192.168.1.33:6543</a></div><div>2018-05-25 11:28:00.862920 N [23866/23866] CoreContext mainserver.cpp:8002 (reconnectTimeout) - MainServer: Connected successfully</div></div><div><br></div><div>Thanks,</div><div>--Greg</div><div><br></div></div></div></blockquote><div><br></div>When I upgraded to v29, I have remote FE connection issues. It turned out to be MariaDB that was installed as part of v29 upgrade. The search path is changed.</div><div><br></div><div>I included some help in my blog on this: (<a href="http://mythtvinstall.blogspot.com/2018/01/creating-combined-mythtv-headless.html" target="_blank">http://mythtvinstall.blogspot.com/2018/01/creating-combined-mythtv-headless.html</a>)</div><div><br></div><div><span style="font-family:Times;font-size:medium;font-variant-ligatures:normal">30.</span><font style="font-family:Times;font-size:medium;font-variant-ligatures:normal;white-space:pre-wrap"> </font><span style="font-family:Times;font-size:medium;font-variant-ligatures:normal">Before you build a remote v29 mythtv-frontend, you need to fix a mysql or rather mariadb issue to allow remote frontends. Move the mythtv.cnf file from /etc/mysql/conf.d to /etc/mysql/mariadb.conf.d. Then edit mythtv.cnf and make sure it has a “bind-address=::” that isn’t commented out. You need to override the bind-address=127.0.0.1 statement in another file setup by the install. Look in the wiki for an explanation on how this works. </span><a href="https://www.mythtv.org/wiki/Database_Setup" style="font-family:Times;font-size:medium;font-variant-ligatures:normal" target="_blank">Database_Setup</a></div><div><br></div><div>Jim A</div><div><br><blockquote type="cite"><div>
_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br><a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br><a href="http://wiki.mythtv.org/Mailing_List_etiquette" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>MythTV Forums: <a href="https://forum.mythtv.org" target="_blank">https://forum.mythtv.org</a><br></div></blockquote></div><br></div>_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
</blockquote></div>