<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:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 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;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I solved it by purging mysql-server-5.1 and mysql-common (which also purged mythtv) in accordance with instructions on
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><a href="http://askubuntu.com/questions/125686/mysql-fails-to-start-after-upgrade-installation-etc">http://askubuntu.com/questions/125686/mysql-fails-to-start-after-upgrade-installation-etc</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Reinstalled and reconfigured mysql-server-5.1 and mythtv and now it works, except I lost contact with all of my recordings because my backup failed :9<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">John<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-AU">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-AU"> mythtv-users-bounces@mythtv.org
[mailto:mythtv-users-bounces@mythtv.org] <b>On Behalf Of </b>John Brown<br>
<b>Sent:</b> Thursday, 31 January 2013 2:01 PM<br>
<b>To:</b> mythtv-users@mythtv.org<br>
<b>Subject:</b> [mythtv-users] Can't connect to myth converg and can't dpkg-configure<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<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>