<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-AU" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">My MythTV stopped working. when I launch the front end the setup page comes up immediately asking me to select my country etc. When I enter that it immediately restarts the frontend and takes me through the setup process again, endlessly.
If I try to run the backend I get a message telling me it can’t connect to the database.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I did reconfigure the network the other day, but the mythTV frontend and backend are on the one box and configured to localhost, so I can't see how changing the IP address of that computer could have caused a problem. The only thing I can
think of is that managed to reconfigure 'localhost' somehow? Regardless ,if I enter the new IP address of the computer in the setup the problem remains unchanged.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The usual solution to this would be: sudo dpkg-reconfigure mythtv-database and sudo dpkg-reconfigure mythtv-common<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">However, when I do that it also gets in loop of repeated asking for the IP address of the host, the administrative user for the data and the password. After several attempts it closes and I am left with:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">john@qpc-Z68X-UD3H-B3:~$ sudo dpkg-reconfigure mythtv-database<o:p></o:p></p>
<p class="MsoNormal">[sudo] password for john: <o:p></o:p></p>
<p class="MsoNormal">Failed to connect to database (incorrect admin password)<o:p></o:p></p>
<p class="MsoNormal">ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.29.80' (111)<o:p></o:p></p>
<p class="MsoNormal">ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.29.80' (111)<o:p></o:p></p>
<p class="MsoNormal">ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.29.80' (111)<o:p></o:p></p>
<p class="MsoNormal">ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.29.80' (111)<o:p></o:p></p>
<p class="MsoNormal">ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.29.80' (111)<o:p></o:p></p>
<p class="MsoNormal">Failed to create or modify database (incorrect admin username/password?)<o:p></o:p></p>
<p class="MsoNormal">Try:<o:p></o:p></p>
<p class="MsoNormal">sudo dpkg-reconfigure mythtv-database<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">This occurs regardless of which user/password I use in mysql.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I'd appreciate any clues on what I should do next, or even just where I should look next.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">John<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>