[mythtv-users] Upgraded the Ubuntu 11.10 and now Myth can't connect to MySQL
Damian
myth at surr.co.uk
Thu Nov 10 11:04:26 UTC 2011
On 09/11/2011 12:00, mythtv-users-request at mythtv.org wrote:
> Date: Tue, 08 Nov 2011 14:08:56 -0600
> From: Bill Meek<keemllib at gmail.com>
> Subject: Re: [mythtv-users] Upgraded the Ubuntu 11.10 and not Myth,
> can't connect to MySQL
> To:mythtv-users at mythtv.org
> Message-ID:<4EB98C58.7030603 at gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> On 11/08/2011 07:46 AM, Damian wrote:
> ...
>
> Hi;
>
> OK, good news. I've duplicated your problem with the
> same error messages and no response after sudo start
> mysql.
>
> Go to /etc/apparmor.d and look at the file:
>
> usr.sbin.mysqld
>
> I suspect you'll see lines like:
>
> /var/run/mysqld/mysqld.pid w,
> /var/run/mysqld/mysqld.sock w,
>
> On my 11.10 system, they look like:
>
> /{,var/}run/mysqld/mysqld.pid w,
> /{,var/}run/mysqld/mysqld.sock w,
>
> Because now /run exists along with /var/run.
>
> You may also see the same file name with .dpkg
> at the end of it (or something like it.)
>
> I'm/guessing/ that when you upgraded, you were
> asked if you wanted to install the new file and
> you answered no.
>
> -- Bill
It works!!
Bill, you are a genius! Thank you so much. It was clearly only a tiny
problem, but you managed to find the needle in the haystack!
You will be correct in how the problem was caused as well. I will have
clicked to keep the old file as I have other problems in the past with
newer files replacing my previous settings. I'm not sure what the
recommended plan would be there (other than /don't upgrade/ ), but here
are my lessons learned:
1) Only upgrade on LTS releases (and some would argue to not even do that)
2) When there are differences between old and new config files during an
upgrade, *cut and paste the diff information* for use if there's a
problem at the end!!!
Thanks again Bill, and that comes from all of the family too.
Now I need to track back what I did along the way. I think the only
thing that needs 'undoing' is one of the files or folders that I granted
universal access to. I'll find that and get it patched back up as it
should be.
Thanks to everyone else who helped too. It was a tricky one to find.
Best wishes
Damian
More information about the mythtv-users
mailing list