[mythtv-users] Parts of mythtv can access DB, others can't. Version 30.
grandmastermarclar at gmail.com
Mon Jun 4 06:27:47 UTC 2018
I just changed all instances of 192.168.1.234 to 127.0.0.,1 in all
instances of config.xml. mythwelcome then picked up my theme. Progress,
although not what I expected. More promising was that mythfilldatabase
But it wasn't until I amended all references in mythconverg.settings
(MariaDB [mythconverg]> update settings set data = '127.0.0.1' where data =
'192.168.1.234';) that mythwelcome and mythfrontend came back to life...
None of these changes were necessary with version 29 last week. I could
have probably stuck with 29 if I hadn't changed all the IP addresses.
Something has definitely crept in to break mythttv.
OK, looks like there's a separate issue with mythtv-status, though.
I've had the 012QMYSQL3 errors for a long time, although the DB is fine (as
far as all the checks are concerned), and this has never caused me any
issues in mythtv.
On Mon, 4 Jun 2018 at 06:50 Ian Campbell <ijc at hellion.org.uk> wrote:
> On Sun, 2018-06-03 at 22:19 +0100, Ian Richardson wrote:
> > The debug just isn't giving me enough. How can I find out exactly how
> > those failing parts are trying to talk to the DB?
> > Jun 3 14:08:11 babylon mythtv-setup.real: mythtv-setup: E
> CoreContext mythdbcon.cpp:897 (prepare) Driver error was
> [2/2013]:#012QMYSQL3: Unable to prepare statement#012Database error
> was:#012Lost connection to MySQL server during query
> From that line in the logs on the ticket it looks like it is
> successfully connecting but then the connection gets unexpectedly (from
> myth's PoV) dropped -- perhaps the mysql/mariadb logs will contain a
> clue as to why it closed the connection?
> The 012QMYSQL3 code has some hits on google -- I haven't dug very deep
> but some of them suggest a db repair might be the way forward.
> mythtv-users mailing list
> mythtv-users at mythtv.org
> MythTV Forums: https://forum.mythtv.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mythtv-users