[mythtv-users] Problem with Ubuntu upgrade

[Damian]

On 22/10/2010 23:33, Greg Oliver wrote:
> 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?

I think so,
See my reply to Bill a couple of minutes ago.

Damian