[mythtv-users] upgrading from mythv repositories resetup SQL flag for remote frontends

[Stephen Worthington]

On Thu, 1 Dec 2016 12:09:05 +0000, you wrote:

>
>
>On 12/01/2016 03:44 AM, Stephen Worthington wrote:
>> On Wed, 30 Nov 2016 16:40:38 +0000, you wrote:
>>
>>> I've noticed that after I get an upgrade of mythtv from the 0.28
>>> repository my mythfrontends will not work either remotely or locally.  I
>>> go to the language screen instead.
>>>
>>> If I go into MCC and enable remote frontends on the MySQL tab it then
>>> works.  I have to do this after each upgrade.
>>>
>>> Why?
>>>
>>> Jim A
>> Check all the config files for MySQL under /etc/mysql.  Find which
>> ones have uncommented "bind=" lines.  I suspect the one that is
>> getting changed to allow external access is one of the files that gets
>> installed from the MythTV packages and may be being overwritten when
>> newer packages get installed.
>>
>> cd /etc/mysql
>> grep -ir "bind=" *
>> ______________
>
>If you mean "bind-address", then
>
>conf.d/mythtv.cnf:                        bind-address=0.0.0.0
>conf.d/mythtv.cnf.dpkg-dist:        #bind-address=::
>
>Hope that helps.

Yes, I meant bind-address.

The "apt-file find" command tells me that the mythtv.cnf file is part
of the mythtv-database package.  So it does get updated whenever the
mythtv-database package is updated, which normally happens with each
new version of MythTV.  Normally, if a package installed file has been
modified, when the file is re-installed from a package update, you
will be asked what you want to do with that file - keep your version,
install the package version, or drop to a command prompt and fix it
yourself.  Is that happening for you?  If not, there is something
wrong with the way packages are being installed on your system.  Maybe
you have set an option somewhere to always install the package file,
regardless of whether it has been modified.  I have never seen an
option that does that though.

In any case, if you do not want to have to answer that question on
each update, you need to create a new config file that is loaded after
the mythtv.cnf file, so that any settings in the file override any
prior settings of the same name.  I have one called
/etc/mysql/conf.d/mysql-tweaks-jsw.cnf (which is alphabetically later
than mysql.cnf).  In that file, put your "bind-address=0.0.0.0"
setting, and any other tweaks you want for the MySQL settings.