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

[Stephen Worthington]

On Thu, 1 Dec 2016 14:02:49 +0000, you wrote:

>
>
>On 12/01/2016 08:04 AM, Stephen Worthington wrote:
>> 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.
>> ___________________________________
>1. I do not get the question on updates about keeping my old .cnf file, 
>but I've seen that message on Apache2, etc.
>2.  good idea on the override file in conf.d
>3. is bind-address=0.0.0.0 the same as commenting the bind-address 
>statement out???

You would need to check the MySQL manual for a definitive answer to
that.  My recollection is that if there is no bind-address setting, it
will default to 127.0.0.1 only, for security reasons.