<p>On May 24, 2012 5:16 AM, "scram69" <<a href="mailto:scram69@gmail.com">scram69@gmail.com</a>> wrote:<br>
><br>
> Ran the update manager on my Mythbuntu 12.04 backend (I know, bad<br>
> idea) last week, and discovered that remote frontends could no longer<br>
> connect.<br>
><br>
> Here's the frontend log message:<br>
><br>
> 2012-05-20 19:48:53.809600 E Unable to connect to database!<br>
> 2012-05-20 19:48:53.809640 E Driver error was [1/2003]:<br>
> QMYSQL: Unable to connect<br>
> Database error was:<br>
> Can't connect to MySQL server on '192.168.1.50' (61)<br>
><br>
> My backend has the static IP address above: I hadn't changed that or<br>
> anything in the frontends' settings.<br>
><br>
> I checked /etc/mythtv/mysql.txt and config.xml - nothing had changed.<br>
> In desperation, I changed the mysql password for the mythtv user from<br>
> the Mythbuntu random gibberish to "mythtv". While that wreaked havoc<br>
> with mythweb, it still did not fix the problem.<br>
><br>
> What I finally discovered was that the update had edited an obscure<br>
> file called /etc/mysql/conf.d/mythtv.cnf. Inexplicably, it was<br>
> changed from<br>
><br>
> [mysqld]<br>
> bind-address=0.0.0.0<br>
><br>
> to<br>
><br>
> [mysqld]<br>
> #bind-address=0.0.0.0<br>
><br>
> The net effect was that the mysql server no longer listened for<br>
> frontends on the network, only for the local frontend. Removing the<br>
> "#" character solved the problem.<br>
><br>
> I figured I'd post here in case anyone else had been screwed over by<br>
> the update manger recently. Any idea why the Mythbuntu update would<br>
> mess around with mysql that way?<br>
> _______________________________________________<br>
> mythtv-users mailing list<br>
> <a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
> <a href="http://www.mythtv.org/mailman/listinfo/mythtv-users">http://www.mythtv.org/mailman/listinfo/mythtv-users</a></p>
<p>Same happened during my upgrade too! Thanks for posting though, this will catch a lot of people out. </p>
<p>Martin </p>