[mythtv-users] Upgraded the Ubuntu 11.10 and not Myth can't connect to MySQL

Damian myth at surr.co.uk
Tue Nov 8 00:08:44 UTC 2011


On 06/11/2011 17:54, mythtv-users-request at mythtv.org wrote:
> Date: Sun, 06 Nov 2011 17:07:49 +0000
> From: Robert Longbottom<rongblor at googlemail.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:<4EB6BEE5.4030807 at googlemail.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> On 06/11/2011 14:01, Damian wrote:
>> >  On 05/11/2011 21:24,mythtv-users-request at mythtv.org  wrote:
> <snip>
>> >  Thanks for talking me though this. Here's the latest, following your
>> >  instructions:
>> >
>> >  damian at MythBox:~$ ls -la /var/run/mysqld
>> >  total 0
>> >  drwxr-xr-x  2 mysql root   40 2011-11-05 11:04 .
>> >  drwxr-xr-x 26 root  root 1000 2011-11-05 11:04 ..
>> >
>> >  damian at MythBox:~$ cd /var/run
>> >  damian at MythBox:/var/run$ sudo chown -R mysql:mysql mysqld
>> >
>> >  damian at MythBox:/var/run$ ls -la /var/run/mysqld
>> >  total 0
>> >  drwxr-xr-x  2 mysql mysql   40 2011-11-05 11:04 .
>> >  drwxr-xr-x 26 root  root  1000 2011-11-05 11:04 ..
>> >
> <snip>
>
>> >  damian at MythBox:/var/log/mysql$ sudo service mysql start
>> >  mysql start/running
>> >
>> >  damian at MythBox:/var/log/mysql$ ps ax |grep -i mysql
>> >  30457 pts/1    S+     0:00 grep -i mysql
>> >
>> >  damian at MythBox:/var/log/mysql$ cat/var/log/mysql/*.err /var/log/mysql/*.log
>> >  cat:/var/log/mysql/*.err: No such file or directory
>> >  111106 13:42:33 [Note] Plugin 'FEDERATED' is disabled.
>> >  111106 13:42:33  InnoDB: Initializing buffer pool, size = 8.0M
>> >  111106 13:42:33  InnoDB: Completed initialization of buffer pool
>> >  111106 13:42:33  InnoDB: Started; log sequence number 0 20263543
>> >  111106 13:42:33 [ERROR] Can't start server : Bind on unix socket:
>> >  Permission denied
>> >  111106 13:42:33 [ERROR] Do you already have another mysqld server
>> >  running on socket: /var/run/mysqld/mysqld.sock ?
>> >  111106 13:42:33 [ERROR] Aborting
> Here is the (first) problem - looks like the mysql user can't write to
> /var/run/mysqld/, which is odd, because based on what you did above I
> would have thought it should be able to.
>
> I think I'd grant everyone access to write to /var/run/mysqld by running
>
> chmod o+w /var/run/mysql
>
> Delete the log file again.  Start the service and see what happens.  If
> it works, see what files are created in /var/run/mysqld and who owns
> them.  Then fix up the permissions so that you don't need to give global
> write access.
>
> It looks like your filesystem permissions have been messed up somehow.
>

Thanks for the post Robert (and sorry for my messing up the subject 
hearer for a couple of post everyone).

Here's where the last bit of help got me:

damian at MythBox:~$ sudo service mysql start
mysql start/running
damian at MythBox:~$ ls -la /var/run/mysqld
total 0
drwxr-xr-x  2 mysql root   40 2011-11-07 20:45 .
drwxr-xr-x 26 root  root 1000 2011-11-07 20:46 ..
damian at MythBox:~$ sudo chmod o+w /var/run/mysqld
damian at MythBox:~$ ls -la /var/run/mysqld
total 0
drwxr-xrwx  2 mysql root   40 2011-11-07 20:45 .
drwxr-xr-x 26 root  root 1000 2011-11-07 20:46 ..
damian at MythBox:~$ cd /var/log/mysql
damian at MythBox:/var/log/mysql$ ls
error.log
damian at MythBox:/var/log/mysql$ sudo rm *.l*
damian at MythBox:/var/log/mysql$ ls
damian at MythBox:/var/log/mysql$ ls -la /var/log/mysql
total 8
drwxr-s---  2 mysql adm  4096 2011-11-07 20:50 .
drwxr-xr-x 22 root  root 4096 2011-11-07 20:45 ..
damian at MythBox:/var/log/mysql$ sudo service mysql restart

This seemed to hang for a long time, so I aborted and tried again:

^C
damian at MythBox:/var/log/mysql$ sudo service mysql stop
mysql stop/waiting
damian at MythBox:/var/log/mysql$ sudo service mysql start


This again just left a blinking cursor, so I opened up another terminal 
and did the following:

damian at MythBox:~$ cd /var/log/mysql
damian at MythBox:/var/log/mysql$ ls
error.log
damian at MythBox:/var/log/mysql$ ps ax |grep -i mysql
  3411 pts/1    S+     0:00 sudo service mysql start
  3412 pts/1    S+     0:00 start mysql
  3985 pts/2    S+     0:00 grep -i mysql
damian at MythBox:/var/log/mysql$ cat /var/log/mysql/*.log
111107 20:51:09 [Note] Plugin 'FEDERATED' is disabled.
111107 20:51:09  InnoDB: Initializing buffer pool, size = 8.0M
111107 20:51:09  InnoDB: Completed initialization of buffer pool
111107 20:51:10  InnoDB: Started; log sequence number 0 20263543
111107 20:51:10 [ERROR] Can't start server : Bind on unix socket: 
Permission denied
111107 20:51:10 [ERROR] Do you already have another mysqld server 
running on socket: /var/run/mysqld/mysqld.sock ?
111107 20:51:10 [ERROR] Aborting

111107 20:51:10  InnoDB: Starting shutdown...
111107 20:51:15  InnoDB: Shutdown completed; log sequence number 0 20263543
111107 20:51:15 [Note] /usr/sbin/mysqld: Shutdown complete

111107 20:51:40 [Note] Plugin 'FEDERATED' is disabled.
111107 20:51:40  InnoDB: Initializing buffer pool, size = 8.0M
111107 20:51:40  InnoDB: Completed initialization of buffer pool
111107 20:51:40  InnoDB: Started; log sequence number 0 20263543
111107 20:51:40 [ERROR] Can't start server : Bind on unix socket: 
Permission denied
111107 20:51:40 [ERROR] Do you already have another mysqld server 
running on socket: /var/run/mysqld/mysqld.sock ?
111107 20:51:40 [ERROR] Aborting

111107 20:51:40  InnoDB: Starting shutdown...
111107 20:51:45  InnoDB: Shutdown completed; log sequence number 0 20263543
111107 20:51:45 [Note] /usr/sbin/mysqld: Shutdown complete

etc etc ....

Any clue for where to go next??

Damian


More information about the mythtv-users mailing list