[mythtv-users] Cannot Connect To Backend
Hika van den Hoven
hikavdh at gmail.com
Sat Nov 29 00:02:37 UTC 2014
Hoi Hika,
Saturday, November 29, 2014, 12:09:46 AM, you wrote:
> Hoi Jay,
> Saturday, November 29, 2014, 12:03:20 AM, you wrote:
>> On 11/28/2014 02:42 PM, Jay Foster 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
>>> _______________________________________________
>>> 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
>>>
>> Ahh, I think I fixed it. When I edited the /etc/mysql/conf.d/mythtv.cnf
>> file, I 'meant' to uncomment out the bind-address 0.0.0.0 entry. I did,
>> but I also added a bind-address 192.168.200.11 after it (which I meant
>> to comment out). Both were not commented, so mysql was binding to
>> 192.168.200.11 instead of INADDR_ANY. This made it accessible only by
>> that address. Using 0.0.0.0 makes it work properly for any interface,
>> which is what I thought I had done. My bad.
>> Jay
> Also check what you have for Host in ~/.mythtv/config.xml on your backend.
> If it's 127.0.0.1, change it to localhost.
This is funny. I have my ip-number in my.cnf and still localhost works
but 127.0.0.1 not. I never noticed for I never type the numbers.
Obviously localhost is either not resolved or is resolved to the full
ip-number. Weird.
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