[mythtv-users] Latest 0.26 Ubuntu updates and mythtv

[Steve Malenfant]

Awesome, email was sent before I finished...Seems like mythtv decided to
override some settings. How nice...Deleted the line and now it works. I
understand why they did it, but they should have probably just used 0.0.0.0
instead.

me at ubuntu:/etc/mysql/conf.d# cat mythtv.cnf
[mysqld]
bind-address=192.168.1.x
max_connections=100



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

> 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/5367cb58/attachment.html>