[mythtv-users] Latest 0.26 Ubuntu updates and mythtv

[Steve Malenfant]

I found the problem...



On Tue, Dec 4, 2012 at 9:08 PM, Steve Malenfant <smalenfant at gmail.com>wrote:

> My bind-address in my.cnf is 127.0.0.1. But if I look at netstat it is
> bound to my 192.168.1.x address.
>
> me at ubuntu:~$ grep bind /etc/mysql/my.cnf
> bind-address            = 127.0.0.1
>
> me at ubuntu:~$ netstat -an | grep 3306
> tcp        0      0 192.168.1.x:3306        0.0.0.0:*               LISTEN
>
>
>
> On Tue, Dec 4, 2012 at 9:14 AM, Mike Perkins <mikep at randomtraveller.org.uk
> > wrote:
>
>> On 04/12/12 13:46, Steve Malenfant wrote:
>>
>>> I upgraded my packages last night and lost mythweb in the process. Looks
>>> like my credentials are OK when I use "localhost" to connect to Mysql,
>>> but
>>> not when specifying 127.0.0.1. I changed my settings in
>>> /etc/mythtv/config.xml from 127.0.0.1 to localhost but didn't seem to
>>> have
>>> any effect on it. Anybody having the same problem? I can't seem to be
>>> able
>>> to override the "127.0.0.1" with all the location I tried.
>>>
>>> root at ubuntu:~/.mythtv# mysql -h 127.0.0.1 -umythtv -p mythconverg
>>> Enter password:
>>> ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
>>>
>>> root at ubuntu:~/.mythtv# mysql -h localhost -umythtv -p mythconverg
>>> Enter password:
>>> 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 185
>>> Server version: 5.5.28-0ubuntu0.12.04.2 (Ubuntu)
>>>
>>> Copyright (c) 2000, 2012, 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> quit
>>>
>>>  See if your mysql configuration has overwritten "bind-address".
>>
>> --
>>
>> Mike Perkins
>>
>> ______________________________**_________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://www.mythtv.org/mailman/**listinfo/mythtv-users<http://www.mythtv.org/mailman/listinfo/mythtv-users>
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20121204/a11194f5/attachment.html>