[mythtv-users] Cannot Connect To Backend

Hika van den Hoven hikavdh at gmail.com
Fri Nov 28 23:03:37 UTC 2014


Hoi Jay,

Friday, November 28, 2014, 11:42:37 PM, you wrote:

> 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
>>
> When I try
> mysql -umythtv -h127.0.0.1 -pZUF0nOq0 mythconverg

> I get

> ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)

> When I use 'localhost', it works.  My /etc/hosts files has
> 127.0.0.1       localhost

> Jay
> _______________________________________________

So you need your mysql root password to add localhost as allowed
machine.
I checked my config. I have both for root, but only localhost for
mythconverg and indeed I cannot connect with 127.0.0.1.


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



More information about the mythtv-users mailing list