[mythtv-users] Cannot Connect To Backend

[Jay Foster]

On 11/28/2014 01:45 PM, Hika van den Hoven wrote:
> Hoi Jay,
>
> Friday, November 28, 2014, 10:48:45 PM, you wrote:
>
>> On 11/28/2014 01:06 PM, Hika van den Hoven wrote:
>>> Hoi Jay,
>>>
>>> Friday, November 28, 2014, 9:44:59 PM, you wrote:
>>>
>>>> On 11/28/2014 10:53 AM, Jay Foster       wrote:
>>>
>>>
>>>> On       11/28/2014 10:42 AM, Bill Meek wrote:
>>>>
>>>> On 11/28/2014 12:25 PM, Jay Foster wrote:
>>>>            ...
>>>>            > On my BE system, I have a /etc/mysql/conf.d directory.
>>>> There is a mythtv.cnf file there:
>>>>
>>>>
>>>>              [mysqld]
>>>>              #bind-address=0.0.0.0
>>>>              max_connections=100
>>>>
>>>>              Should I edit this file?  Should I add a new file?  What should I put in there?
>>>>
>>>>
>>>>            Yes, no and:
>>>>
>>>>            Uncomment the bind-address line. I *think* you have to
>>>>            restart mysql, but haven't changed mine in ages.
>>>>
>>>>
>>>> Do I still need to do the
>>>>
>>>>              $ mysql -u root mythconverg
>>>>              mysql> grant all on mythconverg.* to
>>>> mythtv@"192.168.200.%"           identified by "mythtv";
>>>>              mysql> flush privileges;
>>>>
>>>>
>>>>            Maybe, you can do:
>>>>
>>>>                SHOW GRANTS FOR mythtv;
>>>>
>>>>            to see what's there now. You're looking for something similar to         this:
>>>>
>>>>                GRANT USAGE ON mythconverg.* TO 'mythtv'@'%'
>>>> IDENTIFIED BY         PASSWORD
>>>> '*CC8F35F587CA5A556B4132C2407E556D92172FFC'
>>>>
>>>>
>>>>          Thanks.
>>>>
>>>>          I first changed the bind-address to 192.168.200.11, but then
>>>> changed it back to 0.0.0.0 (INADDR_ANY).
>>>>          I restarted mysql and the new FE  successfully connected to the       BE.
>>>>
>>>>          NOTE: I tried the:
>>>>          mysql -u root mythconverg
>>>>          ERROR 1045 (28000): Access denied for user
>>>> 'root'@'localhost'       (using password: NO)
>>>>          jay at mythbox:/etc/mysql$ sudo mysql -u root mythconverg
>>>>          ERROR 1045 (28000): Access denied for user
>>>> 'root'@'localhost'       (using password: NO)
>>>>
>>>>          but got errors, so I'm glad that I did not need that.
>>>>          Jay
>>>>          _______________________________________________
>>>>          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
>>>>
>>>>
>>>>        Arrg.  I spoke too soon.  Now mythweb no longer works.  I now get
>>>>
>>>>
>>>> Fatal Error
>>>>        !!NoTrans: Can't connect to MySQL server on '127.0.0.1' (111)  [#2003]
>>>>
>>>>        when I try to use mythweb.
>>>>
>>>>        Jay
>>>>
>>>
>>>
>>> What does: mysql -u<your mysqluser> -hlocalhost -p<your mysqlpassword> mythconverg
>>> give?
>>> Tot mails,
>>>     Hika                            mailto:hikavdh at gmail.com
>>>
>>> "Zonder hoop kun je niet leven
>>> Zonder leven is er geen hoop
>>> Het eeuwige dilemma
>>> Zeker als je hoop moet vernietigen om te kunnen overleven!"
>>>
>>> De lerende Mens
>>>
>>> _______________________________________________
>>> 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
>>>
>> Reading table information for completion of table and column names
>> You can turn off this feature to get a quicker startup with -A
>
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>> Your MySQL connection id is 193
>> Server version: 5.5.40-0ubuntu0.14.04.1 (Ubuntu)
>
>> Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
>
>> Oracle is a registered trademark of Oracle Corporation and/or its
>> affiliates. Other names may be trademarks of their respective
>> owners.
>
>> Type 'help;' or '\h' for help. Type '\c' to clear the current input
>> statement.
>
> mysql>>
>
>> Jay
>> _______________________________________________
>
> This means mysql listens to localhost (or 127.0.0.1). So the problem
> is in mythweb or apache. You implied mythweb worked before. So the
> only reason I can think of is that apache/mythweb hasn't incorporated
> the changes. So I suggest restarting apache/mythweb or beter (if
> you're not recording) the backend machine.
>
> Tot mails,
>    Hika                            mailto:hikavdh at gmail.com
>
> "Zonder hoop kun je niet leven
> Zonder leven is er geen hoop
> Het eeuwige dilemma
> Zeker als je hoop moet vernietigen om te kunnen overleven!"
>
> De lerende Mens
>
> _______________________________________________
> 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
>
Restarting apache (reboot) is what caused mythweb to stop working.
Jay