[mythtv-users] Problem with Ubuntu upgrade

[Greg Oliver]

On Fri, Oct 22, 2010 at 2:48 PM, Damian <myth at surr.co.uk> wrote:
> On 22/10/2010 17:26, Greg Oliver wrote:
>>>>
>>>> Either way, if that still does not work, in /etc/my.conf (changes per
>>>> >>  distro), mythtv may be setup to only listen on localhost.  I believe
>>>> >>  it ships that way, but mythtv distros enable the network if you
>>>> >>  specify more than one machine.  I'm not 100% sure what yours is set
>>>> >> to
>>>> >>  though..
>>>> >>
>>>> >>  http://www.mythtv.org/docs/mythtv-HOWTO-6.html    has good info.
>>>> >>  -Greg
>>>> >>
>>>>>>>
>>>>>>> >>>>>  Damian
>>>>>
>>>>> >>>
>>>
>>> >
>>> >  I found the my.conf file in /etc/mysql/my.conf
>>> >
>>> >  What am i looking for? in there? I did a search for 'localhost' and
>>> > found
>>> >  this.
>>> >
>>> >  # Instead of skip-networking the default is now to listen only on
>>> >  # localhost which is more compatible and is not less secure.
>>> >  bind-address            = 127.0.0.1
>>> >  #
>>> >
>>> >  Is this the problem?
>>
>> That needs to be changed to your server's IP and mysql needs to be
>> restarted.  Then re-run your connection test.
>>
>> -Greg
>
> The file on my system is actually called my.cnf (not conf), but I assume
> that's just Ubuntu's version of the same file.
>
> I've tried setting my machine's LAN ip address as the bind-address. I've
> also tried commenting out the bind-address line altogether.
>
> Still can't log in!
>
> I rebooted the machine between each change just to make sure that I'd not
> made a mistake in restarting mysql.
>
> The last line of the my.cnf file reads:
> !includedir /etc/mysql/conf.d/
>
> inside /etc/mysql/conf.d/ there are 3 files:
>  mysqld_safe_syslog.cnf
>  mythtv.cnf
>  mythtv-tweaks.cnf
>
> The contents of mythtv.cnf is:
>
> [mysqld]
> bind-address=0.0.0.0
>
> and the contents of mythtv-tweaks.cnf is:
>
> [mysqld]
> # The following values were partly taken from:
> # http://www.gossamer-threads.com/lists/mythtv/users/90942#90942
> table_cache = 128
> sort_buffer_size = 48M
> net_buffer_length = 8M
> query_cache_type = 1
> query_cache_size = 32M
> # don't do binary logs for mythconverg
> binlog_ignore_db = mythconverg
>
> Does any of that point to anything that needs changing?

That all looks good...

Have you deleted the mythbox entry like Jason suggested earlier?