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

[Jim Abernathy]

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???

Jim A

> ____________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org