<div class="gmail_quote">On Sun, Oct 7, 2012 at 1:00 AM, Nick Rout <span dir="ltr"><<a href="mailto:nick.rout@gmail.com" target="_blank">nick.rout@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im">On Sun, Oct 7, 2012 at 6:12 PM, Andrew <<a href="mailto:mythtv@heathsworld.com">mythtv@heathsworld.com</a>> wrote:<br>
><br>
> Thomas,<br>
><br>
> I just came back to this and saw the posts about the config.xml not being<br>
> upgraded. I went into that config and noticed it didn't copy my current<br>
> settings there and the L:/P: was mythtv/mythtv when it should have been<br>
> mythtv/mythconverg. It's been mythtv/mythconverg as long as I can remember<br>
> for the default install so I just edited the config.xml back to my settings<br>
> and it worked.<br>
><br>
> The only problem I have now is that I had to change my host setting to<br>
> 127.0.0.1 from the age old 192.168.0.1 setting i've had to connect to the<br>
> DB.<br>
<br>
<br>
</div>There is a recent bug in mythtv-database in that when it is updated it<br>
resets mysql to listen only on localhost.<br>
<br>
sudo dpkg-reconfigure mythtv-database<br>
<br>
should fix that for you.<br>
<div class="HOEnZb"><div class="h5">_______________________________________________<br>
mythtv-users mailing list<br></div></div></blockquote><div><br></div><div>That put me in an infinite loop and didn't seem to have access to update even though i used sudo. Thus I manually edited /etc/mysql/conf.d/mythtv.cnf and changed bind-address from 127.0.0.1 to:</div>
<div><br></div><div><div>[mysqld]</div><div>bind-address=192.168.0.1</div><div>max_connections=100</div></div><div><br></div><div>Here it's important that everyone knows that setting the bind address here: /etc/mysql/my.cnf will not work. It has to be in /etc/mysql/conf.d/mythtv.cnf.</div>
<div><br></div><div>Andrew</div></div>